Hierarchical queries no longer running after moving from 11g v1 to v2
Hi all,
we experienced sistematic failure of hierarchical queries after moving from v1 to v2.
This occurs only to queries returning a REF and it can be reproduced by a simple SQL Dev. script such as:
-- create a test type
CREATE OR REPLACE TYPE Test_type AS OBJECT (
key RAW(16),
parentKey RAW(16))
/
-- create an object table of that type
CREATE TABLE Test_table OF Test_type (
key DEFAULT SYS_GUID() PRIMARY KEY)
OBJECT IDENTIFIER IS PRIMARY KEY;
-- this works fine
SELECT f.key FROM Test_table f
START WITH f.parentKey IS NULL
CONNECT BY PRIOR f.key = f.parentKey;
This occurs only to queries returning a REF and it can be reproduced by a simple SQL Dev. script such as:
-- create a test type
CREATE OR REPLACE TYPE Test_type AS OBJECT (
key RAW(16),
parentKey RAW(16))
/
-- create an object table of that type
CREATE TABLE Test_table OF Test_type (
key DEFAULT SYS_GUID() PRIMARY KEY)
OBJECT IDENTIFIER IS PRIMARY KEY;
-- this works fine
SELECT f.key FROM Test_table f
START WITH f.parentKey IS NULL
CONNECT BY PRIOR f.key = f.parentKey;
0