Hello, came across a problem while using bail.
sqlite3 -init poc -bail
where poc contains:
DROP TABLE IF EXISTS t1;
CREATE TABLE t1(a INTEGER PRIMARY KEY, b CHAR(1), c CHAR(2), d ANY);
INSERT INTO t1 VALUES
(10,'J', 'cc', NULL),
(11,'K', 'cc', 'xyz'),
(13,'M', 'cc', NULL);
SELECT sum(a) OVER (PARTITION BY c ORDER BY d ASC) AS xyz FROM t1 ORDER BY sum(xyz);
This code brings error:
Error: near line 8: misuse of aliased window function xyz
and the sqlite shell should terminate, as I am using -bail option, but it does not terminates. Am I missing something or is it a bug ?
Thanks.
Ondrej