summaryrefslogtreecommitdiffstats
path: root/test/select7.test
diff options
context:
space:
mode:
authorDaniel Baumann <daniel.baumann@progress-linux.org>2024-09-19 04:07:40 +0000
committerDaniel Baumann <daniel.baumann@progress-linux.org>2024-09-19 04:07:40 +0000
commit9d2c15192c890a8876bcb9a2ef918756d03718b6 (patch)
tree8340f6a53cda0ba296d162c8c8d767086a337ff9 /test/select7.test
parentAdding upstream version 3.46.0. (diff)
downloadsqlite3-9d2c15192c890a8876bcb9a2ef918756d03718b6.tar.xz
sqlite3-9d2c15192c890a8876bcb9a2ef918756d03718b6.zip
Adding upstream version 3.46.1.upstream/3.46.1upstream
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'test/select7.test')
-rw-r--r--test/select7.test32
1 files changed, 32 insertions, 0 deletions
diff --git a/test/select7.test b/test/select7.test
index d705ebf..0c40510 100644
--- a/test/select7.test
+++ b/test/select7.test
@@ -155,6 +155,38 @@ if {[clang_sanitize_address]==0} {
}
}
+# https://issues.chromium.org/issues/358174302
+# Need to support an unlimited number of terms in a VALUES clause, even
+# if some of those terms contain double-quoted string literals.
+#
+do_execsql_test select7-6.5 {
+ DROP TABLE IF EXISTS t1;
+ CREATE TABLE t1(a,b,c);
+}
+sqlite3_limit db SQLITE_LIMIT_COMPOUND_SELECT 10
+sqlite3_db_config db SQLITE_DBCONFIG_DQS_DML 0
+do_catchsql_test select7-6.6 {
+ INSERT INTO t1 VALUES
+ (NULL,0,""), (X'',0.0,0.0), (X'',X'',""), (0.0,0.0,""), (NULL,NULL,0.0),
+ (0,"",0), (0.0,X'',0), ("",X'',0.0), (0.0,X'',NULL), (0,NULL,""),
+ (0,"",NULL), (0.0,NULL,X''), ("",X'',NULL), (NULL,0,""),
+ (0,NULL,0), (X'',X'',0.0);
+} {1 {no such column: "" - should this be a string literal in single-quotes?}}
+do_execsql_test select7-6.7 {
+ SELECT count(*) FROM t1;
+} {0}
+sqlite3_db_config db SQLITE_DBCONFIG_DQS_DML 1
+do_catchsql_test select7-6.8 {
+ INSERT INTO t1 VALUES
+ (NULL,0,""), (X'',0.0,0.0), (X'',X'',""), (0.0,0.0,""), (NULL,NULL,0.0),
+ (0,"",0), (0.0,X'',0), ("",X'',0.0), (0.0,X'',NULL), (0,NULL,""),
+ (0,"",NULL), (0.0,NULL,X''), ("",X'',NULL), (NULL,0,""),
+ (0,NULL,0), (X'',X'',0.0);
+} {0 {}}
+do_execsql_test select7-6.9 {
+ SELECT count(*) FROM t1;
+} {16}
+
# This block of tests verifies that bug aa92c76cd4 is fixed.
#
do_test select7-7.1 {