Bug 780981 (SOA-3452)

Summary: EDS Ingres as source - Query with LOCATE causing stackoverflow error
Product: [JBoss] JBoss Enterprise SOA Platform 5 Reporter: Warren Gibson <wgibson>
Component: EDSAssignee: Van Halbert <vhalbert>
Status: CLOSED NEXTRELEASE QA Contact:
Severity: high Docs Contact:
Priority: high    
Version: 5.2.0.ER4   
Target Milestone: ---   
Target Release: 5.2.0.ER5   
Hardware: Unspecified   
OS: Unspecified   
URL: http://jira.jboss.org/jira/browse/SOA-3452
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2011-10-21 14:37:44 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Attachments:
Description Flags
stackoverflow.log
none
QT_Ingres10_Push.vdb none

Description Warren Gibson 2011-10-06 16:52:24 UTC 
project_key: SOA

EDS Query Testing is getting unexpected results on 16 queries involving LOCATE.  A couple examples queries are given below:

SELECT INTKEY, LOCATE(1, STRINGNUM) FROM BQT1.SmallA ORDER BY intkey  (Expected 50 records but received only 0)
Remote org.teiid.core.TeiidProcessingException: Source: null
see stackoverflow.log attached


SELECT INTKEY FROM BQT1.SmallA WHERE LOCATE(1, INTKEY) = 1 ORDER BY INTKEY
Remote org.teiid.core.TeiidProcessingException: Source: null
Is also a stackoverflow error.
Comment 1 Warren Gibson 2011-10-06 16:54:10 UTC 
Attachment: Added: stackoverflow.log
Comment 2 Warren Gibson 2011-10-06 16:54:59 UTC 
Attachment: Added: QT_Ingres10_Push.vdb
Comment 3 Van Halbert 2011-10-06 17:09:41 UTC 
Link: Added: This issue Cloned to SOA-3455
Comment 5 Warren Gibson 2011-10-21 14:37:44 UTC 
10/21/2011 - Tested ok.