Op do 10 okt. 2019 om 15:06 schreef Jose Isaias Cabrera:
> > Simon Charette, on Tuesday, October 8, 2019 08:00 PM, wrote...
> > >
> > > While trying to enable support for FILTER (WHERE) on SQLite 3.30 for
> > > the Django ORM we discovered a crash that can be reduced to the
> > > following
> I am sorry, Simon. You are correct. In Windows sqlite3 just disappears. :-)
On Cygwin:
$ sqlite3
SQLite version 3.30.0 2019-10-04 15:03:17
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> CREATE TABLE item (id int, price int);
sqlite> INSERT INTO item (id, price) VALUES (1, 1);
sqlite> SELECT COUNT(id) FILTER (WHERE double_price > 42) FROM (SELECT
id, (price * 2) as double_price FROM item);
Segmentation fault (core dumped)
Indeed, something is wrong there!
Regards,
Jan Nijtmans
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
