Incorrect column values with outer joins and views [CORE1245] #1669
Assignees
Comments
Modified by: @asfernandesstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 2.1 Beta 1 [ 10141 ] |
Modified by: @pcisarWorkflow: jira [ 12020 ] => Firebird [ 15474 ] |
Modified by: @asfernandesstatus: Reopened [ 4 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 2.5 Beta 1 [ 10251 ] Fix Version: 3.0.0 [ 10048 ] => |
|
Commented by: @pcisar QA test added. |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
Modified by: @pavel-zotovQA Status: No test |
Modified by: @pavel-zotovQA Status: No test => Done successfully |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Submitted by: @asfernandes
Relate to CORE1306
Relate to CORE3141
Is related to QA456
Relate to CORE3981
Metadata:
CREATE TABLE T1 (N INTEGER);
CREATE TABLE T2 (N INTEGER);
CREATE VIEW V (N1, N2, N3) AS
select t1.n, t2.n, 3
from t1
full join t2
on (t1.n = t2.n)
;
Data:
insert into t1 values (1);
insert into t1 values (2);
insert into t2 values (2);
This query:
select rdb$relation_id, v.rdb$db_key, v.*
from rdb$database
full outer join v
on (1 = 0)
;
Should return:
RDB$RELATION_ID DB_KEY N1 N2 N3
=============== ================================ ============ ============ ============
<null> 82000000010000008000000002000000 2 2 3
<null> 80000000010000000000000000000000 1 <null> 3
133 <null> <null> <null> <null>
And not:
RDB$RELATION_ID DB_KEY N1 N2 N3
=============== ================================ ============ ============ ============
<null> 81000000010000008000000002000000 2 2 3
<null> 81000000020000008000000001000000 1 <null> 3
131 81000000010000008000000003000000 <null> <null> 3
Commits: 606ae96 cf1212c dd83b27 d1032ae f8c2d59 595a185 db9036b 94b1012
The text was updated successfully, but these errors were encountered: