SQLite Forum

-bail not seem to work properly
Login

-bail not seem to work properly

(1) By anonymous on 2020-11-25 13:22:19 [link] [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 [source]

Please recompile using the latest prerelease snapshot and report back whether or not that clears your problem.