[JBoss JIRA] Created: (TEIID-1750) Memory handling improvements
by Steven Hawkins (JIRA)
Memory handling improvements
----------------------------
Key: TEIID-1750
URL: https://issues.jboss.org/browse/TEIID-1750
Project: Teiid
Issue Type: Quality Risk
Components: Query Engine
Affects Versions: 7.0
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 7.6
The buffermanager will create softreferences for batches that prefer memory, but does not track the memory as held once the value has been passivated.
Also small lobs, such as xml values created via sqlxml, should be inlined into results for greater performance - and so that they can be paged out by the buffermanager rather than being held by a lobmanager.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 4 months
[JBoss JIRA] Created: (TEIID-1656) Add pushdown support for Searched CASE expression over a UNION
by Mark Drilling (JIRA)
Add pushdown support for Searched CASE expression over a UNION
--------------------------------------------------------------
Key: TEIID-1656
URL: https://issues.jboss.org/browse/TEIID-1656
Project: Teiid
Issue Type: Enhancement
Components: Query Engine, Server
Affects Versions: 7.4, 7.1.1
Reporter: Mark Drilling
Assignee: Steven Hawkins
Fix For: 7.4.1
1) User has created a view MyView containing UNION all of two other views, eg "SELECT * FROM View1 UNION ALL SELECT * FROM View 2".
2) Then a user query containing a searched CASE type expression is submitted against the view, eg "SELECT CASE WHEN StringNum IS NULL THEN 0 ELSE 1 END FROM MyView"
3) With current planner the CASE expression is not pushed down to the individual sources. The enhancement request is to allow the pushdown.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 5 months