Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-3335

Uniqueidentifier values are casted inside INSERT clause field list

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Major Major
    • None
    • None
    • JDBC Connector

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

              rhn-engineering-shawkins Steven Hawkins
              kallyamb Nikolay Durygin (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: