Skip to content

Firebird 2.5: SELECT on specific table causes FireDAC timeout and HeidiSQL crash #2492

Description

@pillareck

Description

Environment:

HeidiSQL 12.17.0.7292
Windows 11 x64
Firebird 2.5.9 x64
Firebird experimental driver
Connection using fbclient.dll

Problem:
Connection works correctly and I can browse most tables normally.

However, executing the following query causes a FireDAC timeout exception and HeidiSQL crashes shortly after:

select * from clientes;

Exception:
[FireDAC][Stan]-700. Timeout expired.

Behavior details:

Table "CLIENTES" size: ~4 MB
Other tables work correctly
Database dialect: 3
Firebird server version:
WI-V6.3.9.27139 Firebird 2.5

Additional tests:
This query works correctly:

select first 10 * from clientes;

This query crashes HeidiSQL immediately:

select codigo from clientes;

This behavior may indicate a problem during dataset fetch or field handling on larger result sets.

madExcept crash report attached separately.

Thanks.

bugreport.txt

HeidiSQL version and OS

12.17.0.7292

Database server version

Firebird 2.5.9 x64

Reproduction recipe

Connect HeidiSQL to a Firebird 2.5 database using the experimental Firebird driver and fbclient.dll.
Open SQL editor.
Execute:

select * from clientes;

HeidiSQL throws:
[FireDAC][Stan]-700. Timeout expired.
Shortly after the exception, HeidiSQL crashes/closes.

Additional observations:

select first 10 * from clientes; works correctly.
select codigo from clientes; crashes HeidiSQL immediately.
Other tables can be queried normally.

Error/Backtrace

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugDefective behaviour in HeidiSQLnettype-interbase-firebirdInterbase or Firebird specific issue

    Type

    No type

    Fields

    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions