Lower in upper case mix in the table names

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

pkokorev

Hello,
I ran into an issue while migrating my Activiti MySQL database from Windows to Linux server. Actually, the problem was in the case of the table names, that is ignored under Windows and is taken into account on Linux. I added the "lower_case_table_names=1" option to my Windows MySQL server configuration and regenerated the tables. Now I have both uppercase and lowercase table names in the schema. It seems to work now on both operation systems, but this mix of cases looks a bit suspicious to me. Is it normal to have such a structure? Did anyone already notice something similar when running Activiti with MySQL?
Activiti version : 5.12.1
MySQL version : 5.1.65
Show tables :

ACT_GE_BYTEARRAY
ACT_GE_PROPERTY
ACT_HI_ATTACHMENT
ACT_HI_COMMENT
ACT_HI_TASKINST
ACT_ID_GROUP
ACT_ID_INFO
ACT_ID_MEMBERSHIP
ACT_ID_USER
ACT_RE_DEPLOYMENT
ACT_RE_MODEL
ACT_RE_PROCDEF
ACT_RU_EVENT_SUBSCR
ACT_RU_EXECUTION
ACT_RU_IDENTITYLINK
ACT_RU_JOB
ACT_RU_TASK
ACT_RU_VARIABLE
act_hi_actinst
act_hi_detail
act_hi_procinst
act_hi_varinst
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

trademak

Hi,

Hmm that's strange indeed. The create script only contains upper case table names.
Just tested it and I got the same result. But I have no idea at the moment what's the cause of this. Will do some more investigation this week.

Best regards,