WRONG RESULT with range list partitioning

[mike9]

Hi abhaysk,

Thanks for your feedback.

One more question:
On 10G do you also get, based on the previous script, an ORA 600 when you execute the following script?

SELECT
part_range_key, subpart_list_key
FROM test_range_list_part  PARTITION (p1)
WHERE
(subpart_list_key = 2 and value = 1 )
or
(subpart_list_key = 1) 
or
(subpart_list_key = 11 and value = 1 );
     *
FEHLER in Zeile 3:
ORA-00600: internal error code, arguments: [kkpamFList2], [], [], [], [], [],
[], [] 

when I execute it like

SELECT
part_range_key, subpart_list_key
FROM test_range_list_part PARTITION (p1)
WHERE
(subpart_list_key = 1) 
or
(subpart_list_key = 2 and value = 1 )
or
(subpart_list_key = 11 and value = 1 ); 

I "simply" got a wrong result but no ora 600.

Nice bug