call.transformTo not returning infinitely

[Atri Sharma]

Hi All,

I am working on removing redundant sorts and am stuck when
transforming the call to replace older Sort node with the reduced one.

The code works like following:

final RelCollation newCollation =  RelCollations.of(collationsList);

Sort result = sort.copy(sort.getTraitSet(), sort.getInput(), newCollation,
        sort.offset, sort.fetch);

call.transformTo(result);

The trnasformTo call is stuck forever.

The query is:

select count(*) as c\n"
        + "from sales.emp\n"
        + "where deptno = 10\n"
        + "group by deptno, sal\n"
        + "order by deptno, sal";


Please advise

Regards,

Atri








-- 
Regards,

Atri
l'apprenant