Incorrect full join result with ROW_NUMBER() Function in CTE [CORE4091] #4419
Assignees
Comments
Modified by: Sean Leyne (seanleyne)summary: Incorrect full join result with row_number in CTE => Incorrect full join result with ROW_NUMBER() Function in CTE |
Modified by: @dyemanovassignee: Dmitry Yemanov [ dimitr ] |
Modified by: @dyemanovstatus: Open [ 1 ] => In Progress [ 3 ] |
Modified by: @dyemanovstatus: In Progress [ 3 ] => Open [ 1 ] |
Modified by: @dyemanovVersion: 3.0 Initial [ 10301 ] Fix Version: 3.0 Alpha 1 [ 10331 ] Version: 3.0 Alpha 1 [ 10331 ] => |
|
Commented by: @dyemanov It should be correct now, but RDB$TYPES already contains 251 records in ODS12 ;-) |
|
Commented by: @pcisar Test created. |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Submitted by: Alex Bekhtin (afgm)
Is related to QA583
with A as (
select t.RDB$TYPE, ROW_NUMBER() over (order by t.rdb$db_key) as RN from rdb$types t
),
B as (
select f.rdb$format, ROW_NUMBER() over (order by f.rdb$db_key) as RN from rdb$formats f
)
select * from A
full outer JOIN B ON A.RN = B.RN
--------------
Query return 5 records. Must be 234.
Commits: 6d7b918 FirebirdSQL/fbt-repository@dc88efb
The text was updated successfully, but these errors were encountered: