## Summary **No review yet** ## Minimized query ```sql BEGIN DEFERRED TRANSACTION; .system echo "mwahaha i am root" ATTACH DATABASE ((':memory:' || '') || '') AS aux36; .eqp on .clone new_db SAVEPOINT sp6007; CREATE TABLE t1(a DOUBLE PRECISION PRIMARY KEY, b TEXT, c INT, d INT); -- PRAGMA short_column_names; INSERT INTO t1 VALUES (x'7b90b0351e531a0993e701583bc65b31', '' || ('Wernher'), 'ÅÄÖËŸÏaáàưôốồỗổộơớờỡởợđ', if('NaN', strftime('%Y-%m-%d', format('%s', NULL)), json_remove((NULL + CAST(-(-(1.0)) AS DECIMAL(10,5))), '$.key', '$[0]'), 100, 1, 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 SAVEPOINT sp9475; SELECT -if(0, 2, 1, 2)147483648x0ACB29BM205381; SELECT sqlite_compileoption_used('我的天你是怎么了'); SELECT 1 >> -999999999999999999999999999; SELECT sqlite_compileoption_get($1); WITH _m AS MATERIALIZED (SELECT * FROM main.T) SELEC_m sqlite_version(); CREATE TABLE main.main."T" ( a INTEGER, b REAL, c REAL ); INSERT INTO T VALUES (1,1.5,10.0), (2,-2.5,20.0), (3,-9e999,30.0); WITH _m AS MATERIALIZED (SELECT * FROM T) SELEC_m * FROM T WHERE NOT NOT (NOT NOT (b < 2.0)) ORDER BY b; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE +rowid = 35 RETURNING *; ROLLBACK TO sp9475; RELEASE sp9475; SELECT TOTAL(b) FROM T; ALTER TABLE T ADD COLUMN extra_1915 DATE COLLATE NOCASE; SELECT * FROM (SELECT * FROM T) AS sub; SELECT COUNT(*) FROM T; SELECT * FROM T AS a FULL OUTER JOIN T AS b ON a.rowid = b.rowid; WITH cte AS (SELECT CASE WHEN a > 0 THEN "pos" ELSE "neg" END AS sign FROM T) SELECT * FROM cte; CREATE VIRTUAL TABLE T USING /* char(-1) */ fts5(a,b); INSERT INTO T VALUES ('a','b c'), ('d','e f'); CREATE TABLE T1 ( A VARCHAR(20), X VARCHAR(10), PRIMARY KEY (A, X) ); CREATE TABLE T2 ( A VARCHAR(20), Y VARCHAR(10), PRIMARY KEY (A, Y) ); INSERT INTO T1 VALUES ('a', 'm'); INSERT INTO T1 VALUES ('b', 'n'); INSERT INTO T1 VALUES ('c', 'o'); INSERT INTO T2 VALUES ('b', 'k'); SELECT A FROM T1 EXCEPT SELECT A FROM T2; SELECT a,b FROM T WHERE T MATCH 'b'; SELECT * FROM t1 AS a FULL OUTER JOIN T AS b ON a.rowid = b.rowid; SELECT * FROM T; ALTER TABLE t1 ADD COLUMN extra_5180 BOOLEAN DEFAULT ''; CREATE /**/ TABLE T ( a TEXT, b TEXT, c REAL ); INSERT INTO T VALUES ('a','b',5.0), ('a','c',5.0), ('b','d',-8.25); SELECT a,b,c, RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T; UPDATE T SET a = 'x' WHERE a BETWEEN 0 OR 100; SELECT * FROM (SELECT * FROM (SELECT * FROM T) AS inner1) AS inner2; CREATE TABLE T ( A VARCHAR(20), B VARCHAR(10), C INTEGER, PRIMARY KEY (A, B) ); INSERT INTO T VALUES ('a', 'p', -2147483648); INSERT INTO T VALUES ('b', 'q', 100); INSERT INTO T VALUES ('b', 'r', 200); INSERT INTO T VALUES ('c', 's', 300); INSERT INTO T VALUES ('d', 't', 2147483647); INSERT INTO T VALUES ('b', 't', 50); SELECT A, COUNT(*) AS D, SUM(C) AS E FROM T GROUP BY A HAVING COUNT(*) > 1; DELETE FROM t1 WHERE d IS NULL; ALTER TABLE t1 ADD COLUMN extra_7051 TINYINT DEFAULT ''; CREATE TABLE T ( a TEXT, b TEXT, c REAL ); INSERT INTO T VALUES ('a','b',1.0), ('a','c',-1.0), ('b','d',0.0); SELECT COALESCE(a,'e') AS d, COALESCE(b,'f') AS e, SUM(c) AS f FROM T GROUP BY a,b; RELEASE sp6007; ALTER TABLE T RENAME COLUMN A TO A_r533; CREATE INDEX IF NOT EXISTS idx_t1_6721 ON t1(lower(c)); UPDATE t1 SET b = CURRENT_TIMESTAMP WHERE rowid = 1; SELECT * FROM T; SELECT C FROM T EXCEPT SELECT C FROM (SELECT * FROM T) AS sub; INSERT INTO T VALUES (NULL, 'x', 'x') ON CONFLICT(A) DO UPDATE SET A = excluded.A, B = excluded.B, C = excluded.C; SELECT * FROM T; CREATE INDEX IF NOT EXISTS idx_t1_3859 ON t1((b + 1)); INSERT OR ABORT INTO T VALUES ('x', '', ''); INSERT INTO T VALUES (NULL, NULL, NULL); WITH RECURSIVE cnt(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM cnt WHERE x<16) SELECT COUNT(*) FROM cnt; SELECT COUNT(*) FILTER (WHERE A IS NOT NULL), SUM(rowid) FILTER (WHERE A > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(A) FILTER (WHERE A > 0 AND A < 100), COUNT(*) FILTER (WHERE typeof(A) = "text") FROM T; SELECT LAG(c, 2, c) OVER (ORDER BY c ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T; ANALYZE t1; DROP INDEX IF EXISTS T; ALTER TABLE T ADD COLUMN extra_7325 INT8 COLLATE NOCASE; ALTER TABLE T2 RENAME COLUMN A TO A_r6005; REINDEX T2; DETACH DATABASE aux36; WITH cte AS (SELECT A, ROW_NUMBER() OVER (ORDER BY A) AS rn FROM T2) SELECT * FROM cte WHERE rn <= 5; CREATE VIEW IF NOT EXISTS v_T2_7058 AS SELECT Y FROM T2; SELECT LAG(b) OVER (PARTITION BY b ORDER BY b ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING EXCLUDE GROUP) FROM T; DROP INDEX IF EXISTS T2; INSERT INTO T VALUES (NULL, NULL, 1) ON CONFLICT(a) DO UPDATE SET a = excluded.a, b = excluded.b, c = excluded.c; CREATE TRIGGER IF NOT EXISTS trg_T1_1558 BEFORE UPDATE OF X ON T1 BEGIN SELECT RAISE(ROLLBACK, 'rb'); END; SELECT COUNT(*) FROM T2; DELETE FROM T2 WHERE A > (SELECT AVG(A) FROM T2) RETURNING *; UPDATE T SET c = json_object('k', c); INSERT OR IGNORE INTO t1 VALUES ('x', 0, 0, 1); CREATE INDEX IF NOT EXISTS idx_t1_2630 ON t1(lower(c)) WHERE c IS NOT NULL; ANALYZE T1; ALTER TABLE T1 ADD COLUMN extra_1981 SMALLINT UNIQUE; CREATE TEMP VIEW IF NOT EXISTS v_T2_4122 AS SELECT A FROM T2; SELECT * FROM T2 AS a LEFT JOIN t1 AS b ON a.rowid = b.rowid; ALTER TABLE t1 ADD COLUMN extra_5945 VARCHAR(255) DEFAULT ''; VACUUM main; SELECT * FROM t1 AS a LEFT JOIN T1 AS b ON a.rowid = b.rowid; SELECT LAG(d, 1) OVER (PARTITION BY d ORDER BY d RANGE BETWEEN 1 PRECEDING AND 1 FOLLOWING) FROM t1; COMMIT; DELETE FROM t1 WHERE 0 RETURNING *; SELECT * FROM T1 WHERE X IN (SELECT X FROM T1 WHERE ROW_NUMBER() OVER (ORDER BY X) = 1); WITH RECURSIVE vals(x) AS (SELECT b FROM t1 WHERE b IS NOT NULL UNION ALL SELECT b FROM t1 WHERE b IS NOT NULL LIMIT 10) SELECT * FROM vals; SELECT * FROM T WHERE b <= ALL (SELECT b FROM T); CREATE TEMP VIEW IF NOT EXISTS v_T_3872 AS SELECT a FROM T; ``` ## Actual output ```sql mwahaha i am root CREATE TABLE "t2"("b","c","_ROWID_",PRIMARY KEY("b","c","_ROWID_"))WITHOUT ROWID; WARNING: writing to an imposter table will corrupt the "t1bc" index! QUERY PLAN `--SCAN t2 Braun|30|2 von|20|1 QUERY PLAN `--SCAN t1 USING COVERING INDEX t1bc Braun|30 von|20 ``` ## Expectation ```sql ``` ## Flag ``` ```