EVOLUTION-MANAGER

Edit File: rpl_temporal_mysql56.result

include/master-slave.inc [connection master] connection master; SET TIME_ZONE='+00:00'; connection slave; SET TIME_ZONE='+00:00'; connection master; INSERT INTO mysql56time VALUES ('01:01:01','01:01:01.1','01:01:01.11','01:01:01.111','01:01:01.1111','01:01:01.11111','01:01:01.111111'); INSERT INTO mysql56datetime VALUES ('2001-01-01 01:01:01','2001-01-01 01:01:01.1','2001-01-01 01:01:01.11','2001-01-01 01:01:01.111','2001-01-01 01:01:01.1111','2001-01-01 01:01:01.11111','2001-01-01 01:01:01.111111'); INSERT INTO mysql56timestamp VALUES ('2001-01-01 01:01:01','2001-01-01 01:01:01.1','2001-01-01 01:01:01.11','2001-01-01 01:01:01.111','2001-01-01 01:01:01.1111','2001-01-01 01:01:01.11111','2001-01-01 01:01:01.111111'); connection slave; connection slave; SELECT * FROM mysql56time; t0 838:59:59 t1 838:59:59.0 t2 838:59:59.00 t3 838:59:59.000 t4 838:59:59.0000 t5 838:59:59.00000 t6 838:59:59.000000 t0 00:00:00 t1 00:00:00.0 t2 00:00:00.00 t3 00:00:00.000 t4 00:00:00.0000 t5 00:00:00.00000 t6 00:00:00.000000 t0 -838:59:59 t1 -838:59:59.0 t2 -838:59:59.00 t3 -838:59:59.000 t4 -838:59:59.0000 t5 -838:59:59.00000 t6 -838:59:59.000000 t0 01:01:01 t1 01:01:01.1 t2 01:01:01.11 t3 01:01:01.111 t4 01:01:01.1111 t5 01:01:01.11111 t6 01:01:01.111111 SELECT * FROM mysql56datetime; dt0 0000-00-00 00:00:00 dt1 0000-00-00 00:00:00.0 dt2 0000-00-00 00:00:00.00 dt3 0000-00-00 00:00:00.000 dt4 0000-00-00 00:00:00.0000 dt5 0000-00-00 00:00:00.00000 dt6 0000-00-00 00:00:00.000000 dt0 9999-12-31 23:59:59 dt1 9999-12-31 23:59:59.9 dt2 9999-12-31 23:59:59.99 dt3 9999-12-31 23:59:59.999 dt4 9999-12-31 23:59:59.9999 dt5 9999-12-31 23:59:59.99999 dt6 9999-12-31 23:59:59.999999 dt0 2001-01-01 01:01:01 dt1 2001-01-01 01:01:01.1 dt2 2001-01-01 01:01:01.11 dt3 2001-01-01 01:01:01.111 dt4 2001-01-01 01:01:01.1111 dt5 2001-01-01 01:01:01.11111 dt6 2001-01-01 01:01:01.111111 SELECT * FROM mysql56timestamp; ts0 1970-01-01 00:00:01 ts1 1970-01-01 00:00:01.0 ts2 1970-01-01 00:00:01.00 ts3 1970-01-01 00:00:01.000 ts4 1970-01-01 00:00:01.0000 ts5 1970-01-01 00:00:01.00000 ts6 1970-01-01 00:00:01.000000 ts0 2038-01-19 03:14:07 ts1 2038-01-19 03:14:07.9 ts2 2038-01-19 03:14:07.99 ts3 2038-01-19 03:14:07.999 ts4 2038-01-19 03:14:07.9999 ts5 2038-01-19 03:14:07.99999 ts6 2038-01-19 03:14:07.999999 ts0 2001-01-01 01:01:01 ts1 2001-01-01 01:01:01.1 ts2 2001-01-01 01:01:01.11 ts3 2001-01-01 01:01:01.111 ts4 2001-01-01 01:01:01.1111 ts5 2001-01-01 01:01:01.11111 ts6 2001-01-01 01:01:01.111111 connection master; DROP TABLE mysql56time; DROP TABLE mysql56datetime; DROP TABLE mysql56timestamp; include/rpl_end.inc