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]

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

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

[1]: https://www.sqlite.org/download.html