[
https://issues.apache.org/jira/browse/DRILL-2465?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Daniel Barclay (Drill) updated DRILL-2465:
------------------------------------------
Description:
Fixed most getColumn() bugs reported in DRILL-2420:
- Added COLUMN_SIZE (in part to move later columns to right ordinal position).
- Fixed DECIMAL_DIGITS (was DECIMAL_PRECISION; didn't report values for numeric
types other than DECIMAL).
- Fixed NUM_PREC_RADIX (was -1 for cases that should be NULL).
- Fixed REMARKS (from '' to NULL).
- Fixed COLUMN_DEF (from '' to NULL).
- Fixed CHARACTER_OCTET_LENGTH (was 4). [With workarounds for (possible)
INFORMATION_SCHEMA.COLUMN bugs.]
- Fixed ORDINAL_POSITION (was returning 1 for every column).
- Fixed SCOPE_CATALOG (from '' to NULL).
- Fixed SCOPE_SCHEMA (from '' to NULL).
- Fixed SCOPE_TABLE (from '' to NULL).
- FIXED SOURCE_DATA_TYPE (from VARCHAR to INTEGER.) [With workaround because
SMALLINT not implemented yet.]
[Bug report in progress]
was:
Fixed most getColumn() bugs reported in DRILL-2420:
- Added COLUMN_SIZE (in part to move later columns to right ordinal position).
- Fixed DECIMAL_DIGITS (was DECIMAL_PRECISION; didn't report values for numeric
types other than DECIMAL).
- Fixed NUM_PREC_RADIX (was -1 for cases that should be NULL).
- ???NULLABLE
- Fixed REMARKS (from '' to NULL).
- Fixed COLUMN_DEF (from '' to NULL).
- Fixed CHARACTER_OCTET_LENGTH (was 4). [With workarounds for apparent
INFORMATION_SCHEMA.COLUMN problems.]
- Fixed ORDINAL_POSITION (was returning 1 for every column).
- Fixed SCOPE_CATALOG (from '' to NULL).
- Fixed SCOPE_SCHEMA (from '' to NULL).
- Fixed SCOPE_TABLE (from '' to NULL).
- FIXED SOURCE_DATA_TYPE (from VARCHAR to INTEGER.) [With workaround because
SMALLINT not implemented yet.]
[Bug report in progress]
> Fix multiple DatabaseMetaData.getColumns() bugs (some)
> -------------------------------------------------------
>
> Key: DRILL-2465
> URL: https://issues.apache.org/jira/browse/DRILL-2465
> Project: Apache Drill
> Issue Type: Bug
> Components: Client - JDBC, Metadata
> Reporter: Daniel Barclay (Drill)
> Assignee: Daniel Barclay (Drill)
>
> Fixed most getColumn() bugs reported in DRILL-2420:
> - Added COLUMN_SIZE (in part to move later columns to right ordinal position).
> - Fixed DECIMAL_DIGITS (was DECIMAL_PRECISION; didn't report values for
> numeric types other than DECIMAL).
> - Fixed NUM_PREC_RADIX (was -1 for cases that should be NULL).
> - Fixed REMARKS (from '' to NULL).
> - Fixed COLUMN_DEF (from '' to NULL).
> - Fixed CHARACTER_OCTET_LENGTH (was 4). [With workarounds for (possible)
> INFORMATION_SCHEMA.COLUMN bugs.]
> - Fixed ORDINAL_POSITION (was returning 1 for every column).
> - Fixed SCOPE_CATALOG (from '' to NULL).
> - Fixed SCOPE_SCHEMA (from '' to NULL).
> - Fixed SCOPE_TABLE (from '' to NULL).
> - FIXED SOURCE_DATA_TYPE (from VARCHAR to INTEGER.) [With workaround because
> SMALLINT not implemented yet.]
> [Bug report in progress]
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
