PDA

View Full Version : build test fails



nadsinoz
07-26-2002, 12:39 AM
When I try 'build test', it fails:
C:\java\mondrian-0.2>build test
C:\java\mondrian-0.2>set CLASSPATH=C:\java\mondrian-0.2\/classes;C:\java\mondria
n-0.2\/lib/javacup.jar;C:/java/jakarta-tomcat-4.0.4/common/lib/xerces.jar;C:\jav
a\mondrian-0.2\/lib/boot.jar;C:/oracle/ora81/jdbc/lib/classes12.zip
Buildfile: build.xml
test:
[java] Error in test 'non empty 1(mondrian.test.Main$2)': mondrian.resource
.Error: Internal error: while counting members of level '[Customers].[Country]';
sql=[select count(*) from (select distinct "country" as "c0" from (SELECT *, "f
name" + ' ' + "lname" as "name" FROM "customer") "Customers")]
[java] ORA-00923: FROM keyword not found where expected
[java]
[java] Error in test 'non empty 2(mondrian.test.Main$3)': mondrian.resource
.Error: Internal error: while counting members of level '[Customers].[Country]';
sql=[select count(*) from (select distinct "country" as "c0" from (SELECT *, "f
name" + ' ' + "lname" as "name" FROM "customer") "Customers")]
[java] ORA-00923: FROM keyword not found where expected
[java]
....
I'm using Oracle as the database.
Any ideas?
Thanks,
Chris

jhyde
07-26-2002, 02:10 PM
Which version of Oracle are you using? Select-in-the-from-clause is a relatively recent Oracle feature.

nadsinoz
07-30-2002, 09:54 PM
It's 8.1.7
I shall try MySQL instead!
Thanks,
Chris

jhyde
08-20-2002, 10:36 AM
The problem was the concatenation syntax. Oracle uses '+' rather than '||'. With release 0.3, the only fix was to edit foodmart.xml. As of change 111 (available as mondrian-0.3.111-src.zip), you can foodmart.xml contains multiple queries, one per database dialect, and automatically uses the right one.