Can not update a foreign key on a case sensetive MySql Database
---------------------------------------------------------------
Key: DDLUTILS-195
URL: https://issues.apache.org/jira/browse/DDLUTILS-195
Project: DdlUtils
Issue Type: Bug
Components: Core - MySql
Affects Versions: 1.1
Environment: Trying to update a existing case sensitive mysql database
on Linux
Reporter: meindert hoving
Assignee: Thomas Dudziak
For testing purposes I made my MySql database case sensitive (to avoid problems
when deploying to linux)
The foreign key restrained throws the following exception;
throw new ModelException("The foreignkey "+fkDesc+" in table
"+curTable.getName()+" references the undefined table
"+fk.getForeignTableName());
fk.getForeignTableName is all lower case, while the table name is camel case.
hacking the correct camel case into the piece of code that throws the exception
'fixes' the issue. Therefore the issue is that fk.getForeignTableName())
contains the wrong table name.
This wrong table name comes from JdbcModelReader
fk.setForeignTableName((String)values.get("PKTABLE_NAME"));
The PKTABLE_NAME value comes from readColumn what returns the table name in
lowercase
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
