[CALCITE-522] In remote JDBC driver, transmit static database properties as a map

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.3.0-incubating
• Component/s: avatica
• Assignee: Julian Hyde
• Reporter: Julian Hyde
• Created: 10/Dec/14 22:57
• Updated: 21/Jan/16 22:15
• Resolved: 21/Oct/15 18:08

Description

A lot of DatabaseMetaData methods are not parameterized, and give the same answer every time. Some examples:

• allProceduresAreCallable
• getUserName
• isReadOnly
• getDatabaseProductName
• getDatabaseProductVersion
• getDriverName
• getDriverVersion
• getDriverMajorVersion
• getDriverMinorVersion
• getSqlKeywords
• getNumericFunctions
• getStringFunctions
• getSystemFunctions
• getTimeDateFunctions

This task would define an enum of properties, add a method to Meta that returns (property, value) map.

See DatabaseMetaData and Connection for the full list.

Obsolete the following Meta methods:

• getSqlKeywords
• getNumericFunctions
• getStringFunctions
• getSystemFunctions
• getTimeDateFunctions

Issue Links

• is related to: CALCITE-94 Remote JDBC driver
• is superceded by: CALCITE-701 Add remaining DatabaseMetaData methods to enum DatabaseProperty
• relates to: CALCITE-521 Implement metadata requests in remote JDBC driver