[DRILL-744] Functions should be case insensitive

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Fix Version/s: 0.4.0
• Component/s: Functions - Drill
• Assignee: Venki Korukanti
• Reporter: Krystal
• Created: 14/May/14 20:33
• Updated: 31/Jul/14 06:31
• Resolved: 09/Jun/14 19:48

Description

If the function names are in upper case, the query fails. For example:

0: jdbc:drill:schema=dfs> select to_date('2003/07/09', 'yyyy/MM/dd') from voter where voter_id=10;
------------

EXPR$0

------------

2003-07-09T00:00:00.000-07:00

------------

Same query with function name in uppercase:
select TO_DATE('2003/07/09', 'yyyy/MM/dd') from voter where voter_id=10;

message: "Failure while parsing sql. < ValidationException:[ org.eigenbase.util.EigenbaseContextException: From line 1, column 8 to line 1, column 42 ] < EigenbaseContextException:[ From line 1, column 8 to line 1, column 42 ] < SqlValidatorException:[ No match found for function signature TO_DATE(<CHARACTER>, <CHARACTER>) ]"
]

Issue Links

• is duplicated by: DRILL-699 Function resolutions fails to find functions in registry during the materialization due to case sensitive issues