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