If it's meaningless then shouldn't it be a syntax error?
Michael D. Black Senior Scientist NG Information Systems Advanced Analytics Directorate ________________________________ From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Simon Slavin [slav...@bigfraud.org] Sent: Monday, August 01, 2011 4:43 PM To: General Discussion of SQLite Database Subject: EXT :Re: [sqlite] Virtual Table xBestIndex and NULL Search Conditions (Bug?) On 1 Aug 2011, at 9:47pm, Igor Sereda wrote: > So - who else thinks it's a bug? The SQL standard says 'NULL' means 'I don't know' or 'value missing' or something of the kind. So using a comparison like X > NULL doesn't mean anything, since there can't be a well-ordering principle for a missing value since there's nothing to compare it to. By the way, the recommended way to do what the original line of code does seems to be to use 'typeof(X)'. But I don't know how a beginner SQLite user is expected to know that. Simon. _______________________________________________ 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