You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Boaz Ben-Zvi (JIRA)" <ji...@apache.org> on 2018/12/20 01:39:00 UTC

[jira] [Created] (DRILL-6915) Unit test mysql-test-data.sql in contrib/jdbc-storage-plugin fails on newer MacOS

Boaz Ben-Zvi created DRILL-6915:
-----------------------------------

             Summary: Unit test mysql-test-data.sql in contrib/jdbc-storage-plugin fails on newer MacOS
                 Key: DRILL-6915
                 URL: https://issues.apache.org/jira/browse/DRILL-6915
             Project: Apache Drill
          Issue Type: Bug
          Components: Storage - JDBC
    Affects Versions: 1.14.0
         Environment: MacOS, either High Sierra (10.13) or Mojave (10.14).

 
            Reporter: Boaz Ben-Zvi


The newer MacOS file systems (10.13 and above) are case-insensitive by default. This leads to the following unit test failure:
{code:java}
~/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]{code}
in the test file *mysql-test-data.sql*, where +both+ tables *caseSensitiveTable* and *CASESENSITIVETABLE* are created.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)