## Summary **No review yet** ## Minimized query ```sql PRAGMA short_column_names; BEGIN IMMEDIATE TRANSACTION; CREATE VIRTUAL TABLE t0 USING fts4("x", "y", "z"); DROP TABLE t0; CREATE TABLE main.t1(a,b); INSERT INTO t1 VALUES(pi(),jsonb_insert(4722785646842838875, '$.key', 4722785646842838875)); INSERT INTO t1 VALUES(2,22); INSERT INTO t1 SELECT a+2, b+22 FROM t1; INSERT INTO t1 SELECT a+4, b+44 FROM t1; CREATE TABLE main.t2(c,d); INSERT INTO t2 SELECT a, 900+b FROM t1; PRAGMA automatic_index=ON; SELECT b, d FROM t1 JOIN t2 ON a=c ORDER BY b; SELECT COUNT(*) FROM t2; DELETE FROM t1 WHERE b > (SELECT AVG(b) FROM t1) RETURNING *; CREATE INDEX IF NOT EXISTS idx_t1_3986 ON t1((a + 1)) WHERE a IS NOT NULL; COMMIT TRANSACTION; CREATE TABLE T ( a INTEGER, b TEXT, c INTEGER ); INSERT INTO T VALUES (1,'a',NULL), (2,'b',1), (3,'c',2); WITH RECURSIVE d(a,b,c,e) AS ( SELECT *,1 FROM T WHERE c IS NULL UNION ALL SELECT T.a,T.b,T.c,d.e+1 FROM T JOIN d ON T.c=d.a ) SELECT * FROM d; SELECT * FROM t2 AS a INNER JOIN t1 AS b ON a.rowid = b.rowid; ALTER TABLE t1 ADD COLUMN extra_716 SMALLINT DEFAULT NULL; DROP TRIGGER IF EXISTS t2; VACUUM main; INSERT INTO t1 SELECT * FROM t1; INSERT INTO t1 DEFAULT VALUES; SELECT GROUP_CONCAT(c) FROM t2; INSERT OR ABORT INTO t2 VALUES (NULL, 4); SELECT COUNT(*) FROM t1; ``` ## Actual output ```sql 1 22|922 44|944 66|966 88|988 4 6|66 8|88 1|a||1 2|b|1|2 3|c|2|3 2|922|2|22 4|944|4|44 2,4,6,8 5 ``` ## Expectation ```sql ``` ## Flag ``` ```