View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0005476 | SymmetricDS | Improvement | public | 2022-09-28 16:17 | 2022-10-04 15:15 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.14.0 | ||||
| Target Version | 3.14.2 | Fixed in Version | 3.14.2 | ||
| Summary | 0005476: Ability to disable sync triggers when sync on incoming is enabled | ||||
| Description | Provide a way to disable the sync triggers even when sync on incoming is enabled. When sync on incoming is enabled for a trigger, the text of the trigger uses a condition of 1=1 so the trigger will always fire. Each database platform has a session variable that can be set to 1 to disable the triggers. When sync on incoming is disabled, the text of the trigger tests that the session variable is null. Update the trigger text to test that the session variable is not 2 when sync on incoming is disabled. That way, the trigger will fire when the session variable is null (local change) or 1 (loading data sync), but not if the user sets it to 2. Initial implementation for Oracle, SQL Server, MySQL, and PostgreSQL. | ||||
| Tags | trigger | ||||
|
SymmetricDS: 3.14 932c34d8 2022-09-28 16:19:09 Details Diff |
0005476: ability to disable sync triggers when sync on incoming is enabled |
Affected Issues 0005476 |
|
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/mssql/MsSql2016SymmetricDialect.java | Diff File | ||
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/mssql/MsSqlSymmetricDialect.java | Diff File | ||
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/mysql/MySqlSymmetricDialect.java | Diff File | ||
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/oracle/OracleSymmetricDialect.java | Diff File | ||
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/postgresql/PostgreSqlSymmetricDialect.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/db/AbstractSymmetricDialect.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/db/AbstractTriggerTemplate.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/db/ISymmetricDialect.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2022-09-28 16:17 | elong | New Issue | |
| 2022-09-28 16:17 | elong | Status | new => assigned |
| 2022-09-28 16:17 | elong | Assigned To | => elong |
| 2022-09-28 16:17 | elong | Tag Attached: trigger | |
| 2022-09-28 16:18 | elong | Summary | Disable sync triggers when sync on incoming is enabled => Method to disable sync triggers when sync on incoming is enabled |
| 2022-09-28 16:19 | elong | Summary | Method to disable sync triggers when sync on incoming is enabled => Ability to disable sync triggers when sync on incoming is enabled |
| 2022-09-28 16:19 | elong | Description Updated | View Revisions |
| 2022-09-28 16:19 | elong | Status | assigned => resolved |
| 2022-09-28 16:19 | elong | Resolution | open => fixed |
| 2022-09-28 16:19 | elong | Fixed in Version | => 3.14.2 |
| 2022-09-28 17:00 | admin | Changeset attached | => SymmetricDS 3.14 932c34d8 |
| 2022-10-04 15:15 | admin | Status | resolved => closed |