Push Teiid function LOCATE() to SQL Server ------------------------------------------ Key: TEIID-3793 URL: https://issues.jboss.org/browse/TEIID-3793 Project: Teiid Issue Type: Enhancement Components: JDBC Connector Affects Versions: 8.7.1.6_2 Environment: JBOSS DV 6.2 Microsoft SQL Server 10.50.1600.1 Reporter: Jean-Pierre Matsumoto Assignee: Steven Hawkins Fix For: 8.12.2, 8.13 We have some Teiid views with query similar to: SELECT col1 FROM tableA WHERE SUBSTRING(col1, 1, LOCATE(' ', col1)) = 'PREFIX' SQL Server receives a full scan of col1 table without WHERE: SELECT col1 FROM tableA Because Teiid LOCATE() function is not translated to CHARINDEX() SQL Server function (SUBSTRING is translated).