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.