Bug 1316503 - OData - request is not traslated to valid SQL
Summary: OData - request is not traslated to valid SQL
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: JBoss Data Virtualization 6
Classification: JBoss
Component: Teiid
Version: 6.3.0
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: ER2
: 6.3.0
Assignee: Van Halbert
QA Contact: Juraj Duráni
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2016-03-10 11:20 UTC by Juraj Duráni
Modified: 2016-08-24 11:47 UTC (History)
6 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2016-08-24 11:47:42 UTC
Type: Bug
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker TEIID-4061 0 Major Closed OData - request is not traslated to valid SQL 2016-06-15 12:35:11 UTC

Description Juraj Duráni 2016-03-10 11:20:36 UTC
Description of problem:
*URL:* http://localhost:8080/odata4/olingo_basic/Source/Customers/?$filter=Orders_FK0/$count%20lt%202
*Result:* TEIID31118 Element "g30.customerid" is not defined by any relevant group.
*SQL:*
SELECT g30.idcust, g30.name FROM Source.Customers AS g30 WHERE (SELECT COUNT(*) FROM Source.Orders AS g31 WHERE g30.customerid = g31.idcust) < ? ORDER BY g30.idcust
*Correct SQL:*
SELECT g30.idcust, g30.name FROM Source.Customers AS g30 WHERE (SELECT COUNT(*) FROM Source.Orders AS g31 WHERE g30.idcust = g31.customerid) < ? ORDER BY g30.idcust

Comment 1 JBoss JIRA Server 2016-03-14 20:16:56 UTC
Ramesh Reddy <rareddy> updated the status of jira TEIID-4061 to Coding In Progress

Comment 2 JBoss JIRA Server 2016-03-17 15:48:02 UTC
Ramesh Reddy <rareddy> updated the status of jira TEIID-4061 to Resolved

Comment 3 Juraj Duráni 2016-06-15 07:31:00 UTC
Verified. Teiid returns correct result.

Comment 4 JBoss JIRA Server 2016-06-15 12:35:11 UTC
Steven Hawkins <shawkins> updated the status of jira TEIID-4061 to Closed


Note You need to log in before you can comment on or make changes to this bug.