It does work if you use exec 0 (date '2009-09-01'); (i.e. add the keyword date). Allen Zhang wrote:
Hi, there,
We are testing the Aug SP1 (v5.14.2) release, it seems the exec did not translate the date string, please run attached sql against Aug SP1, it give out the following error, the same script works file on mserver v5.10.4 (May SP1). Sounds like a bug to me.
15:19:53 [CREATE - 0 row(s), 0.000 secs] Command processed. No rows were affected
15:19:53 [SELECT - 3 row(s), 0.000 secs] Result set fetched
15:19:54 [PREPARE - 1 row(s), 0.000 secs] Result set fetched
15:19:54 [EXEC - 0 row(s), 0.000 secs] SQLException:sql.prepare:wrong argument for prepared statement (expected date instead of char)
15:19:54 [EXEC - 0 row(s), 0.000 secs] current transaction is aborted (please ROLLBACK)
15:19:54 [EXEC - 0 row(s), 0.000 secs] current transaction is aborted (please ROLLBACK)
15:19:54 [EXEC - 0 row(s), 0.000 secs] current transaction is aborted (please ROLLBACK)
15:19:54 [COMMIT - 0 row(s), 0.000 secs] COMMIT: failed
ERROR: COMMIT: transaction is aborted, will ROLLBACK instead
15:19:54 [SELECT - 3 row(s), 0.015 secs] Result set fetched
15:19:54 [DROP - 0 row(s), 0.000 secs] Command processed. No rows were affected
... 10 statement(s) executed, 7 row(s) affected, exec/fetch time: 0.015/0.000 sec [3 successful, 2 warnings, 5 errors]
Thanks for the attention.
Allen
------------------------------------------------------------------------
------------------------------------------------------------------------------ Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference
------------------------------------------------------------------------
_______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- Sjoerd Mullender