Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-2450

JDBC : DatabaseMetaData.getColumns is missing the 'COLUMN_SIZE' in the result set

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.1.0
    • Component/s: Client - JDBC
    • Labels:
      None

      Description

      git.commit.id.abbrev=e92db23

      DatabaseMetaData.getColumns is missing the 'COLUMN_SIZE' in the result set. This is also screwing up the order in which other fields are returned.

      Below is the column size returned by postgres for different data types. Though its specific to the data, I am just adding it here

      int8 : 19   (this is a bigint column)
      bool:1
      date:13
      float8:17  (this is a double column)
      float8:17 (this is a float column)
      int4 : 10
      time:15
      timestamp : 29
      varchar : 50
      

      Below are few things an analytic tool might use which are currently not working because of this :

      DECIMAL_DIGITS : 9
      NULLABLE : 11
      REMARKS : 12
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                dsbos Daniel Barclay
                Reporter:
                rkins Rahul Challapalli
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: