[dba-dev] CAST() no longer working with OOO 330m16
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 CAST , do not know if there are more ? andis it whort a issue ? Greetz Fernand
Re: [dba-dev] CAST() no longer working with OOO 330m16
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 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 CAST , do not know if there are more ? andis it whort a issue ? Greetz Fernand - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] CAST() no longer working with OOO 330m16
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 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 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 CAST , do not know if there are more ? andis it whort a issue ? Greetz Fernand - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] CAST() no longer working with OOO 330m16
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 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 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 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 CAST , do not know if there are more ? andis it whort a issue ? Greetz Fernand - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org