[teiid-issues] [JBoss JIRA] Commented: (TEIID-728) Pushing blank-padded literals to source may fail to return correct results

[ https://jira.jboss.org/jira/browse/TEIID-728?page=com.atlassian.jira.plug... ] Steven Hawkins commented on TEIID-728: -------------------------------------- This is not a regression and is actually a problematic issue. We are currently trimming strings based upon the resultset metadata type being CHAR. More than just Oracle reports the return type of a selected string literal as CHAR (DB2/Derby). We can do a better job about not pushing select literals, but some situations (for example pushed unions) are unavoidable. The best approach at the connector level is probably to check for a native type of CHAR and to wrap the column in an rtrim. Regardless pushing a string literal with end spaces with trim strings as a connector binding setting turned on will truncate them. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira