[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