[teiid-issues] [JBoss JIRA] (TEIID-4893) Inconsistent behavior of SUBSTRING function

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-4893?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13403164#comment-13403164 ] 

Steven Hawkins commented on TEIID-4893:
---------------------------------------

Yes, the current function modifier just translates into substring(val from x [, for y]).  It's possible to update that into a case statement instead that handles the 0 and negative cases as well.

> Inconsistent behavior of SUBSTRING function
> -------------------------------------------
>
>                 Key: TEIID-4893
>                 URL: https://issues.jboss.org/browse/TEIID-4893
>             Project: Teiid
>          Issue Type: Bug
>          Components: JDBC Connector
>    Affects Versions: 9.0.3
>         Environment: teiid-9.0.3 on WildFly Full 9.0.2.Final (WildFly Core 1.0.2.Final)
>            Reporter: dalex dalex
>            Assignee: Steven Hawkins
>            Priority: Critical
>
> There is inconsistent behavior of SUBSTRING function in teiid and data sources.



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