Issue Details (XML | Word | Printable)

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

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

Incorrect result with UPDATE OR INSERT ... RETURNING OLD and non-nullable columns

Created: 15/Aug/08 01:21 PM   Updated: 25/Apr/11 03:29 PM
Component/s: Engine
Affects Version/s: 2.1.0, 2.5 Alpha 1, 2.1.1
Fix Version/s: 2.5 Beta 1

Time Tracking:
Not Specified

Issue Links:
Relate
 

Planning Status: Unspecified


 Description  « Hide
Test case:

create table t (
    n integer primary key,
    x1 integer not null,
    x2 integer
);

update or insert into t
    values (1, 1, 1)
    returning old.n, old.x1, old.x2, new.n, new.x1, new.x2;

    CONSTANT CONSTANT CONSTANT N X1 X2
============ ============ ============ ============ ============ ============
           0 0 <null> 1 1 1

First two columns should return NULL.


 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Pavel Cisar added a comment - 25/Apr/11 03:29 PM
QA test added.