2010/6/9 Pavel Ivanov <paiva...@gmail.com> > You can see that these 2 cases compare the same way. They both show > that string is always greater than number and thus '11' > 2 and '2' > > 11. And no affinity rules are applicable here because you use > constants which don't have any affinity.
Perhaps this is the way it was supposed to work. But presence of index does affect something, so I assumed it somehow messes affinity (what else?). _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
