[JBoss JIRA] (TEIID-2476) Exclude hidden tables/columns from metadata
- First Post
- Replies
- Stats
-
Go to
- ----- 2024 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2023 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2022 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2021 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2020 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2019 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2018 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2017 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2016 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2015 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2014 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2013 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2012 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2011 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2010 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2009 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
[
https://issues.jboss.org/browse/TEIID-2476?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-2476:
---------------------------------------
I know that is separate from this issue, but I can log that.
If you hide the system tables, then DatabaseMetaData, ODBC metadata (which is needed even
for just query execution), and even some geospatial logic won't work. So allowing
them to be hidden would be a somewhat extreme case.
As per this issue, if we implement at DatabaseMetadata does't
that differ with System metadata?
DatabaseMetaData uses queries and some additional logic against the system metadata.
I'm just saying that working this at the DatabaseMetaData layer is simpler. For
consistency we'll have to implement this at the system table level and redo any of the
materialization above.
Exclude hidden tables/columns from metadata
-------------------------------------------
Key: TEIID-2476
URL: https://issues.jboss.org/browse/TEIID-2476
Project: Teiid
Issue Type: Enhancement
Components: JDBC Driver, Query Engine
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 9.0
We should offer or possibly default to filtering tables/columns that can not accessed out
of the user metadata. This should be done on the server side - however given the reuse we
have of the system tables for example for materialized pg catalog queries - it is easier
to add filters to the DatabaseMetadata (and ideally pg) metadata queries.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
3231
days inactive
3231
days old
0 comments
1 participants
tags (0)
participants (1)
-
Steven Hawkins (JIRA)