[
https://issues.apache.org/jira/browse/IGNITE-8854?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sergey Kozlov updated IGNITE-8854:
----------------------------------
Description:
# 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}
was:
# 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}
> 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)
