[jira] Commented: (DERBY-3129) Create Demo code, showing how to create and use table functions.

["John H. Embretsen (JIRA)" <ji...@apache.org>]

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