825 B
825 B
Summary
**No review yet**Minimized query
BEGIN TRANSACTION;
PRAGMA vdbe_addoptrace = YES;
PRAGMA journal_mode;
ATTACH DATABASE (':memory:' || '') AS aux37;
CREATE TABLE [T] (
a INTEGER,
b REAL,
c REAL
);
INSERT INTO T VALUES (unhex(round(min('z', 'a', 'm'), ((x'85ae0e696c3a31' + 2) - 0)), ' '),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;
SELECT LEAD(a, 2, 'default') OVER (ORDER BY a ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING EXCLUDE GROUP) FROM T;
DETACH DATABASE aux37;
COMMIT TRANSACTION;
Actual output
memory
Expectation
Flag