Paul Mogren created DRILL-4458:
----------------------------------
Summary: JDBC plugin case sensitive table names
Key: DRILL-4458
URL: https://issues.apache.org/jira/browse/DRILL-4458
Project: Apache Drill
Issue Type: Bug
Components: Storage - JDBC
Affects Versions: 1.5.0
Environment: Drill embedded mode on OSX, connecting to MS SQLServer
Reporter: Paul Mogren
Priority: Minor
I just tried Drill with MS SQL Server and I found that Drill treats table
names case-sensitively, contrary to
https://drill.apache.org/docs/lexical-structure/ which indicates that
table names are "case-insensitive unless enclosed in double quotation
marks”. This presents a problem for users and existing SQL scripts that
expect table names to be case-insensitive.
This works: select * from mysandbox.dbo.AD_Role
This does not work: select * from mysandbox.dbo.ad_role
Mailing list reference including stack trace:
http://mail-archives.apache.org/mod_mbox/drill-user/201603.mbox/%3ccajrw0otv8n5ybmvu6w_efe4npgenrdk5grmh9jtbxu9xnni...@mail.gmail.com%3e
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
