Title:
Bug 83590:(Watson Migration Closure)The SQL Server 2008 hierarchyid datatype is not supported by the current driver
| View in TrackerStatus/Resolution/Reason: Closed/Deferred/
Reporter/Name(from Bugbase): marc esher / marc esher (marcesher)
Created: 07/14/2010
Versions: 9.0.1
Failure Type: Unspecified
Found In Build/Fixed In Build: 0000 /
Priority/Frequency: Major / Unknown
Locale/System: English / Platforms All
Vote Count: 3
Problem:
The SQL Server 2008 hierarchyid datatype is not supported by the current driver. This causes an queries that return a column of type hierarchyid to fail
Method:
1) in sql server 2008, create a table with a hierarchyid/****** Object: Table [dbo].[HierarchyIDBug] Script Date: 07/14/2010 08:58:49 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[HierarchyIDBug]([node] [hierarchyid] NOT NULL,[name] [varchar](50) NOT NULL) ON [PRIMARY]GOSET ANSI_PADDING OFFGO2) in a cfquery, run a query against it: select * from hierarchyidbug
Result:
Error Executing Database Query.[Macromedia][SQLServer JDBC Driver]Data type not supported: Unknown: 0xf0
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 3041769
External Customer Info:
External Company:
External Customer Name: marc esher
External Customer Email: 70390EBF47F01CAF992015B9
External Test Config: 07/14/2010Attachments:
Comments: