[teiid-issues] [JBoss JIRA] (TEIID-3793) Push Teiid function LOCATE() to SQL Server

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-3793?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-3793.
-----------------------------------
    Resolution: Done


Added support to SQL Server, but not to sybase as it supports only the two argument form.

> 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.13, 8.12.2
>
>
> 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)