[teiid-issues] [JBoss JIRA] (TEIID-4975) Couchbase - SUBSTRING function is not translated correctly

[Steven Hawkins (JIRA)]

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

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


> Couchbase - SUBSTRING function is not translated correctly
> ----------------------------------------------------------
>
>                 Key: TEIID-4975
>                 URL: https://issues.jboss.org/browse/TEIID-4975
>             Project: Teiid
>          Issue Type: Bug
>          Components: Misc. Connectors
>    Affects Versions: 8.12.x-6.4
>            Reporter: Juraj Duráni
>            Assignee: Steven Hawkins
>             Fix For: 10.0, 8.12.x-6.4, 9.3.1
>
>
> Teiid's SQL function SUBSTRING(x,y \[, z\]) is translated to N1QL substring(x,y \[, z\]) function, but correct N1QL function is called SUBSTR.
> Documentation: https://developer.couchbase.com/documentation/server/current/n1ql/n1ql-language-reference/stringfun.html#topic_8_12__fn-str-substr



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)