polardbxengine/mysql-test/suite/engines/funcs/t/time_function.test

13 lines
348 B
Plaintext

--disable_warnings
DROP TABLE IF EXISTS t3;
--enable_warnings
SET sql_mode='NO_ENGINE_SUBSTITUTION';
CREATE TABLE t3(c1 TIME NOT NULL);
INSERT INTO t3 VALUES('00:00:00');
INSERT INTO t3 VALUES('23:59:59');
INSERT INTO t3 VALUES('99:99:99');
INSERT INTO t3 VALUES('12:00:00');
INSERT INTO t3 VALUES('13:13:13');
DROP TABLE t3;
SET sql_mode=default;