[teiid-issues] [JBoss JIRA] (TEIID-3335) Uniqueidentifier values are casted inside INSERT clause field list
Steven Hawkins (JIRA)
issues at jboss.org
Fri Feb 13 07:46:49 EST 2015
[ https://issues.jboss.org/browse/TEIID-3335?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Steven Hawkins resolved TEIID-3335.
-----------------------------------
Fix Version/s: (was: 8.10)
Resolution: Duplicate Issue
This is a duplicate of TEIID-3161
So it would need the 8.9 server, not just the driver.
> 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)]
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
More information about the teiid-issues
mailing list