[CALCITE-285] Window functions throws exception without ORDER BY

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Labels: github-import
• Assignee: Unassigned
• Reporter: GitHub Import
• Created: 18/Jun/14 09:00
• Updated: 18/Jun/14 09:00
• Resolved: 18/Jun/14 09:00

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