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

Window functions throws exception without ORDER BY

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:

      Description

      Specifiying a window without a order by gives me this exception:

      {
      "level" : "ERROR",
      "message" : {
      "messagePattern" : "Error {}: {}",
      "arguments" : [ "4b6de09d-6550-4e18-b457-46acdaa44b9b", "Failure
      while parsing sql." ]
      },
      "logger" : "org.apache.drill.exec.work.foreman.Foreman",
      "throwable" : {
      "name" : "java.lang.NullPointerException",
      "stackTrace" : [

      { "className" : "org.eigenbase.sql.SqlIdentifier", "methodName" : "getMonotonicity", "fileName" : "SqlIdentifier.java", "lineNumber" : 263, "codeLocation" : "optiq-core-0.7-SNAPSHOT.jar", "version" : "na", "exact" : false }

      ,

      { "className" : "org.eigenbase.sql.validate.SelectScope", "methodName" : "getMonotonicity", "fileName" : "SelectScope.java", "lineNumber" : 149, "codeLocation" : "optiq-core-0.7-SNAPSHOT.jar", "version" : "na", "exact" : false }

      ,

      { "className" : "org.eigenbase.sql.SqlWindow", "methodName" : "isTableSorted", "fileName" : "SqlWindow.java", "lineNumber" : 323, "codeLocation" : "optiq-core-0.7-SNAPSHOT.jar", "version" : "na", "exact" : false }

      ,

      { "className" : "org.eigenbase.sql.SqlWindow", "methodName" : "validate", "fileName" : "SqlWindow.java", "lineNumber" : 693, "codeLocation" : "optiq-core-0.7-SNAPSHOT.jar", "version" : "na", "exact" : false }

      ,

      { "className" : "org.eigenbase.sql.SqlNodeList", "methodName" : "validate", "fileName" : "SqlNodeList.java", "lineNumber" : 144, "codeLocation" : "optiq-core-0.7-SNAPSHOT.jar", "version" : "na", "exact" : false }

      ,

      { "className" : "org.eigenbase.sql.validate.SqlValidatorImpl", "methodName" : "validateWindowClause", "fileName" : "SqlValidatorImpl.java", "lineNumber" : 2820, "codeLocation" : "optiq-core-0.7-SNAPSHOT.jar", "version" : "na", "exact" : false }

      ,

      { "className" : "org.eigenbase.sql.validate.SqlValidatorImpl", "methodName" : "validateSelect", "fileName" : "SqlValidatorImpl.java", "lineNumber" : 2767, "codeLocation" : "optiq-core-0.7-SNAPSHOT.jar", "version" : "na", "exact" : false }

      ,

      { "className" : "org.eigenbase.sql.validate.SelectNamespace", "methodName" : "validateImpl", "fileName" : "SelectNamespace.java", "lineNumber" : 60, "codeLocation" : "optiq-core-0.7-SNAPSHOT.jar", "version" : "na", "exact" : false }

      ,

      { "className" : "org.eigenbase.sql.validate.AbstractNamespace", "methodName" : "validate", "fileName" : "AbstractNamespace.java", "lineNumber" : 80, "codeLocation" : "optiq-core-0.7-SNAPSHOT.jar", "version" : "na", "exact" : false }

      ,

      { "className" : "org.eigenbase.sql.validate.SqlValidatorImpl", "methodName" : "validateNamespace", "fileName" : "SqlValidatorImpl.java", "lineNumber" : 747, "codeLocation" : "optiq-core-0.7-SNAPSHOT.jar", "version" : "na", "exact" : false }

      ,

      { "className" : "org.eigenbase.sql.validate.SqlValidatorImpl", "methodName" : "validateQuery", "fileName" : "SqlValidatorImpl.java", "lineNumber" : 736, "codeLocation" : "optiq-core-0.7-SNAPSHOT.jar", "version" : "na", "exact" : false }

      ,

      { "className" : "org.eigenbase.sql.SqlSelect", "methodName" : "validate", "fileName" : "SqlSelect.java", "lineNumber" : 209, "codeLocation" : "optiq-core-0.7-SNAPSHOT.jar", "version" : "na", "exact" : false }

      ,

      { "className" : "org.eigenbase.sql.validate.SqlValidatorImpl", "methodName" : "validateScopedExpression", "fileName" : "SqlValidatorImpl.java", "lineNumber" : 710, "codeLocation" : "optiq-core-0.7-SNAPSHOT.jar", "version" : "na", "exact" : false }

      ,

      { "className" : "org.eigenbase.sql.validate.SqlValidatorImpl", "methodName" : "validate", "fileName" : "SqlValidatorImpl.java", "lineNumber" : 426, "codeLocation" : "optiq-core-0.7-SNAPSHOT.jar", "version" : "na", "exact" : false }

      ,

      { "className" : "net.hydromatic.optiq.prepare.PlannerImpl", "methodName" : "validate", "fileName" : "PlannerImpl.java", "lineNumber" : 175, "codeLocation" : "optiq-core-0.7-SNAPSHOT.jar", "version" : "na", "exact" : false }

      }

      ---------------- Imported from GitHub ----------------
      Url: https://github.com/julianhyde/optiq/issues/285
      Created by: tnachen
      Labels:
      Created at: Mon May 19 07:24:32 CEST 2014
      State: closed

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              github-import GitHub Import
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: