Fwd: [dba-dev] Re: CAST() no longer working with OOO 330m16

To whom it may concern. Please take note of the exchange below. This is an essential function that I actually use in OOo 3.2 because of the way OOo  decides on data types with date strings obtained from queries from mysql.

Best regards,

Alex Thurgood




----- Mail transféré -----
De: "Alexander Thurgood" <[email protected]>
À: [email protected]
Envoyé: Mercredi 8 Décembre 2010 14h42:44 GMT +01:00 Afrique centrale - Ouest
Objet: [dba-dev] Re: CAST()  no longer working with OOO 330m16

Hi all,

Le 08/12/10 13:38, Reizinger Zoltán a écrit :
> Hi Fernand,
> It feels to me as I touched in some days ago, and find it, as a known
> issue with cast in MySQL:
> http://qa.openoffice.org/issues/show_bug.cgi?id=115436
> Zoltan
> 


Hmm, this would not be good for me if this is the case because I use a
lot of cast statements with date values in mysql. The reason is simple,
default typing of the values in date strings used to lead to funny
behaviour for me on OOo, which meant that calculations I had in my
queries based on the default types led to incorrect results. I was thus
forced into using CAST to ensure correct handling. If that functionality
has now gone away with the latest dev release, whereas it works in 3.2,
and connector 1.0.0, I see no incentive to move to 3.3.

Alex


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]