View Issue Details

IDProjectCategoryView StatusLast Update
0003789SymmetricDS ProImprovementpublic2022-01-17 13:41
Reporterchenson Assigned Toelong  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.9.15 
Target Version3.13.3Fixed in Version3.13.3 
Summary0003789: Sort SQL configuration export by primary key to make it easier to diff
DescriptionSort SQL configuration export by primary key to make it easier to diff.
Additional InformationCSV 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
TagsNo tags attached.

Activities

mmichalek

2019-01-08 15:48

administrator   ~0001371

Consider sorting these in memory. Sybase and DB2 may be sorting based on different collations.

Issue History

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