|Title:||Assertion fault when window functions are used.|
|Last Modified:||2018-12-07 01:56:46|
|Version Found In:||3.26.0|
drh added on 2018-12-06 17:17:39:
The following SQL leads to an assertion fault. <blockquote><verbatim> SELECT * FROM( SELECT * FROM (SELECT 1 AS c) WHERE c IN ( SELECT (row_number() OVER()) FROM (VALUES (0)) ) ); </verbatim></blockquote> This problem has existed since window functions were added in 3.25.0. Incorrect bytecode is being generated for the row_number() function. This problem was originally reported on the mailing list Gene Sacky.