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. | ||