645
645
SET @org_mode=@@sql_mode;
646
646
#Table creation in strict mode
647
647
SET @@sql_mode='NO_ZERO_DATE,STRICT_ALL_TABLES';
648
650
CREATE TABLE t1 (c1 TIMESTAMP DEFAULT 0);
649
651
ERROR 42000: Invalid default value for 'c1'
650
652
CREATE TABLE t1 (c1 TIMESTAMP DEFAULT '0000-00-00 00:00:00');
651
653
ERROR 42000: Invalid default value for 'c1'
652
654
SET @@sql_mode='NO_ZERO_IN_DATE,STRICT_ALL_TABLES';
653
657
CREATE TABLE t1 (c1 TIMESTAMP DEFAULT '2012-02-00 12:12:12');
654
658
ERROR 42000: Invalid default value for 'c1'
655
659
#Table creation in non-strict mode but with NO_ZERO_DATE/NO_ZERO_IN_DATE
656
660
SET @@sql_mode='NO_ZERO_DATE';
657
663
CREATE TABLE t1 (c1 TIMESTAMP DEFAULT 0);
659
665
Warning 1264 Out of range value for column 'c1' at row 1