[Mondrian] Some SQL points

Julian Hyde jhyde at pentaho.com
Mon Mar 16 11:33:48 EDT 2009


> > Stefan wrote:
> > 
> > sql>select store_id from store where store_city = 'Alameda';
> > +----------+
> > | store_id |
> > +==========+
> > |        0 |
> > +----------+
> > 1 tuple
> > sql>select * from sales_fact_1997 where store_id = 0;
> > 0 tuples
> > 
> > 
> > Please advise :)

> Sherman:
> That store is the head office. It does not have sales directly.
> 
> The same query against the MySQL Foodmart returns 0 rows.

I agree with Sherman. That particular query returns 0 rows, but it should
not return 'Invalid cursor state'. And there are a lot of similar queries
that are failing in the suite that should return rows.

Julian





More information about the Mondrian mailing list