[Mondrian] RE: Cron <jhyde at marmalade> nice sh --login /home/jhyde/open2/mondrian/testAll --nightly

Pappyn Bart Bart.Pappyn at vandewiele.com
Tue Mar 6 03:22:59 EST 2007


Julian,

The test is failing due to the fact that
mondrian.test.ExpDependencies=10 is set.

The first query :

            RolapResult r1 = (RolapResult) executeQuery(
            "select {[Store].[All Stores].[USA].[CA].[San Francisco]} on
columns from [Sales]");
            Util.discard(r1);
            s1 = sqlLogger.getSqlQueries().toString();
            sqlLogger.clear();
            // s1 should not be empty
            assertNotSame("[]", s1);

Results in 4 database queries :

select "store"."store_country" from "store" as "store" where
UPPER("store"."store_country") = UPPER('USA') group by
"store"."store_country" order by "store"."store_country" ASC, 

select "store"."store_state" from "store" as "store" where
"store"."store_country" = 'USA' and UPPER("store"."store_state") =
UPPER('CA') group by "store"."store_state" order by
"store"."store_state" ASC, 

select "store"."store_city" from "store" as "store" where
"store"."store_state" = 'CA' and UPPER("store"."store_city") =
UPPER('San Francisco') group by "store"."store_city" order by
"store"."store_city" ASC, 

select "store"."store_city" as "c0", "store"."store_state" as "c1",
"time_by_day"."the_year" as "c2", sum("sales_fact_1997"."unit_sales") as
"m0" from "store" as "store", "sales_fact_1997" as "sales_fact_1997",
"time_by_day" as "time_by_day" where "sales_fact_1997"."store_id" =
"store"."store_id" and "store"."store_city" = 'San Francisco' and
"store"."store_state" = 'CA' and "sales_fact_1997"."time_id" =
"time_by_day"."time_id" and "time_by_day"."the_year" = 1997 group by
"store"."store_city", "store"."store_state", "time_by_day"."the_year", 
select "customer"."marital_status" from "customer" as "customer" group
by "customer"."marital_status" order by "customer"."marital_status" ASC

The second query (the test expects that no more queries will be executed
and results will come from cache) :

            // Run query again, to make sure only cache is used
            RolapResult r2 = (RolapResult) executeQuery(
            "select {[Store].[All Stores].[USA].[CA].[San Francisco]} on
columns from [Sales]");
            Util.discard(r2);
            s2 = sqlLogger.getSqlQueries().toString();
            sqlLogger.clear();
            assertEquals("[]", s2); 

results in 1 extra query, but this query is not issued in the first mdx
query :

select "promotion"."media_type" from "promotion" as "promotion" group by
"promotion"."media_type" order by "promotion"."media_type" ASC

Is this normal behavior ?  If so, I will disable
mondrian.test.ExpDependencies at the beginning of the test and restore
it
afterwards.

Bart

-----Original Message-----
From: Julian Hyde [mailto:julianhyde at gmail.com] 
Sent: woensdag 28 februari 2007 18:38
To: Pappyn Bart
Cc: mondrian at pentaho.org
Subject: FW: Cron <jhyde at marmalade> nice sh --login
/home/jhyde/open2/mondrian/testAll --nightly

Bart,

Can you look at why testDataSourceChangeListenerPlugin is failing in
this particular configuration? The configuration is: oracle, jdk 1.5,
mondrian.test.ExpDependencies=10 mondrian.test.random.seed=-1
mondrian.expCache.enable=false. It's succeeding in most other
configurations.

You can ignore testCalculatedMeasureAcrossCubes.

Julian

===================
Wed Feb 28 04:39:40 PST 2007
Running test with JDK=jdk1.5 database=oracle props={
mondrian.test.ExpDependencies=10 mondrian.test.random.seed=-1
mondrian.expCache.enable=false} build=true
Buildfile: build.xml
Overriding previous definition of reference to jdk

clean:
   [delete] Deleting 1393 files from /home/jhyde/open2/mondrian/classes
   [delete] Deleting 173 files from
/home/jhyde/open2/mondrian/testclasses
   [delete] Deleting 12 files from /home/jhyde/open2/mondrian
   [delete] Deleted 1 directory from /home/jhyde/open2/mondrian/build

prepare:
    [mkdir] Created dir: /home/jhyde/open2/mondrian/build

parser:
  [javacup] Opening files...
  [javacup] Parsing specification from
/home/jhyde/open2/mondrian/src/main/mondrian/olap/Parser.cup...
  [javacup] Checking specification...
  [javacup] Warning: Terminal "UNKNOWN" was declared but never used
  [javacup] Warning: Non terminal "unsigned_integer" was declared but
never used
  [javacup] Building parse tables...
  [javacup]   Computing non-terminal nullability...
  [javacup]   Computing first sets...
  [javacup]   Building state machine...
  [javacup]   Filling in tables...
  [javacup] *** Reduce/Reduce conflict found in state #99
  [javacup]   between value_expression_primary ::= NULL (*) 
  [javacup]   and     term3 ::= term3 IS NULL (*) 
  [javacup]   under symbols: {EOF, AND, AS, CELL, DIMENSION, ELSE, END,
IN, IS, MATCHES, MEMBER, NOT, ON, OR, PROPERTIES, SELECT, SET, THEN,
WHEN, XOR, COLON, COMMA, EQ, GE, GT, LE, LT, NE, RBRACE, RPAREN}
  [javacup]   Resolved in favor of the second production.

  [javacup] *** Shift/Reduce conflict found in state #99
  [javacup]   between value_expression_primary ::= NULL (*) 
  [javacup]   under symbol EOF
  [javacup]   Resolved in favor of shifting.

  [javacup] *** Shift/Reduce conflict found in state #99
  [javacup]   between value_expression_primary ::= NULL (*) 
  [javacup]   under symbol AND
  [javacup]   Resolved in favor of shifting.

  [javacup] *** Shift/Reduce conflict found in state #99
  [javacup]   between value_expression_primary ::= NULL (*) 
  [javacup]   under symbol AS
  [javacup]   Resolved in favor of shifting.

  [javacup] *** Shift/Reduce conflict found in state #99
  [javacup]   between value_expression_primary ::= NULL (*) 
  [javacup]   under symbol CELL
  [javacup]   Resolved in favor of shifting.

  [javacup] *** Shift/Reduce conflict found in state #99
  [javacup]   between value_expression_primary ::= NULL (*) 
  [javacup]   under symbol DIMENSION
  [javacup]   Resolved in favor of shifting.

  [javacup] *** Shift/Reduce conflict found in state #99
  [javacup]   between value_expression_primary ::= NULL (*) 
  [javacup]   under symbol ELSE
  [javacup]   Resolved in favor of shifting.

  [javacup] *** Shift/Reduce conflict found in state #99
  [javacup]   between value_expression_primary ::= NULL (*) 
  [javacup]   under symbol END
  [javacup]   Resolved in favor of shifting.

  [javacup] *** Shift/Reduce conflict found in state #99
  [javacup]   between value_expression_primary ::= NULL (*) 
  [javacup]   under symbol IN
  [javacup]   Resolved in favor of shifting.

  [javacup] *** Shift/Reduce conflict found in state #99
  [javacup]   between value_expression_primary ::= NULL (*) 
  [javacup]   under symbol IS
  [javacup]   Resolved in favor of shifting.

  [javacup] *** Shift/Reduce conflict found in state #99
  [javacup]   between value_expression_primary ::= NULL (*) 
  [javacup]   under symbol MATCHES
  [javacup]   Resolved in favor of shifting.

  [javacup] *** Shift/Reduce conflict found in state #99
  [javacup]   between value_expression_primary ::= NULL (*) 
  [javacup]   under symbol MEMBER
  [javacup]   Resolved in favor of shifting.

  [javacup] *** Shift/Reduce conflict found in state #99
  [javacup]   between value_expression_primary ::= NULL (*) 
  [javacup]   under symbol NOT
  [javacup]   Resolved in favor of shifting.

  [javacup] *** Shift/Reduce conflict found in state #99
  [javacup]   between value_expression_primary ::= NULL (*) 
  [javacup]   under symbol ON
  [javacup]   Resolved in favor of shifting.

  [javacup] *** Shift/Reduce conflict found in state #99
  [javacup]   between value_expression_primary ::= NULL (*) 
  [javacup]   under symbol OR
  [javacup]   Resolved in favor of shifting.

  [javacup] *** Shift/Reduce conflict found in state #99
  [javacup]   between value_expression_primary ::= NULL (*) 
  [javacup]   under symbol PROPERTIES
  [javacup]   Resolved in favor of shifting.

  [javacup] *** Shift/Reduce conflict found in state #99
  [javacup]   between value_expression_primary ::= NULL (*) 
  [javacup]   under symbol SELECT
  [javacup]   Resolved in favor of shifting.

  [javacup] *** Shift/Reduce conflict found in state #99
  [javacup]   between value_expression_primary ::= NULL (*) 
  [javacup]   under symbol SET
  [javacup]   Resolved in favor of shifting.

  [javacup] *** Shift/Reduce conflict found in state #99
  [javacup]   between value_expression_primary ::= NULL (*) 
  [javacup]   under symbol THEN
  [javacup]   Resolved in favor of shifting.

  [javacup] *** Shift/Reduce conflict found in state #99
  [javacup]   between value_expression_primary ::= NULL (*) 
  [javacup]   under symbol WHEN
  [javacup]   Resolved in favor of shifting.

  [javacup] *** Shift/Reduce conflict found in state #99
  [javacup]   between value_expression_primary ::= NULL (*) 
  [javacup]   under symbol XOR
  [javacup]   Resolved in favor of shifting.

  [javacup] *** Shift/Reduce conflict found in state #99
  [javacup]   between value_expression_primary ::= NULL (*) 
  [javacup]   under symbol COLON
  [javacup]   Resolved in favor of shifting.

  [javacup] *** Shift/Reduce conflict found in state #99
  [javacup]   between value_expression_primary ::= NULL (*) 
  [javacup]   under symbol COMMA
  [javacup]   Resolved in favor of shifting.

  [javacup] *** Shift/Reduce conflict found in state #99
  [javacup]   between value_expression_primary ::= NULL (*) 
  [javacup]   under symbol EQ
  [javacup]   Resolved in favor of shifting.

  [javacup] *** Shift/Reduce conflict found in state #99
  [javacup]   between value_expression_primary ::= NULL (*) 
  [javacup]   under symbol GE
  [javacup]   Resolved in favor of shifting.

  [javacup] *** Shift/Reduce conflict found in state #99
  [javacup]   between value_expression_primary ::= NULL (*) 
  [javacup]   under symbol GT
  [javacup]   Resolved in favor of shifting.

  [javacup] *** Shift/Reduce conflict found in state #99
  [javacup]   between value_expression_primary ::= NULL (*) 
  [javacup]   under symbol LE
  [javacup]   Resolved in favor of shifting.

  [javacup] *** Shift/Reduce conflict found in state #99
  [javacup]   between value_expression_primary ::= NULL (*) 
  [javacup]   under symbol LT
  [javacup]   Resolved in favor of shifting.

  [javacup] *** Shift/Reduce conflict found in state #99
  [javacup]   between value_expression_primary ::= NULL (*) 
  [javacup]   under symbol NE
  [javacup]   Resolved in favor of shifting.

  [javacup] *** Shift/Reduce conflict found in state #99
  [javacup]   between value_expression_primary ::= NULL (*) 
  [javacup]   under symbol RBRACE
  [javacup]   Resolved in favor of shifting.

  [javacup] *** Shift/Reduce conflict found in state #99
  [javacup]   between value_expression_primary ::= NULL (*) 
  [javacup]   under symbol RPAREN
  [javacup]   Resolved in favor of shifting.

  [javacup] *** Shift/Reduce conflict found in state #99
  [javacup]   between term3 ::= term3 IS NULL (*) 
  [javacup]   under symbol EOF
  [javacup]   Resolved in favor of shifting.

  [javacup] *** Shift/Reduce conflict found in state #99
  [javacup]   between term3 ::= term3 IS NULL (*) 
  [javacup]   under symbol AND
  [javacup]   Resolved in favor of shifting.

  [javacup] *** Shift/Reduce conflict found in state #99
  [javacup]   between term3 ::= term3 IS NULL (*) 
  [javacup]   under symbol AS
  [javacup]   Resolved in favor of shifting.

  [javacup] *** Shift/Reduce conflict found in state #99
  [javacup]   between term3 ::= term3 IS NULL (*) 
  [javacup]   under symbol CELL
  [javacup]   Resolved in favor of shifting.

  [javacup] *** Shift/Reduce conflict found in state #99
  [javacup]   between term3 ::= term3 IS NULL (*) 
  [javacup]   under symbol DIMENSION
  [javacup]   Resolved in favor of shifting.

  [javacup] *** Shift/Reduce conflict found in state #99
  [javacup]   between term3 ::= term3 IS NULL (*) 
  [javacup]   under symbol ELSE
  [javacup]   Resolved in favor of shifting.

  [javacup] *** Shift/Reduce conflict found in state #99
  [javacup]   between term3 ::= term3 IS NULL (*) 
  [javacup]   under symbol END
  [javacup]   Resolved in favor of shifting.

  [javacup] *** Shift/Reduce conflict found in state #99
  [javacup]   between term3 ::= term3 IS NULL (*) 
  [javacup]   under symbol IN
  [javacup]   Resolved in favor of shifting.

  [javacup] *** Shift/Reduce conflict found in state #99
  [javacup]   between term3 ::= term3 IS NULL (*) 
  [javacup]   under symbol IS
  [javacup]   Resolved in favor of shifting.

  [javacup] *** Shift/Reduce conflict found in state #99
  [javacup]   between term3 ::= term3 IS NULL (*) 
  [javacup]   under symbol MATCHES
  [javacup]   Resolved in favor of shifting.

  [javacup] *** Shift/Reduce conflict found in state #99
  [javacup]   between term3 ::= term3 IS NULL (*) 
  [javacup]   under symbol MEMBER
  [javacup]   Resolved in favor of shifting.

  [javacup] *** Shift/Reduce conflict found in state #99
  [javacup]   between term3 ::= term3 IS NULL (*) 
  [javacup]   under symbol NOT
  [javacup]   Resolved in favor of shifting.

  [javacup] *** Shift/Reduce conflict found in state #99
  [javacup]   between term3 ::= term3 IS NULL (*) 
  [javacup]   under symbol ON
  [javacup]   Resolved in favor of shifting.

  [javacup] *** Shift/Reduce conflict found in state #99
  [javacup]   between term3 ::= term3 IS NULL (*) 
  [javacup]   under symbol OR
  [javacup]   Resolved in favor of shifting.

  [javacup] *** Shift/Reduce conflict found in state #99
  [javacup]   between term3 ::= term3 IS NULL (*) 
  [javacup]   under symbol PROPERTIES
  [javacup]   Resolved in favor of shifting.

  [javacup] *** Shift/Reduce conflict found in state #99
  [javacup]   between term3 ::= term3 IS NULL (*) 
  [javacup]   under symbol SELECT
  [javacup]   Resolved in favor of shifting.

  [javacup] *** Shift/Reduce conflict found in state #99
  [javacup]   between term3 ::= term3 IS NULL (*) 
  [javacup]   under symbol SET
  [javacup]   Resolved in favor of shifting.

  [javacup] *** Shift/Reduce conflict found in state #99
  [javacup]   between term3 ::= term3 IS NULL (*) 
  [javacup]   under symbol THEN
  [javacup]   Resolved in favor of shifting.

  [javacup] *** Shift/Reduce conflict found in state #99
  [javacup]   between term3 ::= term3 IS NULL (*) 
  [javacup]   under symbol WHEN
  [javacup]   Resolved in favor of shifting.

  [javacup] *** Shift/Reduce conflict found in state #99
  [javacup]   between term3 ::= term3 IS NULL (*) 
  [javacup]   under symbol XOR
  [javacup]   Resolved in favor of shifting.

  [javacup] *** Shift/Reduce conflict found in state #99
  [javacup]   between term3 ::= term3 IS NULL (*) 
  [javacup]   under symbol COLON
  [javacup]   Resolved in favor of shifting.

  [javacup] *** Shift/Reduce conflict found in state #99
  [javacup]   between term3 ::= term3 IS NULL (*) 
  [javacup]   under symbol COMMA
  [javacup]   Resolved in favor of shifting.

  [javacup] *** Shift/Reduce conflict found in state #99
  [javacup]   between term3 ::= term3 IS NULL (*) 
  [javacup]   under symbol EQ
  [javacup]   Resolved in favor of shifting.

  [javacup] *** Shift/Reduce conflict found in state #99
  [javacup]   between term3 ::= term3 IS NULL (*) 
  [javacup]   under symbol GE
  [javacup]   Resolved in favor of shifting.

  [javacup] *** Shift/Reduce conflict found in state #99
  [javacup]   between term3 ::= term3 IS NULL (*) 
  [javacup]   under symbol GT
  [javacup]   Resolved in favor of shifting.

  [javacup] *** Shift/Reduce conflict found in state #99
  [javacup]   between term3 ::= term3 IS NULL (*) 
  [javacup]   under symbol LE
  [javacup]   Resolved in favor of shifting.

  [javacup] *** Shift/Reduce conflict found in state #99
  [javacup]   between term3 ::= term3 IS NULL (*) 
  [javacup]   under symbol LT
  [javacup]   Resolved in favor of shifting.

  [javacup] *** Shift/Reduce conflict found in state #99
  [javacup]   between term3 ::= term3 IS NULL (*) 
  [javacup]   under symbol NE
  [javacup]   Resolved in favor of shifting.

  [javacup] *** Shift/Reduce conflict found in state #99
  [javacup]   between term3 ::= term3 IS NULL (*) 
  [javacup]   under symbol RBRACE
  [javacup]   Resolved in favor of shifting.

  [javacup] *** Shift/Reduce conflict found in state #99
  [javacup]   between term3 ::= term3 IS NULL (*) 
  [javacup]   under symbol RPAREN
  [javacup]   Resolved in favor of shifting.

  [javacup]   Checking for non-reduced productions...
  [javacup] Writing parser...
  [javacup] Closing files...
  [javacup] ------- CUP v0.10k Parser Generation Summary -------
  [javacup]   0 errors and 63 warnings
  [javacup]   56 terminals, 60 non-terminals, and 125 productions
declared, 
  [javacup]   producing 194 unique parse states.
  [javacup]   2 terminals declared but not used.
  [javacup]   0 non-terminals declared but not used.
  [javacup]   0 productions never reduced.
  [javacup]   61 conflicts detected (61 expected).
  [javacup]   Code written to "Parser.java", and "ParserSym.java".
  [javacup] ----------------------------------------------------
(v0.10k)

generate.resources:
    [javac] Compiling 7 source files to
/home/jhyde/open2/mondrian/classes
   [resgen] Generating
/home/jhyde/open2/mondrian/src/main/mondrian/resource/MondrianResource.j
ava
   [resgen] Generating
/home/jhyde/open2/mondrian/classes/mondrian/resource/MondrianResource.pr
operties
   [resgen] Generating
/home/jhyde/open2/mondrian/src/main/mondrian/resource/MondrianResource_e
n_US.java
   [resgen] Generating
/home/jhyde/open2/mondrian/classes/mondrian/resource/MondrianResource_en
_US.properties
   [resgen] Generating
/home/jhyde/open2/mondrian/src/main/mondrian/resource/MondrianResource_d
e_DE.java
   [resgen] Generating
/home/jhyde/open2/mondrian/classes/mondrian/resource/MondrianResource_de
_DE.properties
   [resgen] Generating
/home/jhyde/open2/mondrian/src/main/mondrian/resource/MondrianResource_d
e.java
   [resgen] Generating
/home/jhyde/open2/mondrian/classes/mondrian/resource/MondrianResource_de
.properties
   [resgen] Generating
/home/jhyde/open2/mondrian/src/main/mondrian/resource/MondrianResource_e
s_ES.java
   [resgen] Generating
/home/jhyde/open2/mondrian/classes/mondrian/resource/MondrianResource_es
_ES.properties

def:
   [xomgen] Writing src/main/mondrian/olap/mondrian.dtd
   [xomgen] Writing src/main/mondrian/olap/MondrianDef.java
   [xomgen] Done
     [copy] Copying 1 file to /home/jhyde/open2/mondrian/lib
     [copy] Copying 1 file to /home/jhyde/open2/mondrian/lib
   [xomgen] Writing src/main/mondrian/xmla/datasourcesconfig.dtd
   [xomgen] Writing src/main/mondrian/xmla/DataSourcesConfig.java
   [xomgen] Done
     [copy] Copying 1 file to /home/jhyde/open2/mondrian/lib

compile.java:
    [javac] Compiling 425 source files to
/home/jhyde/open2/mondrian/classes
    [javac] Note: Some input files use or override a deprecated API.
    [javac] Note: Recompile with -Xlint:deprecation for details.
    [javac] Note: Some input files use unchecked or unsafe operations.
    [javac] Note: Recompile with -Xlint:unchecked for details.

compile:

prepare:

parser:
  [javacup] Files are up to date.

generate.resources:
   [resgen]
/home/jhyde/open2/mondrian/src/main/mondrian/resource/MondrianResource.j
ava is up to date
   [resgen]
/home/jhyde/open2/mondrian/classes/mondrian/resource/MondrianResource.pr
operties is up to date
   [resgen]
/home/jhyde/open2/mondrian/src/main/mondrian/resource/MondrianResource_e
n_US.java is up to date
   [resgen]
/home/jhyde/open2/mondrian/classes/mondrian/resource/MondrianResource_en
_US.properties is up to date
   [resgen]
/home/jhyde/open2/mondrian/src/main/mondrian/resource/MondrianResource_d
e_DE.java is up to date
   [resgen]
/home/jhyde/open2/mondrian/classes/mondrian/resource/MondrianResource_de
_DE.properties is up to date
   [resgen]
/home/jhyde/open2/mondrian/src/main/mondrian/resource/MondrianResource_d
e.java is up to date
   [resgen]
/home/jhyde/open2/mondrian/classes/mondrian/resource/MondrianResource_de
.properties is up to date
   [resgen]
/home/jhyde/open2/mondrian/src/main/mondrian/resource/MondrianResource_e
s_ES.java is up to date
   [resgen]
/home/jhyde/open2/mondrian/classes/mondrian/resource/MondrianResource_es
_ES.properties is up to date

def:

compile.java:

compile:

info:
     [echo]
==============================================================
     [echo] | Mondrian configuration info
|
     [echo]
==============================================================
     [echo] project.location      = /home/jhyde/open2/mondrian
     [echo] jdk.home              = /usr/local/jdk1.5.0_10
     [echo] catalina.home         = ${env.CATALINA_HOME}
     [echo] junit.home            = ${env.JUNIT_HOME}
     [echo] mondrian.foodmart.catalogURL =
file:/home/jhyde/open2/mondrian/demo/FoodMart.xml
     [echo] mondrian.foodmart.jdbcURL    =
jdbc:oracle:thin:foodmart/foodmart@//marmalade.hydromatic.net:1521/XE
     [echo] mondrian.jdbcDrivers         = oracle.jdbc.OracleDriver
     [echo]
==============================================================

compile.tests:
    [javac] Compiling 82 source files to
/home/jhyde/open2/mondrian/testclasses
    [javac] Note: Some input files use or override a deprecated API.
    [javac] Note: Recompile with -Xlint:deprecation for details.
    [javac] Note: Some input files use unchecked or unsafe operations.
    [javac] Note: Recompile with -Xlint:unchecked for details.

set.connectString:

test:
Overriding previous definition of reference to jdk

set.connectString:

test-nobuild:
     [echo] Connecting to
jdbc:oracle:thin:foodmart/foodmart@//marmalade.hydromatic.net:1521/XE
     [echo] Connect String:
Provider=mondrian;Jdbc=jdbc:oracle:thin:foodmart/foodmart@//marmalade.hy
dromatic.net:1521/XE;JdbcUser=foodmart;JdbcPassword=foodmart;Catalog=fil
e:demo/FoodMart.xml;JdbcDrivers=oracle.jdbc.OracleDriver;RoleXX='Califor
nia manager';
     [java] log4j:WARN No appenders could be found for logger
(mondrian.olap.MondrianProperties).
     [java] log4j:WARN Please initialize the log4j system properly.
     [java] testName: 
     [java] testClass: 
     [java] java.version: 1.5.0_10
     [java] Iterations=1
     [java] All 1 thread(s) started.

     [java] [0] ........................................
     [java] [40] ........................................
     [java] [80] ........................................
     [java] [120] ........................................
     [java] [160] ........................................
     [java] [200] ........................................
     [java] [240] ........................................
     [java] [280] ........................................
     [java] [320] ........................................
     [java] [360] ........................................
     [java] [400] ........................................
     [java] [440] ........................................
     [java] [480] ........................................
     [java] [520] ........................................
     [java] [560] ........................................
     [java] [600] ........................................
     [java] [640] ........................................
     [java] [680] ........................................
     [java] [720] .............F...........................
     [java] [760] ........................................
     [java] [800] ........................................
     [java] [840] ........................................
     [java] [880] ........................................
     [java] [920] ........................................
     [java] [960] ........................................
     [java] [1000] ........................................
     [java] [1040] ............................F............
     [java] [1080] ........................................
     [java] [1120] ........................................
     [java] [1160] ......................
     [java] There were 2 failures:
     [java] 1)
testCalculatedMeasureAcrossCubes(mondrian.rolap.VirtualCubeTest)junit.fr
amework.ComparisonFailure: Expected:
     [java] Axis #0:
     [java] {}
     [java] Axis #1:
     [java] {[Measures].[Unit Sales]}
     [java] {[Measures].[Units Shipped]}
     [java] {[Measures].[Shipped per Ordered]}
     [java] {[Measures].[Profit per Unit Shipped]}
     [java] Axis #2:
     [java] {[Product].[All Products].[Drink], [Time].[1997].[Q1]}
     [java] {[Product].[All Products].[Drink], [Time].[1997].[Q2]}
     [java] {[Product].[All Products].[Drink], [Time].[1997].[Q3]}
     [java] {[Product].[All Products].[Drink], [Time].[1997].[Q4]}
     [java] {[Product].[All Products].[Food], [Time].[1997].[Q1]}
     [java] {[Product].[All Products].[Food], [Time].[1997].[Q2]}
     [java] {[Product].[All Products].[Food], [Time].[1997].[Q3]}
     [java] {[Product].[All Products].[Food], [Time].[1997].[Q4]}
     [java] {[Product].[All Products].[Non-Consumable],
[Time].[1997].[Q1]}
     [java] {[Product].[All Products].[Non-Consumable],
[Time].[1997].[Q2]}
     [java] {[Product].[All Products].[Non-Consumable],
[Time].[1997].[Q3]}
     [java] {[Product].[All Products].[Non-Consumable],
[Time].[1997].[Q4]}
     [java] Row #0: 5,976
     [java] Row #0: 4637.0
     [java] Row #0: 77.59%
     [java] Row #0: $1.50
     [java] Row #1: 5,895
     [java] Row #1: 4501.0
     [java] Row #1: 76.35%
     [java] Row #1: $1.60
     [java] Row #2: 6,065
     [java] Row #2: 6258.0
     [java] Row #2: 103.18%
     [java] Row #2: $1.15
     [java] Row #3: 6,661
     [java] Row #3: 5802.0
     [java] Row #3: 87.10%
     [java] Row #3: $1.38
     [java] Row #4: 47,809
     [java] Row #4: 37153.0
     [java] Row #4: 77.71%
     [java] Row #4: $1.64
     [java] Row #5: 44,825
     [java] Row #5: 35459.0
     [java] Row #5: 79.11%
     [java] Row #5: $1.62
     [java] Row #6: 47,440
     [java] Row #6: 41545.0
     [java] Row #6: 87.57%
     [java] Row #6: $1.47
     [java] Row #7: 51,866
     [java] Row #7: 34706.0
     [java] Row #7: 66.91%
     [java] Row #7: $1.91
     [java] Row #8: 12,506
     [java] Row #8: 9161.0
     [java] Row #8: 73.25%
     [java] Row #8: $1.76
     [java] Row #9: 11,890
     [java] Row #9: 9227.0
     [java] Row #9: 77.60%
     [java] Row #9: $1.65
     [java] Row #10: 12,343
     [java] Row #10: 9986.0
     [java] Row #10: 80.90%
     [java] Row #10: $1.59
     [java] Row #11: 13,497
     [java] Row #11: 9291.0
     [java] Row #11: 68.84%
     [java] Row #11: $1.86

     [java] Actual:
     [java] Axis #0:
     [java] {}
     [java] Axis #1:
     [java] {[Measures].[Unit Sales]}
     [java] {[Measures].[Units Shipped]}
     [java] {[Measures].[Shipped per Ordered]}
     [java] {[Measures].[Profit per Unit Shipped]}
     [java] Axis #2:
     [java] {[Product].[All Products].[Drink], [Time].[1997].[Q1]}
     [java] {[Product].[All Products].[Drink], [Time].[1997].[Q2]}
     [java] {[Product].[All Products].[Drink], [Time].[1997].[Q3]}
     [java] {[Product].[All Products].[Drink], [Time].[1997].[Q4]}
     [java] {[Product].[All Products].[Food], [Time].[1997].[Q1]}
     [java] {[Product].[All Products].[Food], [Time].[1997].[Q2]}
     [java] {[Product].[All Products].[Food], [Time].[1997].[Q3]}
     [java] {[Product].[All Products].[Food], [Time].[1997].[Q4]}
     [java] {[Product].[All Products].[Non-Consumable],
[Time].[1997].[Q1]}
     [java] {[Product].[All Products].[Non-Consumable],
[Time].[1997].[Q2]}
     [java] {[Product].[All Products].[Non-Consumable],
[Time].[1997].[Q3]}
     [java] {[Product].[All Products].[Non-Consumable],
[Time].[1997].[Q4]}
     [java] Row #0: 
     [java] Row #0: 4637.0
     [java] Row #0: 
     [java] Row #0: $1.50
     [java] Row #1: 
     [java] Row #1: 4501.0
     [java] Row #1: 
     [java] Row #1: $1.60
     [java] Row #2: 
     [java] Row #2: 6258.0
     [java] Row #2: 
     [java] Row #2: $1.15
     [java] Row #3: 
     [java] Row #3: 5802.0
     [java] Row #3: 
     [java] Row #3: $1.38
     [java] Row #4: 
     [java] Row #4: 37153.0
     [java] Row #4: 
     [java] Row #4: $1.64
     [java] Row #5: 
     [java] Row #5: 35459.0
     [java] Row #5: 
     [java] Row #5: $1.62
     [java] Row #6: 
     [java] Row #6: 41545.0
     [java] Row #6: 
     [java] Row #6: $1.47
     [java] Row #7: 
     [java] Row #7: 34706.0
     [java] Row #7: 
     [java] Row #7: $1.91
     [java] Row #8: 
     [java] Row #8: 9161.0
     [java] Row #8: 
     [java] Row #8: $1.76
     [java] Row #9: 
     [java] Row #9: 9227.0
     [java] Row #9: 
     [java] Row #9: $1.65
     [java] Row #10: 
     [java] Row #10: 9986.0
     [java] Row #10: 
     [java] Row #10: $1.59
     [java] Row #11: 
     [java] Row #11: 9291.0
     [java] Row #11: 
     [java] Row #11: $1.86

     [java] Actual java:
     [java] fold(
     [java] "Axis #0:\n" +
     [java] "{}\n" +
     [java] "Axis #1:\n" +
     [java] "{[Measures].[Unit Sales]}\n" +
     [java] "{[Measures].[Units Shipped]}\n" +
     [java] "{[Measures].[Shipped per Ordered]}\n" +
     [java] "{[Measures].[Profit per Unit Shipped]}\n" +
     [java] "Axis #2:\n" +
     [java] "{[Product].[All Products].[Drink], [Time].[1997].[Q1]}\n" +
     [java] "{[Product].[All Products].[Drink], [Time].[1997].[Q2]}\n" +
     [java] "{[Product].[All Products].[Drink], [Time].[1997].[Q3]}\n" +
     [java] "{[Product].[All Products].[Drink], [Time].[1997].[Q4]}\n" +
     [java] "{[Product].[All Products].[Food], [Time].[1997].[Q1]}\n" +
     [java] "{[Product].[All Products].[Food], [Time].[1997].[Q2]}\n" +
     [java] "{[Product].[All Products].[Food], [Time].[1997].[Q3]}\n" +
     [java] "{[Product].[All Products].[Food], [Time].[1997].[Q4]}\n" +
     [java] "{[Product].[All Products].[Non-Consumable],
[Time].[1997].[Q1]}\n" +
     [java] "{[Product].[All Products].[Non-Consumable],
[Time].[1997].[Q2]}\n" +
     [java] "{[Product].[All Products].[Non-Consumable],
[Time].[1997].[Q3]}\n" +
     [java] "{[Product].[All Products].[Non-Consumable],
[Time].[1997].[Q4]}\n" +
     [java] "Row #0: \n" +
     [java] "Row #0: 4637.0\n" +
     [java] "Row #0: \n" +
     [java] "Row #0: $1.50\n" +
     [java] "Row #1: \n" +
     [java] "Row #1: 4501.0\n" +
     [java] "Row #1: \n" +
     [java] "Row #1: $1.60\n" +
     [java] "Row #2: \n" +
     [java] "Row #2: 6258.0\n" +
     [java] "Row #2: \n" +
     [java] "Row #2: $1.15\n" +
     [java] "Row #3: \n" +
     [java] "Row #3: 5802.0\n" +
     [java] "Row #3: \n" +
     [java] "Row #3: $1.38\n" +
     [java] "Row #4: \n" +
     [java] "Row #4: 37153.0\n" +
     [java] "Row #4: \n" +
     [java] "Row #4: $1.64\n" +
     [java] "Row #5: \n" +
     [java] "Row #5: 35459.0\n" +
     [java] "Row #5: \n" +
     [java] "Row #5: $1.62\n" +
     [java] "Row #6: \n" +
     [java] "Row #6: 41545.0\n" +
     [java] "Row #6: \n" +
     [java] "Row #6: $1.47\n" +
     [java] "Row #7: \n" +
     [java] "Row #7: 34706.0\n" +
     [java] "Row #7: \n" +
     [java] "Row #7: $1.91\n" +
     [java] "Row #8: \n" +
     [java] "Row #8: 9161.0\n" +
     [java] "Row #8: \n" +
     [java] "Row #8: $1.76\n" +
     [java] "Row #9: \n" +
     [java] "Row #9: 9227.0\n" +
     [java] "Row #9: \n" +
     [java] "Row #9: $1.65\n" +
     [java] "Row #10: \n" +
     [java] "Row #10: 9986.0\n" +
     [java] "Row #10: \n" +
     [java] "Row #10: $1.59\n" +
     [java] "Row #11: \n" +
     [java] "Row #11: 9291.0\n" +
     [java] "Row #11: \n" +
     [java] "Row #11: $1.86\n")
     [java]  expected:<...5,976
     [java] Row #0: 4637.0
     [java] Row #0: 77.59%
     [java] Row #0: $1.50
     [java] Row #1: 5,895
     [java] Row #1: 4501.0
     [java] Row #1: 76.35%
     [java] Row #1: $1.60
     [java] Row #2: 6,065
     [java] Row #2: 6258.0
     [java] Row #2: 103.18%
     [java] Row #2: $1.15
     [java] Row #3: 6,661
     [java] Row #3: 5802.0
     [java] Row #3: 87.10%
     [java] Row #3: $1.38
     [java] Row #4: 47,809
     [java] Row #4: 37153.0
     [java] Row #4: 77.71%
     [java] Row #4: $1.64
     [java] Row #5: 44,825
     [java] Row #5: 35459.0
     [java] Row #5: 79.11%
     [java] Row #5: $1.62
     [java] Row #6: 47,440
     [java] Row #6: 41545.0
     [java] Row #6: 87.57%
     [java] Row #6: $1.47
     [java] Row #7: 51,866
     [java] Row #7: 34706.0
     [java] Row #7: 66.91%
     [java] Row #7: $1.91
     [java] Row #8: 12,506
     [java] Row #8: 9161.0
     [java] Row #8: 73.25%
     [java] Row #8: $1.76
     [java] Row #9: 11,890
     [java] Row #9: 9227.0
     [java] Row #9: 77.60%
     [java] Row #9: $1.65
     [java] Row #10: 12,343
     [java] Row #10: 9986.0
     [java] Row #10: 80.90%
     [java] Row #10: $1.59
     [java] Row #11: 13,497
     [java] Row #11: 9291.0
     [java] Row #11: 68.84%...> but was:<...
     [java] Row #0: 4637.0
     [java] Row #0: 
     [java] Row #0: $1.50
     [java] Row #1: 
     [java] Row #1: 4501.0
     [java] Row #1: 
     [java] Row #1: $1.60
     [java] Row #2: 
     [java] Row #2: 6258.0
     [java] Row #2: 
     [java] Row #2: $1.15
     [java] Row #3: 
     [java] Row #3: 5802.0
     [java] Row #3: 
     [java] Row #3: $1.38
     [java] Row #4: 
     [java] Row #4: 37153.0
     [java] Row #4: 
     [java] Row #4: $1.64
     [java] Row #5: 
     [java] Row #5: 35459.0
     [java] Row #5: 
     [java] Row #5: $1.62
     [java] Row #6: 
     [java] Row #6: 41545.0
     [java] Row #6: 
     [java] Row #6: $1.47
     [java] Row #7: 
     [java] Row #7: 34706.0
     [java] Row #7: 
     [java] Row #7: $1.91
     [java] Row #8: 
     [java] Row #8: 9161.0
     [java] Row #8: 
     [java] Row #8: $1.76
     [java] Row #9: 
     [java] Row #9: 9227.0
     [java] Row #9: 
     [java] Row #9: $1.65
     [java] Row #10: 
     [java] Row #10: 9986.0
     [java] Row #10: 
     [java] Row #10: $1.59
     [java] Row #11: 
     [java] Row #11: 9291.0
     [java] Row #11: ...>
     [java] 	at
