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

In SQL Server INSERT ... VALUES clause UUID is not substituted

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 8.10
    • None
    • None
    • None

    Description

      Teiid 8.4, SQL Server 2012 Express

      I'm inserting into table with uniqueidentifier field

      INSERT INTO SOME_TABLE(some_uuid, some_ts)
      VALUES (uuid(), now())
      

      and get something like

      195 Remote org.teiid.translator.jdbc.JDBCExecutionException: 195 TEIID11013:TEIID11004 Error executing statement(s): [Prepared Values: [{ts '2015-02-24 21:02:23.803'}] SQL: INSERT INTO "DS"."dbo"."SOME_TABLE" ("SOME_UUID", "SOME_TS") VALUES (uuid(), ?)]

      However if i use INSERT ... SELECT clause it's substituted normally:

      INSERT INTO SOME_TABLE(some_uuid, some_ts)
      SELECT uuid(), now()
      FROM SOME_OTHER_TABLE
      LIMIT 1
      

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: