Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 82250 invoked from network); 4 Nov 2006 16:08:42 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 4 Nov 2006 16:08:42 -0000 Received: (qmail 39006 invoked by uid 500); 4 Nov 2006 16:08:53 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 38835 invoked by uid 500); 4 Nov 2006 16:08:52 -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 38826 invoked by uid 99); 4 Nov 2006 16:08:52 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 04 Nov 2006 08:08:52 -0800 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= 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; Sat, 04 Nov 2006 08:08:40 -0800 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 119617142CE for ; Sat, 4 Nov 2006 08:08:18 -0800 (PST) Message-ID: <23348574.1162656498069.JavaMail.root@brutus> Date: Sat, 4 Nov 2006 08:08:18 -0800 (PST) From: "Bryan Pendleton (JIRA)" To: derby-dev@db.apache.org Subject: [jira] Commented: (DERBY-2030) 'set schema sys' followed by 'show tables' does not show tables in sys schema In-Reply-To: <27498497.1162446856601.JavaMail.root@brutus> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org [ http://issues.apache.org/jira/browse/DERBY-2030?page=comments#action_12447157 ] Bryan Pendleton commented on DERBY-2030: ---------------------------------------- Hi Andrew, I applied the patch and it seems to work fine for me. I can see the behavior changes and they are as I expected. I think the new behavior is reasonable. Are there no tests for this feature in our test suite? I was a little bit surprised that there were no test changes in this patch. > 'set schema sys' followed by 'show tables' does not show tables in sys schema > ----------------------------------------------------------------------------- > > Key: DERBY-2030 > URL: http://issues.apache.org/jira/browse/DERBY-2030 > Project: Derby > Issue Type: Bug > Components: Tools > Affects Versions: 10.2.1.6, 10.3.0.0 > Reporter: Andrew McIntyre > Assigned To: Andrew McIntyre > Priority: Minor > Attachments: ij_showalltables.diff > > > If you create a new database in IJ, followed by 'set schema sys' and then 'show tables', ij shows no tables in the schema. This is because ij's show tables command only shows system tables if a schema is provided. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira