Bug 780691 (SOA-3139) - Teiid - Teradata queries containing LTRIM and RTRIM on the BQT booleanvalue column are returning unexpected BQT results
Summary: Teiid - Teradata queries containing LTRIM and RTRIM on the BQT booleanvalue c...
Keywords:
Status: CLOSED NEXTRELEASE
Alias: SOA-3139
Product: JBoss Enterprise SOA Platform 5
Classification: JBoss
Component: EDS
Version: 5.2.0 GA
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: ---
: 5.2.0 ER1
Assignee: Van Halbert
QA Contact:
URL: http://jira.jboss.org/jira/browse/SOA...
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2011-06-29 19:10 UTC by Warren Gibson
Modified: 2012-05-18 10:19 UTC (History)
0 users

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2011-10-11 17:12:11 UTC
Type: Bug

Attachments (Terms of Use)
QT_teradata12_Push.vdb (223.49 KB, application/octet-stream)
2011-06-29 19:11 UTC, Warren Gibson 		no flags Details
View All Add an attachment (proposed patch, testcase, etc.)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker SOA-3139 0 None Closed Teiid - Teradata queries containing LTRIM and RTRIM on the BQT booleanvalue column are returning unexpected BQT results 2012-01-18 22:08:17 UTC
Red Hat Issue Tracker TEIID-1664 0 None Closed Teiid - Teradata queries containing LTRIM and RTRIM on the BQT booleanvalue column are returning unexpected BQT results 2012-05-18 10:19:19 UTC

Description Warren Gibson 2011-06-29 19:10:27 UTC 
project_key: SOA

Teiid - Teradata queries containing LTRIM and RTRIM on the BQT booleanvalue column are returning unexpected results.  The following query should be returning 22 rows but 0 rows are returned. 

SELECT intkey, booleanvalue FROM BQT1.SmallA WHERE LTRIM(BQT1.SmallA.BooleanValue) = 'true' ORDER BY intkey 

However, if the LTRIM is removed like (SELECT intkey, booleanvalue FROM BQT1.SmallA WHERE BQT1.SmallA.BooleanValue = 'true' ORDER BY intkey)  22 rows are returned. 


This should be logged against Teiid 7.4.1

VDB attached.
Comment 1 Warren Gibson 2011-06-29 19:11:39 UTC 
Attachment: Added: QT_teradata12_Push.vdb
Comment 2 Van Halbert 2011-06-29 19:24:39 UTC 
Link: Added: This issue Cloned to SOA-3140
Comment 4 David Le Sage 2011-08-31 05:29:39 UTC 
Release Notes Docs Status: Added: Not Required
Writer: Added: dlesage
Comment 5 Warren Gibson 2011-10-11 17:12:11 UTC 
10/11/2011 Passed
Comment 6 JBoss JIRA Server 2012-05-18 10:19:19 UTC 
Steven Hawkins <shawkins> updated the status of jira TEIID-1664 to Closed
Note You need to log in before you can comment on or make changes to this bug.