[jira] [Commented] (CALCITE-4969) Can't retrieve metadata for tables in sub-schemas

["Gunnar Morling (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CALCITE-4969?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17466372#comment-17466372 ] 

Gunnar Morling commented on CALCITE-4969:
-----------------------------------------

The sub-schema tables are also not showing up for {{!tables}} in SQLLine (though again, I can query them just fine). Interestingly, tables from the "metadata" schema do show up, perhaps that's handled in some special way?

{code}
0: jdbc:calcite:schemaFactory=org.moditect.jf> !tables
+-----------+-------------+------------+--------------+---------+----------+------------+-----------+---------------------------+----------------+
| TABLE_CAT | TABLE_SCHEM | TABLE_NAME |  TABLE_TYPE  | REMARKS | TYPE_CAT | TYPE_SCHEM | TYPE_NAME | SELF_REFERENCING_COL_NAME | REF_GENERATION |
+-----------+-------------+------------+--------------+---------+----------+------------+-----------+---------------------------+----------------+
|           | metadata    | COLUMNS    | SYSTEM TABLE |         |          |            |           |                           |                |
|           | metadata    | TABLES     | SYSTEM TABLE |         |          |            |           |                           |                |
+-----------+-------------+------------+--------------+---------+----------+------------+-----------+---------------------------+----------------+
{code}

> Can't retrieve metadata for tables in sub-schemas
> -------------------------------------------------
>
>                 Key: CALCITE-4969
>                 URL: https://issues.apache.org/jira/browse/CALCITE-4969
>             Project: Calcite
>          Issue Type: Bug
>    Affects Versions: 1.28.0
>            Reporter: Gunnar Morling
>            Priority: Major
>
> I have created a custom Calcite schema factory which produces a parent schema, which in turn contains multiple sub-schemas. I can query those tables as intended, e.g. SELECT * FROM schemaname.tablename.
> Metadata retrieval for these tables via JDBC fails though; the following doesn't return any subschema tables (note how the schema filter is null):
> {code}
> DatabaseMetaData md = connection.getMetaData();
> ResultSet rs = md.getTables(null, null, "%", null));
> {code}
> [Reported|https://mail-archives.apache.org/mod_mbox/calcite-dev/202112.mbox/%3CCADGJaX9jN8BN_C%2BZswcDspfFYdWZ5p%3DxNey4ho1QZwpjFtAehw%40mail.gmail.com%3E] on the mailing list initially.



--
This message was sent by Atlassian Jira
(v8.20.1#820001)