Re: kkqjpdpvpd: No join pred found

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Mon, 29 Feb 2016 10:33:22 +0100
Message-ID: <56d41063$0$27831$426a74cc_at_news.free.fr>


<mfwoo68_at_gmail.com> a écrit dans le message de news: 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

ORA-00600/ORA-07445 = Oracle bug => search on Metalink/MOS and/or call Oracle support Have a look at alert.log and trace files. You can also read this article: Troubleshooting Internal Errors: http://www.oracle.com/technetwork/issue-archive/2011/11-sep/o51support-453463.html

Regards
Michel Received on Mon Feb 29 2016 - 10:33:22 CET

Original text of this message