执行的SQL报ORA-00600:[qctcte1]内部错误

Question

各位大侠，本人在执行下面sql的过程中报了一个错误： ORA-00600: internal error code, arguments: [qctcte1], [0], [], [], [], [], [], []
但是换一个版本的oracle中执行却又正常，求教大侠们指教一下。
该sql在oracle10.2.0.1.0中没问题，在oracle10.2.0.4.0中报上面错误；执行SQL如下：
select 
                               t.info_id,
                               connect_by_root(t.info_id) baseId,
                               connect_by_root(t.info) baseInfo,
                               t.is_standard,
                               t.info,
                               decode(connect_by_root(t.info_id),t.info_id,2,1) rn
                          from sprms_safetyzone_check_info t
                        connect by prior t.info_id = t.parent_id
                        start with t.parent_id = 0
                                and t.is_standard = 1

Answer 1

oracle10.2.0.4.0 版本位数一样的？
是不是升级过程中有过错误？

Answer 2

不清楚是否升级过程中问题，不过我在外面套一层使用decode就能正常使用，如下
执行sql： 
select 
                         ss.info_id,
                         ss.baseId,
                         ss.baseInfo,
                         ss.is_standard,
                         ss.info,
                         decode(ss.baseId,ss.info_id,2,1) rn
                         from        
                           (select 
                               t.info_id,
                               connect_by_root(t.info_id) baseId,
                               connect_by_root(t.info) baseInfo,
                               t.is_standard,
                               t.info
                          from sprms_safetyzone_check_info t
                        connect by prior t.info_id = t.parent_id
                        start with t.parent_id = 0
                                and t.is_standard = 1) ss