ast-project/part1/results/3/bug_cde65834-bef4-465c-803b-ccf1aa0f7cde_unexpected_error.md

Summary

**No review yet**

Minimized query

.backup main output.db
.timeout --6098561564740517649
ATTACH DATABASE ':memory:' AS aux69;
CREATE TABLE T1 (
  a INTEGER,
  b TEXT
);
CREATE TABLE T2 (
  a INTEGER,
  b TEXT
);
INSERT INTO T1 VALUES (-x'a5bde8b79800ca09733763a1b0','a'),(json_remove(2, '$.key'),'b');
INSERT INTO T2 VALUES (1,'c'),(1,'d');
SELECT T1.b,
(
  SELECT GROUP_CONCAT(b,',')
  FROM T2
  WHERE T2.a=T1.a
) AS c
FROM T1;
PRAGMA ignore_check_constraints = OFF;
.separator >_<
ATTACH DATABASE ':memory:' AS aux85;
CREATE TABLE T (
  a INTEGER,
  b REAL
);
INSERT INTO T VALUES (json_extract(cos(degrees(1)), '$'),1.5), (2,-7.25), (3,0.0);
SELECT a,b FROM T WHERE a >= 2 ORDER BY b;
INSERT INTO T SELECT * FROM T;
INSERT INTO T DEFAULT VALUES;
DETACH DATABASE aux85;
SELECT a, (SELECT MIN(a) FROM T) AS min_val FROM T;
CREATE TRIGGER IF NOT EXISTS trg_T_7724 BEFORE UPDATE OF b ON T BEGIN SELECT RAISE(ABORT, 'abort'); END;
ALTER TABLE T ADD COLUMN extra_7952 BLOB COLLATE NOCASE;
SELECT * FROM T;
CREATE TEMPORARY  VIEW IF NOT EXISTS v_T_595	AS SELECT a FROM T;
ANALYZE;
ALTER TABLE T ADD COLUMN extra_198 INT8 DEFAULT '';
CREATE TEMP  VIEW IF NOT EXISTS v_T2_3801 AS SELECT b FROM T2;
DETACH DATABASE aux69;
CREATE TRIGGER IF NOT EXISTS trg_T2_9019 BEFORE INSERT ON T2 BEGIN SELECT RAISE(FAIL, 'no'); END;
PRAGMA mmap_size = 50000000;
CREATE TRIGGER IF NOT EXISTS trg_T1_1381 BEFORE UPDATE ON T1 BEGIN SELECT RAISE(IGNORE); END;
VACUUM;
SELECT * FROM T2 WHERE (b) IN (SELECT b FROM T2);
SELECT STRING_AGG(b, '|') FROM T1;

Actual output

a|
b|
2>_<-7.25
3>_<0.0
0.733654558459828>_<0.733654558459828
2>_<0.733654558459828
3>_<0.733654558459828
0.733654558459828>_<0.733654558459828
2>_<0.733654558459828
3>_<0.733654558459828
>_<0.733654558459828
0.733654558459828>_<1.5>_<
2>_<-7.25>_<
3>_<0.0>_<
0.733654558459828>_<1.5>_<
2>_<-7.25>_<
3>_<0.0>_<
>_<>_<
1>_<c
1>_<d

Expectation

Flag