You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Ilya Suntsov (JIRA)" <ji...@apache.org> on 2017/09/05 10:15:02 UTC
[jira] [Closed] (IGNITE-6152) Wrong response from grid via jdbc
driver
[ https://issues.apache.org/jira/browse/IGNITE-6152?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ilya Suntsov closed IGNITE-6152.
--------------------------------
> 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
>
> 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)