-
Bug
-
Resolution: Duplicate
-
Major
-
None
-
None
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
INSERT INTO TABLE(record_id, "time", tag_id, "value")
VALUES(UUID(), NOW(), '123', 123);}}
Teiid gives me error
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)]