View Revisions: Issue #3789

Summary 0003789: Sort SQL configuration export by primary key to make it easier to diff
Revision 2018-12-05 20:35 by hanes
Description Sort SQL configuration export by primary key to make it easier to diff.
Revision 2018-12-05 20:32 by hanes
Description Sort sql & csv configuration export by primary key to make it easier to diff.
Revision 2018-12-05 20:27 by hanes
Description Sort sql & csv configuration export by primary key to make it easier to diff.

All but one query seems to have an order by. The one that doesn't have an order by is:

[gui] - JdbcSqlTemplate - (1ms.) select c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version from sym_node c

which seems to be the 46th query run when you do an export.
Revision 2018-11-08 17:14 by chenson
Description Sort sql & csv configuration export by primary key to make it easier to diff
Revision 2018-11-08 17:13 by chenson
Description Sort csv configuration export by primary key to make it easier to diff