[DERBY-2222] 'show indexes in SCHEMANAME' does not work with the client driver

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.2.2.0, 10.3.1.4
• Fix Version/s: 10.2.2.1, 10.3.1.4
• Component/s: Network Client, Tools
• Assignee: Jorgen Loland
• Reporter: Kristian Waagan
• Created: 09/Jan/07 09:33
• Updated: 05/Jul/10 17:12
• Resolved: 08/May/07 07:21

Description

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>

Issue Links

• blocks: DERBY-1484 Client and embedded behave differently when the table name is null in DatabaseMetaData methods
• relates to: DERBY-2019 IJ's describe command does not handle quotes very well