You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@calcite.apache.org by Atri Sharma <at...@gmail.com> on 2017/06/24 18:32:16 UTC

Collation not an active trait for ORDER BY

For a query like:

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

I see that the Sort node generated has traitSet as NULL, whereas I
would expect collation to be an active traitset.

What am I missing, please?

Regards,

Atri


-- 
Regards,

Atri
l'apprenant