Re: [dba-dev] CWS dba33m needs testing CAST() problem
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 ftp://qa-upload.services.openoffice.org/dba33m/. Bye Marc Best regards, Ocke - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org -- Marc Neumann Phone: +49 (0)40 23646 500 | Fax: +49 (0)40 23646 550 Oracle Office GBU ORACLE Deutschland B.V. Co. KG | Nagelsweg 55 | 20097 Hamburg ORACLE Deutschland B.V. Co. KG Hauptverwaltung: Riesstr. 25, D-80992 München Registergericht: Amtsgericht München, HRA 95603 Komplementärin: ORACLE Deutschland Verwaltung B.V. Rijnzathe 6, 3454PV De Meern, Niederlande Handelsregister der Handelskammer Midden-Niederlande, Nr. 30143697 Geschäftsführer: Jürgen Kunz, Marcel van de Molen, Alexander van der Ven - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] CWS dba33m needs testing CAST() problem
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 and native connection.
Regards,
Zoltan
2010.12.10. 8:55 keltezéssel, Ocke Janssen írta:
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.
Best regards,
Ocke
-
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] CWS dba33m needs testing CAST() problem
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 issue is fixed. I uploaded at to qa-upl...@services.openoffice.org in the folder dba33m. Best regards, Ocke - 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] CWS dba33m needs testing CAST() problem
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 your own settings. Go into the program folder and start sbase ;-) That's what I'm doing for Linux. I hope I forgot nothing. - oj PS: We found an issue with select * from table where id in ( 'll',OO') 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 issue is fixed. I uploaded at to qa-upl...@services.openoffice.org in the folder dba33m. Best regards, Ocke - 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
Re: [dba-dev] CWS dba33m needs testing CAST() problem
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: http://wiki.services.openoffice.org/wiki/Run_OOo_versions_parallel or here http://wiki.services.openoffice.org/wiki/NL/TipsEnTrucs/Meerdere_versies_van_OOo_uitvoeren It advises to change the var UserInstallation in bootstrap.ini/rc So do tht, and copy (rename) your OOO330m17 user profile to that location. Then start .. Regards, Cor -- - giving openoffice.org its foundation :: The Document Foundation - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] CWS dba33m needs testing CAST() problem
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 major speed aprovements or come i al back to some settings ? Greetz Fernand Ocke, i manged to install, no more CAST problems :-) for me at least, hopes others come to the same conclusion Thank you for this quick fix Fernand 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 issue is fixed. I uploaded at to qa-upl...@services.openoffice.org in the folder dba33m. Best regards, Ocke - 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
Re: [dba-dev] CWS dba33m needs testing CAST() problem
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 Database registered in your CWS:33dba version. Did you some major speed aprovements or come i al back to some settings ? No. I just did a compile job on our side. Nothing different. But less extensions could do the job. - oj Greetz Fernand Ocke, i manged to install, no more CAST problems :-) for me at least, hopes others come to the same conclusion Thank you for this quick fix Fernand 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 issue is fixed. I uploaded at to qa-upl...@services.openoffice.org in the folder dba33m. Best regards, Ocke - 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 - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] CWS dba33m needs testing CAST() problem
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, it did not pick up the already installed extensions. Alex - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] CWS dba33m needs testing CAST() problem
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 - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
