Null in the first record in a condition on rdb$db_key [CORE2031]

[firebird-issue-importer]

Submitted by: Nikiforov Vasiliy (vasonik)

Is related to QA221

CREATE TABLE A1 (
FA1 INT4,
FA2 INT4
);
insert into a1 (fa1, fa2) values (1, 1);
insert into a1 (fa1, fa2) values (1, 2);
insert into a1 (fa1, fa2) values (1, 3);
insert into a1 (fa1, fa2) values (1, 4);
insert into a1 (fa1, fa2) values (1, 5);

select * from a1;

     FA1          FA2

============ ============
1 1
1 2
1 3
1 4
1 5

update a1 a set a.fa1 =
(select 2 from a1 aa
where a.rdb$db_key = aa.rdb$db_key);

select * from a1;

     FA1          FA2

============ ============
<null> 1
2 2
2 3
2 4
2 5

Commits: ddb042b eda865f

[firebird-issue-importer]

Modified by: @asfernandes

assignee: Adriano dos Santos Fernandes [ asfernandes ]

[firebird-issue-importer]

Modified by: @asfernandes

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

resolution: Fixed [ 1 ]

Fix Version: 2.5 Beta 1 [ 10251 ]

Fix Version: 2.1.2 [ 10270 ]

[firebird-issue-importer]

Modified by: @pmakowski

Link: This issue block progress on QA221 [ QA221 ]

[firebird-issue-importer]

Modified by: @pmakowski

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

[firebird-issue-importer]

Modified by: @pcisar

Link: This issue is related to QA221 [ QA221 ]

[firebird-issue-importer]

Modified by: @pcisar

Link: This issue block progress on QA221 [ QA221 ] =>

[firebird-issue-importer]

Modified by: @pavel-zotov

QA Status: No test

[firebird-issue-importer]

Modified by: @pavel-zotov

QA Status: No test => Done successfully