drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Daniel Barclay (Drill) (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DRILL-3216) Fix existing INFORMATION_SCHEMA.COLUMNS columns
Date Fri, 29 May 2015 21:31:17 GMT

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

Daniel Barclay (Drill) updated DRILL-3216:
------------------------------------------
    Description: 
Change logical null from {{-1}} to actual {{NULL}} in:
- column {{CHARACTER_MAXIMUM_LENGTH}}
- column {{NUMERIC_PRECISION}}
- column {{NUMERIC_PRECISION_RADIX}}
- column {{NUMERIC_SCALE}}

Move {{CHAR}} length from {{NUMERIC_PRECISION}} to {{CHARACTER_MAXIMUM_LENGTH}} (same as {{VARCHAR}}
length):
- Change column NUMERIC_PRECISION from length to logical null for CHAR
- Change column CHARACTER_MAXIMUM_LENGTH from logical null to length for CHAR.

Move {{BINARY}} and {{VARBINARY}} length from {{NUMERIC_PRECISION}} to {{CHARACTER_MAXIMUM_LENGTH}}
(same as CHAR and VARCHAR length):
- Change column NUMERIC_PRECISION from length to logical null for BINARY and VARBINARY.
- Change column CHARACTER_MAXIMUM_LENGTH from logical null to length for  BINARY and VARBINARY.

In column {{DATA_TYPE}}, change "INTERVAL_DAY_TIME" and "INTERVAL_YEAR_MONTH" to "INTERVAL".
Add column {{INTERVAL_TYPE}}.

To correct ordinal position of some existing columns:
- Add column {{COLUMN_DEFAULT}}.
- Add column {{CHARACTER_OCTET_LENGTH}}.
- Reorder column {{NUMERIC_PRECISION}}.

Move date/time and interval precisions from {{NUMERIC_PRECISION}} to {{DATETIME_PRECISION}}
and {{INTERVAL_PRECISION}}:
- Change column {{NUMERIC_PRECISION}} to logically null for date/time and interval types.
- Add column {{DATETIME_PRECISION}}.
- Add column {{INTERVAL_PRECISION}}.


[Editing in progress]
????????

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



  was:
[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.



> 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)
>
> Change logical null from {{-1}} to actual {{NULL}} in:
> - column {{CHARACTER_MAXIMUM_LENGTH}}
> - column {{NUMERIC_PRECISION}}
> - column {{NUMERIC_PRECISION_RADIX}}
> - column {{NUMERIC_SCALE}}
> Move {{CHAR}} length from {{NUMERIC_PRECISION}} to {{CHARACTER_MAXIMUM_LENGTH}} (same
as {{VARCHAR}} length):
> - Change column NUMERIC_PRECISION from length to logical null for CHAR
> - Change column CHARACTER_MAXIMUM_LENGTH from logical null to length for CHAR.
> Move {{BINARY}} and {{VARBINARY}} length from {{NUMERIC_PRECISION}} to {{CHARACTER_MAXIMUM_LENGTH}}
(same as CHAR and VARCHAR length):
> - Change column NUMERIC_PRECISION from length to logical null for BINARY and VARBINARY.
> - Change column CHARACTER_MAXIMUM_LENGTH from logical null to length for  BINARY and
VARBINARY.
> In column {{DATA_TYPE}}, change "INTERVAL_DAY_TIME" and "INTERVAL_YEAR_MONTH" to "INTERVAL".
> Add column {{INTERVAL_TYPE}}.
> To correct ordinal position of some existing columns:
> - Add column {{COLUMN_DEFAULT}}.
> - Add column {{CHARACTER_OCTET_LENGTH}}.
> - Reorder column {{NUMERIC_PRECISION}}.
> Move date/time and interval precisions from {{NUMERIC_PRECISION}} to {{DATETIME_PRECISION}}
and {{INTERVAL_PRECISION}}:
> - Change column {{NUMERIC_PRECISION}} to logically null for date/time and interval types.
> - Add column {{DATETIME_PRECISION}}.
> - Add column {{INTERVAL_PRECISION}}.
> [Editing in progress]
> ????????
> 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



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

Mime
View raw message