aboutsummaryrefslogtreecommitdiff
path: root/test/func.test
diff options
context:
space:
mode:
authordrh <>2022-01-16 19:11:13 +0000
committerdrh <>2022-01-16 19:11:13 +0000
commit7d44b22d45a55a2783a32e67d5bd4487fcb4d00c (patch)
tree3b5ed9d462176b8c55191c805027f48cfa4a4200 /test/func.test
parent72e30421c89695319fa43de906a70ff862fcfe89 (diff)
downloadsqlite-7d44b22d45a55a2783a32e67d5bd4487fcb4d00c.tar.gz
sqlite-7d44b22d45a55a2783a32e67d5bd4487fcb4d00c.zip
Fix test cases so that they all still work even with -DSQLITE_DQS=0.
FossilOrigin-Name: 4883776669ee2f2310ea82b0d6df4d008eebaa7cb252102539cf21a635402ebb
Diffstat (limited to 'test/func.test')
-rw-r--r--test/func.test14
1 files changed, 7 insertions, 7 deletions
diff --git a/test/func.test b/test/func.test
index 008819baa..df9d4dacf 100644
--- a/test/func.test
+++ b/test/func.test
@@ -1007,32 +1007,32 @@ do_test func-21.2 {
} {1 {wrong number of arguments to function replace()}}
do_test func-21.3 {
execsql {
- SELECT typeof(replace("This is the main test string", NULL, "ALT"));
+ SELECT typeof(replace('This is the main test string', NULL, 'ALT'));
}
} {null}
do_test func-21.4 {
execsql {
- SELECT typeof(replace(NULL, "main", "ALT"));
+ SELECT typeof(replace(NULL, 'main', 'ALT'));
}
} {null}
do_test func-21.5 {
execsql {
- SELECT typeof(replace("This is the main test string", "main", NULL));
+ SELECT typeof(replace('This is the main test string', 'main', NULL));
}
} {null}
do_test func-21.6 {
execsql {
- SELECT replace("This is the main test string", "main", "ALT");
+ SELECT replace('This is the main test string', 'main', 'ALT');
}
} {{This is the ALT test string}}
do_test func-21.7 {
execsql {
- SELECT replace("This is the main test string", "main", "larger-main");
+ SELECT replace('This is the main test string', 'main', 'larger-main');
}
} {{This is the larger-main test string}}
do_test func-21.8 {
execsql {
- SELECT replace("aaaaaaa", "a", "0123456789");
+ SELECT replace('aaaaaaa', 'a', '0123456789');
}
} {0123456789012345678901234567890123456789012345678901234567890123456789}
@@ -1315,7 +1315,7 @@ do_test func-29.1 {
CREATE TABLE t29(id INTEGER PRIMARY KEY, x, y);
INSERT INTO t29 VALUES(1, 2, 3), (2, NULL, 4), (3, 4.5, 5);
INSERT INTO t29 VALUES(4, randomblob(1000000), 6);
- INSERT INTO t29 VALUES(5, "hello", 7);
+ INSERT INTO t29 VALUES(5, 'hello', 7);
}
db close
sqlite3 db test.db