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)
