Skip to content

Segmentation fault when running query with partition by and subquery #8437

@qweqq

Description

@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

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions