[teiid-issues] [JBoss JIRA] (TEIID-5457) Issues with sybase/ms sql pad pushdown

[Steven Hawkins (JIRA)]

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

Steven Hawkins resolved TEIID-5457.
-----------------------------------
    Fix Version/s: 10.3.4
                   11.0.2
       Resolution: Done


Corrected the pushdown to account for null values and use the left function to appropriately trim when the pad length is shorter than the string.

> Issues with sybase/ms sql pad pushdown
> --------------------------------------
>
>                 Key: TEIID-5457
>                 URL: https://issues.jboss.org/browse/TEIID-5457
>             Project: Teiid
>          Issue Type: Bug
>          Components: JDBC Connector
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 11.1, 10.3.4, 11.0.2
>
>
> Sybase will return a non-null result then padding a null string.
> Sybase and ms sql will trim from the string from the left when lpad is specified with a pad length shorter than the string.  The expected behavior is to always trim from the right.



--
This message was sent by Atlassian JIRA
(v7.5.0#75005)