ast-project/part1/results/3/bug_64ca052c-9bf2-4f80-be2e-a8df50d81908_unexpected_error.md

Summary

**No review yet**

Minimized query

.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

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

Flag