[CALCITE-701] Add remaining DatabaseMetaData methods to enum DatabaseProperty

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Labels: newbie
• Assignee: Unassigned
• Reporter: Julian Hyde
• Created: 26/Apr/15 01:07
• Updated: 22/Feb/19 01:22

Description

In CALCITE-522, we added a mechanism where constant database properties – that is, methods of DatabaseMetaData that take 0 arguments and return the same value for all connections – are transmitted once, in a map.

We need to convert the remaining methods.

1. Add a constant to enum Meta.DatabaseProperty for each such method. Its default value should probably be the value currently returned by the method in AvaticaDatabaseMetaData.

2. Change the AvaticaDatabaseMetaData method to read the value, similar to getDefaultTransactionIsolation.

3. If necessary (i.e. Calcite's value is not the default) change CalciteMetaImpl.addProperty, as for GET_NUMERIC_FUNCTIONS.

Issue Links

• supercedes: CALCITE-522 In remote JDBC driver, transmit static database properties as a map