Package constants (#8916). Line "Dynamic SQL Error" can be missing in some queries

10 views
Skip to first unread message

Pavel Zotov

unread,
Jun 21, 2026, 4:45:10 AM (3 days ago) Jun 21
to firebird-devel

This is link to following 6x snapshots:
6.0.0.1942-20260511_211500-c2d905a -- last prior package constants;
6.0.0.1942-20260511_214515-7589a56 -- first with package constants (#8916)

Consider command:
echo select 1 from rdb$relations,rdb$indices order by rdb$relation_name rows 1; | isql localhost:employee


On 6.0.0.1942-20260511_211500-c2d905a its output will be:
==========
Statement failed, SQLSTATE = 42702
Dynamic SQL Error
-SQL error code = -204
-Ambiguous field name between table "SYSTEM"."RDB$RELATIONS" and table "SYSTEM"."RDB$INDICES"
-RDB$RELATION_NAME
==========

On 6.0.0.1942-20260511_214515-7589a56 the line "Dynamic SQL Error" is missing:
==========
Statement failed, SQLSTATE = 42702
SQL error code = -204
-Ambiguous field name between table "SYSTEM"."RDB$RELATIONS" and table "SYSTEM"."RDB$INDICES"
-RDB$RELATION_NAME
==========

Is it expected ?

PS.

Such difference does not appear in all cases.
For example, in this case all parts of error message will be same:

echo select foo from rdb$relations,rdb$indices order by rdb$relation_name rows 1; | C:\FB\60sc\isql /:employee

Statement failed, SQLSTATE = 42S22
Dynamic SQL Error
-SQL error code = -206
-Column unknown
-"FOO"

Reply all
Reply to author
Forward
0 new messages