mysql on Mac throws error migrating DB with indexname 'Idx_lastChanged' vs 'Idx_LastChanged'

I think the problem is that HTextFlowTarget has an index named "Idx_LastChanged", but now HTextFlowTargetHistory wants an index "Idx_lastChanged" (note the lower case "L").

So the problem will probably only appear in environments where mysql is configured to be case-insensitive.

I'm not sure if the version of mysql really comes into it.

if you hit the error again, could you please post the error message against this bug?

I have done some tests with case insensitive mode (lower_case_table_names=1) on mysql 5.6, but I wasn't able to reproduce the problem with index names. I think it only happens with lower_case_table_names=2 (the default on Mac), and perhaps only when importing a database from a system which uses a different value for lower_case_table_names.

If it happens again, the workaround is probably to set mysql's system variable lower_case_table_names=1 in my.cnf, which is the recommended setting when using InnoDB tables.

Sure.

On Tue, Sep 29, 2015 at 3:40 PM, Sean Flanigan (JIRA) <

We are closing all the old issues to have more clarity in our backlog for Zanata project. Feel free to re-open or leave a comment if you require our attention on your Jira.