cayenne-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andrus Adamchik (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CAY-1897) Reverse engineering relationships fails on MySQL with lower_case_table_names = 2
Date Wed, 05 Feb 2014 12:44:09 GMT
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)

Mime
View raw message