[sql] Import SQLite 3.17.0.

third_party/sqlite/src/test/view.test

 # 2002 February 26
 #
 # 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 74 matching lines @@
   }
 } {2 3 5 6 8 9}
 do_test view-1.8 {
   db close
   sqlite3 db test.db
   execsql {
     SELECT * FROM v1 ORDER BY a;
   }
 } {2 3 5 6 8 9}
 
+do_execsql_test view-1.10 {
+  CREATE TABLE t9(x INTEGER);
+  CREATE VIEW v9a AS SELECT x FROM t9;
+  CREATE VIEW v9b AS SELECT * FROM t9;
+  CREATE VIEW v9c(x) AS SELECT x FROM t9;
+  CREATE VIEW v9d(x) AS SELECT * FROM t9;
+} {}
+do_execsql_test view-1.11 {
+  PRAGMA table_info(v9a);
+} {0 x INTEGER 0 {} 0}
+do_execsql_test view-1.12 {
+  PRAGMA table_info(v9b);
+} {0 x INTEGER 0 {} 0}
+do_execsql_test view-1.13 {
+  PRAGMA table_info(v9c);
+} {0 x INTEGER 0 {} 0}
+do_execsql_test view-1.14 {
+  PRAGMA table_info(v9d);
+} {0 x INTEGER 0 {} 0}
+
 do_test view-2.1 {
   execsql {
     CREATE VIEW v2 AS SELECT * FROM t1 WHERE a>5
   };  # No semicolon
   execsql2 {
     SELECT * FROM v2;
   }
 } {x 7 a 8 b 9 c 10}
 do_test view-2.2 {
   catchsql {
@@ skipping 544 matching lines @@
   SELECT * FROM x1;
 } {123 234 345}
 do_test view-22.2 {
   unset -nocomplain x
   db eval {SELECT * FROM x1} x break
   lsort [array names x]
 } {{} * :1 :2}
 
 
 finish_test