Re: [dba-dev] CWS dba33m needs testing CAST() problem

2010-12-10 Thread Marc Neumann
Hi, Am 10.12.10 08:55, Ocke Janssen schrieb: Moin, The cws dba33m needs some testing for the issue 115436 (show stopper). It would be great if we could verify that the issue is fixed. I uploaded at to qa-upl...@services.openoffice.org in the folder dba33m. The full URL is

Re: [dba-dev] CWS dba33m needs testing CAST() problem

2010-12-10 Thread Reizinger Zoltán
Hi Ocke I tested cws dba33m on ubuntu 10.10 32bit linux, and queries: SELECT CAST(`date_field` AS CHAR) as `MyDate` FROM `test`.`Tabla1`; SELECT CAST(`date_field` AS DATE) as `MyDate` FROM `test`.`Tabla1`; SELECT CAST ('2010-12-09' AS DATE) FROM `test`.`Tabla1`; Runs without problem with JDBC

Re: [dba-dev] CWS dba33m needs testing CAST() problem

2010-12-10 Thread Fernand Vanrie
Ocke, I am happy to test BUT this stuff is new for me :-) Have the Zip downloaded, how do i INSTALL this stuff , using my existing OOO330m17 settings Greetz Fernand Moin, The cws dba33m needs some testing for the issue 115436 (show stopper). It would be great if we could verify that the

Re: [dba-dev] CWS dba33m needs testing CAST() problem

2010-12-10 Thread Ocke Janssen
Hi Fernand, On 10.12.2010 13:07, Fernand Vanrie wrote: Ocke, I am happy to test BUT this stuff is new for me :-) Have the Zip downloaded, how do i INSTALL this stuff , using my existing OOO330m17 settings Unzip the file to some temp folder. It includes the whole office and should not damage

Re: [dba-dev] CWS dba33m needs testing CAST() problem

2010-12-10 Thread Cor Nouws
Hi Fernand, (Sorry for stepping in) Fernand Vanrie wrote (10-12-10 13:07) I am happy to test BUT this stuff is new for me :-) Have the Zip downloaded, how do i INSTALL this stuff , using my existing OOO330m17 settings pls look here:

Re: [dba-dev] CWS dba33m needs testing CAST() problem

2010-12-10 Thread Fernand Vanrie
Ocke, after some more testing, i found that things go's far far more speedy than with the installed m17 ? can you see a reason for this behavior ? the only differece is that i see the fact that i have less extentions loaded and less Database registered in your CWS:33dba version. Did you some

Re: [dba-dev] CWS dba33m needs testing CAST() problem

2010-12-10 Thread Ocke Janssen
Hi Fernand, On 10.12.2010 13:35, Fernand Vanrie wrote: Ocke, after some more testing, i found that things go's far far more speedy than with the installed m17 ? can you see a reason for this behavior ? the only differece is that i see the fact that i have less extentions loaded and less

Re: [dba-dev] CWS dba33m needs testing CAST() problem

2010-12-10 Thread Alex Thurgood
Hi Ocke, all, - Peter Eberlein pet@refofd.verwalt-berlin.de a écrit : Tested the download on Mac OSX SnowLeopard. Seems to work fine for me with the Mysql connector 1.0.0. Alex P.S. One gripe that I do have is that although this installation overwrote my previous OOo user settings,

Re: [dba-dev] CWS dba33m needs testing CAST() problem

2010-12-10 Thread Alex Thurgood
Hi Ocke, - Ocke Janssen ocke.jans...@oracle.com a écrit : PS: We found an issue with select * from table where id in ( 'll',OO') The only way I can get this to run in that latest downloaded version is by removing the single quotes around the values. Alex