[luciddb-users] LucidDB 0.8.0 release is now available

[John V. S. <js...@gm...>]

Download links are available from http://www.luciddb.org, or from 
http://sourceforge.net/projects/luciddb.

The LucidDB installer still does not support automatic upgrade, so be
sure to install the new release in a new location if you already have an
old version installed.

There is a manual upgrade procedure:

http://docs.eigenbase.org/LucidDbUpgrade

However, due to some catalog model changes in 0.8.0, it will fail for 
the 0.7.4->0.8.0 path.  If you are relying on this procedure, let me 
know and I'll update that page with one-off CREATE OR REPLACE VIEW fixup 
instructions to be performed on the 0.7.4 instance before starting the 
upgrade.

Major new features in this release are warehouse labels and 
hot/incremental backup, inching us closer to "1.0" status (only two more 
tenths of a whole release number to go!).

The binary packages are still built with JDK 1.5, but from a source 
package, it is now possible to build with JDK 1.6, so give that a try if 
you are integrating LucidDB with other components which require a 1.6 JVM.

Incidentally, for anyone curious about the LucidDB/Eigenbase release 
procedure, I've documented it here:

http://pub.eigenbase.org/wiki/ReleaseProcedure

Changes since 0.7.4 include:

- add new feature for warehouse labels
- add new feature for hot/incremental/differential backup/restore
- fix timestamp fractional seconds formatting when cast to VARCHAR
- add new applib.contiguous_value_intervals UDX
- add new sys_root.test_data_server and
   sys_root.test_all_servers_for_wrapper system procedures for
   testing links to SQL/MED data servers
- add ext directories (e.g. for moodss) to distribution (LDB-189)
- fix uninitialized variable which could cause bogus values
   for page allocation performance counters (FNL-78)
- rename non-standard POW function to SQL:2003 standard POWER (FRG-329)
- improve join ordering to use column count when number of rows is the same
- fix for join order optimization when multiple join factors have same 
weight
- add fifo support to flaftile reader
- add Mondrian aggregate designer support
- suppress AWT workaround in distribution startup scripts (FRG-350)
- ignore semijoin candidates with poor selectivity
- fix validator to prevent duplicate aliases in the same FROM clause
- JDK 1.6 build support
- add table prefix mapping support to SQL/MED JDBC wrapper
- add JNDI data source and connection pool support to SQL/MED JDBC wrapper
- fix SQL/MED JDBC wrapper pushdown bug with WHERE boolean_column (FRG-339)
- optimize away redundant buffering for upserts, deletes, and self-inserts
- fix shutdown warning from loopback connections (FRG-345)
- TPC-H query phrasing refinements
- fix bug with default values in INSERT/MERGE with UNION source
- fix flatfile reader bug where csv header row has missing column names
- fix for correlated subqueries on SQL/MED JDBC foreign tables
- fix issues with UDX input restarts (FRG-331)
- improve agg-distinct rewrite to consolidate common subexpressions
- fix native code error message rendering (LDB-177)
- use statement-level queues for all warnings
- fix executor inefficiency from accidental Boost graph copying
- add support for NATURAL JOIN
- optimize away some redundant casts
- lucidDbAllocFile script usage/validation improvements
- improve optimizer to reorder index intersections by selectivity

JVS