Bug 781003 (SOA-3480)

Summary: It is possible to call stored procedure via Teiid JDBC driver on VDB even though VDB doesn't contain the imported procedure
Product: [JBoss] JBoss Enterprise SOA Platform 5 Reporter: Filip Nguyen <fnguyen>
Component: EDSAssignee: Van Halbert <vhalbert>
Status: CLOSED NOTABUG QA Contact:
Severity: high Docs Contact:
Priority: high    
Version: 5.2.0.ER4   
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
URL: http://jira.jboss.org/jira/browse/SOA-3480
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2011-11-15 17:49:22 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
textDBVDB.vdb none

Description Filip Nguyen 2011-10-12 14:24:52 UTC
project_key: SOA

I use setting same as in SOA-3478. But I deleted the procedure from xmi files in the VDB (attachment) and changed query to: 

{code:title=Teiid Query|borderStyle=solid}
String query = "{ CALL getEmployeeSurnames }";
{code} 

The Query is called and result set is returned.

After conversation with Steven Hawkins I understand that this shouldn't be possible and Teiid should respond that it cannot resolve the query.

Comment 1 Van Halbert 2011-10-12 14:28:34 UTC
Link: Added: This issue Cloned to SOA-3481


Comment 2 Filip Nguyen 2011-10-12 14:28:42 UTC
Attachment: Added: textDBVDB.vdb


Comment 3 Filip Nguyen 2011-10-12 14:30:44 UTC
Link: Added: This issue relates to SOA-3478