[
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 derbyall
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: 10.4.1.3
> 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.
