On 8/22/2013 8:41 PM, Simon Slavin wrote:
On 23 Aug 2013, at 1:14am, Igor Tandetnik <[email protected]> wrote:Once again, a concrete example: create table t(x text collate nocase); insert into t values ('A'); select count(*) from t where x = 'a'; In your opinion, what result should this select statement produce? 1, as it does now? 0, as Simon's approach seems to imply? Something else?You seem to thing that I had a problem with this. I don't. If you go back to my earlier post you will see that I was objecting to the way in which the COLLATE token was used in expressions. The above does not use COLLATE in an expression and has nothing to do with my post.
I asked: "does a property of the column affect the behavior of the operator?" And you answered: "I see no reason for it to do that." This example demonstrates a reason for it to do that, does it not?
-- Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
