-
Type:
Bug
-
Status: Resolved (View Workflow)
-
Priority:
Major
-
Resolution: Done
-
Affects Version/s: 8.12.14.6_4
-
Fix Version/s: 11.0, 10.3.2, 10.2.3, 8.12.14.6_4
-
Component/s: JDBC Connector
-
Labels:None
-
Bugzilla References:
-
Bugzilla Update:Perform
Table on SQL Server source created as
CREATE TABLE table_with_variant(id INT, var SQL_VARIANT) |
and loaded with int, float and string data.
Running the following query against a dynamic VDB with metadata import
SELECT cast(var AS string) FROM table_with_variant WHERE id = 1 |
fails with
java.sql.SQLException: Remote com.microsoft.sqlserver.jdbc.SQLServerException: The "variant" data type is not supported.
|
This query used to work with DV 6.4.2, it appears it is a further regression from TEIID-5313 . Querying rows with non-string data works as expected.
SOURCE SRC command with 6.4.2 (working):
SELECT cast(g_0."var" AS varchar(4000)) FROM "dballo05"."dbo"."table_with_variant" g_0 WHERE g_0."id" = 1 |
SOURCE SRC command with 6.4.3 (not working), note missing cast to varchar:
SELECT g_0."var" FROM "dballo06"."dbo"."table_with_variant" g_0 WHERE g_0."id" = 1 |
