Import SQLite 3.10.2.

third_party/sqlite/src/test/autoindex1.test

 # 2010 April 07
 #
 # 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.
 #
 #*************************************************************************
 # This file implements regression tests for SQLite library.  The
 # focus of this script is testing automatic index creation logic.
 #
+# EVIDENCE-OF: R-34271-33106 PRAGMA automatic_index; PRAGMA
+# automatic_index = boolean; Query, set, or clear the automatic indexing
+# capability.
 
 set testdir [file dirname $argv0]
 source $testdir/tester.tcl
 
 # If the library is not compiled with automatic index support then
 # skip all tests in this file.
 #
 ifcapable {!autoindex} {
   finish_test
   return
@@ skipping 478 matching lines @@
 do_execsql_test autoindex1-901 {
   CREATE TABLE t1(x INTEGER PRIMARY KEY, y, z);
   CREATE TABLE t2(a, b);
   CREATE VIEW agg2 AS SELECT a, sum(b) AS m FROM t2 GROUP BY a;
   EXPLAIN QUERY PLAN
   SELECT t1.z, agg2.m
     FROM t1 JOIN agg2 ON t1.y=agg2.m
    WHERE t1.x IN (1,2,3);
 } {/USING AUTOMATIC COVERING INDEX/}
 
+# 2015-04-15:  A NULL CollSeq pointer in automatic index creation.
+#
+do_execsql_test autoindex1-920 {
+  CREATE TABLE t920(x);
+  INSERT INTO t920 VALUES(3),(4),(5);
+  SELECT * FROM t920,(SELECT 0 FROM t920),(VALUES(9)) WHERE 5 IN (x);
+} {5 0 9 5 0 9 5 0 9}
 
 finish_test