[Mondrian] Re: Regression tests MonetDB
John V. Sichi
jsichi at gmail.com
Mon Feb 23 20:38:15 EST 2009
Oh, I see...the TopCount function is generating this.
Yes, E121-03 (Value expressions in ORDER BY clause) is the relevant feature.
The <order by> scoping rules are subtle because of this feature; you can
find them in SQL:2003 Part 2, Section 14.1 <declare cursor>. We think
we have them correctly implemented in the Eigenbase validator.
JVS
Stefan de Konink wrote:
> 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
More information about the Mondrian
mailing list