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

SQL Server uniqueidentifier handling

    XMLWordPrintable

Details

    • Quality Risk
    • Resolution: Done
    • Optional
    • 7.0
    • 6.0.0
    • JDBC Connector
    • None
    • Low

    Description

      SQL Server's uniqueidentifier is typically imported as a string, but cannot be used in comparable operations (distinct, order by, group by). Our designer cost analyzer logic already compensated for this, but a more general fix would be to wrap the uniqueidentifier as cast(col as char(36)), which would be safe.

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            rhn-engineering-shawkins Steven Hawkins
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: