ignite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ilya Suntsov (JIRA)" <j...@apache.org>
Subject [jira] [Created] (IGNITE-6152) Wrong response from grid via jdbc driver
Date Tue, 22 Aug 2017 12:33:00 GMT
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)

Mime
View raw message