View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004226 | SymmetricDS | Bug | public | 2020-01-03 00:53 | 2020-06-04 17:55 |
| Reporter | tmdoit | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.11.0 | ||||
| Target Version | 3.12.0 | Fixed in Version | 3.12.0 | ||
| Summary | 0004226: Table trigger configuration - Sync on Insert/Delete/Update Condition, wrong Sync Condition example | ||||
| Description | In docs is "Sync Conditions can access both old values and new values of a field/column using "old_" and "new_" respectively. [...]". It's not true, you can get values by accessing tables "inserted." and "deleted.". | ||||
| Additional Information | I'm almost sure. :) | ||||
| Tags | trigger | ||||
|
|
Now I read from docs: "On SQL-Server it is added to the "WHERE" clause of a query for inserted/deleted logical tables. See Sync Condition Example.". Maybe update docs to smth like: Sync Condition Example Sync Conditions can access both old values and new values of a field/column using "old_" and "new_" respectively (for MSSQL it is "deleted." and "inserted."). For example, if your column is id and your condition checks the value coming in to be 'test', your condition will be: [...] |
|
|
It would hard to mention the specific alias needed for each of the 20+ databases supported unless we provide a table in the appendix. Maybe we reference the trigger template variable instead, which get replaced with the correct alias for the platform. |
|
SymmetricDS: 3.12 8088937b 2020-05-21 10:55:48 Details Diff |
0004226: trigger template variables and example |
Affected Issues 0004226 |
|
| mod - symmetric-assemble/src/asciidoc/configuration/table-triggers.ad | Diff File | ||
| mod - symmetric-assemble/src/asciidoc/configuration/table-triggers/external-select.ad | Diff File | ||
| add - symmetric-assemble/src/asciidoc/configuration/table-triggers/trigger-variables.ad | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2020-01-03 00:53 | tmdoit | New Issue | |
| 2020-01-03 00:53 | tmdoit | Tag Attached: trigger | |
| 2020-01-03 00:53 | tmdoit | Tag Attached: Condition | |
| 2020-01-07 02:33 | tmdoit | Note Added: 0001674 | |
| 2020-05-21 14:52 | elong | Tag Detached: Condition | |
| 2020-05-21 14:55 | elong | Assigned To | => elong |
| 2020-05-21 14:55 | elong | Status | new => resolved |
| 2020-05-21 14:55 | elong | Resolution | open => fixed |
| 2020-05-21 14:55 | elong | Product Version | 3.11.3 => 3.11.0 |
| 2020-05-21 14:55 | elong | Fixed in Version | => 3.12.0 |
| 2020-05-21 14:55 | elong | Target Version | => 3.12.0 |
| 2020-05-21 14:55 | elong | Note Added: 0001718 | |
| 2020-05-26 18:48 | elong | Status | resolved => closed |
| 2020-06-04 17:55 | admin | Changeset attached | => SymmetricDS 3.12 8088937b |