You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ignite.apache.org by "Ilya Suntsov (JIRA)" <ji...@apache.org> on 2017/08/22 12:33:00 UTC
[jira] [Created] (IGNITE-6152) Wrong response from grid via jdbc
driver
Ilya Suntsov created IGNITE-6152:
------------------------------------
Summary: 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
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)