Import SQLite 3.10.2.

third_party/sqlite/src/test/vtab6.test

 # 2002 May 24
 #
 # The author disclaims copyright to this source code.  In place of
 # a legal notice, here is a blessing:
 #
 #    May you do good and not evil.
 #    May you find forgiveness for yourself and forgive others.
 #    May you share freely, never taking more than you give.
 #
 #***********************************************************************
@@ skipping 215 matching lines @@
 do_test vtab6-2.3 {
   catchsql {
     SELECT * FROM t1 NATURAL RIGHT OUTER JOIN t2;
   }
 } {1 {RIGHT and FULL OUTER JOINs are not currently supported}}
 do_test vtab6-2.4 {
   execsql {
     SELECT * FROM t1 LEFT JOIN t2 ON t1.a=t2.d
   }
 } {1 2 3 {} {} {} 2 3 4 {} {} {} 3 4 5 1 2 3}
+do_test vtab6-2.4.1 {
+  execsql {
+    SELECT * FROM t1 LEFT JOIN t2 ON t1.a IS t2.d
+  }
+} {1 2 3 {} {} {} 2 3 4 {} {} {} 3 4 5 1 2 3}
 do_test vtab6-2.5 {
   execsql {
     SELECT * FROM t1 LEFT JOIN t2 ON t1.a=t2.d WHERE t1.a>1
   }
 } {2 3 4 {} {} {} 3 4 5 1 2 3}
 do_test vtab6-2.6 {
   execsql {
     SELECT * FROM t1 LEFT JOIN t2 ON t1.a=t2.d WHERE t2.b IS NULL OR t2.b>1
   }
 } {1 2 3 {} {} {} 2 3 4 {} {} {}}
@@ skipping 318 matching lines @@
 } {1 {table ab: xBestIndex returned an invalid plan}}
 do_test vtab6-11.4.2 {
   catchsql {
     SELECT a, b, c FROM bc NATURAL JOIN ab;
   }
 } {1 {table bc: xBestIndex returned an invalid plan}}
 
 unset ::echo_module_ignore_usable
 
 finish_test