Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-2323

The configuration parameter "defaultNullCollation" which enum NullCollation { LOW, HIGH, FIRST, LAST } to allow alternative policies, but it can't take effect for over();

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 1.17.0
    • core
    • None

    Description

      For example, the following query:

      select deptno, rank() over(partition by empno order by deptno) from emp order by row_number() over(partition by empno order by deptno.

      The default null order is nulls last for deptno in calcite. But the null order still is nulls last if we set the parameter "defaultNullCollation" with NullCollation.LOW.

       

      Attachments

        Activity

          People

            julianhyde Julian Hyde
            hustfxj John Fang
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: