Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <591285023.1254423023596.JavaMail.jira@brutus>
Date: Thu, 1 Oct 2009 11:50:23 -0700 (PDT)
From: "Sylvain Leroux (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Updated: (DERBY-3809) Add a SHOW FUNCTONS command to ij
In-Reply-To: <1834362499.1217597434131.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


     [ https://issues.apache.org/jira/browse/DERBY-3809?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Sylvain Leroux updated DERBY-3809:
----------------------------------

    Attachment: show-functions-3.diff

This time, I tried to narrow the result columns as much as possible to fit in 80 columns wide terminal. Giving as much space as possible to the REMARKS columns. This is better than the result of SHOW PROCEDURE I think, but class names are still truncated. 

Concerning InvocationTargetException of course you were right: I now re-throw the underlying exception.

I add as test case for SHOW FUNCTIONS without an IN SCHEMA clause. Both JUnit and old tests pass well.

> Add a SHOW FUNCTONS command to ij
> ---------------------------------
>
>                 Key: DERBY-3809
>                 URL: https://issues.apache.org/jira/browse/DERBY-3809
>             Project: Derby
>          Issue Type: Improvement
>          Components: Tools
>    Affects Versions: 10.4.1.3
>            Reporter: Rick Hillegas
>            Assignee: Sylvain Leroux
>         Attachments: show-functions-2.diff, show-functions-3.diff, show-functions.diff
>
>
> Currently, the ij SHOW command can give you information on a number of schema objects, including procedures. It should be fairly easy to add SHOW FUNCTIONS as well. This request surfaced on the user list: http://www.nabble.com/How-can-i-see-my-self-defined-functions--td18773980.html#a18773980

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