[DRILL-2304] Case sensitivity - system and session options are case sensitive

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 0.8.0
• Fix Version/s: 1.2.0
• Component/s: Storage - Information Schema
• Assignee: Jason Altekruse
• Reporter: Ramana Inukonda Nagaraj
• Created: 25/Feb/15 01:12
• Updated: 19/Mar/19 10:18
• Resolved: 04/Sep/15 18:39

Description

TBH I am not sure if this is a bug.

When trying to set a session option and I specify the name in a different case the alter command fails. Considering the way we store session options this might be an invalid bug but considering how typical Database hints and options work this is a bug.

0: jdbc:drill:> alter SESSION  set `STORE.PARQUET.COMPRESSION`='GZIP';
Query failed: SetOptionException: Unknown option: STORE.PARQUET.COMPRESSION

Error: exception while executing query: Failure while executing query. (state=,code=0)

Issue Links

• incorporates: DRILL-6430 Drill Should Not Fail If It Sees Deprecated Options Stored In Zookeeper Or Locally