ast-project/part1/results/1/bug_e73d70f9-3040-471f-b613-0e5f8c2f1dc9_unexpected_error.md

Summary

**No review yet**

Minimized query

create temp table t1(x);
CREATE VIRTUAL TABLE t0 USING fts4("x", "y", "z");
DROP TABLE t0;
insert into t1 values('amx');
insert into t1 values('anx');
insert into t1 values('amy');
insert into t1 values('bmy');
select * from t1 where x like 'a__' intersect select * from t1 where x like '_m_' intersect select * from t1 where x like '__x';
ALTER TABLE t1 RENAME COLUMN x TO x_r2687;
CREATE TEMP  VIEW IF NOT EXISTS v_t1_5688 AS SELECT x FROM t1;
CREATE TABLE T (
  a TEXT,
  b REAL
);
INSERT INTO T VALUES ('a',1.7976931348623157e+308), ('b',-200.5), ('c',9e999);
SELECT a,b,
LEAD(b,1) OVER (ORDER BY b DESC) AS c,
NTILE(2) OVER (ORDER BY b DESC) AS d FROM T;
SELECT * FROM t1;
WITH a AS (SELECT * FROM T WHERE b IS NOT NULL), b AS (SELECT * FROM a WHERE b IS 0), c AS (SELECT * FROM b LIMIT 10) SELECT * FROM c;
SELECT * FROM t1;
CREATE TRIGGER IF NOT EXISTS trg_t1_2875 AFTER UPDATE OF x ON t1 FOR EACH ROW BEGIN SELECT RAISE(FAIL, 'no'); END;
SELECT * FROM T;
PRAGMA wal_checkpoint('NOOP');
DELETE FROM T WHERE rowid = 35;
CREATE TRIGGER IF NOT EXISTS trg_T_3662 AFTER DELETE ON T FOR EACH ROW BEGIN INSERT INTO T(a) VALUES (NULL); END;
REINDEX t1;
SELECT * FROM T CROSS JOIN t1;
DELETE FROM T WHERE 0 RETURNING *;
SELECT * FROM T AS a LEFT OUTER JOIN T AS b ON a.rowid = b.rowid;
DROP TABLE IF EXISTS T;
PRAGMA short_column_names = TRUE;

Actual output

amx
c|Inf|1.79769313486232e+308|1
a|1.79769313486232e+308|-200.5|1
b|-200.5||2
amx
anx
amy
bmy
amx
anx
amy
bmy
a|1.79769313486232e+308
b|-200.5
c|Inf
0|-1|-1
a|1.79769313486232e+308|amx
a|1.79769313486232e+308|anx
a|1.79769313486232e+308|amy
a|1.79769313486232e+308|bmy
b|-200.5|amx
b|-200.5|anx
b|-200.5|amy
b|-200.5|bmy
c|Inf|amx
c|Inf|anx
c|Inf|amy
c|Inf|bmy
a|1.79769313486232e+308|a|1.79769313486232e+308
b|-200.5|b|-200.5
c|Inf|c|Inf

Expectation

Flag