[teiid-issues] [JBoss JIRA] (TEIID-3793) Push Teiid function LOCATE() to SQL Server
Steven Hawkins (JIRA)
issues at jboss.org
Wed Jan 27 16:26:04 EST 2016
[ https://issues.jboss.org/browse/TEIID-3793?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Steven Hawkins closed TEIID-3793.
---------------------------------
> 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).
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
More information about the teiid-issues
mailing list