GROUP BY ROLLUP and CUBE syntax (behavior change)

All columns (even one column) specified in a GROUP BY ROLLUP or GROUP BY CUBE clause must be enclosed within parentheses. The parentheses were not required syntax in previous releases. For more information, see SELECT statement in Chapter 6, “SQL Statements” in the Sybase IQ Reference Manual.