aboutsummaryrefslogtreecommitdiff
path: root/test/fts3ak.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/fts3ak.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/fts3ak.test')
-rw-r--r--test/fts3ak.test26
1 files changed, 13 insertions, 13 deletions
diff --git a/test/fts3ak.test b/test/fts3ak.test
index a263f0b74..080efe52b 100644
--- a/test/fts3ak.test
+++ b/test/fts3ak.test
@@ -21,17 +21,17 @@ ifcapable !fts3 {
db eval {
CREATE VIRTUAL TABLE t1 USING fts3(content);
- INSERT INTO t1 (rowid, content) VALUES(1, "hello world");
- INSERT INTO t1 (rowid, content) VALUES(2, "hello there");
- INSERT INTO t1 (rowid, content) VALUES(3, "cruel world");
+ INSERT INTO t1 (rowid, content) VALUES(1, 'hello world');
+ INSERT INTO t1 (rowid, content) VALUES(2, 'hello there');
+ INSERT INTO t1 (rowid, content) VALUES(3, 'cruel world');
}
# Test that possibly-buffered inserts went through after commit.
do_test fts3ak-1.1 {
execsql {
BEGIN TRANSACTION;
- INSERT INTO t1 (rowid, content) VALUES(4, "false world");
- INSERT INTO t1 (rowid, content) VALUES(5, "false door");
+ INSERT INTO t1 (rowid, content) VALUES(4, 'false world');
+ INSERT INTO t1 (rowid, content) VALUES(5, 'false door');
COMMIT TRANSACTION;
SELECT rowid FROM t1 WHERE t1 MATCH 'world';
}
@@ -42,8 +42,8 @@ do_test fts3ak-1.1 {
do_test fts3ak-1.2 {
execsql {
BEGIN TRANSACTION;
- INSERT INTO t1 (rowid, content) VALUES(6, "another world");
- INSERT INTO t1 (rowid, content) VALUES(7, "another test");
+ INSERT INTO t1 (rowid, content) VALUES(6, 'another world');
+ INSERT INTO t1 (rowid, content) VALUES(7, 'another test');
SELECT rowid FROM t1 WHERE t1 MATCH 'world';
COMMIT TRANSACTION;
}
@@ -54,8 +54,8 @@ do_test fts3ak-1.2 {
do_test fts3ak-1.3 {
execsql {
BEGIN TRANSACTION;
- INSERT INTO t1 (rowid, content) VALUES(8, "second world");
- INSERT INTO t1 (rowid, content) VALUES(9, "second sight");
+ INSERT INTO t1 (rowid, content) VALUES(8, 'second world');
+ INSERT INTO t1 (rowid, content) VALUES(9, 'second sight');
SELECT rowid FROM t1 WHERE t1 MATCH 'world';
ROLLBACK TRANSACTION;
}
@@ -73,8 +73,8 @@ do_test fts3ak-1.4 {
do_test fts3ak-1.5 {
execsql {
BEGIN TRANSACTION;
- INSERT INTO t1 (rowid, content) VALUES(10, "second world");
- INSERT INTO t1 (rowid, content) VALUES(11, "second sight");
+ INSERT INTO t1 (rowid, content) VALUES(10, 'second world');
+ INSERT INTO t1 (rowid, content) VALUES(11, 'second sight');
ROLLBACK TRANSACTION;
SELECT rowid FROM t1 WHERE t1 MATCH 'world';
}
@@ -84,7 +84,7 @@ do_test fts3ak-1.5 {
do_test fts3ak-1.6 {
execsql {
BEGIN;
- INSERT INTO t1 (rowid, content) VALUES(12, "third world");
+ INSERT INTO t1 (rowid, content) VALUES(12, 'third world');
COMMIT;
SELECT rowid FROM t1 WHERE t1 MATCH 'third';
}
@@ -95,7 +95,7 @@ do_test fts3ak-1.6 {
do_test fts3ak-1.7 {
execsql {
BEGIN;
- INSERT INTO t1 (rowid, content) VALUES(13, "third dimension");
+ INSERT INTO t1 (rowid, content) VALUES(13, 'third dimension');
CREATE TABLE x (c);
COMMIT;
SELECT rowid FROM t1 WHERE t1 MATCH 'dimension';