[teiid-issues] [JBoss JIRA] (TEIID-2181) SYS queries should filter by schema/table
[
https://issues.jboss.org/browse/TEIID-2181?page=com.atlassian.jira.plugin...
]
Steven Hawkins resolved TEIID-2181.
-----------------------------------
Resolution: Done
Allowed the sys tables to support criteria necessary for index lookup and expanded the
temp table index logic to cover system tables as well. This also streams the results
better so that we don't create the full result ArrayLists in memory.
The OID logic was moved off of the system tables and into pg/compositemetadatastore
concerns. So we'll still assign consistent oids, we just won't return them with
the system queries - since that would be an unnecessary map lookup as most of the time
(via DatabaseMetadata queries) the oid column isn't requested.
Added a release note / doc update about the change in system table oids.
SYS queries should filter by schema/table
-----------------------------------------
Key: TEIID-2181
URL: https://issues.jboss.org/browse/TEIID-2181
Project: Teiid
Issue Type: Enhancement
Components: Query Engine
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 8.2
The tables returned by datatiermanagerimpl are returned in full for each request
generating a lot of tuple garbage. It would be better to allow filtering (ideally using
schema/table name lookups) as we build the result.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira