747 B
747 B
Summary
**No review yet**Minimized query
CREATE TABLE [T] (
a TEXT,
b REAL
);
INSERT INTO T VALUES ('' || ('a'),like(unistr_quote('Hello'), '')), ('b',-json_remove(200.5)), ('c',9e999);
SELECT a,b,
LEAD(b,1) OVER (ORDER BY b DESC) AS c,
NTILE(2) OVER (ORDER BY b /* PRAGMA automatic_index = FALSE; */ DESC) AS d FROM T;
Actual output
Parse error near line 5: no such function: unistr_quote
INSERT INTO T VALUES ('' || ('a'),like(unistr_quote('Hello'), '')), ('b',-json
error here ---^
Expectation
Flag