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

[Nicholas D (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-3335?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13040038#comment-13040038 ] 

Nicholas D commented on TEIID-3335:
-----------------------------------

Hello,
Teiid 8.4.0 Final. Tried this query with 8.8.1 driver from Squirrel and with 8.9.1 from DBeaver so i don't think it's editor's fault.

Tried it with both dynamic and non-dynamic VDB.
In dynamic VDB this is the model:

<model name="ds">
  <source connection-jndi-name="ds" name="ds" translator-name="sqlserver"/>
</model>

Please tell me if you can't reproduce the issue or i'm doing anything wrong.

> 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
>             Fix For: 8.10
>
>
> 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)]



--
This message was sent by Atlassian JIRA
(v6.3.11#6341)