Hi, I spotted this while looking into something else for Alexey:
The following sql is supposedly valid: select 1 in (1)'hello'; where as select * from t where 1 in (1)'hello'; returns "Error: near "'hello'": syntax error" (which I would expect!) This occurs on v3.6.22, but I haven't checked it against other versions I'm afraid. Cheers Will _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users