Bug 1025738

Summary:	DTGov/RTGov generates wrong column type for uuids with SQL Server
Product:	[JBoss] JBoss Fuse Service Works 6	Reporter:	Michael Burman <yak>
Component:	DT Governance	Assignee:	Steve Johnson <stejohns>
Status:	ASSIGNED ---	QA Contact:	Matej Melko <mmelko>
Severity:	unspecified	Docs Contact:
Priority:	unspecified
Version:	6.0.0	CC:	ldimaggi, soa-p-jira
Target Milestone:	---
Target Release:	FUTURE
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:	Design-Time Governance and Run-Time Governance generate incorrect column type for uuids in the database tables. It generates varchar instead of uniqueidentifier data type. This causes extra space usage by the varchar type, however has no functional impact.	Story Points:	---
Clone Of:		Environment:
Last Closed:		Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

Description Michael Burman 2013-11-01 12:14:37 UTC

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


How reproducible:


Steps to Reproduce:
1.
2.
3.

Actual results:


Expected results:


Additional info:

Comment 2 kconner 2013-11-01 14:57:08 UTC

Assigning to Steve.  SQLServer is not a supported DB for the beta release but this will be addressed by Final.

Comment 3 kconner 2013-11-13 18:13:25 UTC

We do not see this as a blocker for the release as there is no functional impact to this issue other than saving space.