Field alias disapears in complex query [CORE5713] #5979
Assignees
Comments
Modified by: @asfernandesassignee: Adriano dos Santos Fernandes [ asfernandes ] |
|
Commented by: @mrotteveel This sounds similar to CORE5655, which is fixed with 2.5.8, 3.0.3 and 4.0. But I can indeed reproduce this on 2.5.8 and a recent snapshot of 4.0. |
|
Commented by: Alex Kurov (alex.kurov) I've tried 2.5.8.27089 and recent snapshot 3.0.3 |
Modified by: @asfernandesstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 3.0.3 [ 10810 ] Fix Version: 4.0 Beta 1 [ 10750 ] |
Modified by: @asfernandesVersion: 4.0 Initial [ 10621 ] |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Resolved [ 5 ] QA Status: No test => Done successfully |
Modified by: @pavel-zotovstatus: 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 Kurov (alex.kurov)
For example this query has a predictable result with two columns: a1 and a2
select 1 a1, 2 a2
from rdb$database
union all
select 1 a1, coalesce(cast(null as varchar(64)), 0) a2
from rdb$database
But this one has a result with columns a1 and F_1
select a1, a2
from
(select 1 a1, 2 a2
from rdb$database)
group by 1, 2
union all
select 1 a1, coalesce(cast(null as varchar(64)), 0) a2
from rdb$database
Commits: c997f02 a86ce95 FirebirdSQL/jaybird@2a25a6c FirebirdSQL/jaybird@d6fe603
The text was updated successfully, but these errors were encountered: