Return-Path: X-Original-To: apmail-drill-issues-archive@minotaur.apache.org Delivered-To: apmail-drill-issues-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 7DA4E17561 for ; Sat, 14 Mar 2015 03:43:38 +0000 (UTC) Received: (qmail 7239 invoked by uid 500); 14 Mar 2015 03:43:38 -0000 Delivered-To: apmail-drill-issues-archive@drill.apache.org Received: (qmail 7205 invoked by uid 500); 14 Mar 2015 03:43:38 -0000 Mailing-List: contact issues-help@drill.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@drill.apache.org Delivered-To: mailing list issues@drill.apache.org Received: (qmail 7195 invoked by uid 99); 14 Mar 2015 03:43:38 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 14 Mar 2015 03:43:38 +0000 Date: Sat, 14 Mar 2015 03:43:38 +0000 (UTC) From: "Daniel Barclay (Drill) (JIRA)" To: issues@drill.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (DRILL-2459) INFO._SCHEMA's CHARACTER_MAXIMUM_LENGTH is -1 for type CHAR MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/DRILL-2459?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14361576#comment-14361576 ] Daniel Barclay (Drill) commented on DRILL-2459: ----------------------------------------------- The length is also in NUMERIC_PRECISION for both BINARY and BINARY VARBINARY / VARBINARY. > INFO._SCHEMA's CHARACTER_MAXIMUM_LENGTH is -1 for type CHAR > ----------------------------------------------------------- > > Key: DRILL-2459 > URL: https://issues.apache.org/jira/browse/DRILL-2459 > Project: Apache Drill > Issue Type: Bug > Components: Metadata > Reporter: Daniel Barclay (Drill) > Assignee: Steven Phillips > > INFORMATION_SCHEMA.COLUMNS.CHARACTER_MAXIMUM_LENGTH does not report the length for type CHAR. For example, for type descriptor "CHAR(4)", it doesn't return 4. Instead, it returns 1: > 0: jdbc:drill:zk=local> USE dfs.tmp; > +------------+------------+ > | ok | summary | > +------------+------------+ > | true | Default schema changed to 'dfs.tmp' | > +------------+------------+ > 1 row selected (0.05 seconds) > 0: jdbc:drill:zk=local> CREATE OR REPLACE VIEW TempView AS SELECT CAST( NULL AS VARCHAR(3) ), CAST( NULL AS CHAR(4) ) FROM INFORMATION_SCHEMA.CATALOGS LIMIT 1 ; > +------------+------------+ > | ok | summary | > +------------+------------+ > | true | View 'TempView' replaced successfully in 'dfs.tmp' schema | > +------------+------------+ > 1 row selected (0.05 seconds) > 0: jdbc:drill:zk=local> SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'TempView'; > +---------------+--------------+------------+-------------+------------------+-------------+------------+--------------------------+-------------------------+---------------+-------------------+ > | TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | COLUMN_NAME | ORDINAL_POSITION | IS_NULLABLE | DATA_TYPE | CHARACTER_MAXIMUM_LENGTH | NUMERIC_PRECISION_RADIX | NUMERIC_SCALE | NUMERIC_PRECISION | > +---------------+--------------+------------+-------------+------------------+-------------+------------+--------------------------+-------------------------+---------------+-------------------+ > | DRILL | dfs.tmp | TempView | EXPR$0 | 0 | NO | VARCHAR | 3 | -1 | -1 | -1 | > | DRILL | dfs.tmp | TempView | EXPR$1 | 1 | NO | CHAR | -1 | -1 | -1 | 4 | > +---------------+--------------+------------+-------------+------------------+-------------+------------+--------------------------+-------------------------+---------------+-------------------+ > 2 rows selected (0.072 seconds) > 0: jdbc:drill:zk=local> > Hmm. Note the 4 in the NUMERIC_PRECISION column: > 0: jdbc:drill:zk=local> SELECT DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, NUMERIC_PRECISION FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'TempView'; > +------------+--------------------------+-------------------+ > | DATA_TYPE | CHARACTER_MAXIMUM_LENGTH | NUMERIC_PRECISION | > +------------+--------------------------+-------------------+ > | VARCHAR | 3 | -1 | > | CHAR | -1 | 4 | > +------------+--------------------------+-------------------+ > 2 rows selected (0.065 seconds) > 0: jdbc:drill:zk=local> -- This message was sent by Atlassian JIRA (v6.3.4#6332)