On 24 Dec 2009, at 5:51pm, Pavel Ivanov wrote: >> and see whether one of them gives you the behaviour you want. > > I hope you understand that it's not about what behavior is wanted but > about difference in results after switching the order of predicates in > WHERE clause.
Yes, I got it. Changing the order of the operands should not change the result. > But yes, you're right, adding type TEXT magically fixed it and results > became the same. Which makes the bug even more confusing. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users