[teiid-issues] [JBoss JIRA] Resolved: (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 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