Index: third_party/sqlite/src/test/fts3aa.test |
diff --git a/third_party/sqlite/src/test/fts3aa.test b/third_party/sqlite/src/test/fts3aa.test |
index 46304fb19c8b901b9f429e967986cd20e3f5ec90..5d79e9318f2657e219cceaabba67ab5f830f98eb 100644 |
--- a/third_party/sqlite/src/test/fts3aa.test |
+++ b/third_party/sqlite/src/test/fts3aa.test |
@@ -146,6 +146,7 @@ do_test fts3aa-3.3 { |
execsql {SELECT rowid FROM t1 WHERE content MATCH '-two one'} |
} {1 5 9 13 17 21 25 29} |
+breakpoint |
do_test fts3aa-4.1 { |
execsql {SELECT rowid FROM t1 WHERE content MATCH 'one OR two'} |
} {1 2 3 5 6 7 9 10 11 13 14 15 17 18 19 21 22 23 25 26 27 29 30 31} |
@@ -199,4 +200,28 @@ do_test fts3aa-6.4 { |
execsql {SELECT rowid FROM t1 WHERE t1 MATCH 'four'} |
} {-1 0 8 9 10 11 12 13 14 15 24 25 26 27 28 29 30 31} |
+# Test creation of FTS3 and FTS4 tables with columns that contain |
+# an "=" character. |
+# |
+do_execsql_test fts3aa-7.1 { |
+ CREATE VIRTUAL TABLE t2 USING fts3(xyz=abc); |
+ SELECT xyz FROM t2; |
+} {} |
+do_catchsql_test fts3aa-7.2 { |
+ CREATE VIRTUAL TABLE t3 USING fts4(xyz=abc); |
+} {1 {unrecognized parameter: xyz=abc}} |
+do_catchsql_test fts3aa-7.3 { |
+ CREATE VIRTUAL TABLE t3 USING fts4(xyz = abc); |
+} {1 {unrecognized parameter: xyz = abc}} |
+ |
+do_execsql_test fts3aa-7.4 { |
+ CREATE VIRTUAL TABLE t3 USING fts3(tokenize=simple, tokenize=simple); |
+ SELECT tokenize FROM t3; |
+} {} |
+do_catchsql_test fts3aa-7.5 { |
+ CREATE VIRTUAL TABLE t4 USING fts4(tokenize=simple, tokenize=simple); |
+} {1 {unrecognized parameter: tokenize=simple}} |
+ |
+ |
finish_test |
+ |