Hi, I am Li. I started to learn to use the Derby no long time. I used derby database in Eclipse and start connection with ij tool which in derbytools.jar. The derby version is 10.9.Once, I select data from a table with SQL "select * from tig_users where user_id like 'test_01_%';", but got below data. <http://apache-database.10148.n7.nabble.com/file/n144340/QQ%E6%88%AA%E5%9B%BE20150709161621.png> Note the first record, the user_id 'test_01@yiranlocal' should not matching with 'test_01_%', but I got it. I have no idea with this.I try to test this with the newest version 10.11, but got the same result. What happened and how can I get correct data result?I will very pleased for any suggestion.Thanks and Regards,Li
-- View this message in context: http://apache-database.10148.n7.nabble.com/got-wrong-data-with-using-as-condition-tp144340.html Sent from the Apache Derby Users mailing list archive at Nabble.com.
