Import SQLite 3.10.2.

third_party/sqlite/src/test/fts4content.test

 # 2011 October 03
 #
 # 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 30 matching lines @@
 #   
 #   7.* - Test that if content=xxx is specified and table xxx does not
 #         exist, the FTS table can still be used for INSERT and some
 #         SELECT statements.
 #
 #   8.* - Test that if the content=xxx and prefix options are used together,
 #         the 'rebuild' command still works.
 #
 #   9.* - Test using content=xxx where xxx is a virtual table.
 #
+#   11.* - Test that circular references (e.g. "t1(content=t1)") are
+#          detected.
+#
 
 do_execsql_test 1.1.1 {
   CREATE TABLE t1(a, b, c);
   INSERT INTO t1 VALUES('w x', 'x y', 'y z');
   CREATE VIRTUAL TABLE ft1 USING fts4(content=t1);
 }
 
 do_execsql_test 1.1.2 {
   PRAGMA table_info(ft1);
 } {
@@ skipping 338 matching lines @@
   SELECT name FROM sqlite_master WHERE name LIKE '%t5%';
 } {
   t5 t5_content
 }
 
 #-------------------------------------------------------------------------
 # Test cases 6.* test 
 # 
 do_catchsql_test 6.1.1 {
   CREATE VIRTUAL TABLE ft7 USING fts4(content=t7);
-} {1 {vtable constructor failed: ft7}}
+} {1 {no such table: main.t7}}
 
 do_execsql_test 6.2.1 {
   CREATE TABLE t7(one, two);
   CREATE VIRTUAL TABLE ft7 USING fts4(content=t7);
   INSERT INTO t7 VALUES('A B', 'B A');
   INSERT INTO t7 VALUES('C D', 'A A');
   SELECT * FROM ft7;
 } {
   {A B} {B A} {C D} {A A}
 }
 
 do_catchsql_test 6.2.2 {
   DROP TABLE t7;
   SELECT * FROM ft7;
 } {1 {SQL logic error or missing database}}
 
 db close
 sqlite3 db test.db
 do_execsql_test 6.2.3 {
   SELECT name FROM sqlite_master WHERE name LIKE '%t7%'
 } {
   ft7 ft7_segments ft7_segdir sqlite_autoindex_ft7_segdir_1 
   ft7_docsize ft7_stat
 }
 do_catchsql_test 6.2.4 {
   SELECT * FROM ft7;
-} {1 {vtable constructor failed: ft7}}
+} {1 {no such table: main.t7}}
 do_execsql_test 6.2.5 {
   CREATE TABLE t7(x, y);
   INSERT INTO t7 VALUES('A B', 'B A');
   INSERT INTO t7 VALUES('C D', 'A A');
   SELECT * FROM ft7;
 } {
   {A B} {B A} {C D} {A A}
 }
 
 do_execsql_test 6.2.6 {
@@ skipping 130 matching lines @@
 write_file t2.txt {a b c d e f g h i j k l m a b c d e f g h i j k l m}
 write_file t3.txt {n o p q r s t u v w x y z n o p q r s t u v w x y z}
 
 do_execsql_test 10.1 {
   CREATE TABLE idx(id INTEGER PRIMARY KEY, path TEXT);
   INSERT INTO idx VALUES (1, 't1.txt');
   INSERT INTO idx VALUES (2, 't2.txt');
   INSERT INTO idx VALUES (3, 't3.txt');
 
   CREATE VIRTUAL TABLE vt USING fs(idx);
-  SELECT * FROM vt;
+  SELECT path, data FROM vt;
 } {
   1 {a b c d e f g h i j k l m n o p q r s t u v w x y z} 
   2 {a b c d e f g h i j k l m a b c d e f g h i j k l m}
   3 {n o p q r s t u v w x y z n o p q r s t u v w x y z}
 }
 
 do_execsql_test 10.2 {
-  SELECT * FROM vt WHERE rowid = 2;
+  SELECT path, data FROM vt WHERE rowid = 2;
 } {
   2 {a b c d e f g h i j k l m a b c d e f g h i j k l m}
 }
 
 do_execsql_test 10.3 {
   CREATE VIRTUAL TABLE ft USING fts4(content=vt);
   INSERT INTO ft(ft) VALUES('rebuild');
 }
 
 do_execsql_test 10.4 {
   SELECT snippet(ft, '[', ']', '...', -1, 5) FROM ft WHERE ft MATCH 'e'
 } {
   {...c d [e] f g...} {...c d [e] f g...}
 }
 
 do_execsql_test 10.5 {
   SELECT snippet(ft, '[', ']', '...', -1, 5) FROM ft WHERE ft MATCH 't'
 } {
   {...r s [t] u v...} {...r s [t] u v...}
 }
 
 do_execsql_test 10.6 { DELETE FROM ft WHERE docid=2 }
 
 do_execsql_test 10.7 {
   SELECT snippet(ft, '[', ']', '...', -1, 5) FROM ft WHERE ft MATCH 'e'
 } {
   {...c d [e] f g...}
 }
 
+#-------------------------------------------------------------------------
+# Test cases 11.*
+# 
+reset_db
+
+do_catchsql_test 11.1 {
+  CREATE VIRTUAL TABLE x1 USING fts4(content=x1);
+} {1 {vtable constructor called recursively: x1}}
+
+
 finish_test
+