Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <25134780.1178608995576.JavaMail.jira@brutus>
Date: Tue, 8 May 2007 00:23:15 -0700 (PDT)
From: "Kristian Waagan (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Resolved: (DERBY-2222) 'show indexes in SCHEMANAME' does not
 work with the client driver
In-Reply-To: <19108403.1168335267708.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable


     [ https://issues.apache.org/jira/browse/DERBY-2222?page=3Dcom.atlassia=
n.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kristian Waagan resolved DERBY-2222.
------------------------------------

       Resolution: Fixed
    Fix Version/s: 10.3.0.0
                   10.2.3.0

Committed 'DERBY-2222-3.diff' to trunk with revision 536100.
Merged to 10.2 with revision 536107.

Ran derbyall/suitesall (1.4, 1.5 and 1.6) for trunk, run for 10.2 is in pro=
gress now. Will report back and take corrective action if it shows problems=
.

> '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
>         Assigned To: J=C3=B8rgen L=C3=B8land
>             Fix For: 10.2.3.0, 10.3.0.0
>
>         Attachments: DERBY-2222-1.diff, DERBY-2222-1.stat, DERBY-2222-2.d=
iff, DERBY-2222-2.stat, DERBY-2222-3.diff, DERBY-2222-3.diff, DERBY-2222-3.=
stat, DERBY-2222-3.stat, ijMultipleResultSetResult.java
>
>
> 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=3Dtrue';
> 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>

--=20
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.