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

Jump to bottom

Provide information about exact expression which cause "Invalid expression in the select list (not contained in either an aggregate function or the GROUP BY clause)" [CORE5024] #5312

Open
firebird-automations opened this issue Nov 19, 2015 · 4 comments
Open

Provide information about exact expression which cause "Invalid expression in the select list (not contained in either an aggregate function or the GROUP BY clause)" [CORE5024] #5312

firebird-automations opened this issue Nov 19, 2015 · 4 comments
Assignees
@asfernandes
Labels
component: engine priority: minor type: improvement

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @livius2

Votes: 1

Invalid expression in the select list (not contained in either an aggregate function or the GROUP BY clause)

Will be good to see what expression cause this error
Now we must analyze query and look what is wrong - what is used but not contained in group by
@firebird-automations
Copy link
Collaborator Author

Modified by: @livius2

summary: Provide better information for "Invalid expression in the select list (not contained in either an aggregate function or the GROUP BY clause)" => Provide information about exact expression which cause "Invalid expression in the select list (not contained in either an aggregate function or the GROUP BY clause)"

@firebird-automations
Copy link
Collaborator Author

Modified by: Sean Leyne (seanleyne)

description: Invalid expression in the select list (not contained in either an aggregate function or the GROUP BY clause)

Will be good to see what expression cause this error
Now we must analyze query and look what is wrong - what is used but not contained in group by

=>

Invalid expression in the select list (not contained in either an aggregate function or the GROUP BY clause)

Will be good to see what expression cause this error
Now we must analyze query and look what is wrong - what is used but not contained in group by

@firebird-automations
Copy link
Collaborator Author

Commented by: @asfernandes

Put an expression in the error is not possible, but point to its start line/column (if not already done) should be.

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

assignee: Adriano dos Santos Fernandes [ asfernandes ]

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

@asfernandes asfernandes

Labels
component: engine priority: minor type: improvement
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@asfernandes @firebird-automations