# select the whole cycle tree with nocylce
{
my $rs = $schema->resultset('Artist')->search({}, {
- connect_by_nocycle => 1,
start_with => { name => 'cycle-root' },
'+select' => [ \ 'CONNECT_BY_ISCYCLE' ],
- connect_by => { parentid => { -prior => \ 'artistid' } },
+ connect_by_nocycle => { parentid => { -prior => \ 'artistid' } },
});
is_same_sql_bind (