db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-3809) Add a SHOW FUNCTONS command to ij
Date Mon, 28 Sep 2009 15:17:15 GMT

    [ https://issues.apache.org/jira/browse/DERBY-3809?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12760270#action_12760270

Knut Anders Hatlen commented on DERBY-3809:

Thanks for the new patch.

The ij.sql test has not been converted to the JUnit harness yet, so it only runs as part of
the old regression test suite (derbyall). To run the test, you could try one of these commands
(you'll need jakarta-oro-2.0.8.jar in the classpath in addition to the jar files you need
when you run the JUnit tests):

- Single test: java org.apache.derbyTesting.functionTests.harness.RunTest tools/ij.sql

- All tools tests: java org.apache.derbyTesting.functionTests.harness.RunSuite derbytools

- All tests in the old harness: java org.apache.derbyTesting.functionTests.harness.RunSuite

As to the column widths, I think SHOW PROCEDURES tried to make them fit in a standard terminal
window (max 80 chars). But I kind of agree that having columns so narrow that they don't show
the useful information doesn't make much sense.

I'm wondering about the code that catches InvocationTargetException, if it should re-throw
the underlying exception instead of throwing notAvailableForDriver(). I think the ITE will
be thrown only if getFunctions() raises an SQLException, which indicates that some database
failure occurred, and not that the driver doesn't support the call.

For completeness, perhaps we should also have a test case for "SHOW FUNCTIONS" without the
"IN <SCHEMA>" clause.

> 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:
>            Reporter: Rick Hillegas
>            Assignee: Sylvain Leroux
>         Attachments: show-functions-2.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.

View raw message