768
768
SET @org_mode=@@sql_mode;
769
769
#Table creation in strict mode
770
770
SET @@sql_mode='NO_ZERO_DATE,STRICT_ALL_TABLES';
771
773
CREATE TABLE t1 (c1 DATETIME DEFAULT 0);
772
774
ERROR 42000: Invalid default value for 'c1'
773
775
CREATE TABLE t1 (c1 DATETIME DEFAULT '0000-00-00 00:00:00');
774
776
ERROR 42000: Invalid default value for 'c1'
775
777
SET @@sql_mode='NO_ZERO_IN_DATE,STRICT_ALL_TABLES';
776
780
CREATE TABLE t1 (c1 DATETIME DEFAULT '2012-02-00 12:12:12');
777
781
ERROR 42000: Invalid default value for 'c1'
778
782
#Table creation in non-strict mode but with NO_ZERO_DATE/NO_ZERO_IN_DATE
779
783
SET @@sql_mode='NO_ZERO_DATE';
780
786
CREATE TABLE t1 (c1 DATETIME DEFAULT 0);
782
788
Warning 1264 Out of range value for column 'c1' at row 1