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)