[jira] [Created] (CAY-1897) Reverse engineering relationships fails on MySQL with lower_case_table_names = 2

["Andrus Adamchik (JIRA)" <ji...@apache.org>]

Andrus Adamchik created CAY-1897:
------------------------------------

             Summary: Reverse engineering relationships fails on MySQL with lower_case_table_names = 2
                 Key: CAY-1897
                 URL: https://issues.apache.org/jira/browse/CAY-1897
             Project: Cayenne
          Issue Type: Bug
    Affects Versions: 3.1B2
         Environment: OS X 10.9.1
MySQL 5.0, 5.5, 5.6
MySQL ConnectorJ 5.1.28
            Reporter: Andrus Adamchik
            Assignee: Andrus Adamchik
            Priority: Minor


This is an odd regression issue that I am observing on MySQL 5.5 and 5.6, but not on 5.0. When MySQL is using the default option of lower_case_table_names = 2, DbLoaderTest.testLoad() will fail:

  assertTrue(rels.size() > 0); // fails

Changing that to lower_case_table_names = 1 fixes the test. Another oddity I noticed with "2" is that only 'getExportedKeys' of DbLoader is broken. When switching to complimentary 'getImportedKeys', it starts to work. On 5.0 it is the opposite - 'getImportedKeys' is broken, 'getExportedKeys' works. Seems like a JDBC driver bug. 

I am not planning to fix this in Cayenne. This is mostly for documentation  purposes.



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)