Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-5549

Appropriately set `DATA_TYPE` and `IS_GENERATEDCOLUMN` metadata values for `MEASURE` types

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: In Progress
    • Minor
    • Resolution: Unresolved
    • None
    • None
    • avatica, core

    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.

      Attachments

        Activity

          People

            tjbanghart TJ Banghart
            tjbanghart TJ Banghart
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 1h 50m
                1h 50m