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:-
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,
tbl_A.STEP_OWNER,
tblStaff.STAFF_NAME,
tblStaff.STAFF_CODE;
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
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,
tblStaff.STAFF_NAME,
tblStaff.STAFF_CODE
FROM VIEW_01 v01
LEFT JOIN VIEW_02 v02
ON v02.ref_id = v01.ref_id
LEFT JOIN
(SELECT ref_id, STEP_OWNER FROM
( 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,
tbl_A.STEP_OWNER,
tblStaff.STAFF_NAME,
tblStaff.STAFF_CODE;
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?
Thanks
Woo
Received on Mon Feb 29 2016 - 07:51:31 CET