Re: Re: CAST() no longer working with OOO 330m16
Fernand Vanrie <[email protected]> Wed, 08 Dec 2010 18:15:53 +0100
| Newsgroups | gmane.comp.openoffice.dba.devel |
|---|---|
| Message-ID | <[email protected]> |
Alex , its also a fact that there are (better) alternatives for cast Date() convert() or even left() and right() > Hi Fernand, > > Done, but whether it will make any difference ? Its not a blocker because it doesn't cause a crash, or lose your data, but it is surely a regression from 3.2. > > > Alex > > > > ----- "Fernand Vanrie"<[email protected]> a écrit : > >> Alexander , >> >> It sould be good to send this message also to [email protected] >> >> there they decide over live and dead :-) >> >> greetz >> >> Fernand >>> 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] >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [email protected] >> For additional commands, e-mail: [email protected] > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected]