各位大侠,本人在执行下面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
但是换一个版本的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
是不是升级过程中有过错误?
执行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