Details
-
Improvement
-
Status: In Progress
-
Minor
-
Resolution: Unresolved
-
None
-
None
Description
MEASURE types (introduced in CALCITE-5105) currently present themselves as java.sql.Types#OTHER (1111)(ref) It would be advantageous to surface the underlying data type of the MEASURE rather than catch all OTHER since the underlying data type is returned in result sets.
For example a MEASURE<INTEGER> (a measure of type integer) would appear as java.sql.Types#INTEGER (4).
We should also set the IS_GENERATEDCOLUMN metadata value with this change. All MEASURE types would populate the column with "YES" otherwise "NO".
Here's where the JDBC type gets set in CalciteMetaImpl.
For IS_GENERATEDCOLUMN we will need a change to the MetaColumn constructor in Avatica that will allow us to set this value.