[
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)
