[
https://issues.apache.org/jira/browse/IGNITE-8854?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sergey Kozlov updated IGNITE-8854:
----------------------------------
Summary: sqlline: !indexes and !primarykeys return nothing for
o.a.i.IgniteJdbcDriver (was: !indexes and !primarykeys return nothing for
o.a.i.IgniteJdbcDriver)
> sqlline: !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
> Priority: Major
>
> # 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)
