## Summary **No review yet** ## Minimized query ```sql .width BEGIN DEFERRED TRANSACTION; ATTACH DATABASE ':memory:' AS aux50; CREATE TABLE t1(a,b); INSERT INTO t1 VALUES((round((mod(jsonb_array(), 0) * 1), -1) + 1),11); 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 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 GROUP_CONCAT(c, '.') OVER (ORDER BY c ROWS BETWEEN 2 PRECEDING AND 2 FOLLOWING EXCLUDE CURRENT ROW) FROM t2; CREATE TABLE T ( A VARCHAR(15) PRIMARY KEY, B VARCHAR(30) NOT NULL, C BIGINT UNIQUE ); INSERT INTO T VALUES ('a', 'x', -9223372036854775808); INSERT INTO T VALUES ('b', 'y', -1000000); INSERT INTO T VALUES ('c', 'y', 0); INSERT INTO T VALUES ('d', 'y', 42); INSERT INTO T VALUES ('e', 'x', 9223372036854775807); INSERT INTO T VALUES ('f', 'z', 2147483648); SELECT * FROM T WHERE +C > 0 ORDER BY C DESC; DETACH DATABASE aux50; SELECT c, COUNT(*) FROM t2 GROUP BY c HAVING COUNT(*) = (SELECT COUNT(*) FROM t2); ALTER TABLE t2 ADD COLUMN extra_7337 SMALLINT; COMMIT; VACUUM; SELECT * FROM t1 AS a LEFT JOIN T AS b ON a.rowid = b.rowid; UPDATE T SET C = NULL; ``` ## Actual output ```sql 22|922 44|944 66|966 88|988 4.6 2.6.8 2.4.8 4.6 e|x|9223372036854775807 f|z|2147483648 d|y|42 2|22|a|x|-9223372036854775808 4|44|b|y|-1000000 6|66|c|y|0 8|88|d|y|42 ``` ## Expectation ```sql ``` ## Flag ``` ```