## Summary **No review yet** ## Minimized query ```sql SAVEPOINT sp1179; PRAGMA reverse_unordered_selects = NO; PRAGMA short_column_names = TRUE; .databases SAVEPOINT sp5671; .once log.txt ATTACH DATABASE ('' || '') || ('') || (':memory:') AS aux78; .limit CREATE TABLE [T1] ( a INT2, b REAL ); CREATE TABLE T2 ( a INTEGER, b REAL ); INSERT INTO T1 VALUES (ifnull(timediff(concat_ws(',', CAST(upper(-(-(-json_array_length(strftime('%s', sinh(lower('HELLO'))))))) AS INT2), format(NULL, if(NULL, NULL, NULL)), datetime(unhex('4G'), '+1 day')), lower('HeLLo')), (2 + 0.0)),1.0); INSERT INTO T2 VALUES (1,-1.0),(2,9e999); INSERT OR REPLACE INTO T1 SELECT * FROM T2; SELECT * FROM T1; PRAGMA writable_schema = YES; SAVEPOINT sp6649; ATTACH DATABASE ':memory:' AS aux69; .quit .trace CREATE TABLE main.T ( a DOUBLE, b TEXT, c REAL ); INSERT INTO T VALUES (CAST(json_array_length(if(CAST(-(-(length(randomblob(CAST(mod(1.7976931348623157e+308, 1465368752231950166) AS INTEGER))))) AS TINYINT), 1, 0, 1, 0, 1), '$') AS NUMERIC),'a',3.14), (1,'b',-7.75), (2,'c',-9e999); WITH _m AS MATERIALIZED (SELECT * FROM t1) SELECT b,a,c, RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T; ATTACH DATABASE ':memory:' AS aux86; PRAGMA full_column_names = YES; DROP TABLE IF EXISTS _m; CREATE TABLE t1 (c0, c1 REAL PRIMARY KEY); INSERT INTO t1(c0, c1) VALUES ('{', -(-(1))), (0, 0); UPDATE t1 SET c0 = NULL; UPDATE OR REPLACE t1 SET c1 = 1; SELECT DISTINCT * FROM t1 WHERE NOT NOT (NOT NOT (t1.c0 IS NULL)) ; PRAGMA integrity_check; SELECT COUNT(*) FROM t1; SELECT * FROM t1; DETACH DATABASE aux86; REINDEX; ALTER TABLE T ADD COLUMN extra_5481 BLOB NOT NULL DEFAULT 0; SELECT COUNT(*) FROM T; CREATE TABLE T ( a TEXT, b TEXT ); INSERT INTO T VALUES ('a','b'), ('c','d'); SELECT * FROM T WHERE +a = REPLACE('a;',';','') AND b = 'b'; CREATE TABLE T1 ( A VARCHAR(15) PRIMARY KEY, B VARCHAR(30) NOT NULL UNIQUE ); CREATE TABLE T2 ( A VARCHAR(10) PRIMARY KEY, X VARCHAR(15) NOT NULL, C BIGINT, FOREIGN KEY (X) REFERENCES T1(A) ); INSERT INTO T1 VALUES ('p', 'x'); INSERT INTO T1 VALUES ('q', 'y'); INSERT INTO T2 VALUES ('a', 'p', 9223372036854775807); INSERT INTO T2 VALUES ('b', 'q', -9223372036854775808); SELECT X, SUM(C) AS D, COUNT(*) AS E FROM T2 GROUP BY X; SELECT LAG(c0, 2, 'default') OVER (PARTITION BY c0 ORDER BY c0 ROWS BETWEEN 2 PRECEDING AND 2 FOLLOWING EXCLUDE CURRENT ROW) FROM t1; SELECT * FROM t1; CREATE VIEW IF NOT EXISTS v_t1_6883 AS SELECT c1 FROM t1; ALTER TABLE t1 ADD COLUMN extra_3184 INT2 COLLATE NOCASE; SELECT * FROM t1; REINDEX; SELECT c, COUNT(*) FROM T GROUP BY c HAVING COUNT(*) = (SELECT COUNT(*) FROM T); 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; PRAGMA temp_store = 'MEMORY'; VACUUM main; SELECT * FROM T1 WHERE EXISTS (SELECT 1 FROM T1 WHERE 1 = 0); SELECT * FROM T1 WHERE A <> ANY (SELECT A FROM T1); CREATE TEMPORARY VIEW IF NOT EXISTS v_t1_5592 AS SELECT c0 FROM t1; REINDEX T2; UPDATE T SET b = json_object('k', b); DETACH DATABASE aux69; DROP INDEX IF EXISTS T1; SELECT STRING_AGG(C) FROM T2; ROLLBACK TO sp6649; RELEASE sp6649; INSERT OR ABORT INTO T2 VALUES ('x', -9, -9); SELECT COUNT(*) FILTER (WHERE c1 IS NOT NULL), SUM(rowid) FILTER (WHERE c1 > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(c1) FILTER (WHERE c1 > 0 AND c1 < 100), COUNT(*) FILTER (WHERE typeof(c1) = "text") FROM t1; ALTER TABLE T RENAME COLUMN b TO b_r9085; INSERT INTO t1 DEFAULT VALUES; SELECT GROUP_CONCAT(A, '|') FROM T2; INSERT OR ROLLBACK INTO T1 VALUES (6, ''); WITH RECURSIVE tree(id, path) AS (VALUES(1, "/1") UNION ALL SELECT id+1, path || "/" || (id+1) FROM tree WHERE id<14) SELECT * FROM tree; CREATE VIEW IF NOT EXISTS v_T1_7673 AS SELECT B FROM T1; SELECT COUNT(*) FILTER (WHERE B IS NOT NULL), SUM(rowid) FILTER (WHERE B > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(B) FILTER (WHERE B > 0 AND B < 100), COUNT(*) FILTER (WHERE typeof(B) = "text") FROM T1; CREATE TABLE T1 ( a INTEGER, b REAL ); CREATE TABLE T2 ( a INTEGER, b REAL ); INSERT INTO T1 VALUES (1,1.0); INSERT INTO T2 VALUES (1,-1.0),(2,9e999); INSERT OR REPLACE INTO T1 SELECT * FROM T2; SELECT * FROM T1; SELECT COUNT(c) FROM T; UPDATE T SET a = a + 1 WHERE 1; ALTER TABLE T ADD COLUMN extra_6983 DATETIME DEFAULT CURRENT_TIMESTAMP; INSERT INTO T2 VALUES (NULL, NULL); .limit CREATE TABLE T1 ( a INTEGER, b REAL ); CREATE TABLE T2 ( a INTEGER, b REAL ); INSERT INTO T1 VALUES (ifnull(timediff(concat_ws(',', CAST(upper(1) AS INT2), 2, 3), 1), 2),1.0); INSERT INTO T2 VALUES (1,-1.0),(2,9e999); INSERT OR REPLACE INTO T1 SELECT * FROM T2; SELECT * FROM T1; PRAGMA writable_schema = YES; SAVEPOINT sp6649; ATTACH DATABASE ':memory:' AS aux69; .quit .trace CREATE TABLE T ( a DOUBLE, b TEXT, c REAL ); INSERT INTO T VALUES (CAST(json_array_length(if(CAST(-(-(length(randomblob(CAST(mod(1.7976931348623157e+308, 1465368752231950166) AS INTEGER))))) AS TINYINT), 1, 0, 1, 0, 1), '$') AS NUMERIC),'a',3.14), (1,'b',-7.75), (2,'c',-9e999); WITH _m AS MATERIALIZED (SELECT * FROM t1) SELECT b,a,c, RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T; ATTACH DATABASE ':memory:' AS aux86; PRAGMA full_column_names = YES; DROP TABLE IF EXISTS _m; CREATE TABLE t1 (c0, c1 REAL PRIMARY KEY); INSERT INTO t1(c0, c1) VALUES ('{', -(-(1))), (0, 0); UPDATE t1 SET c0 = NULL; UPDATE OR REPLACE t1 SET c1 = 1; SELECT DISTINCT * FROM t1 WHERE NOT NOT (t1.c0 IS NULL); PRAGMA integrity_check; SELECT COUNT(*) FROM t1; SELECT * FROM t1; DETACH DATABASE aux86; REINDEX; ALTER TABLE T ADD COLUMN extra_5481 BLOB NOT NULL DEFAULT 0; SELECT COUNT(*) FROM T; CREATE TABLE T1 ( A VARCHAR(15) PRIMARY KEY, B VARCHAR(30) NOT NULL UNIQUE ); CREATE TABLE T2 ( A VARCHAR(10) PRIMARY KEY, X VARCHAR(15) NOT NULL, C BIGINT, FOREIGN KEY (X) REFERENCES T1(A) ); INSERT INTO T1 VALUES ('p', 'x'); INSERT INTO T1 VALUES ('q', 'y'); INSERT INTO T2 VALUES ('a', 'p', 9223372036854775807); INSERT INTO T2 VALUES ('b', 'q', -9223372036854775808); SELECT X, SUM(C) AS D, COUNT(*) AS E FROM T2 GROUP BY X; SELECT LAG(c0, 2, 'default') OVER (PARTITION BY c0 ORDER BY c0 ROWS BETWEEN 2 PRECEDING AND 2 FOLLOWING EXCLUDE CURRENT ROW) FROM t1; SELECT * FROM t1; CREATE VIEW IF NOT EXISTS v_t1_6883 AS SELECT c1 FROM t1; ALTER TABLE t1 ADD COLUMN extra_3184 INT2 COLLATE NOCASE; SELECT * FROM t1; REINDEX; SELECT c, COUNT(*) FROM T GROUP BY c HAVING COUNT(*) = (SELECT COUNT(*) FROM T); 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; PRAGMA temp_store = 'MEMORY'; VACUUM main; SELECT * FROM T1 WHERE EXISTS (SELECT 1 FROM T1 WHERE 1 = 0); SELECT * FROM T1 WHERE A <> ANY (SELECT A /**/ FROM T1); CREATE TEMPORARY VIEW IF NOT EXISTS v_t1_5592 AS SELECT c0 FROM t1; REINDEX T2; UPDATE T SET b = json_object('k', b); DETACH DATABASE aux69; DROP INDEX IF EXISTS T1; SELECT STRING_AGG(C) FROM T2; ROLLBACK TO sp6649; RELEASE sp6649; INSERT OR ABORT INTO T2 VALUES ('x', -9, -9); SELECT COUNT(*) FILTER (WHERE c1 IS NOT NULL), SUM(rowid) FILTER (WHERE c1 > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(c1) FILTER (WHERE c1 > 0 AND /**/ c1 < 100), COUNT(*) FILTER (WHERE typeof(c1) = "text") FROM t1; ALTER TABLE T RENAME COLUMN b TO b_r9085; INSERT INTO t1 DEFAULT VALUES; SELECT GROUP_CONCAT(A, '|') FROM T2; INSERT OR ROLLBACK INTO T1 VALUES (6, ''); WITH RECURSIVE tree(id, path) AS (VALUES(1, "/1") UNION ALL SELECT id+1, path || "/" || (id+1) FROM tree WHERE id<14) SELECT * FROM tree; CREATE VIEW IF NOT EXISTS v_T1_7673 AS SELECT B FROM T1; SELECT COUNT(*) FILTER (WHERE B IS NOT NULL), SUM(rowid) FILTER (WHERE B > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(B) FILTER (WHERE B > 0 AND B < 100), COUNT(*) FILTER (WHERE typeof(B) = "text") FROM T1; CREATE TABLE T1 ( a INTEGER, b REAL ); CREATE TABLE T2 ( a INTEGER, b REAL ); INSERT INTO T1 VALUES (1,1.0); INSERT INTO T2 VALUES (1,-1.0),(2,9e999); INSERT OR REPLACE INTO T1 SELECT * FROM T2; SELECT * FROM T1; SELECT COUNT(c) FROM T; UPDATE T SET a = a + 1 WHERE 1; ALTER TABLE T ADD COLUMN extra_6983 DATETIME DEFAULT CURRENT_TIMESTAMP; INSERT INTO T2 VALUES (NULL, NULL); .limit CREATE TABLE T1 ( a INTEGER, b REAL ); CREATE TABLE T2 ( a INTEGER, b REAL ); INSERT INTO T1 VALUES (ifnull(timediff(concat_ws(',', CAST(upper(1) AS INT2), 2, 3), 1), 2),1.0); INSERT INTO T2 VALUES (1,-1.0),(2,9e999); INSERT OR REPLACE INTO T1 SELECT * FROM T2; SELECT * FROM T1; PRAGMA writable_schema = YES; SAVEPOINT sp6649; ATTACH DATABASE ':memory:' AS aux69; .quit .trace CREATE TABLE T ( a DOUBLE, b TEXT, c REAL ); INSERT INTO T VALUES (CAST(json_array_length(if(CAST(-(-(length(randomblob(CAST(mod(1.7976931348623157e+308, 1465368752231950166) AS INTEGER))))) AS TINYINT), 1, 0, 1, 0, 1), '$') AS NUMERIC),'a',3.14), (1,'b',-7.75), (2,'c',-9e999); WITH _m AS MATERIALIZED (SELECT * FROM t1) SELECT b,a,c, RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T; ATTACH DATABASE ':memory:' AS aux86; PRAGMA full_column_names = YES; DROP TABLE IF EXISTS _m; CREATE TABLE t1 (c0, c1 REAL PRIMARY KEY); INSERT INTO t1(c0, c1) VALUES ('{', -(-(1))), (0, 0); UPDATE t1 SET c0 = NULL; UPDATE OR REPLACE t1 SET c1 = 1; SELECT DISTINCT * FROM t1 WHERE NOT NOT (t1.c0 IS NULL); PRAGMA integrity_check; SELECT COUNT(*) FROM t1; SELECT * FROM t1; DETACH DATABASE aux86; REINDEX; ALTER TABLE T ADD COLUMN extra_5481 BLOB NOT NULL DEFAULT 0; SELECT COUNT(*) FROM T; CREATE TABLE T1 ( A VARCHAR(15) PRIMARY KEY, B VARCHAR(30) NOT NULL UNIQUE ); CREATE TABLE T2 ( A VARCHAR(10) PRIMARY KEY, X VARCHAR(15) NOT NULL, C BIGINT, FOREIGN KEY (X) REFERENCES T1(A) ); INSERT INTO T1 /* .recover */ VALUES ('p', 'x'); INSERT INTO T1 VALUES ('q', 'y'); INSERT INTO T2 VALUES ('a', 'p', 9223372036854775807); INSERT INTO T2 VALUES ('b', 'q', -9223372036854775808); SELECT X, SUM(C) AS D, COUNT(*) AS E FROM T2 GROUP BY X; SELECT LAG(c0, 2, 'default') OVER (PARTITION BY c0 ORDER BY c0 ROWS BETWEEN 2 PRECEDING AND 2 FOLLOWING EXCLUDE CURRENT ROW) FROM t1; SELECT * FROM t1; CREATE VIEW IF NOT EXISTS v_t1_6883 AS SELECT c1 FROM t1; ALTER TABLE t1 ADD COLUMN extra_3184 INT2 COLLATE NOCASE; SELECT * FROM t1; REINDEX; SELECT c, COUNT(*) FROM T GROUP BY c HAVING COUNT(*) = (SELECT COUNT(*) FROM T); 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; PRAGMA temp_store = 'MEMORY'; VACUUM main; SELECT * FROM T1 WHERE EXISTS (SELECT 1 FROM T1 WHERE 1 = 0); SELECT * FROM T1 WHERE A <> ANY (SELECT A FROM T1); CREATE TEMPORARY VIEW IF NOT EXISTS v_t1_5592 AS SELECT c0 FROM t1; REINDEX T2; UPDATE T SET b = json_object('k', b); DETACH DATABASE aux69; DROP INDEX IF EXISTS T1; SELECT STRING_AGG(C) FROM T2; ROLLBACK TO sp6649; RELEASE sp6649; INSERT OR ABORT INTO T2 VALUES ('x', -9, -9); SELECT COUNT(*) FILTER (WHERE c1 IS NOT NULL), SUM(rowid) FILTER (WHERE c1 > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(c1) FILTER (WHERE c1 > 0 AND c1 < 100), COUNT(*) FILTER (WHERE typeof(c1) = "text") FROM t1; ALTER TABLE T RENAME COLUMN b TO b_r9085; INSERT INTO t1 DEFAULT VALUES; SELECT GROUP_CONCAT(A, '|') FROM T2; INSERT OR ROLLBACK INTO T1 VALUES (6, ''); WITH RECURSIVE tree(id, path) AS (VALUES(1, "/1") UNION ALL SELECT id+1, path || "/" || (id+1) FROM tree WHERE id<14) SELECT * FROM tree; CREATE VIEW IF NOT EXISTS v_T1_7673 AS SELECT B FROM T1; SELECT COUNT(*) FILTER (WHERE B IS NOT NULL), SUM(rowid) FILTER (WHERE B > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(B) FILTER (WHERE B > 0 AND B < 100), COUNT(*) FILTER (WHERE typeof(B) = "text") FROM T1; CREATE TABLE T1 ( a INTEGER, b REAL ); CREATE TABLE T2 ( a INTEGER, b REAL ); INSERT INTO T1 VALUES (1,1.0); INSERT INTO T2 VALUES (1,-1.0),(2,9e999); INSERT OR REPLACE INTO T1 SELECT * FROM T2; SELECT * FROM T1; SELECT COUNT(c) FROM T; UPDATE T SET a = a + 1 WHERE 1; ALTER TABLE T ADD COLUMN extra_6983 DATETIME DEFAULT CURRENT_TIMESTAMP; INSERT INTO T2 VALUES (NULL, NULL); VACUUM; CREATE VIEW IF NOT EXISTS v_T2_6393 AS SELECT a FROM T2; ALTER TABLE T1 RENAME COLUMN b TO b_r8651; SELECT LEAD(a) OVER (ORDER BY a) FROM T1; ALTER TABLE T DROP COLUMN a; SELECT * FROM T1 AS a FULL OUTER JOIN T1 AS b ON a.rowid = b.rowid; CREATE TABLE T1 ( A VARCHAR(10) PRIMARY KEY, B VARCHAR(15) UNIQUE, C INTEGER ); CREATE TABLE T2 ( X VARCHAR(20) PRIMARY KEY, A VARCHAR(10) NOT NULL UNIQUE, FOREIGN KEY (A) REFERENCES T1(A) ); INSERT INTO T1 VALUES ('a', 'p', -2147483648); INSERT INTO T1 VALUES ('b', 'q', 2147483647); INSERT INTO T2 VALUES ('m', 'a'); INSERT INTO T2 VALUES ('n', 'b'); SELECT T2.X, T1.B, T1.C FROM T2, T1 WHERE T2.A = T1.A AND T1.C >= 0; SELECT * FROM t1 WHERE c1 IN (SELECT c1 FROM t1 t2 WHERE t2.c1 = t1.c1); SELECT * FROM T2 AS /* load_extension({v}) */ a INNER JOIN T AS b ON a.rowid = b.rowid; DETACH DATABASE aux78; SELECT COUNT(*) FILTER (WHERE c1 IS NOT NULL), SUM(rowid) FILTER (WHERE c1 > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(c1) FILTER (WHERE c1 > 0 AND c1 < 100), COUNT(*) FILTER (WHERE typeof(c1) = "text") FROM t1; UPDATE T2 SET A = 'x'; PRAGMA cache_spill = NO; INSERT INTO T2 SELECT * FROM T2; VACUUM main; CREATE VIRTUAL TABLE T USING fts5(a,b); INSERT INTO T VALUES ('a','b c'), ('d','e f'); SELECT a,b FROM T WHERE T MATCH 'b'; SELECT * FROM T1 WHERE EXISTS (SELECT 1 FROM T1 WHERE C > 0); ROLLBACK TRANSACTION TO SAVEPOINT sp5671; RELEASE SAVEPOINT sp5671; ALTER TABLE T DROP COLUMN a; SELECT A, (SELECT MIN(A) FROM T2) AS min_val FROM T2; 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 T1; SELECT * FROM T1 WHERE A IN (SELECT A FROM T1 WHERE A IN (SELECT A FROM T1)); ALTER TABLE t1 ADD COLUMN extra_514 DATE DEFAULT (abs(random()) % 1000); SELECT SUM(A) FROM T1; ALTER TABLE t1 RENAME TO t1_r1859; SELECT COUNT(*) FROM t1; SELECT MAX(c0) FROM t1; SELECT NTILE(1) OVER (PARTITION BY X ORDER BY X ROWS BETWEEN 2 PRECEDING AND 2 FOLLOWING EXCLUDE CURRENT ROW) FROM T2; CREATE TEMP VIEW IF NOT EXISTS v_T_8701 AS SELECT b FROM T; REINDEX; SELECT 0x0ACB29BM205381; SELECT sqlite_compileoption_used('我的天你是怎么了'); SELECT 1 >> -999999999999999999999999999; SELECT sqlite_compileoption_get($1); SELECT sqlite_version(); INSERT INTO t1 SELECT * FROM t1; SELECT * FROM t1; SELECT STRING_AGG(a, '|') FROM T; SELECT * FROM T1; SELECT GROUP_CONCAT(X, '|') FROM T2; ALTER TABLE T2 DROP COLUMN A; INSERT INTO T VALUES (NULL, NULL, NULL); INSERT INTO t1 SELECT * FROM t1; CREATE INDEX IF NOT EXISTS idx_T1_6502 ON T1(B); SELECT COUNT(*) FROM T2; ROLLBACK TO sp1179; RELEASE sp1179; SELECT * FROM t1; INSERT INTO T2 DEFAULT VALUES; INSERT OR REPLACE INTO t1 VALUES (-5, 7); VACUUM; ALTER TABLE T2 DROP COLUMN X; SELECT * FROM T1; SELECT * FROM T1 AS a JOIN T AS b ON a.rowid = b.rowid; ALTER TABLE T2 ADD COLUMN extra_7126 FLOAT DEFAULT CURRENT_TIMESTAMP; INSERT INTO T VALUES (NULL, NULL, NULL); ALTER TABLE T1 DROP COLUMN A; SELECT c, (SELECT AVG(c) FROM T) AS avg_val FROM T; SELECT COUNT(*) FROM T2; ALTER TABLE t1 DROP COLUMN c0; INSERT INTO T2 SELECT * FROM T2; ALTER TABLE t1 DROP COLUMN c0; WITH cte AS (SELECT * FROM T2) SELECT * FROM cte LEFT JOIN T2 ON cte.X = T2.X; UPDATE t1 SET c1 = '' WHERE c1 BETWEEN 0 AND 100; INSERT INTO t1 DEFAULT VALUES; ALTER TABLE t1 DROP COLUMN c1; ``` ## Actual output ```sql main: "" r/w length 1000000000 sql_length 1000000000 column 2000 expr_depth 1000 compound_select 500 vdbe_op 250000000 function_arg 127 attached 10 like_pattern_length 50000 variable_number 32766 trigger_depth 1000 worker_threads 0 1|-1.0 2|Inf ``` ## Expectation ```sql ``` ## Flag ``` ```