View Revisions: Issue #4201

Summary 0004201: Failed to create update trigger for triggers that use and external_select with $(curTriggerValue)
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.
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.