db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Hillegas (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-4566) Make it possible to define variables in ij
Date Mon, 01 Mar 2010 14:49:05 GMT

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

Rick Hillegas commented on DERBY-4566:

Hi Sylvain. This is a very interesting topic. I think there are at least 2 separate use cases
in here:

1) Filtering and joining metadata results.

2) Using scalar variables to control branching and looping.

I think that (1) is largely addressed by the functions and table functions attached to DERBY-3973.
Those routines are more powerful than the SHOW commands. Some effort could be put into making
the DERBY-3973 routines always available.

I would support some limited effort around (2). In particular, I would like to be able to
declare integer variables, perform simple arithmetic on them, and use them to control a loop.
I have often wanted this capability in ij in order to populate tables for a test.


> Make it possible to define variables in ij
> ------------------------------------------
>                 Key: DERBY-4566
>                 URL: https://issues.apache.org/jira/browse/DERBY-4566
>             Project: Derby
>          Issue Type: Improvement
>          Components: Tools
>            Reporter: Sylvain Leroux
>            Assignee: Sylvain Leroux
> It would be nice to have a way in ij to store statement results in variables for later
> Notably, It would allow to use (meta)data obtained by some statements (such as SHOW ....)
beyond the simple display of the result. Moreover, it could be a first step toward extending
the scripting capabilities of ij.
> See http://old.nabble.com/IJ-scripting-(variables-in-IJ-)-td27290712.html
> Related to DERBY-4557

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

View raw message