[DRILL-4458] JDBC plugin case sensitive table names

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 1.5.0
• Component/s: Storage - JDBC

Environment

Drill embedded mode on OSX, connecting to MS SQLServer

• External issue ID: DRILL-3993
• Assignee: Unassigned
• Reporter: Paul Mogren
• Created: 01/Mar/16 14:36
• Updated: 06/Jul/18 17:36

Description

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/[e-mail]%3e

Issue Links

• is blocked by: DRILL-3993 Rebase Drill on Calcite master branch
• is related to: DRILL-5427 SQL Execution Syntax incorrect for Sybase RDBMS