[teiid-issues] [JBoss JIRA] (TEIID-3335) Uniqueidentifier values are casted inside INSERT clause field list

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)]