You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Daniel Barclay (Drill) (JIRA)" <ji...@apache.org> on 2015/05/29 19:58:17 UTC

[jira] [Updated] (DRILL-3216) Fix existing INFORMATION_SCHEMA.COLUMNS columns

     [ https://issues.apache.org/jira/browse/DRILL-3216?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Daniel Barclay (Drill) updated DRILL-3216:
------------------------------------------
    Description: 
[Editing in progress]

Change logical null from -1 to actual NULL for it in:
- CHARACTER_MAXIMUM_LENGTH
- NUMERIC_PRECISION
- ??? which others

Move CHAR length from in NUMERIC_PRECISION to in CHARACTER_MAXIMUM_LENGTH.

Add missing numeric precision and scale values:
- Change NUMERIC_PRECISION from logical null to precision for:
  - ??? which types
- Change NUMERIC_SCALE from logical null to precision for:
  - ??? which types

To correct ordinal positions of existing columns:
- Add COLUMN_DEFAULT.
- Add CHARACTER_OCTET_LENGTH.
- Reorder NUMERIC_PRECISION.


  was:[Editing in progress]


> Fix existing INFORMATION_SCHEMA.COLUMNS columns
> -----------------------------------------------
>
>                 Key: DRILL-3216
>                 URL: https://issues.apache.org/jira/browse/DRILL-3216
>             Project: Apache Drill
>          Issue Type: Bug
>            Reporter: Daniel Barclay (Drill)
>
> [Editing in progress]
> Change logical null from -1 to actual NULL for it in:
> - CHARACTER_MAXIMUM_LENGTH
> - NUMERIC_PRECISION
> - ??? which others
> Move CHAR length from in NUMERIC_PRECISION to in CHARACTER_MAXIMUM_LENGTH.
> Add missing numeric precision and scale values:
> - Change NUMERIC_PRECISION from logical null to precision for:
>   - ??? which types
> - Change NUMERIC_SCALE from logical null to precision for:
>   - ??? which types
> To correct ordinal positions of existing columns:
> - Add COLUMN_DEFAULT.
> - Add CHARACTER_OCTET_LENGTH.
> - Reorder NUMERIC_PRECISION.



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