Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
None
Description
With the default sql_mode (no NO_ZERO_IN_DATE), the server accepts and stores dates with a zero day or month, for example:
CREATE TABLE t (a DATE);
INSERT INTO t VALUES ('2000-03-00');
Reading such a value with several getters makes the driver throw exceptions that are not SQLException, which applications do not catch and whose message does not say which value was at fault
A JDBC getter must report a value it cannot represent through an SQLException only.