[teiid-issues] [JBoss JIRA] Closed: (TEIID-880) SQL Server uniqueidentifier handling

SQL Server uniqueidentifier handling ------------------------------------ Key: TEIID-880 URL: https://jira.jboss.org/browse/TEIID-880 Project: Teiid Issue Type: Quality Risk Components: JDBC Connector Affects Versions: 6.0.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Optional Fix For: 7.0 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.