[
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)
