On 17 Aug 2017, at 12:46am, Jens Alfke <j...@mooseyard.com> wrote:
> sqlite> SELECT 1 WHERE 'foo' = 'FOO' COLLATE nocase;
> 1 = 1
> sqlite> SELECT 1 WHERE ('foo' = 'FOO') COLLATE nocase;
> sqlite>
>
> So it appears the COLLATE operator is ignored if the expression it applies to
> is parenthesized, which is surprising.
Is there a chance this isn’t doing what you think it’s doing ? Perhaps it is
evaluating the contents of the brackets first, then getting a true/false value,
and applying the COLLATE to that value.
Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
