Icon View Incident Report

Serious Serious
Reported By: Clive Bennett
Reported On: 3/20/2004
For: Version 4.05 Build 1
# 1619 SQL SELECT Statement GROUP BY Clause Not Working Properly Without an ORDER BY

The following query used to group correctly in V4.04 In the new V4.05, the grouping does not occur unless I add an ORDER BY
Clause.

select
  4,period,'Depreciation',sum(dep_int_amt),project_code
from
  rpt_balance_sheet_variable_items
where
  dep_or_int_flag = 'D'
group by
  period,project_code



Comments Comments and Workarounds
Adding an ORDER BY clause that exactly matches the GROUP BY clause fixes the problem.


Resolution Resolution
Fixed Problem on 3/20/2004 in version 4.06 build 1
Image