Kbase P103582: syntax error (7587) in SQL-92 query when using SUBSTR function in GROUP BY.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1x
SYMPTOM(s):
syntax error in SQL-92 query:
[MERANT][ODBC PROGRESS driver][PROGRESS]Syntax error (7587)
The GROUP BY clause contains the SUBSTR function
CAUSE:
The GROUP BY clause can only contain column names. Functions are not allowed.
This is the form which the SQL-92 standard defines. That is, the standard defines the GROUP BY list as containing column references only.
FIX:
As a workaround, you can define a view with a calculated field using the SUBSTR function. Then you can use this field in the GROUP BY criteria.