Bug 996550

Summary: Sybase15 subquery using HAVING clause failing
Product: [JBoss] JBoss Data Virtualization 6 Reporter: Van Halbert <vhalbert>
Component: DocumentationAssignee: David Le Sage <dlesage>
Status: CLOSED CURRENTRELEASE QA Contact: wgibson
Severity: high Docs Contact:
Priority: unspecified    
Version: 6.0.0CC: atangrin, fnguyen, ldimaggi, mharvey, vhalbert, wgibson
Target Milestone: ER1Keywords: Documentation
Target Release: 6.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Known Issue
Doc Text:
In SYBASE 15, if a query is submitted with a subquery that contains the HAVING clause, it will fail. You can workaround this by using a custom translator to set supportsOnlyCorrelatedSubqueries to true, which will disable a non-correlated subquery pushdown such as this. However similar issues may still exist with other subqueries.
Story Points: ---
Clone Of: 912548 Environment:
Last Closed: 2014-02-04 01:48:04 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:
Embargoed:
Bug Depends On: 912548    
Bug Blocks:    

Comment 1 belong 2013-09-18 00:34:06 UTC
Are we able to remove this bug from the Private group?

Comment 6 belong 2013-12-10 04:16:52 UTC
Documented in Release Notes as 'other issue'.

Comment 8 JBoss JIRA Server 2014-04-23 11:33:57 UTC
Steven Hawkins <shawkins> updated the status of jira TEIID-2458 to Closed