Re: [dba-dev] CWS srb1 status

2010-12-08 Thread Ocke Janssen
Hi Zoltán, On 07.12.2010 16:11, Reizinger Zoltán wrote: Hi Ocke, Now I see from releases mail, that the cws srb1 integrated into DEV300m95. The issue http://www.openoffice.org/issues/show_bug.cgi?id=99049 needs some changes, especially target milestone. I will wait for ORB form DEV300m95,

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

2010-12-08 Thread Fernand Vanrie
Just found that queries who worked for years are halted now (OOO 330m16) using Cast(timestampvalue as date) CAST(timestampvalue as date) use to run in direct SQL mode I think that CAST as date is no longer loved and by mySQL they recommand DATE(timestampvalue) i have some queries around with

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

2010-12-08 Thread Reizinger Zoltán
Hi Fernand, The CAST(timestampvalue as date) working for me in windows version of OOo 3.3RC7(m17), with SQL direct, with built-in hsqldb. Regards, Zoltan 2010.12.08. 11:45 keltezéssel, Fernand Vanrie írta: Just found that queries who worked for years are halted now (OOO 330m16) using

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

2010-12-08 Thread Fernand Vanrie
hi Zoltán , Indeed with the built-in hsqldb CAST still works, but no longer with a connection (using the native connector) to mySQL ! same situation for OOO 330m16 and m17 Fernand Hi Fernand, The CAST(timestampvalue as date) working for me in windows version of OOo 3.3RC7(m17), with SQL

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

2010-12-08 Thread Reizinger Zoltán
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 2010.12.08. 13:12 keltezéssel, Fernand Vanrie írta: hi Zoltán , Indeed with the built-in hsqldb CAST still works, but no

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

2010-12-08 Thread Alexander Thurgood
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

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

2010-12-08 Thread Fernand Vanrie
Alexander , It sould be good to send this message also to relea...@openoffice.org 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

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

2010-12-08 Thread Alex Thurgood
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 s...@pmgroup.be a écrit : Alexander , It sould be good to send this message also to

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

2010-12-08 Thread Fernand Vanrie
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

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

2010-12-08 Thread Alex Thurgood
Fernand, Well I also use EXTRACT(), but have found that I still have to CAST the type. If I just use the DATE/TIME functions on their own, the results are inconsistent across the months, especially when adding or subtracting. I haven't kept any of my old queries that did direct application of