On 2 Aug 2011, at 1:10am, Igor Sereda wrote: > 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 ;)
The spec for '<=' should say that comparing any number with NULL always gives a NULL result. If SQLite is doing anything apart from that, it's a bug. Okay, here it is: SQL92 8.2 (1) (a): "If XV or YV is the null value, then "X <comp op> Y" is unknown." In this context, returning 'unknown' means returning NULL. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users