Bug 996550 - Sybase15 subquery using HAVING clause failing
Summary: Sybase15 subquery using HAVING clause failing
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: JBoss Data Virtualization 6
Classification: JBoss
Component: Documentation
Version: 6.0.0
Hardware: Unspecified
OS: Unspecified
unspecified
high
Target Milestone: ER1
: 6.0
Assignee: David Le Sage
QA Contact: wgibson
URL:
Whiteboard:
Depends On: 912548
Blocks:
TreeView+ depends on / blocked
 
Reported: 2013-08-13 12:28 UTC by Van Halbert
Modified: 2014-06-18 08:27 UTC (History)
6 users (show)

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.
Clone Of: 912548
Environment:
Last Closed: 2014-02-04 01:48:04 UTC
Type: Bug
Embargoed:

Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker TEIID-2458 0 Major Closed Sybase15 subquery using HAVING clause failing 2018-02-01 00:33:49 UTC

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 7 belong 2013-12-11 01:14:50 UTC 
Added to Release Notes.

URL: http://documentation-devel.engineering.redhat.com/docs/en-US/Red_Hat_JBoss_Data_Virtualization/6/html/Release_Notes/chap-Issues.html#Other_Issues
Comment 8 JBoss JIRA Server 2014-04-23 11:33:57 UTC 
Steven Hawkins <shawkins> updated the status of jira TEIID-2458 to Closed
Note You need to log in before you can comment on or make changes to this bug.