ast-project/part1/results/2/bug_3eb3a500-44e1-4053-95fa-b1ac7cc85e98_logic.md

Summary

**No review yet**

Minimized query

PRAGMA analysis_limit;
PRAGMA full_column_names = YES;
PRAGMA query_only = 0;
.mode
CREATE TABLE T1 (
  A VARCHAR(10) PRIMARY KEY,
  B VARCHAR(15) UNIQUE,
  C BIGINT
);
CREATE TABLE T2 (
  X VARCHAR(20) PRIMARY KEY,
  A VARCHAR(10),
  FOREIGN KEY (A) REFERENCES T1(A)
);
INSERT INTO T1 VALUES ('a', 'p', 9999999999999);
INSERT INTO T1 VALUES ('b', 'q', -9999999999999);
INSERT INTO T2 VALUES ('m', 'a');
INSERT INTO T2 VALUES ('n', 'b');
SELECT T2.X, T1.C FROM T2 INNER JOIN T1 ON T2.A = T1.A WHERE T1.C > -1000000000000;
DELETE FROM T2 WHERE A > (SELECT AVG(A) FROM T2) RETURNING *;
REINDEX T2;

Actual output

0
current output mode: list
m|9999999999999
m|a
n|b

Expectation

0
current output mode: list --escape ascii
m|9999999999999
m|a
n|b

Flag