ast-project/part1/results/2/bug_475bc22d-3822-4c69-812a-b8e35d283a48_unexpected_error.md

Summary

**No review yet**

Minimized query

.eqp off
.prompt
.connection
ATTACH DATABASE ':memory:' AS aux57;
.progress NULL
ATTACH DATABASE ':memory:' AS aux98;
CREATE TABLE T (
  a DOUBLE,
  b TEXT,
  c REAL
);
INSERT INTO T VALUES (tan(concat('a', 'b', 'c')),'a',CAST(json_valid(datetime(nullif(NULL, unhex(x'0e447c775161bae0c58333712cadca', ' ')), '+1 day'), 2) AS SMALLINT)), (2,'b',-3.5), (3,'c',9e999);
WITH d AS (SELECT * FROM T) SELECT * FROM d WHERE NOT +c < 0;
UPDATE T SET b = -85 WHERE b IS NOT NULL;
VACUUM;
DETACH DATABASE aux98;
WITH RECURSIVE tree(id, parent, depth) AS (VALUES(1, NULL, 0) UNION ALL SELECT id+1, id, depth+1 FROM tree WHERE depth<6) SELECT * FROM tree;
SELECT * FROM T AS a JOIn T AS b ON a.rowid = b.rowid;
SELECT * FROM T AS a RIGHT JOIN T AS b ON a.rowid = b.rowid;
PRAGMA trusted_schema = ON;
VACUUM;
WITH cte(x) AS (VALUES(NULL),(1),(NULL)) SELECT * FROM cte WHERE x IS NOT NULL;
DETACH DATABASE aux57;
CREATE TABLE T1 (
  a INTEGER,
  b TEXT
);
CREATE TABLE "T2" (
  a INTEGER,
  b TEXT
);
INSERT INTO T1 VALUES (1,'a'),(2,'b');
INSERT INTO T2 VALUES (1,'c'),(1,'d'); /* soundex('Rupert') */ SELECT T1.b,
(
  SELECT GROUP_CONCAT(b,',')
  FROM T2
  WHERE T2.a=T1.a
) AS c
FROM T1;
ANALYZE T1;
ANALYZE T1;
DELETE FROM T2 WHERE b > (SELECT AVG(b) FROM T2) RETURNING *;
CREATE TRIGGER IF NOT EXISTS trg_T1_2080 AFTER UPDATE OF b ON T1 FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'rb'); END;
REINDEX T;
DELETE FROM T1 WHERE 0;
ALTER TABLE T2 RENAME COLUMN a TO a_r2;
REINDEX;
CREATE TRIGGER IF NOT EXISTS trg_T_1920 AFTER DELETE ON T BEGIN SELECT RAISE(IGNORE); END;
DROP INDEX IF EXISTS T2;
CREATE TRIGGER IF NOT EXISTS trg_T1_9937 BEFORE UPDATE OF b ON T1 BEGIN SELECT RAISE(ROLLBACK, 'rb'); END;
WITH cte AS (SELECT b, COUNT(*) AS cnt FROM T1 GROUP BY b) SELECT * FROM cte WHERE cnt > 1;
WITH cte AS (SELECT NULL AS x, NULL AS y) SELECT x, y, x IS NULL FROM cte;
INSERT OR IGNORE INTO T1 VALUES (8, -3);
UPDATE T SET b = NULL WHERE rowid = 1 RETURNING *;
CREATE  INDEX IF NOT EXISTS idx_T_3339 ON T(lower(a)) WHERE a IS NOT NULL;

SELECT COUNT(*) FROM T;
SELECT * FROM T1 AS a LEFT JOIN T AS b ON a.rowid = b.rowid;
VACUUM main;
SELECT * FROM T;
REINDEX;
SELECT AVG(a) FROM T1;

Actual output

ACTIVE 0: :memory:
1||0
2|1|1
3|2|2
4|3|3
5|4|4
6|5|5
7|6|6
1
a|c,d
b|
1|c
1|d
||1
0
1|a|||
2|b|||
8|-3|||
3.66666666666667

Expectation

Flag