View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004392 | SymmetricDS | Bug | public | 2020-05-08 14:28 | 2025-03-26 17:35 |
| Reporter | elong | Assigned To | |||
| Priority | normal | ||||
| Status | acknowledged | Resolution | open | ||
| Product Version | 3.12.0 | ||||
| Summary | 0004392: Trigger names can be too long and should stay within max identifier length for platform | ||||
| Description | Some 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. | ||||
| Tags | dialect: oracle, trigger | ||||