[Mondrian] NULL literal

Julian Hyde julianhyde at speakeasy.net
Wed Feb 28 20:55:50 EST 2007


Richard,

You only did half of what I suggested: you wrote testcases but you
didn't validate the results against MSAS.

I ran

  with member [Measures].[Foo] as ' 4 / NULL  '
  select {[Measures].[Foo]} on 0
  from [Sales]

on MSAS 2K and it gave

  1.#INF

as the answer. Now you've added a test which ensures the result is NULL,
i.e. wrong.

Change 8802 is not an improvement. Please back it out.

Julian
 

> -----Original Message-----
> From: mondrian-bounces at pentaho.org 
> [mailto:mondrian-bounces at pentaho.org] On Behalf Of Richard Emberson
> Sent: Wednesday, February 28, 2007 2:18 PM
> To: Mondrian developer mailing list
> Subject: Re: [Mondrian] NULL literal
> 
> In the	8802 checkin I added a NULL literal test method
> testNullLiteral() to BasicQueryTest.
> 
> Richard
> 
> Julian Hyde wrote:
> >  
> > 
> >> Interesting page on NULL and IS EMPTY
> >>
> >>
> > 
> http://sqljunkies.com/WebLog/mosha/archive/2005/06/30/mdx_is_e
> mpty.aspx
> > 
> > Looks like a page full of potential testcases to me!
> > 
> > Anyone out there itching to contribute to mondrian by 
> writing Q/A tests?
> > We could use your help!
> > 
> > Julian
> > 
> > _______________________________________________
> > Mondrian mailing list
> > Mondrian at pentaho.org
> > http://lists.pentaho.org/mailman/listinfo/mondrian
> > 
> 
> 
> -- 
> Quis custodiet ipsos custodes:
> This email message is for the sole use of the intended 
> recipient(s) and
> may contain confidential information.  Any unauthorized review, use,
> disclosure or distribution is prohibited.  If you are not the intended
> recipient, please contact the sender by reply email and destroy all
> copies of the original message.
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
> 




More information about the Mondrian mailing list