drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Paul Mogren (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-4458) JDBC plugin case sensitive table names
Date Tue, 01 Mar 2016 14:37:18 GMT
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_Efe4nPGeNRdK5GRMH9jTBxu9xnNifNQ@mail.gmail.com%3e

This message was sent by Atlassian JIRA

View raw message