On Wed, Jul 14, 2010 at 8:17 AM, Igor Sereda <ser...@gmail.com> wrote:
> > On page http://www.sqlite.org/lang_expr.html : > > "When a SELECT is the right operand of the IN operator, the IN operator > returns TRUE if the SELECT result contains no NULLs and if the left operand > matches any of the values in the SELECT result." > > The part "SELECT result contains no NULLs" does not seem to hold true (and > for the better!): > Improvements to the IN operator documentation can be found here: http://www.sqlite.org/draft/lang_expr.html#in_op Note that in the process of making these documentation improvements, we discovered a bug in the NULL handling of the IN operator: http://www.sqlite.org/src/tktview/80e031a00f45dca877ed92b225209cfa09280f4f We are working to fix this bug prior to the 3.7.0 release. > > sqlite> SELECT 'selected' WHERE 1 IN (SELECT null UNION SELECT 1); > selected > > Cheers, > Igor > -- > View this message in context: > http://old.nabble.com/Documentation-error-in-explanation-of-%22IN-subquery%22-%28lang_expr.html%29-tp29161289p29161289.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 > -- --------------------- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users