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

[Steve Hawkins (JIRA)]

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

Steve Hawkins closed TEIID-728.
-------------------------------



> Pushing blank-padded literals to source may fail to return correct results
> --------------------------------------------------------------------------
>
>                 Key: TEIID-728
>                 URL: https://jira.jboss.org/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: 7.0
>
>
> 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/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira