[Mondrian] NULL literal

Richard Emberson remberson at edgedynamics.com
Wed Feb 28 12:22:35 EST 2007


Interesting page on NULL and IS EMPTY

http://sqljunkies.com/WebLog/mosha/archive/2005/06/30/mdx_is_empty.aspx


Julian Hyde wrote:
>> Out on the web I find examples of the use of the NULL
>> literal in numeric expressions and when a NULL occurs,
>> the expression it self is NULL, e.g,.
>>
>> NULL/NULL == NULL.
>>
>> In the mondrian code, A Literal is compiled into a
>> ConstantCalc, The integer and double values of
>> a 'null' Object constructor parameter are
>> 0 for both integer and double rather than
>> the DoubleNull object (calling evaluateDouble()
>> yields 0.0 rather than DoubleNull).
>>
>> Is this a bug?
> 
> Sounds like it's a bug. There are a lot of corner cases involving NULL
> and EMPTY that I didn't explicitly think about.
> 
> Can you give an example MDX query which demonstrates this behavior? (I
> tried to write one involving '(NULL / NULL) IS NULL' and MSAS complained
> at me. Probably my ignorance at when 'IS NULL' can be applied.)
> 
> 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.



More information about the Mondrian mailing list