## Summary **No review yet** ## Minimized query ```sql PRAGMA full_column_names; .cd bugs BEGIN EXCLUSIVE; SAVEPOINT sp3113; CREATE TABLE t1(a INTEGER PRIMARY KEY, b TEXT, c INT, d INT); INSERT INTO t1 VALUES (atanh(NULL), 'Wernher', unicode('你好'), if(-(-(json_set(1, '$.key', 1))), 100, 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 ATTACH DATABASE ':memory:' AS aux64; ATTACH DATABASE ':memory:' AS aux0; -- if(NULL, {v}) ATTACH DATABASE ':memory:' AS aux28; .system false && echo "success" || echo "error code: $?" CREATE TABLE [T] ( a FLOAT, b REAL ); INSERT INTO T VALUES (json_array_length(log(-(-(CAST(exp(strftime('%Y-%m-%d', x'')) AS CHARINT))), length('你好')), '$'),CAST('{' AS CHARACTER(20))), (2,-7.25), (3,0.0); SELECT a,b FROM T WHERE NOT NOT (+a /**/ >= 2) ORDER BY b; DeLete FROM T WHERE +rowid = 85 RETURNING *; DELETE FROM T WHERE 0; SELECT LAG(b, 2, 'default') OVER (PARTITION BY b ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING OR CURRENT ROW EXCLUDE TIES) FROM T; DETACH DATABASE aux28; DETACH DATABASE aux0; DETACH DATABASE aux64; INSERT INTO t1 VALUES (NULL, NULL, NULL, NULL); INSERT OR ROLLBACK INTO t1 VALUES (0, 'x', NULL, NULL); DROP VIEW IF EXISTS t1; DELETE FROM t1 WHERE 1 RETURNING *; REINDEX t1; SELECT MAX(d) OVER (PARTITION BY d ORDER BY d ROWS BETWEEN 2 PRECEDING AND 2 FOLLOWING EXCLUDE CURRENT ROW) FROM t1; INSERT INTO t1 DEFAULT VALUES; RELEASE sp3113; ANALYZE t1; SELECT GROUP_CONCAT(b) FROM t1; COMMIT TRANSACTION; SELECT COUNT(*) FROM t1; UPDATE t1 SET a = a + 1 WHERE a IS NOT NULL; CREATE TABLE T ( a INTEGER, b TEXT, c REAL ); INSERT INTO T VALUES (1,'a',1.25), (2,'b',-3.5), (3,'c',0.0); SELECT * FROM T WHERE c < 2.0 ORDER BY c; .cd bugs BEGIN EXCLUSIVE; SAVEPOINT sp3113; CREATE TABLE t1(a INTEGER PRIMARY KEY, b TEXT, c INT, d INT); INSERT INTO t1 VALUES (atanh(NULL), 'Wernher', unicode('你好'), if(1, 100, 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 ATTACH DATABASE ':memory:' AS aux64; ATTACH DATABASE ':memory:' AS aux0; -- if(NULL, {v}) ATTACH DATABASE ':memory:' AS aux28; .system false && echo "success" || echo "error code: $?" CREATE TABLE [T] ( a FLOAT, b REAL ); INSERT INTO T VALUES (json_array_length(log(-(-(CAST(exp(strftime('%Y-%m-%d', x'')) AS CHARINT))), length('你好')), '$'),CAST('{' AS CHARACTER(20))), (2,-7.25), (3,0.0); SELECT a,b FROM T WHERE +a /**/ >= 2 ORDER BY b; DeLete FROM T WHERE +rowid = 85 RETURNING *; DELETE FROM T WHERE 0; SELECT LAG(b, 2, 'default') OVER (PARTITION BY b ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING OR CURRENT ROW EXCLUDE TIES) FROM T; DETACH DATABASE aux28; DETACH DATABASE aux0; DETACH DATABASE aux64; INSERT INTO t1 VALUES (NULL, NULL, NULL, NULL); INSERT OR ROLLBACK INTO t1 VALUES (0, 'x', NULL, NULL); DROP VIEW IF EXISTS t1; DELETE FROM t1 WHERE 1 RETURNING *; REINDEX t1; SELECT MAX(d) OVER (PARTITION BY d ORDER BY d ROWS BETWEEN 2 PRECEDING AND 2 FOLLOWING EXCLUDE CURRENT ROW) FROM t1; INSERT INTO t1 DEFAULT VALUES; RELEASE sp3113; ANALYZE t1; SELECT GROUP_CONCAT(b) FROM t1; COMMIT TRANSACTION; SELECT COUNT(*) FROM t1; UPDATE t1 SET a = a + 1 WHERE a IS NOT NULL; CREATE TABLE T ( a INTEGER, b TEXT, c REAL ); INSERT INTO T VALUES (1,'a',1.25), (2,'b',-3.5), (3,'c',0.0); SELECT * FROM T WHERE c < 2.0 ORDER BY c; .cd bugs BEGIN EXCLUSIVE; SAVEPOINT sp3113; CREATE TABLE t1(a INTEGER PRIMARY KEY, b TEXT, c INT, d INT); INSERT INTO t1 VALUES (atanh(NULL), 'Wernher', unicode('你好'), if(1, 100, 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 ATTACH DATABASE ':memory:' AS aux64; ATTACH DATABASE ':memory:' AS aux0; -- if(NULL, {v}) ATTACH DATABASE ':memory:' AS aux28; .system false && echo "success" || echo "error code: $?" CREATE TABLE [T] ( a FLOAT, b REAL ); INSERT INTO T VALUES (json_array_length(log(-(-(CAST(exp(strftime('%Y-%m-%d', x'')) AS CHARINT))), length('你好')), '$'),CAST('{' AS CHARACTER(20))), (2,-7.25), (3,0.0); SELECT a,b FROM T WHERE +a /**/ >= 2 ORDER BY b; DeLete FROM T WHERE +rowid = 85 RETURNING *; DELETE FROM T WHERE 0; SELECT LAG(b, 2, 'default') OVER (PARTITION BY b ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING OR CURRENT ROW EXCLUDE TIES) FROM T; DETACH DATABASE aux28; DETACH DATABASE aux0; DETACH DATABASE aux64; INSERT INTO t1 VALUES (NULL, NULL, NULL, NULL); INSERT OR ROLLBACK INTO t1 VALUES (0, 'x', NULL, NULL); DROP VIEW IF EXISTS t1; DELETE FROM t1 WHERE 1 RETURNING *; REINDEX t1; SELECT MAX(d) OVER (PARTITION BY d ORDER BY d ROWS BETWEEN 2 PRECEDING AND 2 FOLLOWING EXCLUDE CURRENT ROW) FROM t1; INSERT INTO t1 DEFAULT VALUES; RELEASE sp3113; ANALYZE t1; SELECT GROUP_CONCAT(b) FROM t1; COMMIT TRANSACTION; SELECT COUNT(*) FROM t1; UPDATE t1 SET a = a + 1 WHERE a IS NOT NULL; CREATE TABLE T ( a INTEGER, b TEXT, c REAL ); INSERT INTO T VALUES (1,'a',1.25), (2,'b',-3.5), (3,'c',0.0); SELECT * FROM T WHERE c < 2.0 ORDER BY c; .cd bugs BEGIN EXCLUSIVE; SAVEPOINT sp3113; CREATE TABLE t1(a INTEGER PRIMARY KEY, b TEXT, c INT, d INT); INSERT INTO t1 VALUES (atanh(NULL), 'Wernher', unicode('你好'), if(1, 100, 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 ATTACH DATABASE ':memory:' AS aux64; ATTACH DATABASE ':memory:' AS aux0; -- if(NULL, {v}) ATTACH DATABASE ':memory:' AS aux28; .system false && echo "success" || echo "error code: $?" CREATE TABLE [T] ( a FLOAT, b REAL ); INSERT INTO T VALUES (json_array_length(log(-(-(CAST(exp(strftime('%Y-%m-%d', x'')) AS CHARINT))), length('你好')), '$'),CAST('{' AS CHARACTER(20))), (2,-7.25), (3,0.0); SELECT a,b FROM T WHERE +a /**/ >= 2 ORDER BY b; DeLete FROM T WHERE +rowid = 85 RETURNING *; DELETE FROM T WHERE 0; SELECT LAG(b, 2, 'default') OVER (PARTITION BY b ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING OR CURRENT ROW EXCLUDE TIES) FROM T; DETACH DATABASE aux28; DETACH DATABASE aux0; DETACH DATABASE aux64; INSERT INTO t1 VALUES (NULL, NULL, NULL, NULL); INSERT OR ROLLBACK INTO t1 VALUES (0, 'x', NULL, NULL); DROP VIEW IF EXISTS t1; DELETE FROM t1 WHERE 1 RETURNING *; REINDEX t1; SELECT MAX(d) OVER (PARTITION BY d ORDER BY d ROWS BETWEEN 2 PRECEDING AND 2 FOLLOWING EXCLUDE CURRENT ROW) FROM t1; INSERT INTO t1 DEFAULT VALUES; RELEASE sp3113; ANALYZE t1; SELECT GROUP_CONCAT(b) FROM t1; COMMIT TRANSACTION; SELECT COUNT(*) FROM t1; UPDATE t1 SET a = a + 1 WHERE a IS NOT NULL; CREATE TABLE T ( a INTEGER, b TEXT, c REAL ); INSERT INTO T VALUES (1,'a',1.25), (2,'b',-3.5), (3,'c',0.0); SELECT * FROM T WHERE c < 2.0 ORDER BY c; .cd bugs BEGIN EXCLUSIVE; SAVEPOINT sp3113; CREATE TABLE t1(a INTEGER PRIMARY KEY, b TEXT, c INT, d INT); INSERT INTO t1 VALUES (atanh(NULL), 'Wernher', unicode('你好'), if(1, 100, 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 ATTACH DATABASE ':memory:' AS aux64; ATTACH DATABASE ':memory:' AS aux0; -- if(NULL, {v}) ATTACH DATABASE ':memory:' AS aux28; .system false && echo "success" || echo "error code: $?" CREATE TABLE [T] ( a FLOAT, b REAL ); INSERT INTO T VALUES (json_array_length(log(-(-(CAST(exp(strftime('%Y-%m-%d', x'')) AS CHARINT))), length('你好')), '$'),CAST('{' AS CHARACTER(20))), (2,-7.25), (3,0.0); SELECT a,b FROM T WHERE +a /**/ >= 2 ORDER BY b; DeLete FROM T WHERE +rowid = 85 RETURNING *; DELETE FROM T WHERE 0; SELECT LAG(b, 2, 'default') OVER (PARTITION BY b ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING OR CURRENT ROW EXCLUDE TIES) FROM T; DETACH DATABASE aux28; DETACH DATABASE aux0; DETACH DATABASE aux64; INSERT INTO t1 VALUES (NULL, NULL, NULL, NULL); INSERT OR ROLLBACK INTO t1 VALUES (0, 'x', NULL, NULL); DROP VIEW IF EXISTS t1; DELETE FROM t1 WHERE 1 RETURNING *; REINDEX t1; SELECT MAX(d) OVER (PARTITION BY d ORDER BY d ROWS BETWEEN 2 PRECEDING AND 2 FOLLOWING EXCLUDE CURRENT ROW) FROM t1; INSERT INTO t1 DEFAULT VALUES; RELEASE sp3113; ANALYZE t1; SELECT GROUP_CONCAT(b) FROM t1; COMMIT TRANSACTION; SELECT COUNT(*) FROM t1; UPDATE t1 SET a = a + 1 WHERE a IS NOT NULL; CREATE TABLE T ( a INTEGER, b TEXT, c REAL ); INSERT INTO T VALUES (1,'a',1.25), (2,'b',-3.5), (3,'c',0.0); SELECT * FROM T WHERE c < 2.0 ORDER BY c; .cd bugs BEGIN EXCLUSIVE; SAVEPOINT sp3113; CREATE TABLE t1(a INTEGER PRIMARY KEY, b TEXT, c INT, d INT); INSERT INTO t1 VALUES (atanh(NULL), 'Wernher', unicode('你好'), if(1, 100, 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 ATTACH DATABASE ':memory:' AS aux64; ATTACH DATABASE ':memory:' AS aux0; -- if(NULL, {v}) ATTACH DATABASE ':memory:' AS aux28; .system false && echo "success" || echo "error code: $?" CREATE TABLE [T] ( a FLOAT, b REAL ); INSERT INTO T VALUES (json_array_length(log(-(-(CAST(exp(strftime('%Y-%m-%d', x'')) AS CHARINT))), length('你好')), '$'),CAST('{' AS CHARACTER(20))), (2,-7.25), (3,0.0); SELECT a,b FROM T WHERE +a /**/ >= 2 ORDER BY b; DeLete FROM T WHERE +rowid = 85 RETURNING *; DELETE FROM T WHERE 0; SELECT LAG(b, 2, 'default') OVER (PARTITION BY b ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING OR CURRENT ROW EXCLUDE TIES) FROM T; DETACH DATABASE aux28; DETACH DATABASE aux0; DETACH DATABASE aux64; INSERT INTO t1 VALUES (NULL, NULL, NULL, NULL); INSERT OR ROLLBACK INTO t1 VALUES (0, 'x', NULL, NULL); DROP VIEW IF EXISTS t1; DELETE FROM t1 WHERE 1 RETURNING *; REINDEX t1; SELECT MAX(d) OVER (PARTITION BY d ORDER BY d ROWS BETWEEN 2 PRECEDING AND 2 FOLLOWING EXCLUDE CURRENT ROW) FROM t1; INSERT INTO t1 DEFAULT VALUES; RELEASE sp3113; ANALYZE t1; SELECT GROUP_CONCAT(b) FROM t1; COMMIT TRANSACTION; SELECT COUNT(*) FROM t1; UPDATE t1 SET a = a + 1 WHERE a IS NOT NULL; CREATE TABLE T ( a INTEGER, b TEXT, c REAL ); INSERT INTO T VALUES (1,'a',1.25), (2,'b',-3.5), (3,'c',0.0); SELECT * FROM T WHERE c < 2.0 ORDER BY c; .cd bugs BEGIN EXCLUSIVE; SAVEPOINT sp3113; CREATE TABLE t1(a INTEGER PRIMARY KEY, b TEXT, c INT, d INT); INSERT INTO t1 VALUES (atanh(NULL), 'Wernher', unicode('你好'), if(1, 100, 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 ATTACH DATABASE ':memory:' AS aux64; ATTACH DATABASE ':memory:' AS aux0; -- if(NULL, {v}) ATTACH DATABASE ':memory:' AS aux28; .system false && echo "success" || echo "error code: $?" CREATE TABLE [T] ( a FLOAT, b REAL ); INSERT INTO T VALUES (json_array_length(log(-(-(CAST(exp(strftime('%Y-%m-%d', x'')) AS CHARINT))), length('你好')), '$'),CAST('{' AS CHARACTER(20))), (2,-7.25), (3,0.0); SELECT a,b FROM T WHERE +a /**/ >= 2 ORDER BY b; DeLete FROM T WHERE +rowid = 85 RETURNING *; DELETE FROM T WHERE 0; SELECT LAG(b, 2, 'default') OVER (PARTITION BY b ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING OR CURRENT ROW EXCLUDE TIES) FROM T; DETACH DATABASE aux28; DETACH DATABASE aux0; DETACH DATABASE aux64; INSERT INTO t1 VALUES (NULL, NULL, NULL, NULL); INSERT OR ROLLBACK INTO t1 VALUES (0, 'x', NULL, NULL); DROP VIEW IF EXISTS t1; DELETE FROM t1 WHERE 1 RETURNING *; REINDEX t1; SELECT MAX(d) OVER (PARTITION BY d ORDER BY d ROWS BETWEEN 2 PRECEDING AND 2 FOLLOWING EXCLUDE CURRENT ROW) FROM t1; INSERT INTO t1 DEFAULT VALUES; RELEASE sp3113; ANALYZE t1; SELECT GROUP_CONCAT(b) FROM t1; COMMIT TRANSACTION; SELECT COUNT(*) FROM t1; UPDATE t1 SET a = a + 1 WHERE a IS NOT NULL; CREATE TABLE T ( a INTEGER, b TEXT, c REAL ); INSERT INTO T VALUES (1,'a',1.25), (2,'b',-3.5), (3,'c',0.0); SELECT * FROM T WHERE c < 2.0 ORDER BY c; .cd bugs BEGIN EXCLUSIVE; SAVEPOINT sp3113; CREATE TABLE t1(a INTEGER PRIMARY KEY, b TEXT, c INT, d INT); INSERT INTO t1 VALUES (atanh(NULL), 'Wernher', unicode('你好'), if(1, 100, 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 ATTACH DATABASE ':memory:' AS aux64; ATTACH DATABASE ':memory:' AS aux0; -- if(NULL, {v}) ATTACH DATABASE ':memory:' AS aux28; .system false && echo "success" || echo "error code: $?" CREATE TABLE [T] ( a FLOAT, b REAL ); INSERT INTO T VALUES (json_array_length(log(-(-(CAST(exp(strftime('%Y-%m-%d', x'')) AS CHARINT))), length('你好')), '$'),CAST('{' AS CHARACTER(20))), (2,-7.25), (3,0.0); SELECT a,b FROM T WHERE +a /**/ >= 2 ORDER BY b; DeLete FROM T WHERE +rowid = 85 RETURNING *; DELETE FROM T WHERE 0; SELECT LAG(b, 2, 'default') OVER (PARTITION BY b ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING OR CURRENT ROW EXCLUDE TIES) FROM T; DETACH DATABASE aux28; DETACH DATABASE aux0; DETACH DATABASE aux64; INSERT INTO t1 VALUES (NULL, NULL, NULL, NULL); INSERT OR ROLLBACK INTO t1 VALUES (0, 'x', NULL, NULL); DROP VIEW IF EXISTS t1; DELETE FROM t1 WHERE 1 RETURNING *; REINDEX t1; SELECT MAX(d) OVER (PARTITION BY d ORDER BY d ROWS BETWEEN 2 PRECEDING AND 2 FOLLOWING EXCLUDE CURRENT ROW) FROM t1; INSERT INTO t1 DEFAULT VALUES; RELEASE sp3113; ANALYZE t1; SELECT GROUP_CONCAT(b) FROM t1; COMMIT TRANSACTION; SELECT COUNT(*) FROM t1; UPDATE t1 SET a = a + 1 WHERE a IS NOT NULL; CREATE TABLE T ( a INTEGER, b TEXT, c REAL ); INSERT INTO T VALUES (1,'a',1.25), (2,'b',-3.5), (3,'c',0.0); SELECT * FROM T WHERE c < 2.0 ORDER BY c; INSERT INTO T DEFAULT VALUES; WITH cte AS (SELECT * FROM T) SELECT (SELECT COUNT(*) FROM cte) AS total, * FROM cte LIMIT 1; INSERT INTO t1 VALUES (NULL, NULL, NULL, NULL); INSERT INTO T DEFAULT VALUES; DROP TABLE IF EXISTS T; UPDATE t1 SET c = c + 1 WHERE c IS NOT NULL RETURNING *; SELECT * FROM T WHERE c NOT IN (SELECT c FROM T); SELECT COUNT(c) FILTER (WHERE c IS NOT NULL) OVER (PARTITION BY c ORDER BY c ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM t1; DROP TABLE IF EXISTS T; SELECT COUNT(*) FROM T; ALTER TABLE T RENAME COLUMN a TO a_r8411; VACUUM; ``` ## Actual output ```sql 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 von|20|2 Braun|30 von|20 ``` ## Expectation ```sql ``` ## Flag ``` ```