View Revisions: Issue #5778

Summary 0005778: Change timestamp size on sym tables with a timestamp as a primary key
Revision 2023-05-15 18:49 by cquamme
Description To avoid errors during table syncs between databases with different precisions, we will change the timestamp size on sym tables with a timestamp as a primary key to be a size of 2. Some databases (Oracle, SQL Server) will have an error during upgrade with this change, so we will make sure the appropriate actions are taken during the upgrade process to avoid this causing an error.

Affected sym tables:
table_reload_request
node_group_channel_wnd
node_host_channel_stats
node_host_job_stats
node_host_stats
registration_request
Revision 2023-04-06 16:59 by cquamme
Description To avoid errors during table syncs between databases with different precisions, we will change the size of create_time on the sym_table_reload_request table to be a size of 2. Some databases (Oracle, SQL Server) will have an error during upgrade with this change, so we will make sure the appropriate actions are taken during the upgrade process to avoid this causing an error.