This behavior of "is" appeared in 3.6.19. What version of SQLite do you have?
Pavel On Tue, Oct 27, 2009 at 12:15 PM, Tom Sillence <t...@sillence.co.uk> wrote: > The documentation, http://sqlite.org/lang_expr.html suggests that "is" > behaves like "=" except that "null is null" returns true. However in > practice the sqlite sql parser won't accept the word "is" followed by > anything other than "null" (oh and I suppose "not" as in "is not"). > > sqlite> select 1 is 2; > SQL error: near "2": syntax error > sqlite> select 1 is null; > 0 > > It seems to me the documentation is wrong here. That said I'd much rather > the behaviour of sqlite changed to match the docs rather than vice-versa > because I really want to write neat queries like: > > select col1 is col2 from table > > Cheers > > Tom Sillence > _______________________________________________ > 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