This project has moved and is read-only. For the latest updates, please go here.


Error message regarding no column references in ORDER BY


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).
Closed Oct 31, 2014 at 7:37 AM by terrajobst