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

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 1.15.0
    • Fix Version/s: 1.15.0
    • Component/s: Storage - JDBC
    • Labels:
    • Environment:

      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

              • Assignee:
                vvysotskyi Volodymyr Vysotskyi
                Reporter:
                ben-zvi Boaz Ben-Zvi
                Reviewer:
                Arina Ielchiieva
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: