Index: third_party/sqlite/src/test/view.test |
diff --git a/third_party/sqlite/src/test/view.test b/third_party/sqlite/src/test/view.test |
index 235f8605ac451baa69f20a62bd266e86425c6a83..694b3c6abd8590db93a3d0fe7128bfa189686b38 100644 |
--- a/third_party/sqlite/src/test/view.test |
+++ b/third_party/sqlite/src/test/view.test |
@@ -92,6 +92,26 @@ do_test view-1.8 { |
} |
} {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 |