View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0002458 | SymmetricDS | New Feature | public | 2015-12-01 14:44 | 2016-08-09 17:12 |
| Reporter | azarubkin | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.7.27 | ||||
| Target Version | 3.8.0 | Fixed in Version | 3.8.0 | ||
| Summary | 0002458: Add arbitrary text at the beginning of the trigger | ||||
| Description | This is related to http://www.symmetricds.org/issues/view.php?id=2457 Since we can add arbitrary text after SymmetricDS trigger runs (field TRIGGER.CUSTOM_ON_INSERT_TEXT, CUSTOM_ON_UPDATE_TEXT, CUSTOM_ON_DELETE_TEXT), can we please have an ability to add arbitrary text also before SymmetricDS trigger runs? I.e. add three more LONGVARCHAR fields to TRIGGER table which will contain texts to execute before SymmetricDS triggers on insert, update, delete actions. | ||||
| Tags | No tags attached. | ||||
|
|
Can you put your trigger as a "before" trigger instead? Can you explain your use case for running text at the top of the SymmetricDS trigger? I'm concerned that this feature would allow users to modify data before the current row can be captured into sym_data, which would cause data to be captured in the wrong order. |
|
|
I just realized that you entered 2457 also (http://www.symmetricds.org/issues/view.php?id=2457) about preserving identities, so maybe you were looking for flexible ways to accomplish that. I guess we could just put a warning in documentation on modifying tables in a before_customer_on_x_text. |
|
|
Yes, exactly. I was looking for ways to solve issue 0002457. I'm not going to modify data there, I promise :-) |
|
SymmetricDS: 3.8 e1c2ff5d 2016-05-24 08:27:17 Details Diff |
0002458: Add arbitrary text at the beginning of the trigger |
Affected Issues 0002458 |
|
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/ase/AseTriggerTemplate.java | Diff File | ||
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/db2/Db2As400TriggerTemplate.java | Diff File | ||
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/db2/Db2TriggerTemplate.java | Diff File | ||
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/db2/Db2zOsTriggerTemplate.java | Diff File | ||
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/firebird/FirebirdTriggerTemplate.java | Diff File | ||
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/informix/InformixTriggerTemplate.java | Diff File | ||
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/interbase/InterbaseTriggerTemplate.java | Diff File | ||
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/mssql/MsSqlTriggerTemplate.java | Diff File | ||
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/mssql2000/MsSql2000TriggerTemplate.java | Diff File | ||
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/mysql/MySqlTriggerTemplate.java | Diff File | ||
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/oracle/OracleTriggerTemplate.java | Diff File | ||
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/postgresql/GreenplumTriggerTemplate.java | Diff File | ||
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/postgresql/PostgreSqlTriggerTemplate.java | Diff File | ||
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/sqlanywhere/SqlAnywhereTriggerTemplate.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/model/Trigger.java | Diff File | ||
| mod - symmetric-core/src/main/resources/symmetric-schema.xml | Diff File | ||
|
SymmetricDS: 3.8 e1290aeb 2016-05-24 10:57:54 Details Diff |
0002458: Add arbitrary text at the beginning of the trigger |
Affected Issues 0002458 |
|
| mod - symmetric-core/src/main/resources/symmetric-schema.xml | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2015-12-01 14:44 | azarubkin | New Issue | |
| 2015-12-03 19:45 | elong | Note Added: 0000736 | |
| 2015-12-03 19:51 | elong | Note Added: 0000737 | |
| 2015-12-04 12:29 | azarubkin | Note Added: 0000738 | |
| 2016-05-24 13:00 | admin | Changeset attached | => SymmetricDS 3.8 e1c2ff5d |
| 2016-05-24 15:00 | admin | Changeset attached | => SymmetricDS 3.8 e1290aeb |
| 2016-05-24 18:03 | elong | Status | new => resolved |
| 2016-05-24 18:03 | elong | Fixed in Version | => 3.8.0 |
| 2016-05-24 18:03 | elong | Resolution | open => fixed |
| 2016-05-24 18:03 | elong | Assigned To | => elong |
| 2016-05-24 18:03 | admin | Target Version | => 3.8.0 |
| 2016-05-24 18:04 | elong | Relationship added | related to 0002457 |
| 2016-08-09 17:12 | admin | Status | resolved => closed |