[jira] [Closed] (DRILL-2465) Fix multiple DatabaseMetaData.getColumns() bugs (some)

["Krystal (JIRA)" <ji...@apache.org>]

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

Krystal closed DRILL-2465.
--------------------------

Confirmed with Daniel that this is covered by his unit tests and can be closed.

> 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)
>            Priority: Blocker
>             Fix For: 0.9.0
>
>         Attachments: DRILL-2465.1.patch.txt
>
>
> Fixed most {{getColumn()}} bugs reported in DRILL-2420:
> - Added {{COLUMN_SIZE}} (in part to move later columns to right ordinal position).  [With workarounds for INFORMATION_SCHEMA.COLUMN bugs.]
> - 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.]



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