[Mondrian] RE: Regression tests MonetDB

Julian Hyde jhyde at pentaho.com
Tue Feb 17 16:19:25 EST 2009


 

> >> Do you have a way to evaluate an expression so that it 
> always returns 
> >> a single row? Oracle has the Dual table, MySQL has 'select 
> >> expression'. Etc.
> > 
> > Are you talking about limit 1?
> MonetDB supports 'select expression' e.g.
> ql>select 1+1, sin(0.5);
> +----------------------+------------------+
> | sql_add_single_value | sin_single_value |
> +======================+==================+
> |                    2 | 0.47942555       |
> +----------------------+------------------+
> 1 tuple

Good. Then MonetDbDialect can be like MySqlDialect in that regard. See
http://mondrian.pentaho.org/headapi/mondrian/spi/Dialect.html#generateInline
(java.util.List,+java.util.List,+java.util.List) and
http://mondrian.pentaho.org/headapi/src-html/mondrian/spi/impl/MySqlDialect.
html#line.118

Julian





More information about the Mondrian mailing list