Ora-00600:[Qctcte1] Reported On A Select Query with an Aggregate Subquery (Doc ID 435509.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.3 to 10.2.0.3 [Release 10.2]
Information in this document applies to any platform.

Symptoms

The following error is reported when executing a Select query with an aggregate subquery:

ORA-00600: internal error code, arguments: [qctcte1], [0], [], [], [], [], [], []

Stack functions are as follows:

qctcte qctooei qctown qctcopn qctcopn qctcopn qctcpqb qctcpqbl qctcpqb qctcpqbl

The failing query can be similar to:

SELECT 1 FROM t1 a,  t2 b
  WHERE
         ( a.c1= b.c1) and
         (b.c2 = (select max(to_number(x.c2)) from t2 X 
                   where X.c1 = a.c1 and  X.c3='1'))
    AND b.c3 = '1';

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms