ast-project/part1/results/1/bug_15655fe8-d231-46bf-9dfb-cba336c53931_unexpected_error.md

Summary

**No review yet**

Minimized query

PRAGMA empty_result_callbacks = TRUE;
PRAGMA legacy_alter_table = OFF;
ATTACH DATABASE ':memory:' AS aux42;
-- PRAGMA case_sensitive_like = 1;

BEGIN DEFERRED TRANSACTION;
-- -mmap 5

SAVEPOINT sp1653;
CREATE TABLE T (
  a DOUB,
  b REAL,
  c REAL
);
INSERT INTO T VALUES (power(-likely(CAST(-if(1, 9223372036854775807, 0, 9223372036854775807, 0, 9223372036854775807) AS INT)), 1),1.5,10.0), (2,-2.5,20.0), (3,-9e999,30.0);
SELECT * FROM T WHERE b < 2.0 ORDER BY b;
ALTER TABLE T  RENAME TO T_r6919;
CREATE TABLE T (
  a INTEGER,
  b REAL,
  c REAL
);
INSERT INTO T VALUES (1,2.0,10.5), (1,-3.5,20.25), (2,9e999,-1.0);
WITH d AS (SELECT a,SUM(b*c) AS e FROM T GROUP BY a) SELECT * FROM d;
ALTER TABLE T DROP COLUMN a;
SELECT COUNT(*) FROM T;
PRAGMA stats;
UPDATE T SET c = ('x' || '') WHERE rowid = 1 RETURNING *;
RELEASE sp1653;
WITH cte AS (SELECT NULL AS x, NULL AS y) SELECT x, y, x IS NULL FROM cte;
END;
VACUUM;
DETACH DATABASE aux42;
SELECT MIN(b) FILTER (WHERE b IS NOT NULL) OVER (ORDER BY b RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING EXCLUDE NO OTHERS) FROM T;
ALTER TABLE T DROP COLUMN c;
ANALYZE T;
PRAGMA ignore_check_constraints = ON;
ANALYZE;
ALTER TABLE T ADD COLUMN extra_5916 BIGINT COLLATE RTRIM;
SELECT * FROM T AS a LEFT OUTER JOIN T AS b ON a.rowid = b.rowid;
CREATE  INDEX IF NOT EXISTS idx_T_2413 ON T(lower(b)) WHERE b > 0;
CREATE TEMP  VIEW IF NOT EXISTS v_T_6052 AS SELECT b FROM T;
DELETE FROM T WHERE b > (SELECT AVG(b) FROM T) RETURNING *;
REINDEX T;
PRAGMA parser_trace = 0;
SELECT * FROM T;

Actual output

1|-49.875
2|-Inf
3
2.0|x
||1
-3.5
2.0
Inf
2.0||2.0|
-3.5||-3.5|
Inf||Inf|
2.0|
-3.5|
Inf|

Expectation

Flag