Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-4458

JDBC plugin case sensitive table names

Attach filesAttach ScreenshotAdd voteVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Minor
    • Resolution: Unresolved
    • 1.5.0
    • None
    • Storage - JDBC
    • None
    • Drill embedded mode on OSX, connecting to MS SQLServer

    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/%3cCAJrw0OTv8N5yBMvu6W_Efe4nPGeNRdK5GRMH9jTBxu9xnNifNQ@mail.gmail.com%3e

      Attachments

        Issue Links

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            Unassigned Unassigned
            fkamogee Paul Mogren

            Dates

              Created:
              Updated:

              Slack

                Issue deployment