[jira] [Created] (CALCITE-905) getTables returns empty result in JdbcMeta

["Jan Van Besien (JIRA)" <ji...@apache.org>]

Jan Van Besien created CALCITE-905:
--------------------------------------

             Summary: getTables returns empty result in JdbcMeta
                 Key: CALCITE-905
                 URL: https://issues.apache.org/jira/browse/CALCITE-905
             Project: Calcite
          Issue Type: Bug
            Reporter: Jan Van Besien
            Assignee: Julian Hyde


getTables on the metadata of a connection does not work (returns empty ResultSet) with avatica remoting using a JdbcMeta.

{code}
connection.getMetaData().getTables(null, null, null, null);
{code}

The problem seems to be related to the String[] types argument of the getTables method, this works as expected:

{code}
connection.getMetaData().getTables(null, null, null, new String[]{"TABLE"});
{code}

I think it boils down to the JdbcMeta#toArray(List<String> typeList) method which returns an empty array in stead of null, resulting in the creation of an incorrect typeFilter in CalciteMetaImpl#getTables (line 254).



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)