[CALCITE-905] getTables returns empty result in JdbcMeta

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.5.0
• Assignee: Julian Hyde
• Reporter: Jan Van Besien
• Created: 30/Sep/15 09:00
• Updated: 27/Feb/24 22:24
• Resolved: 07/Oct/15 23:25

Description

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

connection.getMetaData().getTables(null, null, null, null);

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

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

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).