Kbase P128469: SQL-92: When did Progress add the GROUP BY expression feature support?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/23/2008 |
|
Status: Unverified
GOAL:
SQL-92: When did Progress add the GROUP BY expression feature support?
GOAL:
Does OpenEdge support the GROUP BY expressions feature?
GOAL:
Does OpenEdge support the multiple GROUP BY expressions feature?
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.1B
FIX:
Progress added the support for simple GROUP BY expressions in OpenEdge 10.1B release. Subsequent OpenEdge Service Packs, 10.1B01, 10.1B02 and 10.1B03, included a widened and strengthened support for the GROUP BY feature.
For example, single GROUP BY expression support was introduced in 10.1B and queries similar to the following run successfully under 10.1B and later:
SELECT
QUARTER(orderdate), SUM(price * qty)
FROM
PUB.Order, PUB.Orderline
WHERE
PUB.Order.Ordernum = PUB.Orderline.Ordernum
GROUP BY
QUARTER(orderdate)
Also, multiple GROUP BY expressions support was included in the OpenEdge 10.1B03 Service Pack and queries similar to the following run successfully under 10.1B03 and later:
SELECT
CONCAT( 'Q.' , CAST(quarter(ORDERDATE) AS CHAR (1))),
CONVERT('char', price),
SUM(price * qty)
FROM
PUB.Order, PUB.Orderline
WHERE
PUB.Order.Ordernum = PUB.Orderline.Ordernum
GROUP BY
CONCAT( 'Q.' , CAST(quarter(ORDERDATE) AS CHAR (1))),
CONVERT('char', price)