[IGNITE-8055] Sqline command !tables works incorrect for client node - ASF JIRA

XML

Word

Printable

JSON

For reproducing:

You should start one local server and one local client nodes and follow the instructions:

1)Connect to server node:

sqlline.bat --color=true --verbose=true -u jdbc:ignite:thin://127.0.0.1:10800

2)Create new table on server node:

CREATE TABLE City (id LONG PRIMARY KEY, name VARCHAR)WITH "template=replicated";

3)Check that table exists from server node:

!tables

On this step table should be shown in the response.

4)Connect to client node:

sqlline.bat --color=true --verbose=true -u jdbc:ignite:thin://127.0.0.1:10801

5)Check that table exists from server node:

!tables

On this step there is no "city" table in the list.

Next commands work from client node as well:
SELECT * FROM City
DROP TABLE City

duplicates

IGNITE-6173 SQL: do not start caches on client nodes

relates to

IGNITE-13482 Client node cannot ALTER TABLE if it was created on a different node

IGNITE-8060 Sqline creating tables on client nodes works incorrect in case of node's shutdown

IGNITE-8100 jdbc getSchemas method could miss schemas for not started remote caches