[
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.diff
Thanks Knut,
I send the ICLA as soon as possible.
----
Here is a first work on this issue.
I've changed the ij grammar to add the following commands:
SHOW FUNCTIONS;
SHOW FUNCTIONS IN <schema>
This has required to add the new FUNCTIONS token.
Concerning the Java method "ijResult showFunctions(String schema) throws
SQLException", the request was borrowed from
http://www.nabble.com/Re%3A-How-can-i-see-my-self-defined-functions--p18774587.html
Despite the fact the parser only allows an identifier in the "IN" clause, I
assume I should somehow escape the schema name. But I don't really know how to
do that. Using a prepared statement seems to be a little bit excessive, isn't
it?
----
At this point, I'm having hard time running the test suites (most of the tests
failed when using "ant junit-all". I will check my configuration in order to
find why).
Sylvain
> 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.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.
