ast-project/part1/results/3/bug_d4e4fe3a-8567-4312-b35c-94a6db732b35_unexpected_error.md

Summary

**No review yet**

Minimized query

PRAGMA fullsync = OFF;
PRAGMA locking_mode = 'NORMAL';
BEGIN EXCLUSIVE;
.eqp auto
PRAGMA temp_store = '0';
-- .log ON

.explain auto
PRAGMA query_only = OFF;
ATTACH DATABASE ':memory:' AS aux18;
.log ON
PRAGMA /**/ legacy_alter_table = ON;
CREATE TABLE [T] (
  a TEXT,
  b INTEGER,
  c REAL
);
INSERT INTO T VALUES ('a',NULL,jsonb_group_array(hex('hello'))), ('a',substr(julianday(CAST(-x'' AS BLOB)), -(-(ceiling(pi())))),-sign(-(jsonb_array() + (0.0 + 0)))), ('b',1,4.5);
SELECT a,b,c,
SUM(c) OVER (
  PARTITION BY a
  ORDER BY b
) AS d
FROM T;
SELECT * FROM T AS a RIGHT OUTER JOIN T AS b ON a.rowid = b.rowid;
SELECT b, (SELECT AVG(b) FROM T) AS avg_val FROM T;
SELECT CUME_DIST() OVER (PARTITION BY a ORDER BY a RANGE BETWEEN 1 PRECEDING AND 1 FOLLOWING) FROM T;
DETACH DATABASE aux18;
COMMIT TRANSACTION;

Actual output

exclusive

Expectation

Flag