Re: [sqlite] Segmentation fault when using window function with (nested?) subquery

On 12/6/18, Larry Brasfield wrote: > > 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. Thanks, but I have no trouble reproducing the problem. It is an issue

Re: [sqlite] Segmentation fault when using window function with (nested?) subquery

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

[sqlite] Segmentation fault when using window function with (nested?) subquery

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