Kbase P125128: SQL-92: When did the support for the GROUP BY clause with SQL-92 functions like LPAD, RPAD, RTRIM, L
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
7/26/2007 |
|
Status: Unverified
GOAL:
SQL-92: When did the support for the GROUP BY clause with SQL-92 functions like LPAD, RPAD, RTRIM, LTRIM etc. start?
GOAL:
SQL-92: When did the support for the general group-by-expression start?
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.1B
FIX:
The support for the general group-by-expression started in OpenEdge 10.1B. That is it became permissible to include SQL-92 functions like LPAD, RPAD, RTRIM, LTRIM etc. in the SELECT statement that contains a GROUP BY clause. For example, the following SELECT statement was not supported in versions earlier than the OpenEdge 10.1B version:
SLECT Country, LPAD(RTRIM(LTRIM(City)), 10) FROM PUB.Customer GROUP BY Country, City;