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.

Sign up for GitHub

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

Error message regarding no column references in ORDER BY #28

Open
terrajobst opened this issue Oct 31, 2014 · 0 comments
Open

Error message regarding no column references in ORDER BY #28

terrajobst opened this issue Oct 31, 2014 · 0 comments

Comments

@terrajobst
Copy link
Owner

Ported from CodePlex

The query reports an error if it detects a constant expression in the ORDER BY clause:

A constant expression was encountered in the ORDER BY list.

This is exactly what SQL Server does. In contrast to SQL Server I would suggest the same error message for GROUP BY:

Each ORDER BY expression must contain at least one column.

(The part with "that is not an outer reference" does not make sense, since nested queries cannot contain an ORDER BY).
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@terrajobst