| Description | "Invalid trigger sql gets generated for MySQL when trigger has source_catalog_name defined. I fixed this by modifying the getTransactionTriggerExpression method in MySqlDbDialect. {code} Index: src/main/java/org/jumpmind/symmetric/db/mysql/MySqlDbDialect.java =================================================================== --- src/main/java/org/jumpmind/symmetric/db/mysql/MySqlDbDialect.java (revision 3175) +++ src/main/java/org/jumpmind/symmetric/db/mysql/MySqlDbDialect.java (working copy) @@ -129,12 +129,7 @@ @Override public String getTransactionTriggerExpression(String defaultCatalog, String defaultSchema, Trigger trigger) { - if (trigger.getSourceCatalogName() != null) { - defaultCatalog = defaultCatalog + "".""; - } else { - defaultCatalog = """"; - } - return defaultCatalog + getTransactionFunctionName() + ""()""; + return getTransactionFunctionName() + ""()""; } @Override {code}" |
|---|