View Issue Details

IDProjectCategoryView StatusLast Update
0004392SymmetricDSBugpublic2020-05-08 14:28
Reporterelong Assigned To 
Prioritynormal 
Status newResolutionopen 
Product Version3.12.0 
Summary0004392: Trigger names can be too long and should stay within max identifier length for platform
DescriptionSome database allow longer names for tables, but trigger names are shorter. Each dialect in SymmetricDS set the MaxIdentifierLength on the DatabaseInfo, but that information doesn't seem to be used when generating the trigger name. For example, on Oracle 12.2, table names can be 128 bytes, but trigger names are still limited to 30 characters. The workaround is to specify sym_trigger with name_for_insert/update/delete_trigger that is within 30 characters.
Tagsdialect: oracle, trigger

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2020-05-08 14:28 elong New Issue
2020-05-08 14:28 elong Tag Attached: dialect: oracle
2020-05-08 14:28 elong Tag Attached: trigger