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

Unit test mysql-test-data.sql in contrib/jdbc-storage-plugin fails on newer MacOS

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Blocker
    • Resolution: Fixed
    • 1.15.0
    • 1.15.0
    • Storage - JDBC
    • MacOS, either High Sierra (10.13) or Mojave (10.14).

       

    Description

      The newer MacOS file systems (10.13 and above) are case-insensitive by default. This leads to the following unit test failure:

      ~/drill > mvn clean install -rf :drill-jdbc-storage
      [INFO] Scanning for projects...
      [INFO] ------------------------------------------------------------------------
      [INFO] Detecting the operating system and CPU architecture
      [INFO] ------------------------------------------------------------------------
      [INFO] os.detected.name: osx
      [INFO] os.detected.arch: x86_64
      [INFO] os.detected.version: 10.14
      .....
      [INFO] ------------------------------------------------------------------------
      [INFO] Building contrib/jdbc-storage-plugin 1.15.0-SNAPSHOT
      [INFO] ------------------------------------------------------------------------
      .....
      [INFO] >> 2018-12-19 15:11:32 7136 [Warning] Setting lower_case_table_names=2 because file system for __drill/contrib/storage-jdbc/target/mysql-data/data/ is case insensitive
      .....
      [ERROR] Failed to execute:
      create table CASESENSITIVETABLE (
      a BLOB,
      b BLOB
      )
      [INFO] ------------------------------------------------------------------------
      [INFO] Reactor Summary:
      [INFO]
      [INFO] contrib/jdbc-storage-plugin ........................ FAILURE [01:30 min]
      .......
      [ERROR] Failed to execute goal org.codehaus.mojo:sql-maven-plugin:1.5:execute (create-tables) on project drill-jdbc-storage: Table 'casesensitivetable' already exists -> [Help 1]

      in the test file mysql-test-data.sql, where both tables caseSensitiveTable and CASESENSITIVETABLE are created.

      Attachments

        Issue Links

          Activity

            People

              volodymyr Vova Vysotskyi
              ben-zvi Boaz Ben-Zvi
              Arina Ielchiieva Arina Ielchiieva
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: