[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:comment-tabpanel&focusedCommentId=13624786#comment-13624786 ] 

Steven Hawkins commented on TEIID-5457:
---------------------------------------

For later AES versions "sql sqlnull on" can be run as an initialization query just like with mysql - http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc00641.1570110/doc/html/car1378941581165.html

> 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
>
>
> 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)