ast-project/part1/results/3/bug_b4548fc0-3d89-4e07-b00a-07b0d0a58177_logic.md

Summary

**No review yet**

Minimized query

ATTACH DATABASE ':memory:' AS aux54;
-- LEAD({c}, 2, 'default')

CREATE TABLE T (
  a INTEGER,
  b TEXT,
  c REAL,
  d REAL
);
INSERT INTO T VALUES (-iif(NULL, likelihood(4041010528813953889, 0.5), 4041010528813953889),'a',40.5,-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999);
SELECT b FROM T WHERE ABS(c) > 5 AND ABS(d) > 5;
WITH RECURSIVE empty(x) AS (SELECT 1 WHERE 1=0 UNION ALL SELECT x+1 FROM empty WHERE x<10) SELECT * FROM empty;
SELECT * FROM T AS a RIGHT JOIN T AS b ON a.rowid = b.rowid;

SELECT COUNT(*) FROM T;
DETACH DATABASE aux54;

SELECT COUNT(*) FROM T;
UPDATE T SET a = a + 1 WHERE rowid = 1;
UPDATE T SET a = json_object('k', a) WHERE a IS NOT NULL RETURNING *;
UPDATE T SET a = a + 1;
DELETE FROM T WHERE 0;
SELECT * FROM T;

Actual output

a
b
c
-4041010528813953889|a|40.5|-70.0|-4041010528813953889|a|40.5|-70.0
2|b|-10.25|20.5|2|b|-10.25|20.5
3|c|Inf|-Inf|3|c|Inf|-Inf
3
3
{"k":-4041010528813953888}|a|40.5|-70
{"k":2}|b|-10.25|20.5
{"k":3}|c|Inf|-Inf
1|a|40.5|-70.0
1|b|-10.25|20.5
1|c|Inf|-Inf

Expectation

a
b
c
-4041010528813953889|a|40.5|-70.0|-4041010528813953889|a|40.5|-70.0
2|b|-10.25|20.5|2|b|-10.25|20.5
3|c|Inf|-Inf|3|c|Inf|-Inf
3
3
{"k":-4041010528813953888}|a|40.5|-70.0
{"k":2}|b|-10.25|20.5
{"k":3}|c|Inf|-Inf
1|a|40.5|-70.0
1|b|-10.25|20.5
1|c|Inf|-Inf

Flag