Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.5, 10.3.27, 5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL)
-
None
-
Linux
Description
See the following test script:
CREATE TABLE test( |
t text NOT NULL, |
d date NOT NULL |
);
|
|
insert into test values ("x",CURRENT_DATE()); |
|
SET SESSION sql_mode = "STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE"; |
|
ALTER TABLE test |
CHANGE d d DATE NOT NULL AFTER t, |
ADD i text NOT NULL AFTER d |
;
|
Resulting in
Error (1292): Incorrect date value: '0000-00-00' for column `test`.`d` at row 1
As you can see this is totally wrong, there is no such value 0000-00-00 in this table, and the alter statement should succeed.
Attachments
Issue Links
- relates to
-
MDEV-24691 sql_mode NO_ZERO_DATE conflicts with versioned tables
- Open