Table columns hide destination variables of RETURNING INTO [CORE1256]

[firebird-automations]

Submitted by: @asfernandes

Is related to QA146

SQL> create table t (n integer)!
SQL>
SQL> -- ok
SQL> execute block returns (n integer)
CON> as
CON> begin
CON> insert into t values (1) returning n into :n;
CON> suspend;
CON> end!

       N

============
1

SQL> -- not ok
SQL> execute block returns (n integer)
CON> as
CON> begin
CON> insert into t values (1) returning n into n;
CON> suspend;
CON> end!

       N

============
<null>

Commits: bf89534

[firebird-automations]

Modified by: @asfernandes

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

resolution: Fixed [ 1 ]

[firebird-automations]

Modified by: @pcisar

Link: This issue is related to QA146 [ QA146 ]

[firebird-automations]

Modified by: @pcisar

Version: 2.0.2 [ 10130 ] =>

[firebird-automations]

Commented by: @pcisar

I have created a test according to your specification, but I can't reproduce the bug with 2.0.1 and 2.1 Alpha 1. They return 1 like 2.1 Beta 1. I can't close it until we'll clarify it as either test case or Affected version definition is wrong.

[firebird-automations]

Commented by: @asfernandes

Because you wrote the test using the first statement (into :n)...
The incorrect is the second (into n).

[firebird-automations]

Commented by: @pcisar

Fix verified for 2.1 Beta 1, test added.

[firebird-automations]

Modified by: @pcisar

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

[firebird-automations]

Modified by: @pcisar

Workflow: jira [ 12090 ] => Firebird [ 15566 ]

[firebird-automations]

Modified by: @pavel-zotov

QA Status: No test

[firebird-automations]

Modified by: @pavel-zotov

QA Status: No test => Done successfully