ignite-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Maxim Muzafarov (Jira)" <j...@apache.org>
Subject [jira] [Commented] (IGNITE-10585) JDBC driver returns FLOAT in column metadata for REAL SQL type
Date Tue, 08 Oct 2019 13:12:00 GMT

    [ https://issues.apache.org/jira/browse/IGNITE-10585?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16946841#comment-16946841
] 

Maxim Muzafarov commented on IGNITE-10585:
------------------------------------------

Moved to 2.9 due to inactivity. Please, feel free to move it back if you will be able to complete
the ticket by 2.8 code freeze date, December 2, 2019.

> JDBC driver returns FLOAT in column metadata for REAL SQL type
> --------------------------------------------------------------
>
>                 Key: IGNITE-10585
>                 URL: https://issues.apache.org/jira/browse/IGNITE-10585
>             Project: Ignite
>          Issue Type: Bug
>          Components: jdbc
>    Affects Versions: 2.7
>            Reporter: Ray Liu
>            Assignee: Ray Liu
>            Priority: Major
>             Fix For: 2.8
>
>
> When I create a table usingĀ 
> create table c(a varchar, b real, primary key(a));
> The meta information for column b is wrong when I use !desc c to check.
> 0: jdbc:ignite:thin://127.0.0.1/> !desc c
>  TABLE_CAT
>  TABLE_SCHEM PUBLIC
>  TABLE_NAME C
>  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 C
>  COLUMN_NAME B
>  DATA_TYPE 7
>  {color:#d04437}TYPE_NAMEĀ FLOAT{color}
>  COLUMN_SIZE null
>  BUFFER_LENGTH null
>  DECIMAL_DIGITS null
>  NUM_PREC_RADIX 10
>  NULLABLE 1
>  REMARKS
>  COLUMN_DEF
>  SQL_DATA_TYPE 8
>  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



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Mime
View raw message