ignite-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Taras Ledkov (JIRA)" <j...@apache.org>
Subject [jira] [Assigned] (IGNITE-6152) Wrong response from grid via jdbc driver
Date Tue, 22 Aug 2017 14:05:00 GMT

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

Taras Ledkov reassigned IGNITE-6152:
------------------------------------

    Assignee: Taras Ledkov

> Wrong response from grid via jdbc driver
> ----------------------------------------
>
>                 Key: IGNITE-6152
>                 URL: https://issues.apache.org/jira/browse/IGNITE-6152
>             Project: Ignite
>          Issue Type: Bug
>          Components: jdbc
>    Affects Versions: 2.1
>         Environment: OS X 10.10.5
> java version "1.8.0_91"
>            Reporter: Ilya Suntsov
>            Assignee: Taras Ledkov
>             Fix For: 2.2
>
>
> Now I'm testing command line tool - *sqlline* ([link to github|https://github.com/julianhyde/sqlline])
for execute sql queries to AI grid via thin jdbc driver.
> When I was trying to get column list from AI grid and H2 database I got 2 different responses
from the same table.
> Ignite:
> {noformat}
> 0: jdbc:ignite:thin://127.0.0.1/> !columns person
> +--------------------------------+--------------------------------+--------------------------------+
> |           TABLE_CAT            |          TABLE_SCHEM           |           TABLE_NAME
          |
> +--------------------------------+--------------------------------+--------------------------------+
> |                                | PUBLIC                         | PERSON          
              |
> |                                | PUBLIC                         | PERSON          
              |
> |                                | PUBLIC                         | PERSON          
              |
> +--------------------------------+--------------------------------+--------------------------------+
> {noformat}  
> H2:
> {noformat}
> +-----------+-------------+------------+-------------+-------------+-----------+-------------+---------------+----------------+----------------+-------------+---------+------------+---------------+------------------+-----------+
> | TABLE_CAT | TABLE_SCHEM | TABLE_NAME | COLUMN_NAME |  DATA_TYPE  | TYPE_NAME | COLUMN_SIZE
| BUFFER_LENGTH | DECIMAL_DIGITS | NUM_PREC_RADIX |  NULLABLE   | REMARKS | COLUMN_DEF | SQL_DATA_TYPE
| SQL_DATETIME_SUB | CHAR_OCTE |
> +-----------+-------------+------------+-------------+-------------+-----------+-------------+---------------+----------------+----------------+-------------+---------+------------+---------------+------------------+-----------+
> | TEST"     | PUBLIC      | PERSON     | ID          | -5          | BIGINT    | 19 
        | 19            | 0              | 10             | 0           |         |      
     | -5            | 0                | 19        |
> | TEST"     | PUBLIC      | PERSON     | NAME        | 12          | VARCHAR   | 2147483647
 | 2147483647    | 0              | 10             | 1           |         |            |
12            | 0                | 214748364 |
> | TEST"     | PUBLIC      | PERSON     | CITY_ID     | -5          | BIGINT    | 19 
        | 19            | 0              | 10             | 0           |         |      
     | -5            | 0                | 19        |
> +-----------+-------------+------------+-------------+-------------+-----------+-------------+---------------+----------------+----------------+-------------+---------+------------+---------------+------------------+-----------+
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message