Segmentation fault when running query with partition by and subquery

[qweqq]

Hello!

When running the following query, firebird crashes with a Segmentation fault:

select  row_number() over (partition by (select 1 from rdb$database)) from rdb$database;

Tested on Debian 12.9 (latest stable) with both Debian packaged binaries for Firebird 3 and official binaries by the FirebirdSQL project for Firebird 3.0.12, 4.0.5 and 5.0.2. When running the query against a Firebird 3.0.11 x64 on Windows Server 2019 it also crashes.

Regards,
Hristo Stefanov

[qweqq]

The crash also happens on 3.0.12 - mentioning this since there's a missing "affect-version:" label and hoping for the fix to be backported to it as well.