From derby-dev-return-41064-apmail-db-derby-dev-archive=db.apache.org@db.apache.org Wed Apr 25 08:04:38 2007 Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 39794 invoked from network); 25 Apr 2007 08:04:36 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 25 Apr 2007 08:04:36 -0000 Received: (qmail 83746 invoked by uid 500); 25 Apr 2007 08:04:43 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 83710 invoked by uid 500); 25 Apr 2007 08:04:43 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 83700 invoked by uid 99); 25 Apr 2007 08:04:43 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 25 Apr 2007 01:04:43 -0700 X-ASF-Spam-Status: No, hits=-100.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.4] (HELO brutus.apache.org) (140.211.11.4) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 25 Apr 2007 01:04:35 -0700 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 6281271404A for ; Wed, 25 Apr 2007 01:04:15 -0700 (PDT) Message-ID: <10832381.1177488255371.JavaMail.jira@brutus> Date: Wed, 25 Apr 2007 01:04:15 -0700 (PDT) From: =?utf-8?Q?J=C3=B8rgen_L=C3=B8land_=28JIRA=29?= To: derby-dev@db.apache.org Subject: [jira] Updated: (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 X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/DERBY-2222?page=3Dcom.atlassia= n.jira.plugin.system.issuetabpanels:all-tabpanel ] J=C3=B8rgen L=C3=B8land updated DERBY-2222: --------------------------------- Attachment: ijMultipleResultSetResult.java DERBY-2222-1.stat DERBY-2222-1.diff By fixing DERBY-1484, DatabaseMetaData#getIndexInfo will no longer allow nu= ll values for the table name. This breaks the "show indexes" functionality = of ij in its current implementation.=20 To remedy this, the "show index" functionality has been rewritten to someth= ing like: ---- code --- ij.jj#showIndexes (schema, table){ if (table !=3D null) return new ijResultSetResult(dbmd.getIndexInfo(schema,= table)) else=20 dbmd.getTables(schema) for each tablename in schema=20 resultSetList.add(dbmd.getIndexInfo(schema, table)) return new ijMultipleResultSetResult(resultSetList) ---- /code --- The posted patch adds a new subclass of ijResultImpl (currently called ijMu= ltipleResultSetResult) that effectively is a List of ResultSet. JDBCDisplay= Util is modified to handle this by showing the banner first, and then show = all the rows in all resultsets in the ijMultipleResultSetResult object.=20 I will apply the same fix to all ij functionality that uses methods in Data= baseMetaData where table =3D null is no longer allowed. See DERBY-1484 for = details. > '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 > Attachments: DERBY-2222-1.diff, DERBY-2222-1.stat, ijMultipleResu= ltSetResult.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.