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

Identify, fix _existing_ INFO._SCHEMA columns in conflict with SQL spec. by 1.0

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.2.0
    • Component/s: Metadata
    • Labels:
      None

      Description

      Much of the INFORMATION_SCHEMA.COLUMNS table doesn't follow the SQL specification.

      Most cases are columns that simply aren't implemented yet, because they are of lower priority, probably because they won't be useful in Drill.

      However, some columns that already exist conflict with what the SQL specification specifies for them. (For example, non-applicable precision values are represented as -1 rather than NULL.)

      Those existing columns should probably be corrected before GA/version 1.0, so that users don't start depending on invalid values, which will make it harder to correct things later).

      TBD: enumeration of specific problems/corrections
      (rough notes of current awareness:

      • some -1 should be NULL
      • some -1/NULL for numeric precision should be 0
      • floating-point numeric precision should be in bits, not digits
      • it might be that type names should be canonical names, not syntactic-shortcut names (e.g., "VARCHAR" -> "CHARACTER_VARYING")
      • character-type length and numeric precision might be wrongly combined into same column
        )

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: