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

Fix multiple DatabaseMetaData.getColumns() bugs (some)

    Details

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

      Description

      Fixed most getColumn() bugs reported in DRILL-2420:

      • Added COLUMN_SIZE (in part to move later columns to right ordinal position). [With workarounds for INFORMATION_SCHEMA.COLUMN bugs.]
      • Fixed DECIMAL_DIGITS (was DECIMAL_PRECISION; didn't report values for numeric types other than DECIMAL).
      • Fixed NUM_PREC_RADIX (was -1 for cases that should be NULL).
      • Fixed REMARKS (from '' to NULL).
      • Fixed COLUMN_DEF (from '' to NULL).
      • Fixed CHARACTER_OCTET_LENGTH (was 4). [With workarounds for (possible) INFORMATION_SCHEMA.COLUMN bugs.]
      • Fixed ORDINAL_POSITION (was returning 1 for every column).
      • Fixed SCOPE_CATALOG (from '' to NULL).
      • Fixed SCOPE_SCHEMA (from '' to NULL).
      • Fixed SCOPE_TABLE (from '' to NULL).
      • Fixed SOURCE_DATA_TYPE (from VARCHAR to INTEGER.) [With workaround because SMALLINT not implemented yet.]

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                dsbos Daniel Barclay
                Reporter:
                dsbos Daniel Barclay
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: