bug in v7.02 on redhat 7
Scott Cao <scottc@cs.ucla.edu>
From: Scott Cao <scottc@CS.UCLA.EDU>
To: pgsql-bugs@postgresql.org
Date: 2000-12-14T01:19:19Z
Lists: pgsql-bugs
query="select * from product where cat1 like 'Home decoration--%'" this query does not return any tuples in v7.02 but return 1 tuple in v6.5x with the same database population. I ran another query="select * from product where cat1='Home decoration--musical'". This query return one tuple. I ran another query="select * from product where cat1 like '%Home decoration--%'". This query return one tuple.