[sql] Import SQLite 3.17.0.

third_party/sqlite/src/test/where3.test

 # 2006 January 31
 #
 # 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 27 matching lines @@
     INSERT INTO t2 VALUES(4,444);
     CREATE INDEX t2i1 ON t2(p);
     
     INSERT INTO t3 VALUES(999,'nine');
     CREATE INDEX t3i1 ON t3(x);
     
     SELECT * FROM t1, t2 LEFT JOIN t3 ON q=x WHERE p=2 AND a=q;
   }
 } {222 two 2 222 {} {}}
 
-ifcapable explain {
+ifcapable explain&&!cursorhints {
   do_test where3-1.1.1 {
      explain_no_trace {SELECT * FROM t1, t2 LEFT JOIN t3 ON q=x
                         WHERE p=2 AND a=q}
   } [explain_no_trace {SELECT * FROM t1, t2 LEFT JOIN t3 ON x=q
                         WHERE p=2 AND a=q}]
 }
 
 # Ticket #1830
 #
 # This is similar to the above but with the LEFT JOIN on the
@@ skipping 20 matching lines @@
     INSERT INTO child1 ( child1key, value ) VALUES ( 'C1.3', 'Value for C1.3' );
     INSERT INTO child2 ( child2key, value ) VALUES ( 'C2.3', 'Value for C2.3' );
 
     SELECT parent1.parent1key, child1.value, child2.value
     FROM parent1
     LEFT OUTER JOIN child1 ON child1.child1key = parent1.child1key
     INNER JOIN child2 ON child2.child2key = parent1.child2key;
   }
 } {1 {Value for C1.1} {Value for C2.1} 2 {} {Value for C2.2} 3 {Value for C1.3} {Value for C2.3}}
 
-ifcapable explain {
+ifcapable explain&&!cursorhints {
   do_test where3-1.2.1 {
      explain_no_trace {
        SELECT parent1.parent1key, child1.value, child2.value
        FROM parent1
        LEFT OUTER JOIN child1 ON child1.child1key = parent1.child1key
        INNER JOIN child2 ON child2.child2key = parent1.child2key;
      }
   } [explain_no_trace {
        SELECT parent1.parent1key, child1.value, child2.value
        FROM parent1
@@ skipping 381 matching lines @@
   do_execsql_test where3-7.$disabled_opt.8 {
     SELECT x3 FROM t73 LEFT JOIN t74 ON x4=y3;
   } {123 123}
   do_execsql_test where3-7.$disabled_opt.9 {
     SELECT DISTINCT x3 FROM t73 LEFT JOIN t74 ON x4=y3;
   } {123}
 }
 
 
 finish_test