[Mondrian] Re: Regression tests MonetDB

Stefan de Konink stefan at konink.de
Mon Feb 23 19:27:38 EST 2009


John V. Sichi wrote:
> Stefan de Konink wrote:
>> Julian Hyde wrote:
>>> Glad you found a hack, but every database I know allows you to have 
>>> spaces, mixed case, and punctuation in identifers, so you should add 
>>> that feature. Standard SQL uses double-quote to quote such identifiers.
>>
>> If you can give the page number of ISO 9075 standard that defines 
>> especially *this*, I am sure it will come in more soon ;) But there is 
>> a fundamental problem (in kernel) with this currently that should be 
>> fixed first.
> 
> Part 2 pp135-142 (Section 5.2, <token> and <separator>)
> 
> Part 2 pp151-160 (Section 5.4, Names and identifiers)
> 
> JVS "has recently been working on Unicode support in LucidDB so knows 
> these nearly by heart now"

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.


Stefan





More information about the Mondrian mailing list