View Revisions: Issue #4201
| Summary | 0004201: Failed to create update trigger for triggers that use and external_select with $(curTriggerValue) | ||
|---|---|---|---|
| Revision | 2020-05-22 18:13 by elong | ||
| Description | We observe several "Failed to create trigger x ... Reason The multi-part identifier "inserted.customerid" could not be bound" for all update triggers that use and external_select with $(curTriggerValue) on a MsSql Server. See central_3.11_log_snippet.log. First analyze shows that happens after https://www.symmetricds.org/issues/view.php?id=3901 MsSqlTriggerTemplate.java -> updateTriggerTemplate. I guess it affects updateReloadTriggerTemplate, too I formatted the sql and made it work. Diff the enclosed failing_sql.txt with fixed_sql.txt, please. |
||
| Revision | 2019-12-12 10:31 by mkurz | ||
| Description | We observe several "Failed to create trigger x ... Reason The multi-part identifier "inserted.customerid" could not be bound" for all update triggers that use and external_select with $(curTriggerValue) on a MsSql Server. See central_3.11_log_snippet.log. First analyze shows that happens after https://www.symmetricds.org/issues/view.php?id=3901 MsSqlTriggerTemplate.java -> updateTriggerTemplate. I guess it affects updateReloadTriggerTemplate, too I formatted the sql and made it work. Diff the enclosed failing_sql.txt with fixed_sql.txt, please. |
||