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

Fix multiple DatabaseMetaData.getColumns() bugs (some)

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Blocker
    • Resolution: Fixed
    • None
    • 0.9.0
    • Client - JDBC, Metadata
    • 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

        1. DRILL-2465.1.patch.txt
          152 kB
          Daniel Barclay

        Issue Links

          incorporates

          Bug - A problem which impairs or prevents the functions of the product. DRILL-2450 JDBC : DatabaseMetaData.getColumns is missing the 'COLUMN_SIZE' in the result set

          • Blocker - Blocks development and/or testing work, production could not run
          • Closed
          is blocked by

          Bug - A problem which impairs or prevents the functions of the product. DRILL-2503 Having many WHENs causes ClassReader.accept()/EXPAND_FRAMES error

          • Critical - Crashes, loss of data, severe memory leak.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. DRILL-2439 getBoolean(...) on BOOLEAN column says wrong type

          • Blocker - Blocks development and/or testing work, production could not run
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. DRILL-2461 INFORMATION_SCHEMA's COLUMNS dies when INTERVAL ... column exists

          • Blocker - Blocks development and/or testing work, production could not run
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. DRILL-2463 Implement JDBC mapping of SQL NULL for ResultSet.getXxx() methods

          • Blocker - Blocks development and/or testing work, production could not run
          • Closed
          is part of

          Task - A task that needs to be done. DRILL-2420 [umbrella] Identify, fix DatabaseMetaData.getColumns() bugs

          • Major - Major loss of function.
          • Resolved
          is related to

          Bug - A problem which impairs or prevents the functions of the product. DRILL-2470 [umbrella] Implement SMALLINT and maybe TINYINT

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. DRILL-2519 INFORMATION_SCHEMA.COLUMNS is missing <interval_qualifier> info

          • Major - Major loss of function.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. DRILL-2128 DatabaseMetaData.getColumns()'s DATA_TYPE has wrong type

          • Blocker - Blocks development and/or testing work, production could not run
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. DRILL-2763 [umbrella] Implement INFORMATION_SCHEMA.COLUMNS enough for relevant tools

          • Major - Major loss of function.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. DRILL-3216 Fix existing(+) INFORMATION_SCHEMA.COLUMNS columns

          • Major - Major loss of function.
          • Resolved

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: