## Summary **No review yet** ## Minimized query ```sql .headers off ATTACH DATABASE ':memory:' AS aux55; -- if(0, {v}, 0, {v}, 0, {v}, {v}) BEGIN EXCLUSIVE; SAVEPOINT sp5645; PRAGMA page_count; PRAGMA count_changes; PRAGMA count_changes = FALSE; PRAGMA trusted_schema = ON; CREATE TABLE [t1](a VARCHAR(9223372036854775808) PRIMARY KEY, b TEXT, c INT, d INT); INSERT INTO t1 VALUES (ifnull('a', 'b'), 'Wernher', (10 + 0.0), 100); INSERT INTO t1 VALUES (2, 'von', 20, 200); INSERT INTO t1 VALUES (3, 'Braun', 30, 300); CREATE INDEX t1bc ON t1(b, c); PRAGMA writable_schema = ON; .imposter t1bc t2 SELECT * FROM t2; SELECT b, c FROM t1 ORDER BY b, c; .quit .tables non_existent_table CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL ); INSERT INTO T VALUES (round(1.0, 2),'a',1.25), (2,'b',-3.5), (3,'c',9e999); WITH d AS (SELECT * FROM T) SELECT * FROM d WHERE +c > 0; INSERT INTO T VALUES (NULL, NULL, NULL); SELECT NTH_VALUE(b, b) OVER (PARTITION BY b ORDER BY b ROWS BETWEEN 2 PRECEDING OR 2 FOLLOWING EXCLUDE CURRENT ROW) FROM T; VACUUM main; PRAGMA locking_mode = 'NORMAL'; PRAGMA auto_vacuum = 0; SELECT * FROM t1 AS a RIGHT OUTER JOIN t1 AS b ON a.rowid = b.rowid; INSERT OR ROLLBACK INTO t1 VALUES (NULL, 'x', -7, 0); SELECT * FROM t1 WHERE (c) IN (SELECT c FROM t1); UPDATE t1 SET b = 79 WHERE b BETWEEN 0 AND 100; SELECT MIN(d) FROM t1; ROLLBACK TRANSACTION TO SAVEPOINT sp5645; RELEASE SAVEPOINT sp5645; SELECT GROUP_CONCAT(a) FROM t1; COMMIT TRANSACTION; INSERT INTO t1 DEFAULT VALUES; VACUUM main; SELECT * FROM t1 NATURAL JOIN t1; DROP TABLE IF EXISTS t1; ALTER TABLE t1 RENAME TO t1_r5125; DETACH DATABASE aux55; ``` ## Actual output ```sql 1 0 CREATE TABLE "t2"("b","c","_ROWID_",PRIMARY KEY("b","c","_ROWID_"))WITHOUT ROWID; WARNING: writing to an imposter table will corrupt the "t1bc" index! Braun|30|3 Wernher|10|1 von|20|2 Braun|30 Wernher|10 von|20 ``` ## Expectation ```sql 1 0 CREATE TABLE "t2"("b","c","_ROWID_",PRIMARY KEY("b","c","_ROWID_"))WITHOUT ROWID; Braun|30|3 Wernher|10|1 von|20|2 Braun|30 Wernher|10 von|20 ``` ## Flag ``` ```