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

Reply via email to