View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0005788 | SymmetricDS | Bug | public | 2023-04-12 01:58 | 2023-10-09 20:00 |
| Reporter | zhujiawen | Assigned To | emiller | ||
| Priority | urgent | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.14.5 | ||||
| Target Version | 3.14.10 | Fixed in Version | 3.14.10 | ||
| Summary | 0005788: The source_table_name wildcard behavior does not match the documentation on the website | ||||
| Description | I create trigger one trigger use * wailcard match all table expect table drug_stock_hosp，another trigger specified `drug_stock_hosp`.But trigger `ep` match table drug_stock_hosp： mysql> select * from sym_trigger \G; *************************** 1. row *************************** trigger_id: ep source_catalog_name: NULL source_schema_name: NULL source_table_name: * channel_id: ep reload_channel_id: reload sync_on_update: 1 sync_on_insert: 1 sync_on_delete: 1 sync_on_incoming_batch: 0 name_for_update_trigger: NULL name_for_insert_trigger: NULL name_for_delete_trigger: NULL sync_on_update_condition: NULL sync_on_insert_condition: NULL sync_on_delete_condition: NULL custom_before_update_text: NULL custom_before_insert_text: NULL custom_before_delete_text: NULL custom_on_update_text: NULL custom_on_insert_text: NULL custom_on_delete_text: NULL external_select: NULL tx_id_expression: NULL channel_expression: NULL excluded_column_names: NULL included_column_names: NULL sync_key_names: NULL use_stream_lobs: 0 use_capture_lobs: 0 use_capture_old_data: 1 use_handle_key_updates: 1 stream_row: 0 create_time: 2023-04-11 18:02:32 last_update_by: NULL last_update_time: 2023-04-11 18:02:32 description: NULL *************************** 2. row *************************** trigger_id: ep_drug_stock_hosp source_catalog_name: NULL source_schema_name: NULL source_table_name: drug_stock_hosp channel_id: ep reload_channel_id: reload sync_on_update: 1 sync_on_insert: 1 sync_on_delete: 1 sync_on_incoming_batch: 0 name_for_update_trigger: NULL name_for_insert_trigger: NULL name_for_delete_trigger: NULL sync_on_update_condition: NULL sync_on_insert_condition: NULL sync_on_delete_condition: NULL custom_before_update_text: NULL custom_before_insert_text: NULL custom_before_delete_text: NULL custom_on_update_text: NULL custom_on_insert_text: NULL custom_on_delete_text: NULL external_select: NULL tx_id_expression: NULL channel_expression: NULL excluded_column_names: drug_name included_column_names: NULL sync_key_names: NULL use_stream_lobs: 0 use_capture_lobs: 0 use_capture_old_data: 1 use_handle_key_updates: 1 stream_row: 0 create_time: 2023-04-11 17:43:28 last_update_by: NULL last_update_time: 2023-04-11 17:43:28 description: NULL 2 rows in set (0.00 sec) ERROR: No query specified documentation on the website: The source_table_name may contain the asterisk ('*') wildcard character so that one TRIGGER table entry can define synchronization for many tables. System tables and any tables that start with the SymmetricDS table prefix will be excluded. A list of wildcard tokens can also be supplied. If there are multiple tokens, they should be delimited with a comma. A wildcard token can also start with a bang ('!') to indicate an exclusive match. Tokens are always evalulated from left to right. When a table match is made, the table is either added to or removed from the list of tables. If another trigger already exists for a table, then that table is not included in the wildcard match (the explictly defined trigger entry take precendence). https://www.symmetricds.org/doc/3.6/user-guide/html-single/user-guide.html#configuration-table-triggers | ||||
| Tags | No tags attached. | ||||
|
SymmetricDS: 3.14 7aa79885 2023-10-09 19:21:48 evan-miller-jumpmind Details Diff |
0005788: Fixed issue where explicitly defined triggers did not take precedence over wildcard triggers |
Affected Issues 0005788 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/TriggerRouterService.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2023-04-12 01:58 | zhujiawen | New Issue | |
| 2023-04-19 17:51 | pmarzullo | Assigned To | => pmarzullo |
| 2023-04-19 17:51 | pmarzullo | Status | new => assigned |
| 2023-10-09 19:22 | emiller | Assigned To | pmarzullo => emiller |
| 2023-10-09 19:22 | emiller | Status | assigned => resolved |
| 2023-10-09 19:22 | emiller | Resolution | open => fixed |
| 2023-10-09 19:22 | emiller | Fixed in Version | => 3.14.10 |
| 2023-10-09 19:22 | emiller | Target Version | => 3.14.10 |
| 2023-10-09 20:00 | Changeset attached | => SymmetricDS 3.14 7aa79885 | |
| 2023-10-27 20:06 | admin | Status | resolved => closed |