Issue Details (XML | Word | Printable)

Key: CORE-2031
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Adriano dos Santos Fernandes
Reporter: Nikiforov Vasiliy
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Null in the first record in a condition on rdb$db_key

Created: 04/Aug/08 05:50 AM   Updated: 26/Jan/09 08:28 AM
Component/s: None
Affects Version/s: 2.1.0
Fix Version/s: 2.1.2, 2.5 Beta 1

Time Tracking:
Not Specified

Environment: WI-V2.1.1.17910 Firebird 2.1
Issue Links:
Relate
 

Planning Status: Unspecified


 Description  « Hide
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



 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.