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/06/01 20:13:19 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}}:
- Change column {{CHARACTER_MAXIMUM_LENGTH}}.
- Change column {{NUMERIC_PRECISION}}.
- Change column {{NUMERIC_PRECISION_RADIX}}.
- Change column {{NUMERIC_SCALE}}.
Change column {{DATA_TYPE}} from short names (e.g., "CHAR") to specified names (e.g., "CHARACTER").
Change column {{ORDINAL_POSITION}} from zero-based to one-based.
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.
Fix data type names "INTERVAL_DAY_TIME" and "INTERVAL_YEAR_MONTH" to "INTERVAL":
- Change column {{DATA_TYPE}} to list "INTERVAL" for interval types.
- 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}}.
Implement {{NUMERIC_PRECISION_RADIX}}:
- Change column {{NUMERIC_PRECISION_RADIX}} from always logically null to appropriate values (2, 10, NULL).
Add missing numeric precision and scale values (for non-DECIMAL types):
- Change NUMERIC_SCALE from logical null to zero for integer types.
- Change NUMERIC_PRECISION from logical null to precision for non-DECIMAL numeric types.
was:
[Editing in progress]
Change logical null from {{-1}} to actual {{NULL}}:
- Change column {{CHARACTER_MAXIMUM_LENGTH}}.
- Change column {{NUMERIC_PRECISION}}.
- Change column {{NUMERIC_PRECISION_RADIX}}.
- Change column {{NUMERIC_SCALE}}.
Change column {{ORDINAL_POSITION}} from zero-based to one-based.
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.
Fix data type names "INTERVAL_DAY_TIME" and "INTERVAL_YEAR_MONTH" to "INTERVAL":
- Change column {{DATA_TYPE}} to list "INTERVAL" for interval types.
- 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}}.
Implement {{NUMERIC_PRECISION_RADIX}}:
- Change column {{NUMERIC_PRECISION_RADIX}} from always logically null to appropriate values (2, 10, NULL).
Add missing numeric precision and scale values (for non-DECIMAL types):
- Change NUMERIC_SCALE from logical null to zero for integer types.
- Change NUMERIC_PRECISION from logical null to precision for non-DECIMAL numeric types.
> 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}}:
> - Change column {{CHARACTER_MAXIMUM_LENGTH}}.
> - Change column {{NUMERIC_PRECISION}}.
> - Change column {{NUMERIC_PRECISION_RADIX}}.
> - Change column {{NUMERIC_SCALE}}.
> Change column {{DATA_TYPE}} from short names (e.g., "CHAR") to specified names (e.g., "CHARACTER").
> Change column {{ORDINAL_POSITION}} from zero-based to one-based.
> 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.
> Fix data type names "INTERVAL_DAY_TIME" and "INTERVAL_YEAR_MONTH" to "INTERVAL":
> - Change column {{DATA_TYPE}} to list "INTERVAL" for interval types.
> - 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}}.
> Implement {{NUMERIC_PRECISION_RADIX}}:
> - Change column {{NUMERIC_PRECISION_RADIX}} from always logically null to appropriate values (2, 10, NULL).
> Add missing numeric precision and scale values (for non-DECIMAL types):
> - Change NUMERIC_SCALE from logical null to zero for integer types.
> - Change NUMERIC_PRECISION from logical null to precision for non-DECIMAL numeric types.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)