## Summary **No review yet** ## Minimized query ```sql .print https://yewtu.be/watch?v=dQw4w9WgXcQ ATTACH DATABASE ':memory:' AS aux28; CREATE TEMPORARY TABLE "t0"(x, y, z); SELECT -concat_ws('|', NULL, NULL, NULL); SELECT * FROM sqlite_temp_master WHERE sql GLOB '000[]***'; DROP TABLE t0; .quit .filectrl PRAGMA cache_spill = TRUE; PRAGMA vdbe_addoptrace = TRUE; PRAGMA stats; CREATE TEMPORARY TABLE t0(x, y, z); SELECT -trunc(json_quote(99999999999999999999999999999999999999999999999999)); SELECT * FROM sqlite_temp_master WHERE NOT sql GLOB '000[]***'; DROP TABLE t0; .timer on CREATE TABLE t3(x,y); INSERT INTO t3 VALUES(1,NULL); 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; INSERT INTO t3 VALUES(2,NULL); INSERT INTO t3 VALUES(3,4); SELECT count(x), y FROM t3 GROUP BY y ORDER BY 1; SELECT * FROM t3 AS a NATURAL JOIN t3 AS b ON a.rowid = b.rowid; CREATE VIEW IF NOT EXISTS v_t3_1775 AS SELECT y FROM t3; VACUUM main; INSERT INTO t3 VALUES (NULL, NULL); DROP TRIGGER IF EXISTS T; .quit .filectrl PRAGMA cache_spill = TRUE; PRAGMA vdbe_addoptrace = TRUE; PRAGMA stats; CREATE TEMPORARY TABLE t0(x, y, z); SELECT -trunc(json_quote(99999999999999999999999999999999999999999999999999)); SELECT * FROM sqlite_temp_master WHERE NOT sql GLOB '000[]***'; DROP TABLE t0; .timer on CREATE TABLE t3(x,y); INSERT INTO t3 VALUES(1,NULL); 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; INSERT INTO t3 VALUES(2,NULL); INSERT INTO t3 VALUES(3,4); SELECT count(x), y FROM t3 GROUP BY y ORDER BY 1; SELECT * FROM t3 AS a LEFT OUTER JOIN t3 AS b ON a.rowid = b.rowid; CREATE VIEW IF NOT EXISTS v_t3_1775 AS SELECT y FROM t3; VACUUM main; INSERT INTO t3 VALUES (NULL, NULL); DROP TRIGGER IF EXISTS T; .quit .filectrl PRAGMA cache_spill = TRUE; PRAGMA vdbe_addoptrace = TRUE; PRAGMA stats; CREATE TEMPORARY TABLE t0(x, y, z); SELECT -trunc(json_quote(99999999999999999999999999999999999999999999999999)); SELECT * FROM sqlite_temp_master WHERE NOT sql GLOB '000[]***'; DROP TABLE t0; .timer on CREATE TABLE t3(x,y); INSERT INTO t3 VALUES(1,NULL); 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; INSERT INTO t3 VALUES(2,NULL); INSERT INTO t3 VALUES(3,4); SELECT count(x), y FROM t3 GROUP BY y ORDER BY 1; SELECT * FROM t3 AS a LEFT OUTER JOIN t3 AS b ON a.rowid = b.rowid; CREATE VIEW IF NOT EXISTS v_t3_1775 AS SELECT y FROM t3; VACUUM main; INSERT INTO t3 VALUES (NULL, NULL); DROP TRIGGER IF EXISTS T; CREATE TEMP VIEW IF NOT EXISTS v_t0_2745 AS SELECT y FROM t0; UPDATE t0 SET y = NULL WHERE 1 RETURNING *; SELECT * FROM t3; ANALYZE; DELETE FROM t3 WHERE 1; ALTER TABLE t0 DROP COLUMN x; DELETE FROM t3 WHERE 1; SELECT * FROM t0 AS a LEFT OUTER JOIN t0 AS b ON a.rowid = b.rowid; 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; REINDEX; SELECT * FROM t0 WHERE y NOT IN (SELECT y FROM t0 WHERE y IS NULL); DETACH DATABASE aux28; ALTER TABLE T ADD COLUMN extra_139 ANY DEFAULT 0; SELECT * FROM T WHERE A <> ALL (SELECT A FROM T); 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 T; DROP INDEX IF EXISTS t3; 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; CREATE INDEX IF NOT EXISTS idx_t3_3532 ON t3(x); INSERT INTO t3 VALUES (1, 'x') ON CONFLICT(x) DO UPDATE SET x = excluded.x, y = excluded.y; ``` ## Actual output ```sql https://yewtu.be/watch?v=dQw4w9WgXcQ ``` ## Expectation ```sql ``` ## Flag ``` ```