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

[Steven Hawkins (JIRA)]

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

Steven Hawkins resolved TEIID-728.
----------------------------------

    Resolution: Done


Changed the trim logic to apply an rtrim to all columns marked with a native type of char or nchar and a return type of string.  There are many instances where this is unnecessary, but the solution is always consistent with Teiid (i.e. evaluating the length function, etc.).

> Pushing blank-padded literals to source may fail to return correct results
> --------------------------------------------------------------------------
>
>                 Key: TEIID-728
>                 URL: https://jira.jboss.org/jira/browse/TEIID-728
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 6.2.0
>         Environment: fedora 10, JDK 1.6, Teiid from 7/16/2009
>            Reporter: Paul Nittel
>            Assignee: Steven Hawkins
>             Fix For: 6.3
>
>
> While reviewing possible CTC errors, it was noticed that SPACE(n) was not returning the number of spaces specified. We did see that going directly to Oracle worked correctly. Steve H. believes Oracle is returning a CHAR type and Teiid is trimming the values as a result. (It would not have if the return type was VARCHAR, like SQL Server returns.)

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