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)