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
CREATE VIEW without column list when UNION is used [CORE1402] #1820
Comments
Modified by: @pcisarWorkflow: jira [ 12750 ] => Firebird [ 14436 ] |
Commented by: @dyemanov Test cases: recreate view V1 as recreate view V2 as recreate view V3 as recreate view V4 as |
Modified by: @dyemanovassignee: Dmitry Yemanov [ dimitr ] |
Modified by: @dyemanovstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 2.5 RC1 [ 10300 ] |
Modified by: @pmakowskistatus: Resolved [ 5 ] => Closed [ 6 ] |
Submitted by: Emil Totev (emilt)
Relate to CORE2424
Is related to QA301
Column list should not be required when creating views based on UNION statements.
Column names should be the same as when the SELECT query is run outside the view.
"The column identifiers of the output set are those specified in the first SELECT specification.
If you would like to use alternative column names, column aliasing can be used in the
output list of the first SELECT specification"
Commits: 1b5a289
The text was updated successfully, but these errors were encountered: