[Mondrian] [Fwd: Eigenbase perforce change 9873 for review]

[John V. Sichi]

Rushan's change below is checked in as LucidDB-specific, but according 
to SQL:2003, generating exponential literal format for double-precision 
values should always be the right thing to do, since without an 
exponent, the DBMS is supposed to interpret the literal as a fixed-point 
value.

In cases like this, is it preferable to "not rock the boat" by making 
the change LucidDB-specific?  The alternative is to change Mondrian to 
make it expect SQL:2003 behavior from the DBMS by default, and change 
other dialects as needed (e.g. if a DBMS does not support the standard 
exponential format).

(Don't ask why anyone would be crazy enough to use floating-point values 
as member keys in the first place.)

JVS

-------- Original Message --------
Subject: Eigenbase perforce change 9873 for review
Date: Tue, 11 Sep 2007 17:28:01 -0700 (PDT)
From: Rushan Chen <rchen at lucidera.com>
To: Andreas Voss <tonbeller at a-voss.de>, Bart Pappyn 
<bppn at users.sourceforge.net>, Julian Hyde <jhyde at users.sourceforge.net>, 
John V. Sichi <jsichi at gmail.com>, Matt Campbell 
<Matthew.Campbell at thomson.com>, Robin Tharappel 
<rtharappel at prospricing.com>, Sam Birney <sbirney at jaspersoft.com>, 
Zelaine Fong <zfong at lucidera.com>

http://p4web.eigenbase.org/@md=d&c=6PU@//9873?ac=10

Change 9873 by rchen at rchen.fao.eigenbase on 2007/09/11 17:26:23

	MONDRIAN: append "E0" to the SQL generated for double literals in 
LucidDB so that doubles will not be interpreted as decimals. For a 
collection of decimals, LucidDB might round up some of the "longer" 
values. This is not the bahavior Mondrian expects for collection of 
doubles. The change makes sure LucidDB will recognize the double literals.