Bug 1214445 (TEIID-3451)

Summary:	OData does not inject schema into queries
Product:	[JBoss] JBoss Data Virtualization 6	Reporter:	dsteigne
Component:	Teiid	Assignee:	jolee
Status:	CLOSED CURRENTRELEASE	QA Contact:	Juraj Duráni <jdurani>
Severity:	high	Docs Contact:
Priority:	high
Version:	6.1.0	CC:	aszczucz, drieden, felias, jdurani, jolee, jstastny, vhalbert
Target Milestone:	---	Keywords:	QA-Closed
Target Release:	One-off release
Hardware:	All
OS:	All
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:
Clones:	1215675 (view as bug list)		Environment:
Last Closed:	2016-02-10 08:49:48 UTC	Type:	Support Patch
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:
Bug Depends On:
Bug Blocks:	1213582

Description dsteigne 2015-04-22 17:54:13 UTC

Description of problem:
The DV 6.1.0 OData service does not inject a fully qualified object names for tables for  POSTS, PUTs, and DELETEs:

12:50:34,367 DEBUG [org.teiid.COMMAND_LOG] (http-localhost/127.0.0.1:8080-1)    START USER COMMAND:     startTime=2015-04-22 12:50:34.367       requestID=XxHTbednhDq7.0        txID=null       sessionID=XxHTbednhDq7  applicationName=JDBC    principal=teiidUser@teiid-security      vdbName=ImsOne   vdbVersion=2    sql=INSERT INTO Subscription (SUBSCRIPTION_ID, CLIENT_NAME, DEST_CONNECTION_URI, DEST_SCHEMA_NAME, DEST_TABLE_NAME, PROVIDER_URL, TOPIC_NAME) VALUES (?, ?, ?, ?, ?, ?, ?)
12:50:34,380 DEBUG [org.teiid.COMMAND_LOG] (http-localhost/127.0.0.1:8080-1)    ERROR USER COMMAND:     endTime=2015-04-22 12:50:34.379 requestID=XxHTbednhDq7.0        txID=null       sessionID=XxHTbednhDq7  principal=teiidUser@teiid-security      vdbName=ImsOne  vdbVersion=2    finalRowCount=null
12:50:34,380 WARN  [org.teiid.PROCESSOR] (http-localhost/127.0.0.1:8080-1) TEIID30020 Processing exception for request XxHTbednhDq7.0 'Group specified is ambiguous, resubmit the query by fully qualifying the group name: Subscription'. Originally QueryResolverException ResolverUtil.java:814. Enable more detailed logging to see the entire stacktrace.
12:50:34,383 WARN  [org.teiid.ODATA] (http-localhost/127.0.0.1:8080-1) TEIID16012 Could not produce a successful OData response.  Returning status ServerErrorException with message Group specified is ambiguous, resubmit the query by fully qualifying the group name: Subscription.

Same insert works fine over JDBC.  Offending line from 8.7.0 public github:

https://github.com/teiid/teiid/blob/8.7.x/odata/src/main/java/org/teiid/odata/ODataSQLBuilder.java#L969

Note that private Table findTable() on line 925 depends upon org.odata4j.core.EdmEntitySet#getName to return the name, but this is not fully qualified

Version-Release number of selected component (if applicable):
6.1

How reproducible:


Steps to Reproduce:
1.
2.
3.

Actual results:


Expected results:


Additional info:


Document URL: 

Section Number and Name: 

Describe the issue: 

Suggestions for improvement: 

Additional information:

Comment 3 jolee 2015-05-19 15:34:34 UTC

integration	git:jboss-integration/teiid.git 
upstream	git:teiid/teiid.git

[jolee@jolee540 teiid]$ git push upstream TEIID-3451:8.7.x 
Counting objects: 40, done.
Delta compression using up to 8 threads.
Compressing objects: 100% (27/27), done.
Writing objects: 100% (40/40), 3.86 KiB | 0 bytes/s, done.
Total 40 (delta 15), reused 7 (delta 0)
To git:teiid/teiid.git
   f31e342..73f2c71  TEIID-3451 -> 8.7.x

[jolee@jolee540 teiid]$ git push integration TEIID-3451:8.7.x-prod-ipv6.1 
Counting objects: 40, done.
Delta compression using up to 8 threads.
Compressing objects: 100% (27/27), done.
Writing objects: 100% (40/40), 4.08 KiB | 0 bytes/s, done.
Total 40 (delta 15), reused 7 (delta 0)
To git:jboss-integration/teiid.git
   f31e342..73f2c71  TEIID-3451 -> 8.7.x-prod-ipv6.1

Comment 4 JBoss JIRA Server 2015-06-22 15:22:57 UTC

Steven Hawkins <shawkins> updated the status of jira TEIID-3451 to Closed