ignite-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ray (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (IGNITE-10356) JDBC thin driver returns wrong data type for Date and Decimal SQL type
Date Thu, 22 Nov 2018 05:30:00 GMT

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

Ray updated IGNITE-10356:
-------------------------
    Description: 
JDBC thin driver will return wrong metadata for column type when user creates a table with
Date and Decimal type.

 

Steps to reproduce.

1. Start one node and create table using this command

create table a(a varchar, b decimal,c date, primary key(a));

2. Run "!desc a" to show the metadata of table a

This results is as follows:

TABLE_CAT
TABLE_SCHEM PUBLIC
TABLE_NAME A
COLUMN_NAME A
DATA_TYPE 12
TYPE_NAME VARCHAR
COLUMN_SIZE null
BUFFER_LENGTH null
DECIMAL_DIGITS null
NUM_PREC_RADIX 10
NULLABLE 1
REMARKS
COLUMN_DEF
SQL_DATA_TYPE 12
SQL_DATETIME_SUB null
CHAR_OCTET_LENGTH 2147483647
ORDINAL_POSITION 1
IS_NULLABLE YES
SCOPE_CATLOG
SCOPE_SCHEMA
SCOPE_TABLE
SOURCE_DATA_TYPE null
IS_AUTOINCREMENT NO
IS_GENERATEDCOLUMN NO

TABLE_CAT
TABLE_SCHEM PUBLIC
TABLE_NAME A
COLUMN_NAME B
DATA_TYPE 1111
TYPE_NAME OTHER
COLUMN_SIZE null
BUFFER_LENGTH null
DECIMAL_DIGITS null
NUM_PREC_RADIX 10
NULLABLE 1
REMARKS
COLUMN_DEF
SQL_DATA_TYPE 1111
SQL_DATETIME_SUB null
CHAR_OCTET_LENGTH 2147483647
ORDINAL_POSITION 2
IS_NULLABLE YES
SCOPE_CATLOG
SCOPE_SCHEMA
SCOPE_TABLE
SOURCE_DATA_TYPE null
IS_AUTOINCREMENT NO
IS_GENERATEDCOLUMN NO

TABLE_CAT
TABLE_SCHEM PUBLIC
TABLE_NAME A
COLUMN_NAME C
DATA_TYPE 1111
TYPE_NAME OTHER
COLUMN_SIZE null
BUFFER_LENGTH null
DECIMAL_DIGITS null
NUM_PREC_RADIX 10
NULLABLE 1
REMARKS
COLUMN_DEF
SQL_DATA_TYPE 1111
SQL_DATETIME_SUB null
CHAR_OCTET_LENGTH 2147483647
ORDINAL_POSITION 3
IS_NULLABLE YES
SCOPE_CATLOG
SCOPE_SCHEMA
SCOPE_TABLE
SOURCE_DATA_TYPE null
IS_AUTOINCREMENT NO
IS_GENERATEDCOLUMN NO

 

Column b and c has the wrong DATA_TYPE and TYPE_NAME.

 

  was:
JDBC thin driver will return wrong metadata for column type when user creates a table with
Date and Decimal type.

 


> JDBC thin driver returns wrong data type for Date and Decimal SQL type
> ----------------------------------------------------------------------
>
>                 Key: IGNITE-10356
>                 URL: https://issues.apache.org/jira/browse/IGNITE-10356
>             Project: Ignite
>          Issue Type: Bug
>    Affects Versions: 2.6, 2.7
>            Reporter: Ray
>            Assignee: Ray
>            Priority: Critical
>             Fix For: 2.8
>
>
> JDBC thin driver will return wrong metadata for column type when user creates a table
with Date and Decimal type.
>  
> Steps to reproduce.
> 1. Start one node and create table using this command
> create table a(a varchar, b decimal,c date, primary key(a));
> 2. Run "!desc a" to show the metadata of table a
> This results is as follows:
> TABLE_CAT
> TABLE_SCHEM PUBLIC
> TABLE_NAME A
> COLUMN_NAME A
> DATA_TYPE 12
> TYPE_NAME VARCHAR
> COLUMN_SIZE null
> BUFFER_LENGTH null
> DECIMAL_DIGITS null
> NUM_PREC_RADIX 10
> NULLABLE 1
> REMARKS
> COLUMN_DEF
> SQL_DATA_TYPE 12
> SQL_DATETIME_SUB null
> CHAR_OCTET_LENGTH 2147483647
> ORDINAL_POSITION 1
> IS_NULLABLE YES
> SCOPE_CATLOG
> SCOPE_SCHEMA
> SCOPE_TABLE
> SOURCE_DATA_TYPE null
> IS_AUTOINCREMENT NO
> IS_GENERATEDCOLUMN NO
> TABLE_CAT
> TABLE_SCHEM PUBLIC
> TABLE_NAME A
> COLUMN_NAME B
> DATA_TYPE 1111
> TYPE_NAME OTHER
> COLUMN_SIZE null
> BUFFER_LENGTH null
> DECIMAL_DIGITS null
> NUM_PREC_RADIX 10
> NULLABLE 1
> REMARKS
> COLUMN_DEF
> SQL_DATA_TYPE 1111
> SQL_DATETIME_SUB null
> CHAR_OCTET_LENGTH 2147483647
> ORDINAL_POSITION 2
> IS_NULLABLE YES
> SCOPE_CATLOG
> SCOPE_SCHEMA
> SCOPE_TABLE
> SOURCE_DATA_TYPE null
> IS_AUTOINCREMENT NO
> IS_GENERATEDCOLUMN NO
> TABLE_CAT
> TABLE_SCHEM PUBLIC
> TABLE_NAME A
> COLUMN_NAME C
> DATA_TYPE 1111
> TYPE_NAME OTHER
> COLUMN_SIZE null
> BUFFER_LENGTH null
> DECIMAL_DIGITS null
> NUM_PREC_RADIX 10
> NULLABLE 1
> REMARKS
> COLUMN_DEF
> SQL_DATA_TYPE 1111
> SQL_DATETIME_SUB null
> CHAR_OCTET_LENGTH 2147483647
> ORDINAL_POSITION 3
> IS_NULLABLE YES
> SCOPE_CATLOG
> SCOPE_SCHEMA
> SCOPE_TABLE
> SOURCE_DATA_TYPE null
> IS_AUTOINCREMENT NO
> IS_GENERATEDCOLUMN NO
>  
> Column b and c has the wrong DATA_TYPE and TYPE_NAME.
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message