View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0003789 | SymmetricDS Pro | Improvement | public | 2018-11-08 17:13 | 2022-01-17 13:41 |
| Reporter | chenson | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.9.15 | ||||
| Target Version | 3.13.3 | Fixed in Version | 3.13.3 | ||
| Summary | 0003789: Sort SQL configuration export by primary key to make it easier to diff | ||||
| Description | Sort SQL configuration export by primary key to make it easier to diff. | ||||
| Additional Information | CSV export looks like all the queries have an order by already. SQL needs order by still, as shown (there may be additional sql at the end of this list unrelated to the export) [gui] - JdbcSqlTemplate - (0ms.) select "NODE_GROUP_ID", "DESCRIPTION", "CREATE_TIME", "LAST_UPDATE_BY", "LAST_UPDATE_TIME" from "SYM_NODE_GROUP" [gui] - JdbcSqlTemplate - (0ms.) select "SOURCE_NODE_GROUP_ID", "TARGET_NODE_GROUP_ID", "DATA_EVENT_ACTION", "SYNC_CONFIG_ENABLED", "IS_REVERSIBLE", "CREATE_TIME", "LAST_UPDATE_BY", "LAST_UPDATE_TIME" from "SYM_NODE_GROUP_LINK" [gui] - JdbcSqlTemplate - (0ms.) select "EXTERNAL_ID", "NODE_GROUP_ID", "PARAM_KEY", "PARAM_VALUE", "CREATE_TIME", "LAST_UPDATE_BY", "LAST_UPDATE_TIME" from "SYM_PARAMETER" [gui] - JdbcSqlTemplate - (0ms.) select "CHANNEL_ID", "PROCESSING_ORDER", "MAX_BATCH_SIZE", "MAX_BATCH_TO_SEND", "MAX_DATA_TO_ROUTE", "EXTRACT_PERIOD_MILLIS", "ENABLED", "USE_OLD_DATA_TO_ROUTE", "USE_ROW_DATA_TO_ROUTE", "USE_PK_DATA_TO_ROUTE", "RELOAD_FLAG", "FILE_SYNC_FLAG", "CONTAINS_BIG_LOB", "BATCH_ALGORITHM", "DATA_LOADER_TYPE", "DESCRIPTION", "QUEUE", "MAX_NETWORK_KBPS", "DATA_EVENT_ACTION", "CREATE_TIME", "LAST_UPDATE_BY", "LAST_UPDATE_TIME" from "SYM_CHANNEL" [gui] - JdbcSqlTemplate - (0ms.) select "NODE_GROUP_ID", "CHANNEL_ID", "START_TIME", "END_TIME", "ENABLED" from "SYM_NODE_GROUP_CHANNEL_WND" [gui] - JdbcSqlTemplate - (1ms.) select "TRIGGER_ID", "SOURCE_CATALOG_NAME", "SOURCE_SCHEMA_NAME", "SOURCE_TABLE_NAME", "CHANNEL_ID", "RELOAD_CHANNEL_ID", "SYNC_ON_UPDATE", "SYNC_ON_INSERT", "SYNC_ON_DELETE", "SYNC_ON_INCOMING_BATCH", "NAME_FOR_UPDATE_TRIGGER", "NAME_FOR_INSERT_TRIGGER", "NAME_FOR_DELETE_TRIGGER", "SYNC_ON_UPDATE_CONDITION", "SYNC_ON_INSERT_CONDITION", "SYNC_ON_DELETE_CONDITION", "CUSTOM_BEFORE_UPDATE_TEXT", "CUSTOM_BEFORE_INSERT_TEXT", "CUSTOM_BEFORE_DELETE_TEXT", "CUSTOM_ON_UPDATE_TEXT", "CUSTOM_ON_INSERT_TEXT", "CUSTOM_ON_DELETE_TEXT", "EXTERNAL_SELECT", "TX_ID_EXPRESSION", "CHANNEL_EXPRESSION", "EXCLUDED_COLUMN_NAMES", "INCLUDED_COLUMN_NAMES", "SYNC_KEY_NAMES", "USE_STREAM_LOBS", "USE_CAPTURE_LOBS", "USE_CAPTURE_OLD_DATA", "USE_HANDLE_KEY_UPDATES", "STREAM_ROW", "CREATE_TIME", "LAST_UPDATE_BY", "LAST_UPDATE_TIME", "DESCRIPTION" from "SYM_TRIGGER" [gui] - JdbcSqlTemplate - (0ms.) select "ROUTER_ID", "TARGET_CATALOG_NAME", "TARGET_SCHEMA_NAME", "TARGET_TABLE_NAME", "SOURCE_NODE_GROUP_ID", "TARGET_NODE_GROUP_ID", "ROUTER_TYPE", "ROUTER_EXPRESSION", "SYNC_ON_UPDATE", "SYNC_ON_INSERT", "SYNC_ON_DELETE", "USE_SOURCE_CATALOG_SCHEMA", "CREATE_TIME", "LAST_UPDATE_BY", "LAST_UPDATE_TIME", "DESCRIPTION" from "SYM_ROUTER" [gui] - JdbcSqlTemplate - (0ms.) select "TRIGGER_ID", "ROUTER_ID", "ENABLED", "INITIAL_LOAD_ORDER", "INITIAL_LOAD_SELECT", "INITIAL_LOAD_DELETE_STMT", "PING_BACK_ENABLED", "CREATE_TIME", "LAST_UPDATE_BY", "LAST_UPDATE_TIME", "DESCRIPTION" from "SYM_TRIGGER_ROUTER" [gui] - JdbcSqlTemplate - (0ms.) select "TRANSFORM_ID", "SOURCE_NODE_GROUP_ID", "TARGET_NODE_GROUP_ID", "TRANSFORM_POINT", "SOURCE_CATALOG_NAME", "SOURCE_SCHEMA_NAME", "SOURCE_TABLE_NAME", "TARGET_CATALOG_NAME", "TARGET_SCHEMA_NAME", "TARGET_TABLE_NAME", "UPDATE_FIRST", "UPDATE_ACTION", "DELETE_ACTION", "TRANSFORM_ORDER", "COLUMN_POLICY", "CREATE_TIME", "LAST_UPDATE_BY", "LAST_UPDATE_TIME", "DESCRIPTION" from "SYM_TRANSFORM_TABLE" [gui] - JdbcSqlTemplate - (0ms.) select "LOAD_FILTER_ID", "LOAD_FILTER_TYPE", "SOURCE_NODE_GROUP_ID", "TARGET_NODE_GROUP_ID", "TARGET_CATALOG_NAME", "TARGET_SCHEMA_NAME", "TARGET_TABLE_NAME", "FILTER_ON_UPDATE", "FILTER_ON_INSERT", "FILTER_ON_DELETE", "BEFORE_WRITE_SCRIPT", "AFTER_WRITE_SCRIPT", "BATCH_COMPLETE_SCRIPT", "BATCH_COMMIT_SCRIPT", "BATCH_ROLLBACK_SCRIPT", "HANDLE_ERROR_SCRIPT", "CREATE_TIME", "LAST_UPDATE_BY", "LAST_UPDATE_TIME", "LOAD_FILTER_ORDER", "FAIL_ON_ERROR" from "SYM_LOAD_FILTER" [gui] - JdbcSqlTemplate - (0ms.) select "TRANSFORM_ID", "INCLUDE_ON", "TARGET_COLUMN_NAME", "SOURCE_COLUMN_NAME", "PK", "TRANSFORM_TYPE", "TRANSFORM_EXPRESSION", "TRANSFORM_ORDER", "CREATE_TIME", "LAST_UPDATE_BY", "LAST_UPDATE_TIME", "DESCRIPTION" from "SYM_TRANSFORM_COLUMN" [gui] - JdbcSqlTemplate - (0ms.) select "CONFLICT_ID", "SOURCE_NODE_GROUP_ID", "TARGET_NODE_GROUP_ID", "TARGET_CHANNEL_ID", "TARGET_CATALOG_NAME", "TARGET_SCHEMA_NAME", "TARGET_TABLE_NAME", "DETECT_TYPE", "DETECT_EXPRESSION", "RESOLVE_TYPE", "PING_BACK", "RESOLVE_CHANGES_ONLY", "RESOLVE_ROW_ONLY", "CREATE_TIME", "LAST_UPDATE_BY", "LAST_UPDATE_TIME" from "SYM_CONFLICT" [gui] - JdbcSqlTemplate - (0ms.) select "GROUPLET_ID", "GROUPLET_LINK_POLICY", "DESCRIPTION", "CREATE_TIME", "LAST_UPDATE_BY", "LAST_UPDATE_TIME" from "SYM_GROUPLET" [gui] - JdbcSqlTemplate - (1ms.) select "GROUPLET_ID", "EXTERNAL_ID", "CREATE_TIME", "LAST_UPDATE_BY", "LAST_UPDATE_TIME" from "SYM_GROUPLET_LINK" [gui] - JdbcSqlTemplate - (0ms.) select "GROUPLET_ID", "TRIGGER_ID", "ROUTER_ID", "APPLIES_WHEN", "CREATE_TIME", "LAST_UPDATE_BY", "LAST_UPDATE_TIME" from "SYM_TRIGGER_ROUTER_GROUPLET" [gui] - JdbcSqlTemplate - (0ms.) select "TRIGGER_ID", "CHANNEL_ID", "RELOAD_CHANNEL_ID", "BASE_DIR", "RECURSE", "INCLUDES_FILES", "EXCLUDES_FILES", "SYNC_ON_CREATE", "SYNC_ON_MODIFIED", "SYNC_ON_DELETE", "SYNC_ON_CTL_FILE", "DELETE_AFTER_SYNC", "BEFORE_COPY_SCRIPT", "AFTER_COPY_SCRIPT", "CREATE_TIME", "LAST_UPDATE_BY", "LAST_UPDATE_TIME", "DESCRIPTION" from "SYM_FILE_TRIGGER" [gui] - JdbcSqlTemplate - (0ms.) select "TRIGGER_ID", "ROUTER_ID", "ENABLED", "INITIAL_LOAD_ENABLED", "TARGET_BASE_DIR", "CONFLICT_STRATEGY", "CREATE_TIME", "LAST_UPDATE_BY", "LAST_UPDATE_TIME", "DESCRIPTION" from "SYM_FILE_TRIGGER_ROUTER" [gui] - JdbcSqlTemplate - (1ms.) select "EXTENSION_ID", "EXTENSION_TYPE", "INTERFACE_NAME", "NODE_GROUP_ID", "ENABLED", "EXTENSION_ORDER", "EXTENSION_TEXT", "CREATE_TIME", "LAST_UPDATE_BY", "LAST_UPDATE_TIME" from "SYM_EXTENSION" [gui] - JdbcSqlTemplate - (0ms.) select "MONITOR_ID", "NODE_GROUP_ID", "EXTERNAL_ID", "TYPE", "EXPRESSION", "THRESHOLD", "RUN_PERIOD", "RUN_COUNT", "SEVERITY_LEVEL", "ENABLED", "CREATE_TIME", "LAST_UPDATE_BY", "LAST_UPDATE_TIME" from "SYM_MONITOR" [gui] - JdbcSqlTemplate - (1ms.) select "NOTIFICATION_ID", "NODE_GROUP_ID", "EXTERNAL_ID", "SEVERITY_LEVEL", "TYPE", "EXPRESSION", "ENABLED", "CREATE_TIME", "LAST_UPDATE_BY", "LAST_UPDATE_TIME" from "SYM_NOTIFICATION" [gui] - JdbcSqlTemplate - (0ms.) select "JOB_NAME", "JOB_TYPE", "REQUIRES_REGISTRATION", "JOB_EXPRESSION", "DESCRIPTION", "DEFAULT_SCHEDULE", "DEFAULT_AUTO_START", "NODE_GROUP_ID", "CREATE_BY", "CREATE_TIME", "LAST_UPDATE_BY", "LAST_UPDATE_TIME" from "SYM_JOB" [corp-000] - JdbcSqlTemplate - (1ms.) select monitor_id, node_id, event_time, type, event_value, event_count, threshold, severity_level, host_name, is_resolved, is_notified, details, last_update_time from sym_monitor_event where severity_level >= 300 and is_resolved = 0 order by event_time desc [corp-000] - JdbcSqlTemplate - (1ms.) select node_id, queue from sym_extract_request where status='NE' group by node_id, queue [corp-000] - JdbcSqlTemplate - (1ms.) select monitor_id, external_id, node_group_id, type, expression, enabled, threshold, run_period, run_count, severity_level, create_time, last_update_by, last_update_time from sym_monitor where (node_group_id = 'corp' or node_group_id = 'ALL') and (external_id = '000' or external_id = 'ALL') and enabled = 1 [corp-000] - JdbcSqlTemplate - (1ms.) select monitor_id, node_id, event_time, type, event_value, event_count, threshold, severity_level, host_name, is_resolved, is_notified, details, last_update_time from sym_monitor_event where node_id = '000' and is_resolved = 0 | ||||
| Tags | No tags attached. | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2018-11-08 17:13 | chenson | New Issue | |
| 2018-11-08 17:14 | chenson | Summary | Sort csv configuration export by primary key to make it easier to diff => Sort sql & csv configuration export by primary key to make it easier to diff |
| 2018-11-08 17:14 | chenson | Description Updated | View Revisions |
| 2018-11-16 13:00 | hanes | Status | new => acknowledged |
| 2018-12-05 20:27 | hanes | Description Updated | View Revisions |
| 2018-12-05 20:32 | hanes | Target Version | 3.10.0 => 3.9.16 |
| 2018-12-05 20:32 | hanes | Description Updated | View Revisions |
| 2018-12-05 20:32 | hanes | Additional Information Updated | View Revisions |
| 2018-12-05 20:35 | hanes | Summary | Sort sql & csv configuration export by primary key to make it easier to diff => Sort SQL configuration export by primary key to make it easier to diff |
| 2018-12-05 20:35 | hanes | Description Updated | View Revisions |
| 2018-12-05 20:35 | hanes | Additional Information Updated | View Revisions |
| 2018-12-05 20:36 | hanes | Additional Information Updated | View Revisions |
| 2018-12-27 15:28 | chenson | Target Version | 3.9.16 => 3.10.0 |
| 2019-01-08 15:48 | mmichalek | Note Added: 0001371 | |
| 2019-05-08 12:41 | admin | Target Version | 3.10.0 => 3.10.3 |
| 2019-06-24 17:47 | elong | Target Version | 3.10.3 => 3.10.4 |
| 2019-08-09 18:28 | elong | Target Version | 3.10.4 => 3.10.5 |
| 2019-11-01 12:23 | admin | Target Version | 3.10.5 => 3.10.6 |
| 2019-11-14 19:34 | elong | Target Version | 3.10.6 => 3.10.7 |
| 2019-12-09 15:27 | admin | Target Version | 3.10.7 => 3.10.8 |
| 2020-01-02 14:46 | admin | Target Version | 3.10.8 => 3.10.9 |
| 2020-01-22 19:09 | elong | Target Version | 3.10.9 => 3.10.10 |
| 2020-02-14 13:26 | elong | Target Version | 3.10.10 => 3.10.11 |
| 2020-03-16 20:15 | admin | Target Version | 3.10.11 => 3.10.12 |
| 2020-05-26 12:26 | elong | Target Version | 3.10.12 => 3.11.10 |
| 2020-06-24 20:34 | elong | Target Version | 3.11.10 => 3.12.2 |
| 2020-07-20 13:09 | elong | Target Version | 3.12.2 => 3.12.3 |
| 2020-08-31 19:44 | elong | Target Version | 3.12.3 => 3.12.4 |
| 2020-09-23 15:33 | admin | Target Version | 3.12.4 => 3.12.5 |
| 2020-11-09 13:49 | admin | Target Version | 3.12.5 => 3.12.6 |
| 2021-01-08 20:46 | admin | Target Version | 3.12.6 => 3.12.7 |
| 2021-02-25 13:10 | admin | Target Version | 3.12.7 => 3.12.8 |
| 2021-03-30 19:14 | admin | Target Version | 3.12.8 => 3.12.9 |
| 2021-04-28 14:43 | admin | Target Version | 3.12.9 => 3.12.10 |
| 2021-05-28 11:55 | admin | Target Version | 3.12.10 => 3.12.11 |
| 2021-07-12 20:53 | admin | Target Version | 3.12.11 => 3.13.0 |
| 2021-11-02 20:09 | elong | Target Version | 3.13.0 => 3.13.1 |
| 2021-12-11 17:09 | admin | Target Version | 3.13.1 => 3.13.2 |
| 2021-12-20 14:27 | admin | Target Version | 3.13.2 => 3.13.3 |
| 2022-01-11 21:34 | elong | Assigned To | => elong |
| 2022-01-11 21:34 | elong | Status | acknowledged => resolved |
| 2022-01-11 21:34 | elong | Resolution | open => fixed |
| 2022-01-11 21:34 | elong | Fixed in Version | => 3.13.3 |
| 2022-01-17 13:41 | admin | Status | resolved => closed |