New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Full outer join in derived table with coalesce (iif) [CORE4083] #4411
Comments
Modified by: Nikolay Teselko (nikolayv81)description: select expected result (ожидаемый результат): null null null null got result (полученный результат ): null null null null Problem with more then 2 full join and subrequest ru: http://www.sql.ru/forum/actualthread.aspx?tid=1017752 => select expected result (ожидаемый результат): null null null null got result (полученный результат ): null null null null Problem with more then 2 full join and subrequest |
Commented by: @dyemanov Tested with all FB 2.1.x versions and the result was: null 1 null 1 |
Commented by: Nikolay Teselko (nikolayv81) changed: expected result (ожидаемый результат) |
Modified by: Nikolay Teselko (nikolayv81)description: select expected result (ожидаемый результат): null null null null got result (полученный результат ): null null null null Problem with more then 2 full join and subrequest ru: http://www.sql.ru/forum/actualthread.aspx?tid=1017752 => select expected result (ожидаемый результат): null 1 null null got result (полученный результат ): null null null null Problem with more then 2 full join and subrequest |
Modified by: Nikolay Teselko (nikolayv81)description: select expected result (ожидаемый результат): null 1 null null got result (полученный результат ): null null null null Problem with more then 2 full join and subrequest ru: http://www.sql.ru/forum/actualthread.aspx?tid=1017752 => select expected result (ожидаемый результат): null 1 null 1 got result (полученный результат ): null null null null Problem with more then 2 full join and subrequest |
Commented by: Nikolay Teselko (nikolayv81) checked in oracle (expected result) in 2.1 not worked fine |
Modified by: Nikolay Teselko (nikolayv81)description: select expected result (ожидаемый результат): null 1 null 1 got result (полученный результат ): null null null null Problem with more then 2 full join and subrequest ru: http://www.sql.ru/forum/actualthread.aspx?tid=1017752 => select expected result (ожидаемый результат): got result (полученный результат ): null null null null Problem with more then 2 full join and subrequest |
Commented by: @dyemanov Good test case, it also shows a bug in FB3 (it returns one row filled with nulls) |
Modified by: @dyemanovVersion: 2.1.5 Update 1 [ 10522 ] Version: 2.5.2 [ 10450 ] Version: 2.1.5 [ 10420 ] Version: 2.0.7 [ 10390 ] Version: 2.5.1 [ 10333 ] Version: 2.1.4 [ 10361 ] Version: 2.5.0 [ 10221 ] Version: 2.0.6 [ 10303 ] Version: 3.0 Initial [ 10301 ] Version: 2.1.3 [ 10302 ] Version: 2.1.2 [ 10270 ] Version: 2.0.5 [ 10222 ] Version: 2.1.1 [ 10223 ] Version: 2.1.0 [ 10041 ] |
Commented by: Nikolay Teselko (nikolayv81) in our version of 2.1 (LI-V6.3.1.17910 Firebird 2.1) incorrect work full join select got result: i think it's different errors, i can't install last version of 2.1 |
Modified by: @dyemanovassignee: Dmitry Yemanov [ dimitr ] |
Modified by: @dyemanovstatus: Open [ 1 ] => In Progress [ 3 ] |
Modified by: @dyemanovstatus: In Progress [ 3 ] => Open [ 1 ] |
Modified by: @asfernandes |
Modified by: @asfernandesassignee: Dmitry Yemanov [ dimitr ] => Adriano dos Santos Fernandes [ asfernandes ] summary: full outer join in subrequest with coalesce ( iif ) => Full outer join in derived table with coalesce (iif) |
Modified by: @asfernandesstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 3.0 Alpha 1 [ 10331 ] |
Commented by: @sim1984 Whether it is impossible to port it in a branch 2.5.x? |
Commented by: Nikolay Teselko (nikolayv81) Problem only in dsql/pass1.cpp.pass1_derived_table? |
Commented by: @asfernandes Fix backported to 2.5.3. |
Modified by: @asfernandesFix Version: 2.5.3 [ 10461 ] |
Modified by: @pmakowskistatus: Resolved [ 5 ] => Closed [ 6 ] |
Submitted by: Nikolay Teselko (nikolayv81)
Is related to CORE1246
Is related to QA525
Relate to CORE4873
Votes: 1
select
A_SOME_FIELD,
B_SOME_FIELD,
C_SOME_FIELD,
COALESCE_FIELD
from
(
select
A.SOME_FIELD as A_SOME_FIELD,
B.SOME_FIELD as B_SOME_FIELD,
C.SOME_FIELD as C_SOME_FIELD,
coalesce(A.SOME_FIELD, B.SOME_FIELD, c.SOME_FIELD) as COALESCE_FIELD
from
(select null as SOME_FIELD from RDB$DATABASE) A
full join
(select 1 as SOME_FIELD from RDB$DATABASE) B on B.SOME_FIELD = A.SOME_FIELD
full join
(select null as SOME_FIELD from RDB$DATABASE) C on C.SOME_FIELD = B.SOME_FIELD
) x
expected result (ожидаемый результат):
( checked in oracle )
null null null null
null 1 null 1
null null null null
got result (полученный результат ):
null null null null
null 1 null null <---
null null null null
Problem with more then 2 full join and subrequest
in firebird 2.1.3 request works NOT fine
ru: http://www.sql.ru/forum/actualthread.aspx?tid=1017752
Commits: 929de3d e8d26b0 821dbb4 6d7b918 FirebirdSQL/fbt-repository@5f26ded FirebirdSQL/fbt-repository@df8a79c FirebirdSQL/fbt-repository@f079a00 FirebirdSQL/fbt-repository@0a8691c FirebirdSQL/fbt-repository@dc88efb
The text was updated successfully, but these errors were encountered: