RELEASE.txt

Mondrian 3.1.1.12687 production release notes
=============================================

Introduction
------------

Mondrian 3.1.1.12687 is a minor release version of the leading
open-source OLAP engine. To find out more about mondrian, go
to http://mondrian.pentaho.org.

Contents
--------

As usual, there are two distributions for this release:
 * mondrian-<version>.zip contains the FoodMart dataset in
   SQL and Access format
 * mondrian-<version>-derby.zip contains the FoodMart
   dataset as an Apache Derby database

Each distribution contains the full mondrian source code, as
mondrian-<version>-src.zip, documentation including
generated API documentation, and a web archive mondrian.war.
This web archive contains all classes and libraries (jars)
necessary to run mondrian.

This release runs on Java version 1.5 and higher. For
backwards compatibility on Java 1.4, substitute
mondrian-jdk14.jar for mondrian.jar, and add
retroweaver-rt-1.2.4.jar to your classpath.

For further installation instructions, see
http://mondrian.pentaho.org/documentation/installation.php
or the included file doc/installation.html.

Main functionality in this release
----------------------------------

 - Tuple Aggregate Support
 - Database Dialecting Architecture. Database dialects are
   now pluggable, which means that they can be added to the
   classpath and Mondrian will use the most appropriate one.
 - Infobright Dialect Support
 - General performance improvements (SQL generation and
   sorting algorithms)
 - Allow SSAS2005-compatible syntax for resolving names
   of dimensions, hierarchies, levels, members, and in
   particular multiple hierarchies in a
 dimension. Since
   this is a minor release, we wish to avoid breaking
   changes, so this functionality is off by default. To
   enable, set mondrian.olap.SsasCompatibleNaming=true.
 - Netezza Dialect (3.1.1)
 - Various Workbench changes (3.1.1) 

API changes from 3.0 to 3.1
---------------------------
 - High cardinality related array to list changes
 - Database dialect changes
 - AxisOrdinal changes. mondrian.olap.AxisOrdinal used to
   be an enum, is now an interface. Code that explicitly
   depends on this class will need to be recompiled.
 - Upgrade to olap4-0.9.7.145.

See CHANGES.txt for a list of all source code changes
since the previous release.

Bugs and feature requests fixed since mondrian-3.1.0-12477-RC1
--------------------------------------------------------------

Bugs:
MONDRIAN-7   - Heterogeneous axis gives wrong results
MONDRIAN-473 - Performance bug in RolapEvaluator.setContext (partial fix)
MONDRIAN-519 - ClassCastException: parent/child and no closure
MONDRIAN-524 - VB functions: expected primitive type, got java.lang.Object
MONDRIAN-528 - MySQL database identified as INFOBRIGHT
MONDRIAN-539 - Problem with the MID function getting last character in a string.
MONDRIAN-540 - Netezza is an UNKNOWN Dialect
MONDRIAN-550 - Performance bug with NON EMPTY and large axes

Bugs and feature requests fixed since mondrian-3.0.3
----------------------------------------------------

Bugs:
1971406 - perf regression from change for large dimensions
1998598 - Non empty function doesn't work for high
          cardinality
2046318 - olap4j driver should throw OlapException on
          validate error
2062790 - Inline tables do not work on Microsoft SQL Server
2118478 - periodstodate w/level ought not require dim of
          type
 time
2141337 - Roles and virtual cubes
2150537 - error deducing type of Ytd/Qtd/Mtd functions
          within Generate
2186217 - NPE for dimension with Join (patch attached)
2141503 - Strange SQL condition appears when executing query
2189467 - ParallelPeriod applied to Levels or StrToMember
          gives NPE
2026930 - MondrianOlap4jMember.getCaption() throws exception
2279539 - mondrian.xsd line 69 MemeberGrant -> MemberGrant
2414144 - Incorrect getting parent member in parent-child
          hierarchy
2489311 - BitKey.compareTo is inefficient
2488492 - Union between calc mem and head function throws
          exception
1961163 - NON EMPTY and Filter() breaking aggregate
          calculations
2527862 - Failed to get Hierarchy list for particular
          dimension
2384825 - ClassCastException when obtaining RolapCubeLevel
2207515 - Aggregates incorrect with grouping sets
2106108 - Schema Workbench setAllTables assumes
          {"TABLE","VIEW"} 
2561069 - Schema workbench JDBC Explorer does not work with
          Oracle
 10g
2613265 - readVirtualFile() can return the incorrect file
2645300 - Move Infobright dialect from EE to CE
2666196 - Performance degradation with change 11049
2684180 - mondrian.rolap.SqlTupleReader Swallows Exceptions
2688790 - Hierarchy Naming Compatibility issue
2138156 - Workbench Publish name issue
2138161 - Workbench Dimension selection issue
2153098 - Mondrian exceptions when clicking on Dimension
          in Workbench
2153653 - Database preferences not enforced when modified
          in Workbench
2208219 - Workbench fails if the Mondrian schema has a
          <view> <sql> element
2208312 - Mouse right click doesn�t work on MAC OS X or
          Linux

Feature Requests:
1579663 - Read tuples from aggregate tables
2155850 - Workbench Database Schema Option

Pentaho Related Bugs (found at jira.pentaho.com):

BISERVER-2379 - Workbench- The MDX Query window fails when
          connected to SQL server 2000
BISERVER-2491 - Mondrian: rollupPolicy=partial and queries
          to upper members don't work
BISERVER-2786 - Schema Workbench: Provide more information
          when schema is invalid due to invalid hierarchies
------------------------------------------------------------