ast-project/part1/results/2/bug_aad566fd-e084-4760-b4fe-a116b0fb3ed0_logic.md

Summary

**No review yet**

Minimized query

CREATE TABLE T (
  a INTEGER,
  b TEXT,
  c REAL
);
INSERT INTO T VALUES (substring(-pi(), random() % 100),'' || ('a'),1.25), (2,'b',-3.5), (3,'c',0.0);
SELECT * FROM T WHERE c < 2.0 ORDER BY c;
ALTER TABLE T RENAME COLUMN c TO c_r522;
INSERT INTO T SELECT * FROM T;

Actual output

2|b|-3.5
3|c|0.0
5358979|a|1.25

Expectation

2|b|-3.5
3|c|0.0
|a|1.25

Flag