> 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. But yes, you're right, adding type TEXT magically fixed it and results became the same.
Pavel On Thu, Dec 24, 2009 at 12:40 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 24 Dec 2009, at 1:17pm, Pavel Ivanov wrote: > >> But this behavior is definitely a bug: > > You might change the behaviour by defining the type of the column: > > create table t(f1); > > Try > > create table t(f1 TEXT); > > and see whether one of them gives you the behaviour you want. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
