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

["Volodymyr Vysotskyi (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DRILL-6915?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16726050#comment-16726050 ] 

Volodymyr Vysotskyi commented on DRILL-6915:
--------------------------------------------

[~ben-zvi], could you please confirm that PR fixes the issue on your env?

> 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.15.0
>         Environment: MacOS, either High Sierra (10.13) or Mojave (10.14).
>  
>            Reporter: Boaz Ben-Zvi
>            Assignee: Volodymyr Vysotskyi
>            Priority: Blocker
>             Fix For: 1.15.0
>
>
> 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)