[teiid-issues] [JBoss JIRA] (TEIID-2181) SYS queries should filter by schema/table

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-2181?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

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