antdb connect by算子调试

drop table if exists t1;

create table t1(id int, lid int, name text);

insert into t1 values (1, NULL, 'A');

insert into t1 values (2, 1, 'B');

insert into t1 values (3, 1, 'C');

insert into t1 values (4, 2, 'D');

insert into t1 values (5, 2, 'E');

insert into t1 values (6, 3, 'F');

insert into t1 values (7, 3, 'G');

insert into t1 values (8, 4, 'H');

insert into t1 values (9, 7, 'I');

set grammar to oracle;

select * from t1 start with id=1 connect by prior id=lid;

select *, level, CONNECT_BY_ROOT name, sys_connect_by_path(name, '/') from t1 start with id=1 connect by prior id=lid;

select *, level from t1 start with id=1 connect by prior id=lid;

set grammar to oracle;

select * from t1 start with id=1 connect by prior id[InvalidCharacterError: "LID;<" did not match the Name production]