priority: Major [ 3 ] => Minor [ 4 ]

description: Error when compiling the procedure containing the statement if (x = (select ...))

for example:

compilation procedures

create or alter procedure Test_C
as
declare variable X varchar(16);
begin

if (x =(select '123' from Rdb$Database)) then
begin
exit;
end
end

fails with a message
Column unknown. X

=>

Error when compiling the procedure containing the statement if (x = (select ...))

for example:

create or alter procedure Test_C
as
declare variable X varchar(16);
begin

if (x = (select '123' from Rdb$Database)) then
begin
exit;
end
end

fails with a message
Column unknown. X

Of course, it can be worked around using the colon prefix: if (:x = (select ...)) but the following works without errors:

create or alter procedure Test_C
as
declare variable X varchar(16);
begin

if ((select '123' from Rdb$Database) = x) then
begin
exit;
end
end

Supposedly, the parser should be consistent here.

Version: 2.5.2 [ 10450 ]

assignee: Adriano dos Santos Fernandes [ asfernandes ]

Version: 2.5.3 [ 10461 ] =>

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

resolution: Fixed [ 1 ]

Fix Version: 2.5.3 [ 10461 ]

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

QA Status: Done successfully

Link: This issue is related to QA606 [ QA606 ]