PSQL doesnt allow to use singleton query result as input parameter of stored procedure when procedure accessed using 'execute procedure' [CORE2538]

[firebird-automations]

Submitted by: Yakov Hrebtov (jake)

Is related to QA406

An attempt to compile PSQL block with:

execute procedure New_Procedure((select 1 from rdb$database));

gives:

Column does not belong to referenced table.
Dynamic SQL Error.
SQL error code = -206.
Subselect illegal in this context.

but 'select from...' compiles smoothly:

select 1
from New_Procedure((select 1 from rdb$database))
into :Foo;

ISQL allows both kind of calls.

Commits: 9bd287b

[firebird-automations]

Modified by: @asfernandes

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 2.5 RC1 [ 10300 ]

assignee: Adriano dos Santos Fernandes [ asfernandes ]

[firebird-automations]

Modified by: @pcisar

Link: This issue is related to QA406 [ QA406 ]

[firebird-automations]

Commented by: @pcisar

QA test added.

[firebird-automations]

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

[firebird-automations]

Modified by: @pavel-zotov

QA Status: No test

[firebird-automations]

Modified by: @pavel-zotov

QA Status: No test => Done successfully