[Mondrian] Re: Regression tests MonetDB
Stefan de Konink
stefan at konink.de
Mon Feb 23 19:55:37 EST 2009
John V. Sichi wrote:
> Stefan de Konink wrote:
>> Maybe you are better than google, but do you by any chance know where
>> we can find the syntax requirement for the following:
>>
>> select "store"."store_country" as "c0", "store"."store_state" as "c1",
>> "store"."store_city" as "c2" 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
>> "sales_fact_1997"."time_id" = "time_by_day"."time_id" and
>> "time_by_day"."the_year" = 1997 group by "store"."store_country",
>> "store"."store_state", "store"."store_city" order by
>>
>> count("sales_fact_1997"."product_id") DESC,
>>
>> "store"."store_country" ASC, "store....
>>
>>
>> It is the count part in the order by section.
>
> I've never seen Mondrian generate an agg call inside the ORDER BY...what
> MDX and schema did you use to make it do that?
5) queryTest_29ce2f3512f79d38_TOPCOUNT.xml
(Attached for your convenience)
If you really want to see some incredble weird stuff take a look in:
11) queryTest_aggregate_ffc012281623093.xml
Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal
error: while building member cache; sql=[select "store"."store_country"
as "c0" from "store" as "store" where
UPPER("store"."store_country") = UPPER('20319')
group by "store"."store_country" order by "store"."store_country" ASC]
sql>select store_country from store;
+---------------+
| store_country |
+===============+
| USA |
| Mexico |
| USA |
| USA |
| Mexico |
| Mexico |
| USA |
| USA |
| Mexico |
| Mexico |
| Mexico |
| USA |
| Mexico |
| USA |
| USA |
| USA |
| USA |
| USA |
| Mexico |
| Canada |
| Canada |
| Mexico |
| USA |
| USA |
| USA |
+---------------+
Stefan
-------------- next part --------------
A non-text attachment was scrubbed...
Name: queryTest_29ce2f3512f79d38_TOPCOUNT.xml
Type: text/xml
Size: 7420 bytes
Desc: not available
Url : http://lists.pentaho.org/pipermail/mondrian/attachments/20090224/739d9874/attachment.xml
More information about the Mondrian
mailing list