'show indexes in SCHEMANAME' does not work with the client driver
-----------------------------------------------------------------
Key: DERBY-2222
URL: https://issues.apache.org/jira/browse/DERBY-2222
Project: Derby
Issue Type: Bug
Components: Network Client, Tools
Affects Versions: 10.2.2.0, 10.3.0.0
Reporter: Kristian Waagan
The ij command 'show indexes in SCHEMANAME' does not work at all with the
client driver.
It does work with the embedded driver.
Sample output from ij:
ij> connect 'jdbc:derby://localhost/myDB;create=true';
ij> create table test (id int primary key);
0 rows inserted/updated/deleted
ij> show indexes in app;
ERROR XJ103: Table name can not be null
ij> show indexes from test;
TABLE_NAME |COLUMN_NAME |NON_U&|TYPE|ASC&|CARDINA&|PAGES
----------------------------------------------------------------------------
TEST |ID |0 |3 |A |NULL |NULL
1 row selected
ij> show indexes from app.test;
TABLE_NAME |COLUMN_NAME |NON_U&|TYPE|ASC&|CARDINA&|PAGES
----------------------------------------------------------------------------
TEST |ID |0 |3 |A |NULL |NULL
1 row selected
ij>
Using delimited table and/or schema names does not work, but I think this is
according to documentation.
I.e.:
ij> show indexes from "TEST";
ERROR 42X01: Syntax error: Encountered "show" at line 1, column 1.
ij> show indexes from "APP".test;
ERROR 42X01: Syntax error: Encountered "show" at line 1, column 1.
ij> show indexes from "APP"."TEST";
ERROR 42X01: Syntax error: Encountered "show" at line 1, column 1.
ij>
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
