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)