mondrian.test.TestContext.assertEqualsVerbose(TestContext.java:634)
     [java] 	at
mondrian.test.TestContext.assertEqualsVerbose(TestContext.java:602)
     [java] 	at
mondrian.test.TestContext.assertQueryReturns(TestContext.java:577)
     [java] 	at
mondrian.test.FoodMartTestCase.assertQueryReturns(FoodMartTestCase.java:
128)
     [java] 	at
mondrian.rolap.VirtualCubeTest.testCalculatedMeasureAcrossCubes(VirtualC
ubeTest.java:309)
     [java] 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
     [java] 	at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav
a:39)
     [java] 	at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java:25)
     [java] 	at
mondrian.test.MondrianTestRunner$2.run(MondrianTestRunner.java:130)
     [java] 	at java.lang.Thread.run(Thread.java:595)
     [java] 2)
testDataSourceChangeListenerPlugin(mondrian.rolap.DataSourceChangeListen
erTest)junit.framework.ComparisonFailure: expected:<......> but
was:<..., select "store"."store_country" as "c0" from "store" "store"
group by "store"."store_country" order by "store"."store_country" ASC,
select "store"."store_state" as "c0" from "store" "store" where
"store"."store_country" = 'USA' group by "store"."store_state" order by
"store"."store_state" ASC, select "store"."store_city" as "c0" from
"store" "store" where "store"."store_state" = 'CA' group by
"store"."store_city" order by "store"."store_city" ASC...>
     [java] 	at
mondrian.rolap.DataSourceChangeListenerTest.testDataSourceChangeListener
Plugin(DataSourceChangeListenerTest.java:138)
     [java] 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
     [java] 	at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav
a:39)
     [java] 	at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java:25)
     [java] 	at
mondrian.test.MondrianTestRunner$2.run(MondrianTestRunner.java:130)
     [java] 	at java.lang.Thread.run(Thread.java:595)

     [java] FAILURES!!!
     [java] Tests run: 1182,  Failures: 2,  Errors: 0

     [java] Time: 180.395
     [java] Test stopped due to errors.
     [java] Java Result: 1

BUILD SUCCESSFUL
Total time: 3 minutes 30 seconds 



______________________________________________________________________
This email has been scanned by the Email Security System.
______________________________________________________________________



More information about the Mondrian mailing list