[teiid-issues] [JBoss JIRA] (TEIID-5457) Issues with sybase/ms sql pad pushdown
[
https://issues.jboss.org/browse/TEIID-5457?page=com.atlassian.jira.plugin...
]
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)