[SPARK-20145] "SELECT * FROM range(1)" works, but "SELECT * FROM RANGE(1)" doesn't

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.2.0
• Fix Version/s: 2.2.0
• Component/s: SQL
• Assignee: sam elamin
• Reporter: Juliusz Sompolski
• Created: 29/Mar/17 14:47
• Updated: 04/Apr/17 00:17
• Resolved: 04/Apr/17 00:17

Description

Executed at clean tip of the master branch, with all default settings:

scala> spark.sql("SELECT * FROM range(1)")
res1: org.apache.spark.sql.DataFrame = [id: bigint]

scala> spark.sql("SELECT * FROM RANGE(1)")
org.apache.spark.sql.AnalysisException: could not resolve `RANGE` to a table-valued function; line 1 pos 14
at org.apache.spark.sql.catalyst.analysis.package$AnalysisErrorAt.failAnalysis(package.scala:42)
at org.apache.spark.sql.catalyst.analysis.ResolveTableValuedFunctions$$anonfun$apply$1.applyOrElse(ResolveTableValuedFunctions.scala:126)
at org.apache.spark.sql.catalyst.analysis.ResolveTableValuedFunctions$$anonfun$apply$1.applyOrElse(ResolveTableValuedFunctions.scala:106)
at org.apache.spark.sql.catalyst.plans.logical.LogicalPlan$$anonfun$resolveOperators$1.apply(LogicalPlan.scala:62)
...

I believe it should be case insensitive?

Issue Links

• links to: [Github] Pull Request #17487 (samelamin)