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