Gene Sacky wrote: > This query causes segmentation fault in SQLite 3.26.0 (on macOS 10.14.1). > -------------- > SELECT * FROM( > SELECT * FROM (SELECT 1 AS c) WHERE c IN ( > SELECT (row_number() OVER()) FROM (VALUES (0)) > ) > ) > -------------- > > However, no error occurs in the following queries. The only difference is > whether it is wrapped with "SELECT * FROM" . > -------------- > SELECT * FROM( > SELECT 1 AS c WHERE c IN ( > SELECT (row_number() OVER()) FROM (VALUES (0)) > ) > ) > -------------- > > -------------- > SELECT * FROM (SELECT 1 AS c) WHERE c IN ( > SELECT (row_number() OVER()) FROM (VALUES (0)) > ) > --------------
The above fault and non-fault also occur on Windows 10 x64 (with a 64-bit build) with the SQLite3 v3.26 shell. I can provide build options and compile flags if that would be useful. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
