ignite-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sergey Kozlov (JIRA)" <j...@apache.org>
Subject [jira] [Created] (IGNITE-8854) !indexes and !primarykeys return nothing for o.a.i.IgniteJdbcDriver
Date Fri, 22 Jun 2018 10:34:00 GMT
Sergey Kozlov created IGNITE-8854:
-------------------------------------

             Summary: !indexes and !primarykeys return nothing for o.a.i.IgniteJdbcDriver
                 Key: IGNITE-8854
                 URL: https://issues.apache.org/jira/browse/IGNITE-8854
             Project: Ignite
          Issue Type: Bug
          Components: jdbc
    Affects Versions: 2.4
            Reporter: Sergey Kozlov


# Start cluster
# Start {{bin/sqlline.sh -d org.apache.ignite.IgniteJdbcDriver ...}} 
# Create tables with indexes like following:
{noformat}
3/151        CREATE TABLE PUBLIC.CAR(ID INT PRIMARY KEY, PARKINGID INT NOT NULL, NAME VARCHAR(255))
WITH "TEMPLATE=PARTITIONED";
No rows affected (0,249 seconds)
4/151        CREATE TABLE PUBLIC.PARKING(ID INT PRIMARY KEY, NAME VARCHAR(255), CAPACITY INT
NOT NULL) WITH "TEMPLATE=REPLICATED";
No rows affected (0,155 seconds)
...
8/151        !primarykeys PUBLIC.CAR
'TABLE_CAT','TABLE_SCHEM','TABLE_NAME','COLUMN_NAME','KEY_SEQ','PK_NAME'
9/151        !primarykeys PUBLIC.PARKING
'TABLE_CAT','TABLE_SCHEM','TABLE_NAME','COLUMN_NAME','KEY_SEQ','PK_NAME'
...
12/151       CREATE INDEX CAR_NAME_IDX ON PUBLIC.CAR(NAME);
No rows affected (0.071 seconds)
13/151       CREATE INDEX PARKING_IDX ON PUBLIC.PARKING(NAME, CAPACITY);
No rows affected (0.022 seconds)
14/151       !indexes
'TABLE_CAT','TABLE_SCHEM','TABLE_NAME','NON_UNIQUE','INDEX_QUALIFIER','INDEX_NAME','TYPE','ORDINAL_POSITION','COLUMN_NAME','ASC_OR_DESC','CARDINALITY','PAGES','FILTER_CONDITION'
...
{noformat}

For {{ org.apache.ignite.IgniteJdbcDriver}} commands work as expected:
{noformat}
8/151        !primarykeys PUBLIC.CAR
'TABLE_CAT','TABLE_SCHEM','TABLE_NAME','COLUMN_NAME','KEY_SEQ','PK_NAME'
'','PUBLIC','CAR','_KEY','1','ID'
9/151        !primarykeys PUBLIC.PARKING
'TABLE_CAT','TABLE_SCHEM','TABLE_NAME','COLUMN_NAME','KEY_SEQ','PK_NAME'
'','PUBLIC','PARKING','_KEY','1','ID'
...
12/151       CREATE INDEX CAR_NAME_IDX ON PUBLIC.CAR(NAME);
No rows affected (0.067 seconds)
13/151       CREATE INDEX PARKING_IDX ON PUBLIC.PARKING(NAME, CAPACITY);
No rows affected (0.023 seconds)
14/151       !indexes
'TABLE_CAT','TABLE_SCHEM','TABLE_NAME','NON_UNIQUE','INDEX_QUALIFIER','INDEX_NAME','TYPE','ORDINAL_POSITION','COLUMN_NAME','ASC_OR_DESC','CARDINALITY','PAGES','FILTER_CONDITION'
'','PUBLIC','CAR','true','','CAR_NAME_IDX','3','0','NAME','A','0','0',''
'','PUBLIC','PARKING','true','','PARKING_IDX','3','0','NAME','A','0','0',''
'','PUBLIC','PARKING','true','','PARKING_IDX','3','1','CAPACITY','A','0','0',''
{noformat}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message