[jira] [Created] (DRILL-2721) Identify, fix _existing_ INFO._SCHEMA columns in conflict with SQL spec. by 1.0

["Daniel Barclay (Drill) (JIRA)" <ji...@apache.org>]

Daniel Barclay (Drill) created DRILL-2721:
---------------------------------------------

             Summary: Identify, fix _existing_ INFO._SCHEMA columns in conflict with SQL spec. by 1.0
                 Key: DRILL-2721
                 URL: https://issues.apache.org/jira/browse/DRILL-2721
             Project: Apache Drill
          Issue Type: Bug
          Components: Metadata
            Reporter: Daniel Barclay (Drill)
            Assignee: Daniel Barclay (Drill)


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
)





--
This message was sent by Atlassian JIRA
(v6.3.4#6332)