Skip to content
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

Field alias disapears in complex query [CORE5713] #5979

Closed
firebird-issue-importer opened this issue Jan 17, 2018 · 7 comments
Closed

Field alias disapears in complex query [CORE5713] #5979

firebird-issue-importer opened this issue Jan 17, 2018 · 7 comments

Comments

@firebird-issue-importer

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

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jan 17, 2018

Modified by: @asfernandes

assignee: Adriano dos Santos Fernandes [ asfernandes ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jan 17, 2018

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.

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jan 17, 2018

Commented by: Alex Kurov (alex.kurov)

I've tried 2.5.8.27089 and recent snapshot 3.0.3

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jan 18, 2018

Modified by: @asfernandes

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 3.0.3 [ 10810 ]

Fix Version: 4.0 Beta 1 [ 10750 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jan 18, 2018

Modified by: @asfernandes

Version: 4.0 Initial [ 10621 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jan 18, 2018

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Resolved [ 5 ]

QA Status: No test => Done successfully

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jan 18, 2018

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Closed [ 6 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment