]
Nicholas D commented on TEIID-3335:
-----------------------------------
Do i have any options if i'm stuck with 8.4 version? Will changing driver help?
Uniqueidentifier values are casted inside INSERT clause field list
------------------------------------------------------------------
Key: TEIID-3335
URL:
https://issues.jboss.org/browse/TEIID-3335
Project: Teiid
Issue Type: Bug
Components: JDBC Connector
Reporter: Nicholas D
Assignee: Steven Hawkins
Labels: sqlserver2012
When inserting into SQL Server table which has uniqueidentifier values - Teiid casts
these fields to char(36) inside field list.
Example. When i execute query
bq. INSERT INTO TABLE(record_id, "time", tag_id, "value")
VALUES(UUID(), NOW(), '123', 123);}}
Teiid gives me error
bq. Error: TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 ds: 102
TEIID11013:TEIID11004 Error executing statement(s): [Prepared Values: [{ts '2015-02-12
15:40:18.051'}] SQL: INSERT INTO "dbo"."TABLE"
(cast("RECORD_ID" as char(36)), "TIME", "TAG_ID",
"VALUE") VALUES (uuid(), ?, '123', 123)]