Import SQLite 3.10.2.

third_party/sqlite/src/test/resolver01.test

 # 2013-04-13
 #
 # 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 tests features of the name resolver (the component that
 # figures out what identifiers in the SQL statement refer to) that
-# were fixed by ticket [2500cdb9be]
+# were fixed by ticket [2500cdb9be].
 #
 # See also tickets [1c69be2daf] and [f617ea3125] from 2013-08-14.
 #
+# Also a fuzzer-discovered problem on 2015-04-23.
+#
 
 set testdir [file dirname $argv0]
 source $testdir/tester.tcl
 
 # "ORDER BY y" binds to the output result-set column named "y"
 # if available.  If no output column is named "y", then try to
 # bind against an input column named "y".
 #
 # This is classical SQL92 behavior.
 #
@@ skipping 166 matching lines @@
 do_execsql_test resolver01-6.3 {
   CREATE TABLE t63(name);
   INSERT INTO t63 VALUES (NULL);
   INSERT INTO t63 VALUES ('abc');
   SELECT count(),
        NULLIF(name,'abc') AS name
     FROM t63
    GROUP BY lower(name);
 } {1 {} 1 {}}
 
+do_execsql_test resolver01-7.1 {
+  SELECT 2 AS x WHERE (SELECT x AS y WHERE 3>y);
+} {2}
+do_execsql_test resolver01-7.2 {
+  SELECT 2 AS x WHERE (SELECT x AS y WHERE 1>y);
+} {}
 
 
 
 
 finish_test