[
https://issues.jboss.org/browse/TEIID-1963?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration commented on TEIID-1963:
------------------------------------------------
Van Halbert <vhalbert(a)redhat.com> made a comment on [bug
799620|https://bugzilla.redhat.com/show_bug.cgi?id=799620]
Per project:
The numeric issue is dependent upon the table data and is not a general issue with the SQL
generated. The other issues have to do with the implicit string conversion form of numeric
values. We already KI that the string format of implicit/explicitly converted numeric
values is db dependent, so this is not completely unexpected. Moving into the open to
community bucket if an ingres user wishes to address. Note that all of the failing BQT
queries shown in the attachment are rather contrived and unlikely to be issued directly by
a user.
--------
This issue is going to be flagged as WONT FIX since Teiid is not considering fixing this
issue unless someone in the community decides they need it. If someone in Red Hat
decides they really need the fix, please reopen this.
EDS Ingres10 as Source - LPAD, RIGHT, UPPER and ABS queries returning
unexpected results
----------------------------------------------------------------------------------------
Key: TEIID-1963
URL:
https://issues.jboss.org/browse/TEIID-1963
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.1.1
Reporter: Warren Gibson
Priority: Optional
Fix For: Open To Community
Attachments: Ingres_LPAD_ABS_RIGHT_UPPER.ods
EDS query testing using Ingres 10 as the source is returning unexpected query
results for 4 queries involving the LPAD, RIGHT, UPPER, and ABS function.
Spreadsheet is attached showing the queries involved and the query results.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see:
http://www.atlassian.com/software/jira