## Summary **No review yet** ## Minimized query ```sql SAVEPOINT sp4770; -- typeof(1.0) .limit SAVEPOINT sp9818; ATTACH DATABASE ':memory:' AS aux84; SAVEPOINT sp2531; .check SAVEPOINT sp9694; PRAGMA encoding = 'UTF-8'; ATTACH DATABASE ':memory:' AS aux44; CREATE TABLE main.main.`T` ( a REAL, b REAL, c REAL ); INSERT INTO T VALUES (strftime('%s', if(coalesce(NULL, NULL, NULL) -> sqrt(datetime(-(-(CAST(x'2f' AS BLOB))))), typeof(NULL), (-(-(0)) + 9145485036963515638))),1.5,10.0), (2,-2.5,20.0), (3,-9e999,30.0); WITH _m AS MATERIALIZED (WITH _m AS MATERIALIZED (SELECT * FROM T) SELEC_m * FROM T) SELEC_m * FROM T WHERE NOT NOT (NOT NOT (+b < 2.0)) ORDER BY b; DETACH DATABASE aux44; SELECT * FROM T WHERE EXISTS (SELECT 1 FROM T t2 WHERE t2.a = T.a); INSERT INTO T VALUES (NULL, NULL, NULL); INSERT OR ROLLBACK INTO T VALUES (NULL, NULL, ''); WITH RECURSIVE cnt(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM cnt WHERE +x<21) SELECT * FROM cnt; ALTER TABLE T DROP COLUMN b; DROP VIEW IF EXISTS T; SELECT ROW_NUMBER() OVER (ORDER BY a ROWS BETWEEN 2 PRECEDING AND 2 FOLLOWING EXCLUDE CURRENT ROW) FROM T; INSERT OR ROLLBACK INTO T VALUES (-2, NULL, 0); ROLLBACK TO sp9694; RELEASE sp9694; ALTER TABLE T ADD COLUMN extra_4532 UNSIGNED BIG INT DEFAULT (abs(random()) % 1000); SELECT a, COUNT(*) FROM T GROUP BY a HAVING COUNT(*) = (SELECT COUNT(*) FROM T); CREATE TRIGGER IF NOT EXISTS trg_T_7371 BEFORE UPDATE ON T FOR EACH ROW BEGIN SELECT RAISE(FAIL, 'no'); END; SELECT COUNT(*) FROM T; ROLLBACK TO sp2531; RELEASE sp2531; INSERT OR ABORT INTO T VALUES (6, 0, 0); SELECT COUNT(*) FROM T; WITH RECURSIVE cnt(x) AS (VALUES(1) UNION SELECT x+1 FROM cnt WHERE x<8) SELECT * FROM cnt; WITH RECURSIVE cnt(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM cnt WHERE x<0) SELECT * FROM cnt; DETACH DATABASE aux84; SELECT * FROM T t1 JOIN T t2 ON t1.a = (SELECT a FROM T LIMIT 1); ALTER TABLE T RENAME TO T_r9068; CREATE TABLE T ( A VARCHAR(10) PRIMARY KEY, B VARCHAR(15), C BIGINT NOT NULL, UNIQUE (B, C) ); INSERT INTO T VALUES ('a', 'p', 3000); INSERT INTO T VALUES ('b', 'q', 9223372036854775807); INSERT INTO T VALUES ('c', 'r', 1700); INSERT INTO T VALUES ('e', 'q', -9223372036854775808); INSERT INTO T VALUES ('f', 'r', 0); SELECT B, COUNT(*) AS D, SUM(C) AS E, AVG(C) AS F FROM T GROUP BY B HAVING SUM(C) > 0; ROLLBACK TRANSACTION TO SAVEPOINT sp9818; RELEASE SAVEPOINT sp9818; SELECT STRING_AGG(a, '|') FROM T; INSERT INTO T VALUES (NULL, NULL, NULL); SELECT LEAD(a, 1, NULL) OVER (ORDER BY a ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T; SELECT RANK() OVER (ORDER BY c GROUPS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) FROM T; SELECT COUNT(*) FROM T; SELECT * FROM T AS a RIGHT OUTER JOIN T AS b ON a.rowid = b.rowid; INSERT INTO T VALUES (NULL, NULL, NULL); ALTER TABLE T ADD COLUMN extra_9504 DOUBLE COLLATE RTRIM; SELECT * FROM T NATURAL JOIN T; ANALYZE; INSERT INTO T DEFAULT VALUES; INSERT INTO T DEFAULT VALUES; INSERT INTO T VALUES (NULL, NULL, NULL); WITH cte AS (SELECT CASE WHEN a > 0 THEN "pos" ELSE "neg" END AS sign FROM T) SELECT * FROM cte; SELECT FIRST_VALUE(c) OVER (ORDER BY c ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW EXCLUDE TIES) FROM T; ALTER TABLE T ADD COLUMN extra_5697 BIGINT COLLATE NOCASE; RELEASE sp4770; PRAGMA short_column_names = OFF; CREATE TRIGGER IF NOT EXISTS trg_T_534 AFTER UPDATE OF A ON T BEGIN SELECT RAISE(FAIL, 'no'); END; SELECT * FROM T WHERE C = (SELECT GROUP_CONCAT(C) FROM T); SAVEPOINT sp4770; .limit SAVEPOINT sp9818; ATTACH DATABASE ':memory:' AS aux84; SAVEPOINT sp2531; .check SAVEPOINT sp9694; PRAGMA encoding = 'UTF-8'; ATTACH DATABASE ':memory:' AS aux44; CREATE TABLE main.main.`T` ( a REAL, b REAL, c REAL ); INSERT INTO T VALUES (strftime('%s', if(coalesce(NULL, NULL, NULL) -> sqrt(datetime(-(-(CAST(x'2f' AS BLOB))))), typeof(NULL), (0 + 9145485036963515638))),1.5,10.0), (2,-2.5,20.0), (3,-9e999,30.0); WITH _m AS MATERIALIZED (WITH _m AS MATERIALIZED (SELECT * FROM T) SELEC_m * FROM T) SELEC_m * FROM T WHERE NOT NOT (NOT NOT (+b < 2.0)) ORDER BY b; DETACH DATABASE aux44; SELECT * FROM T WHERE EXISTS (SELECT 1 FROM T t2 WHERE t2.a = T.a); INSERT INTO T VALUES (NULL, NULL, NULL); INSERT OR ROLLBACK INTO T VALUES (NULL, NULL, ''); WITH RECURSIVE cnt(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM cnt WHERE +x<21) SELECT * FROM cnt; ALTER TABLE T DROP COLUMN b; DROP VIEW IF EXISTS T; SELECT ROW_NUMBER() OVER (ORDER BY a ROWS BETWEEN 2 PRECEDING AND 2 FOLLOWING EXCLUDE CURRENT ROW) FROM T; INSERT OR ROLLBACK INTO T VALUES (-2, NULL, 0); ROLLBACK TO sp9694; RELEASE sp9694; ALTER TABLE T ADD COLUMN extra_4532 UNSIGNED BIG INT DEFAULT (abs(random()) % 1000); SELECT a, COUNT(*) FROM T GROUP BY a HAVING COUNT(*) = (SELECT COUNT(*) FROM T); CREATE TRIGGER IF NOT EXISTS trg_T_7371 BEFORE UPDATE ON T FOR EACH ROW BEGIN SELECT RAISE(FAIL, 'no'); END; SELECT COUNT(*) FROM T; ROLLBACK TO sp2531; RELEASE sp2531; INSERT OR ABORT INTO T VALUES (6, 0, 0); SELECT COUNT(*) FROM T; WITH RECURSIVE cnt(x) AS (VALUES(1) UNION SELECT x+1 FROM cnt WHERE x<8) SELECT * FROM cnt; WITH RECURSIVE cnt(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM cnt WHERE x<0) SELECT * FROM cnt; DETACH DATABASE aux84; SELECT * FROM T t1 JOIN T t2 ON t1.a = (SELECT a FROM T LIMIT 1); ALTER TABLE T RENAME TO T_r9068; CREATE TABLE T ( A VARCHAR(10) PRIMARY KEY, B VARCHAR(15), C BIGINT NOT NULL, UNIQUE (B, C) ); INSERT INTO T VALUES ('a', 'p', 3000); INSERT INTO T VALUES ('b', 'q', 9223372036854775807); INSERT INTO T VALUES ('c', 'r', 1700); INSERT INTO T VALUES ('e', 'q', -9223372036854775808); INSERT INTO T VALUES ('f', 'r', 0); SELECT B, COUNT(*) AS D, SUM(C) AS E, AVG(C) AS F FROM T GROUP BY B HAVING SUM(C) > 0; ROLLBACK TRANSACTION TO SAVEPOINT sp9818; RELEASE SAVEPOINT sp9818; SELECT STRING_AGG(a, '|') FROM T; INSERT INTO T VALUES (NULL, NULL, NULL); SELECT LEAD(a, 1, NULL) OVER (ORDER BY a ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T; SELECT RANK() OVER (ORDER BY c GROUPS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) FROM T; SELECT COUNT(*) FROM T; SELECT * FROM T AS a RIGHT OUTER JOIN T AS b ON a.rowid = b.rowid; INSERT INTO T VALUES (NULL, NULL, NULL); ALTER TABLE T ADD COLUMN extra_9504 DOUBLE COLLATE RTRIM; SELECT * FROM T NATURAL JOIN T; ANALYZE; INSERT INTO T DEFAULT VALUES; INSERT INTO T DEFAULT VALUES; INSERT INTO T VALUES (NULL, NULL, NULL); WITH cte AS (SELECT CASE WHEN a > 0 THEN "pos" ELSE "neg" END AS sign FROM T) SELECT * FROM cte; SELECT FIRST_VALUE(c) OVER (ORDER BY c ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW EXCLUDE TIES) FROM T; ALTER TABLE T ADD COLUMN extra_5697 BIGINT COLLATE NOCASE; RELEASE sp4770; PRAGMA short_column_names = OFF; CREATE TRIGGER IF NOT EXISTS trg_T_534 AFTER UPDATE OF A ON T BEGIN SELECT RAISE(FAIL, 'no'); END; SELECT * FROM T WHERE C = (SELECT GROUP_CONCAT(C) FROM T); SAVEPOINT sp4770; .limit SAVEPOINT sp9818; ATTACH DATABASE ':memory:' AS aux84; SAVEPOINT sp2531; .check SAVEPOINT sp9694; PRAGMA encoding = 'UTF-8'; ATTACH DATABASE ':memory:' AS aux44; CREATE TABLE main.main.`T` ( a REAL, b REAL, c REAL ); INSERT INTO T VALUES (strftime('%s', if(coalesce(NULL, NULL, NULL) -> sqrt(datetime(-(-(CAST(x'2f' AS BLOB))))), typeof(NULL), (0 + 9145485036963515638))),1.5,10.0), (2,-2.5,20.0), (3,-9e999,30.0); WITH _m AS MATERIALIZED (WITH _m AS MATERIALIZED (SELECT * FROM T) SELEC_m * FROM T) SELEC_m * FROM T WHERE NOT NOT (NOT NOT (+b < 2.0)) ORDER BY b; DETACH DATABASE aux44; SELECT * FROM T WHERE EXISTS (SELECT 1 FROM T t2 WHERE t2.a = T.a); INSERT INTO T VALUES (NULL, NULL, NULL); INSERT OR ROLLBACK INTO T VALUES (NULL, NULL, ''); WITH RECURSIVE cnt(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM cnt WHERE +x<21) SELECT * FROM cnt; ALTER TABLE T DROP COLUMN b; DROP VIEW IF EXISTS T; SELECT ROW_NUMBER() OVER (ORDER BY a ROWS BETWEEN 2 PRECEDING AND 2 FOLLOWING EXCLUDE CURRENT ROW) FROM T; INSERT OR ROLLBACK INTO T VALUES (-2, NULL, 0); ROLLBACK TO sp9694; RELEASE sp9694; ALTER TABLE T ADD COLUMN extra_4532 UNSIGNED BIG INT DEFAULT (abs(random()) % 1000); SELECT a, COUNT(*) FROM T GROUP BY a HAVING COUNT(*) = (SELECT COUNT(*) FROM T); CREATE TRIGGER IF NOT EXISTS trg_T_7371 BEFORE UPDATE ON T FOR EACH ROW BEGIN SELECT RAISE(FAIL, 'no'); END; SELECT COUNT(*) FROM T; ROLLBACK TO sp2531; RELEASE sp2531; INSERT OR ABORT INTO T VALUES (6, 0, 0); SELECT COUNT(*) FROM T; WITH RECURSIVE cnt(x) AS (VALUES(1) UNION SELECT x+1 FROM cnt WHERE x<8) SELECT * FROM cnt; WITH RECURSIVE cnt(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM cnt WHERE x<0) SELECT * FROM cnt; DETACH DATABASE aux84; SELECT * FROM T t1 JOIN T t2 ON t1.a = (SELECT a FROM T LIMIT 1); ALTER TABLE T RENAME TO T_r9068; CREATE TABLE T ( A VARCHAR(10) PRIMARY KEY, B VARCHAR(15), C BIGINT NOT NULL, UNIQUE (B, C) ); INSERT INTO T VALUES ('a', 'p', 3000); INSERT INTO T VALUES ('b', 'q', 9223372036854775807); INSERT INTO T VALUES ('c', 'r', 1700); INSERT INTO T VALUES ('e', 'q', -9223372036854775808); INSERT INTO T VALUES ('f', 'r', 0); SELECT B, COUNT(*) AS D, SUM(C) AS E, AVG(C) AS F FROM T GROUP BY B HAVING SUM(C) > 0; ROLLBACK TRANSACTION TO SAVEPOINT sp9818; RELEASE SAVEPOINT sp9818; SELECT STRING_AGG(a, '|') FROM T; INSERT INTO T VALUES (NULL, NULL, NULL); SELECT LEAD(a, 1, NULL) OVER (ORDER BY a ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T; SELECT RANK() OVER (ORDER BY c GROUPS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) FROM T; SELECT COUNT(*) FROM T; SELECT * FROM T AS a RIGHT OUTER JOIN T AS b ON a.rowid = b.rowid; INSERT INTO T VALUES (NULL, NULL, NULL); ALTER TABLE T ADD COLUMN extra_9504 DOUBLE COLLATE RTRIM; SELECT * FROM T NATURAL JOIN T; ANALYZE; INSERT INTO T DEFAULT VALUES; INSERT INTO T DEFAULT VALUES; INSERT INTO T VALUES (NULL, NULL, NULL); WITH cte AS (SELECT CASE WHEN a > 0 THEN "pos" ELSE "neg" END AS sign FROM T) SELECT * FROM cte; SELECT FIRST_VALUE(c) OVER (ORDER BY c ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW EXCLUDE TIES) FROM T; ALTER TABLE T ADD COLUMN extra_5697 BIGINT COLLATE NOCASE; RELEASE sp4770; PRAGMA short_column_names = OFF; CREATE TRIGGER IF NOT EXISTS trg_T_534 AFTER UPDATE OF A ON T BEGIN SELECT RAISE(FAIL, 'no'); END; SELECT * FROM T WHERE C = (SELECT GROUP_CONCAT(C) FROM T); SAVEPOINT sp4770; .limit SAVEPOINT sp9818; ATTACH DATABASE ':memory:' AS aux84; SAVEPOINT sp2531; .check SAVEPOINT sp9694; PRAGMA encoding = 'UTF-8'; ATTACH DATABASE ':memory:' AS aux44; CREATE TABLE main.main.`T` ( a REAL, b REAL, c REAL ); INSERT INTO T VALUES (strftime('%s', if(coalesce(NULL, NULL, NULL) -> sqrt(datetime(-(-(CAST(x'2f' AS BLOB))))), typeof(NULL), (0 + 9145485036963515638))),1.5,10.0), (2,-2.5,20.0), (3,-9e999,30.0); WITH _m AS MATERIALIZED (WITH _m AS MATERIALIZED (SELECT * FROM T) SELEC_m * FROM T) SELEC_m * FROM T WHERE NOT NOT (NOT NOT (+b < 2.0)) ORDER BY b; DETACH DATABASE aux44; SELECT * FROM T WHERE EXISTS (SELECT 1 FROM T t2 WHERE t2.a = T.a); INSERT INTO T VALUES (NULL, NULL, NULL); INSERT OR ROLLBACK INTO T VALUES (NULL, NULL, ''); WITH RECURSIVE cnt(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM cnt WHERE +x<21) SELECT * FROM cnt; ALTER TABLE T DROP COLUMN b; DROP VIEW IF EXISTS T; SELECT ROW_NUMBER() OVER (ORDER BY a ROWS BETWEEN 2 PRECEDING AND 2 FOLLOWING EXCLUDE CURRENT ROW) FROM T; INSERT OR ROLLBACK INTO T VALUES (-2, NULL, 0); ROLLBACK TO sp9694; RELEASE sp9694; ALTER TABLE T ADD COLUMN extra_4532 UNSIGNED BIG INT DEFAULT (abs(random()) % 1000); SELECT a, COUNT(*) FROM T GROUP BY a HAVING COUNT(*) = (SELECT COUNT(*) FROM T); CREATE TRIGGER IF NOT EXISTS trg_T_7371 BEFORE UPDATE ON T FOR EACH ROW BEGIN SELECT RAISE(FAIL, 'no'); END; SELECT COUNT(*) FROM T; ROLLBACK TO sp2531; RELEASE sp2531; INSERT OR ABORT INTO T VALUES (6, 0, 0); SELECT COUNT(*) FROM T; WITH RECURSIVE cnt(x) AS (VALUES(1) UNION SELECT x+1 FROM cnt WHERE x<8) SELECT * FROM cnt; WITH RECURSIVE cnt(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM cnt WHERE x<0) SELECT * FROM cnt; DETACH DATABASE aux84; SELECT * FROM T t1 JOIN T t2 ON t1.a = (SELECT a FROM T LIMIT 1); ALTER TABLE T RENAME TO T_r9068; CREATE TABLE T ( A VARCHAR(10) PRIMARY KEY, B VARCHAR(15), C BIGINT NOT NULL, UNIQUE (B, C) ); INSERT INTO T VALUES ('a', 'p', 3000); INSERT INTO T VALUES ('b', 'q', 9223372036854775807); INSERT INTO T VALUES ('c', 'r', 1700); INSERT INTO T VALUES ('e', 'q', -9223372036854775808); INSERT INTO T VALUES ('f', 'r', 0); SELECT B, COUNT(*) AS D, SUM(C) AS E, AVG(C) AS F FROM T GROUP BY B HAVING SUM(C) > 0; ROLLBACK TRANSACTION TO SAVEPOINT sp9818; RELEASE SAVEPOINT sp9818; SELECT STRING_AGG(a, '|') FROM T; INSERT INTO T VALUES (NULL, NULL, NULL); SELECT LEAD(a, 1, NULL) OVER (ORDER BY a ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T; SELECT RANK() OVER (ORDER BY c GROUPS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) FROM T; SELECT COUNT(*) FROM T; SELECT * FROM T AS a RIGHT OUTER JOIN T AS b ON a.rowid = b.rowid; INSERT INTO T VALUES (NULL, NULL, NULL); ALTER TABLE T ADD COLUMN extra_9504 DOUBLE COLLATE RTRIM; SELECT * FROM T NATURAL JOIN T; ANALYZE; INSERT INTO T DEFAULT VALUES; INSERT INTO T DEFAULT VALUES; INSERT INTO T VALUES (NULL, NULL, NULL); WITH cte AS (SELECT CASE WHEN a > 0 THEN "pos" ELSE "neg" END AS sign FROM T) SELECT * FROM cte; SELECT FIRST_VALUE(c) OVER (ORDER BY c ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW EXCLUDE TIES) FROM T; ALTER TABLE T ADD COLUMN extra_5697 BIGINT COLLATE NOCASE; RELEASE sp4770; PRAGMA short_column_names = OFF; CREATE TRIGGER IF NOT EXISTS trg_T_534 AFTER UPDATE OF A ON T BEGIN SELECT RAISE(FAIL, 'no'); END; SELECT * FROM T WHERE C = (SELECT GROUP_CONCAT(C) FROM T); SAVEPOINT sp4770; .limit SAVEPOINT sp9818; ATTACH DATABASE ':memory:' AS aux84; SAVEPOINT sp2531; .check SAVEPOINT sp9694; PRAGMA encoding = 'UTF-8'; ATTACH DATABASE ':memory:' AS aux44; CREATE TABLE main.main.`T` ( a REAL, b REAL, c REAL ); INSERT INTO T VALUES (strftime('%s', if(coalesce(NULL, NULL, NULL) -> sqrt(datetime(-(-(CAST(x'2f' AS BLOB))))), typeof(NULL), (0 + 9145485036963515638))),1.5,10.0), (2,-2.5,20.0), (3,-9e999,30.0); WITH _m AS MATERIALIZED (WITH _m AS MATERIALIZED (SELECT * FROM T) SELEC_m * FROM T) SELEC_m * FROM T WHERE NOT NOT (NOT NOT (+b < 2.0)) ORDER BY b; DETACH DATABASE aux44; SELECT * FROM T WHERE EXISTS (SELECT 1 FROM T t2 WHERE t2.a = T.a); INSERT INTO T VALUES (NULL, NULL, NULL); INSERT OR ROLLBACK INTO T VALUES (NULL, NULL, ''); WITH RECURSIVE cnt(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM cnt WHERE +x<21) SELECT * FROM cnt; ALTER TABLE T DROP COLUMN b; DROP VIEW IF EXISTS T; SELECT ROW_NUMBER() OVER (ORDER BY a ROWS BETWEEN 2 PRECEDING AND 2 FOLLOWING EXCLUDE CURRENT ROW) FROM T; INSERT OR ROLLBACK INTO T VALUES (-2, NULL, 0); ROLLBACK TO sp9694; RELEASE sp9694; ALTER TABLE T ADD COLUMN extra_4532 UNSIGNED BIG INT DEFAULT (abs(random()) % 1000); SELECT a, COUNT(*) FROM T GROUP BY a HAVING COUNT(*) = (SELECT COUNT(*) FROM T); CREATE TRIGGER IF NOT EXISTS trg_T_7371 BEFORE UPDATE ON T FOR EACH ROW BEGIN SELECT RAISE(FAIL, 'no'); END; SELECT COUNT(*) FROM T; ROLLBACK TO sp2531; RELEASE sp2531; INSERT OR ABORT INTO T VALUES (6, 0, 0); SELECT COUNT(*) FROM T; WITH RECURSIVE cnt(x) AS (VALUES(1) UNION SELECT x+1 FROM cnt WHERE x<8) SELECT * FROM cnt; WITH RECURSIVE cnt(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM cnt WHERE x<0) SELECT * FROM cnt; DETACH DATABASE aux84; SELECT * FROM T t1 JOIN T t2 ON t1.a = (SELECT a FROM T LIMIT 1); ALTER TABLE T RENAME TO T_r9068; CREATE TABLE T ( A VARCHAR(10) PRIMARY KEY, B VARCHAR(15), C BIGINT NOT NULL, UNIQUE (B, C) ); INSERT INTO T VALUES ('a', 'p', 3000); INSERT INTO T VALUES ('b', 'q', 9223372036854775807); INSERT INTO T VALUES ('c', 'r', 1700); INSERT INTO T VALUES ('e', 'q', -9223372036854775808); INSERT INTO T VALUES ('f', 'r', 0); SELECT B, COUNT(*) AS D, SUM(C) AS E, AVG(C) AS F FROM T GROUP BY B HAVING SUM(C) > 0; ROLLBACK TRANSACTION TO SAVEPOINT sp9818; RELEASE SAVEPOINT sp9818; SELECT STRING_AGG(a, '|') FROM T; INSERT INTO T VALUES (NULL, NULL, NULL); SELECT LEAD(a, 1, NULL) OVER (ORDER BY a ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T; SELECT RANK() OVER (ORDER BY c GROUPS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) FROM T; SELECT COUNT(*) FROM T; SELECT * FROM T AS a RIGHT OUTER JOIN T AS b ON a.rowid = b.rowid; INSERT INTO T VALUES (NULL, NULL, NULL); ALTER TABLE T ADD COLUMN extra_9504 DOUBLE COLLATE RTRIM; SELECT * FROM T NATURAL JOIN T; ANALYZE; INSERT INTO T DEFAULT VALUES; INSERT INTO T DEFAULT VALUES; INSERT INTO T VALUES (NULL, NULL, NULL); WITH cte AS (SELECT CASE WHEN a > 0 THEN "pos" ELSE "neg" END AS sign FROM T) SELECT * FROM cte; SELECT FIRST_VALUE(c) OVER (ORDER BY c ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW EXCLUDE TIES) FROM T; ALTER TABLE T ADD COLUMN extra_5697 BIGINT COLLATE NOCASE; RELEASE sp4770; PRAGMA short_column_names = OFF; CREATE TRIGGER IF NOT EXISTS trg_T_534 AFTER UPDATE OF A ON T BEGIN SELECT RAISE(FAIL, 'no'); END; SELECT * FROM T WHERE C = (SELECT GROUP_CONCAT(C) FROM T); ALTER TABLE T RENAME TO T_r7047; SELECT * FROM T WHERE EXISTS (SELECT 1 FROM T WHERE EXISTS (SELECT 1 FROM T)); CREATE INDEX IF NOT EXISTS idx_T_4760 ON T(lower(A)); INSERT INTO T DEFAULT VALUES; DROP TABLE IF EXISTS T; ``` ## Actual output ```sql 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 ``` ## Expectation ```sql length 1000000000 sql_length 1000000000 column 2000 expr_depth 1000 compound_select 500 vdbe_op 250000000 function_arg 1000 attached 10 like_pattern_length 50000 variable_number 32766 trigger_depth 1000 worker_threads 0 ``` ## Flag ``` ```