kkqjpdpvpd: No join pred found

From: <mfwoo68_at_gmail.com>
Date: Sun, 28 Feb 2016 22:51:31 -0800 (PST)
Message-ID: <95946c84-fd9c-470b-80d4-88c2a004205f_at_googlegroups.com>

I have the following SQL statement:-

SELECT v02.start_date,

    SUM(ELAPSED_TIME) AS create_tm,
    COUNT(DISTINCT v01.REF_ID) AS create_app_cnt,     tbl_A.STEP_OWNER,
  FROM VIEW_01 v01
  ON v02.ref_id = v01.ref_id

      ( SELECT ref_id, STEP_OWNER,
          ROW_NUMBER() over (partition BY REF_ID order by step_name DESC,
          start_date ASC nulls last) AS ROW_NO
          FROM v03
          WHERE STEP_NAME IN ('001','003')
      WHERE row_no=1
     ) tbl_A

  ON tbl_A.ref_id=v02.ref_id <<--- LINE 01   LEFT JOIN code_staff tblStaff
  ON tblStaff.staff_id = tbl_A.step_owner   WHERE v01.STEP_NAME IN ('001','003')
  GROUP BY v02.start_date,

Once I run it against the SQLDeveloper it prompts :-

ORA-00600: internal error code, arguments: [kkqjpdpvpd: No join pred found.], [], [], [], [], [], [], [], [], [], [], [] 00600. 00000 - "internal error code, arguments: [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s]" *Cause: This is the generic internal error number for Oracle program

           exceptions. It indicates that a process has encountered a low-level,
           unexpected condition. The first argument is the internal message
           number. This argument and the database version number are critical in
           identifying the root cause and the potential impact to your system.

But if I change the statement in LINE 01 (above) to the following it can runs properly "ON tbl_A.ref_id=v01.ref_id"

May I know why?

Woo Received on Mon Feb 29 2016 - 07:51:31 CET

Original text of this message