[DRILL-2311] Create table with same columns of different case results in a java.lang.IllegalStateException

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.8.0
• Fix Version/s: 0.8.0
• Component/s: SQL Parser
• Assignee: Sean Hsuan-Yi Chu
• Reporter: Ramana Inukonda Nagaraj
• Created: 25/Feb/15 18:35
• Updated: 17/Mar/15 20:27
• Resolved: 17/Mar/15 18:56

Description

Doing a create table with same column in different case results in a runtime exception. This query should fail at planning or parsing.

CREATE TABLE drill_parquet_mulCaseColumns3 as select cast( BIGINT_col as bigint) BIGINT_col,cast( DECIMAL9_col as decimal) bigint_col FROM dfs.`/user/root/alltypes.json`;

Issue Links

• is depended upon by: DRILL-1911 Querying same field multiple times with different case would hit memory leak and return incorrect result.
• is depended upon by: DRILL-1943 Handle aliases and column names that differ in case only