db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sylvain Leroux (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-3809) Add a SHOW FUNCTONS command to ij
Date Fri, 25 Sep 2009 10:14:16 GMT

     [ 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.


Mime
View raw message