|
If you were logged in you would be able to see more operations.
|
|
|
|
Environment:
|
LI-V2.1.2.18118 Classic AMD64
|
|
Issue Links:
|
Relate
|
|
|
|
This issue is related to:
|
|
|
|
|
|
|
|
| Planning Status: |
Unspecified
|
|
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.
|
|
Description
|
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. |
Show » |
|
Bug
PSQL doesnt allow to use singleton query result as input parameter of stored procedure when procedure accessed using 'execute procedure'