|
If you were logged in you would be able to see more operations.
|
|
|
|
Environment:
|
WI-V2.1.1.17910 Firebird 2.1
|
|
Issue Links:
|
Relate
|
|
|
|
This issue is related to:
|
|
|
|
|
|
|
|
| Planning Status: |
Unspecified
|
|
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
|
|
Description
|
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
|
Show » |
| There are no comments yet on this issue.
|
|
Bug
Null in the first record in a condition on rdb$db_key