ast-project/part1/results/1/bug_cb8d32cf-9e37-4699-861d-666989c869b3_unexpected_error.md

Summary

**No review yet**

Minimized query

.dump main
PRAGMA secure_delete = YES;
CREATE TABLE T (
  a INTEGER,
  b TEXT,
  c INTEGER
);
INSERT INTO T VALUES (octet_length(123),'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;
ALTER TABLE T ADD COLUMN extra_6942 NUMERIC DEFAULT 0;

Actual output

PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
COMMIT;
1

Expectation

Flag