Разница между 9i и 8i или баг?

Windows,
select Supplier, Art, SupplDate,
(select max(ID)
from SMDocuments D, SMSpec S
where D.DocType = 'WI' and D.DocState = 3
and D.OpCode = 0
and D.ClientIndex = Supplier
and D.CreatedAt = SupplDate
and D.DocType = S.DocType and D.ID = S.DocID
and S.Article = Art
) DocID
from
(
select D.ClientIndex as Supplier, S.Article as Art,
max(D.CreatedAt) as SupplDate from SMSpec S, SMDocuments D
where D.DocType = S.DocType and
S.DocID = D.ID and
S.DocType = 'WI' and
D.DocState = 3 and
D.OpCode = 0
group by D.ClientIndex, S.Article
)
/
на
Oracle8i Enterprise Edition Release 8.1.6.3.0 - Production
JServer Release 8.1.6.3.0 - Production
отрабатывает нормально, на
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
падает
max(D.CreatedAt) as SupplDate from SMSpec S, SMDocuments D
*
ERROR at line 14:
ORA-00979: not a GROUP BY expression

что может быть? Ищу,но может кто подскажет? Вроде нет ошибки-то...

помогло добавление
group by D.ClientIndex, S.Article,D.CreatedAt
но это нелогично и тормозно очень, я привел только часть, подзапрос...

OlegON

Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production падает

А чего ты хотел от самого глючного релиза 9iR2???
Поставь хотя бы патч 9.2.0.4, а лучше сразу 9.2.0.6