PDA

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



Pappyn Bart
03-06-2007, 04:30 AM
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 (DOT) com]
Sent: woensdag 28 februari 2007 18:38
To: Pappyn Bart
Cc: mondrian (AT) pentaho (DOT) org
Subject: FW: Cron <jhyde@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.
______________________________________________________________________
_______________________________________________
Mondrian mailing list
Mondrian (AT) pentaho (DOT) org
http://lists.pentaho.org/mailman/listinfo/mondrian