db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "John H. Embretsen (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-3129) Create Demo code, showing how to create and use table functions.
Date Tue, 16 Oct 2007 08:40:51 GMT

    [ https://issues.apache.org/jira/browse/DERBY-3129?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12535200

John H. Embretsen commented on DERBY-3129:

I applied the patch and took the vtiDemo.sql script for a quick test drive. Although I probably
didn't get half of what these sample table functions are able to do and how they work during
my brief encounter, my impression is that they demonstrate some very useful and powerful features!

Is this demo supposed to be included in our (future) released bin-distributions? If so, more
detailed instructions for compiling the Java classes and running the demo should be included,
as well as references to more information/documentation (I probably didn't have to mention
this, but I did it just in case... ;) ).

For Derby developers the demo seems to work fine, at least after tuning the SQL script a little
(paths, urls) and making sure the MySQL example database is available as expected. A minor
inconvenience was that MySQL calls this database "world" [1], not "worlddb" as the URLs in
the script say, so I had to do another round of changing the MySQL connection URLs (or recreate
the db in MySQL).

I also found a minor inconsistency when changing the paths to the derby trunk: The script
comments say that it assumes to find the derby code at '/opt/DerbyTrunk', but the script also
referred to './trunk' at one point (at line 144, in the query for "how active were the committers
in 2006?"). After updating all path references to trunk, everything went fine.

Well done!

[1]: http://dev.mysql.com/doc/world-setup/en/world-setup.html

> Create Demo code, showing how to create and use table functions.
> ----------------------------------------------------------------
>                 Key: DERBY-3129
>                 URL: https://issues.apache.org/jira/browse/DERBY-3129
>             Project: Derby
>          Issue Type: Improvement
>          Components: Demos/Scripts
>    Affects Versions:
>            Reporter: Rick Hillegas
>            Assignee: Rick Hillegas
>         Attachments: derby-3129-sampleTableFunctions-aa.diff
> Create some useful, sample table functions.

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

View raw message