ast-project/part1/results/3/bug_346a0234-e9f7-47ef-82ce-16aa3fd5c42e_logic.md

Summary

**No review yet**

Minimized query

ATTACH DATABASE ':memory:' AS aux68;
.fullschema
CREATE TABLE T (
  a TEXT,
  b TEXT,
  c REAL
);
INSERT INTO T VALUES ('a','b',x'682f554feb092cde0c4f302c570051'), ('a','c',-(-((mod(json_extract(5.0, '$.key'), 5.0) - 0)))), ('b','d',-8.25);
SELECT a,b,c,
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;
INSERT INTO T SELECT * FROM T;
ALTER TABLE T DROP COLUMN a; /* pi() */ WITH RECURSIVE cnt(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM cnt WHERE x>=83) SELECT MAX(x) FROM cnt;
WITH cte AS (SELECT * FROM T) SELECT * FROM cte;
CREATE TRIGGER IF NOT EXISTS trg_T_6741 BEFORE INSERT ON T BEGIN SELECT RAISE(IGNORE); END;
DETACH DATABASE aux68;

Actual output

/* No STAT tables available */
a|b|h/UOë	,ÞO0,W|1
a|c||2
b|d|-8.25|1
1
b|h/UOë	,ÞO0,W
c|
d|-8.25
b|h/UOë	,ÞO0,W
c|
d|-8.25

Expectation

/* No STAT tables available */
a|b|h/UOë	,Þ^LO0,W|1
a|c||2
b|d|-8.25|1
1
b|h/UOë	,Þ^LO0,W
c|
d|-8.25
b|h/UOë	,Þ^LO0,W
c|
d|-8.25

Flag