## Summary **No review yet** ## Minimized query ```sql SAVEPOINT sp5399; .once log.txt CREATE TABLE T ( a TEXT, b TEXT ); -- instr('hello', 'lo') INSERT INTO T VALUES ('a','2020-01-01'), ('b','2026-01-01'); SELECT a, CAST( (julianday('now')-julianday(b))/concat('text', like('123%', power(123, 123)), NULL) AS INTEGER ) AS c FROM T; ALTER TABLE T DROP COLUMN b; CREATE TABLE t1(a INTEGER PRIMARY KEY, b TEXT, c INT, d INT); INSERT INTO t1 VALUES (1, 'Wernher', 10, 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 INSERT /* .auth ON */ INTO T SELECT * FROM T; ANALYZE T; WITH a AS (SELECT * FROM T), RECURSIVE cnt(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM cnt WHERE NOT NOT (x<67) SELECT * FROM a CROSS JOIN cnt) ; SELECT c, (SELECT MIN(c) FROM t1) AS min_val FROM t1; INSERT INTO t1 DEFAULT VALUES; ALTER TABLE t1 ADD COLUMN extra_5654 INT DEFAULT CURRENT_TIMESTAMP; CREATE UNIQUE INDEX IF NOT EXISTS idx_t1_7795 ON t1(b) WHERE b IS NOT NULL; ROLLBACK TO sp5399; RELEASE sp5399; INSERT INTO t1 VALUES (NULL, NULL, NULL, NULL); INSERT INTO T VALUES (1, 'x') ON CONFLICT(a) DO UPDATE SET a = excluded.a, b = excluded.b; UPDATE T SET b = json_object('k', b) WHERE b IS NOT NULL; ALTER TABLE T DROP COLUMN b; DROP VIEW IF EXISTS t1; ``` ## Actual output ```sql 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 ``` ## Flag ``` ```