Simon, Michael - To my humble knowledge, operations with NULL have well-defined semantics, both in SQL-you-name-it standards and in SQLite. "A < B" may have three results - TRUE, FALSE and NULL. It doesn't matter whether you can make any sense of it - it's the spec ;)
Therefore I'm trying to report a bug here according to guideline at http://www.sqlite.org/src/wiki?name=Bug+Reports - I would very much like to hear from SQLite developers whether this report makes sense or if additional information is needed. Cheers, Igor Simon Slavin-3 wrote: > > > On 1 Aug 2011, at 10:45pm, Black, Michael (IS) wrote: > >> If it's meaningless then shouldn't it be a syntax error? > > It's about as meaningless as > > X <= maxreal > > so it would take quite a lot of processing time to identify it as > meaningless. Not sure as if it's worth the processing time. Any decent > debugging effort should find the problem. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://old.nabble.com/Virtual-Table-xBestIndex-and-NULL-Search-Conditions-%28Bug-%29-tp32172549p32174172.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users