Red Hat Bugzilla – Bug 1025738
DTGov/RTGov generates wrong column type for uuids with SQL Server
Last modified: 2018-03-29 17:52:44 EDT
Description of problem: RTGov and DTGov generate their database tables with SQL Server 2008 dialect using untyped access:
unitId varchar(255) not null
As this data is actually in UUID format, it should be stored as:
unitId uniqueidentifier not null
The advantages is that this column uses only 16 bytes of data (instead of 36 bytes which is the minimum when stored as varchar).
Version-Release number of selected component (if applicable): FSW6.0.0beta
Steps to Reproduce:
Assigning to Steve. SQLServer is not a supported DB for the beta release but this will be addressed by Final.
We do not see this as a blocker for the release as there is no functional impact to this issue other than saving space.