Strange Start Connect Prior
Me, again
- fighting another issue with the Start Connect Prior Logic!
Script:
SELECT CONNECT_BY_ROOT(IXKIT) OSZ56ITMP,
CONNECT_BY_ROOT(IXKITL) OSZ56LITM,
LEVEL OSLEV,
A.IXKIT,
A.IXITM
FROM TESTDTA.F3002 A
WHERE A.IXTBM ='M'
AND IXEFFF <114037
AND IXEFFT >114037
START WITH A.IXKIT = 263273
AND IXMMCU =' 2740001'
CONNECT BY NOCYCLE PRIOR A.IXITM=A.IXKIT
AND PRIOR A.IXCMCU =A.IXMMCU
Now, look at the highlighted values. I understood that the results should be passing the IXITM Value into the IXKIT Value, when the Level is Incremented. There are a couple occasions where the IXITM number that 'should' be passed to the next row - is completely odd. Look at the highlighted rows. Am I missing something - or did I crash into a bug?