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

SUM CASE WHEN xxx THEN 1 without "ELSE" throws NPE in AggregateCaseToFilterRule

    XMLWordPrintableJSON

    Details

      Description

      Add a test in CsvTest:

       

      @Test void testSumCaseWhenWithoutElse() throws SQLException {
        sql("model", "select sum( CASE WHEN empno=10 THEN 1 END ) from EMPS").ok();
      }
      

      Will throw NPE

       

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                julianhyde Julian Hyde
                Reporter:
                Aron.tao Jiatao Tao
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 4h 10m
                  4h 10m