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)
