[Mondrian] Re: Regression tests MonetDB

John V. Sichi jsichi at gmail.com
Mon Feb 23 19:45:09 EST 2009


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?

JVS




More information about the Mondrian mailing list