-bail not seem to work properly
(1) By anonymous on 2020-11-25 13:22:19 [source]
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
(2) By Richard Hipp (drh) on 2020-11-25 14:03:36 in reply to 1 [link] [source]
Please recompile using the latest prerelease snapshot and report back whether or not that clears your problem.