On 22 Aug 2013, at 6:15pm, Igor Tandetnik <i...@tandetnik.org> wrote:
> But again, by what formal mechanism does a property of the column affect the > behavior of the operator? I see no reason for it to do that. I can see why the property of the column might affect the behaviour of an index made on that column but there are problems if it affects comparisons made using values from that column. For example, the meaning of something like create table t(x text collate nocase, y text collate rtrim); select * from t where x = y; is not at all clear purely from reading the SQL code. You have to have actually read the picky details. And the consequences of the picky details are that under SQLite3, these two queries: select * from t where x = y; select * from t where y = x; can return different results. Which I find annoying. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users