Bug 780961 (SOA-3430)

Summary: EDS ODBC query on a namespace ending in 'e' fails
Product: [JBoss] JBoss Enterprise SOA Platform 5 Reporter: dsteigne
Component: EDSAssignee: Van Halbert <vhalbert>
Status: CLOSED WONTFIX QA Contact:
Severity: high Docs Contact:
Priority: high    
Version: 5.1.0 GA   
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
URL: http://jira.jboss.org/jira/browse/SOA-3430
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2011-10-03 20:23:48 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
Testing.vdb none

Description dsteigne 2011-10-03 14:12:00 UTC 
Help Desk Ticket Reference: https://c.na7.visual.force.com/apex/Case_View?id=500A0000008RaPH
Workaround Description: You can use LIKE 'select nspname from pg_catalog.pg_namespace where nspname LIKE 'LOOKHERE%'

project_key: SOA

The attached testing vdb contains the following namespaces:
LOOKHERE                                                                                                                                                   TestPG                                                                                                                                                      LOOKAGAIN 

If you run the following query via ODBC (JDBC works ):
select nspname from pg_catalog.pg_namespace where nspname = 'LOOKHERE'

It returns zero rows, but if you run the same query with 'LOOKAGAIN' in your criteria you get the one row,  It seems that any namespace ending in an E doesn't match via ODBC.
Comment 1 Van Halbert 2011-10-03 15:42:28 UTC 
Link: Added: This issue Cloned to SOA-3432
Comment 2 dsteigne 2011-10-03 15:53:12 UTC 
Attachment: Added: Testing.vdb