Bug 1025738 - DTGov/RTGov generates wrong column type for uuids with SQL Server
Summary: DTGov/RTGov generates wrong column type for uuids with SQL Server
Keywords:
Status: ASSIGNED
Alias: None
Product: JBoss Fuse Service Works 6
Classification: JBoss
Component: DT Governance
Version: 6.0.0
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: ---
: FUTURE
Assignee: Steve Johnson
QA Contact: Matej Melko
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2013-11-01 12:14 UTC by Michael Burman
Modified: 2023-05-15 19:52 UTC (History)
2 users (show)

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.
Clone Of:
Environment:
Last Closed:
Type: Bug
Embargoed:

Attachments (Terms of Use)

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.
Note You need to log in before you can comment on or make changes to this bug.