| 1 |
include/master-slave.inc |
| 2 |
[connection master] |
| 3 |
connection master; |
| 4 |
SET TIME_ZONE='+00:00'; |
| 5 |
connection slave; |
| 6 |
SET TIME_ZONE='+00:00'; |
| 7 |
connection master; |
| 8 |
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'); |
| 9 |
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'); |
| 10 |
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'); |
| 11 |
connection slave; |
| 12 |
connection slave; |
| 13 |
SELECT * FROM mysql56time; |
| 14 |
t0 838:59:59 |
| 15 |
t1 838:59:59.0 |
| 16 |
t2 838:59:59.00 |
| 17 |
t3 838:59:59.000 |
| 18 |
t4 838:59:59.0000 |
| 19 |
t5 838:59:59.00000 |
| 20 |
t6 838:59:59.000000 |
| 21 |
t0 00:00:00 |
| 22 |
t1 00:00:00.0 |
| 23 |
t2 00:00:00.00 |
| 24 |
t3 00:00:00.000 |
| 25 |
t4 00:00:00.0000 |
| 26 |
t5 00:00:00.00000 |
| 27 |
t6 00:00:00.000000 |
| 28 |
t0 -838:59:59 |
| 29 |
t1 -838:59:59.0 |
| 30 |
t2 -838:59:59.00 |
| 31 |
t3 -838:59:59.000 |
| 32 |
t4 -838:59:59.0000 |
| 33 |
t5 -838:59:59.00000 |
| 34 |
t6 -838:59:59.000000 |
| 35 |
t0 01:01:01 |
| 36 |
t1 01:01:01.1 |
| 37 |
t2 01:01:01.11 |
| 38 |
t3 01:01:01.111 |
| 39 |
t4 01:01:01.1111 |
| 40 |
t5 01:01:01.11111 |
| 41 |
t6 01:01:01.111111 |
| 42 |
SELECT * FROM mysql56datetime; |
| 43 |
dt0 0000-00-00 00:00:00 |
| 44 |
dt1 0000-00-00 00:00:00.0 |
| 45 |
dt2 0000-00-00 00:00:00.00 |
| 46 |
dt3 0000-00-00 00:00:00.000 |
| 47 |
dt4 0000-00-00 00:00:00.0000 |
| 48 |
dt5 0000-00-00 00:00:00.00000 |
| 49 |
dt6 0000-00-00 00:00:00.000000 |
| 50 |
dt0 9999-12-31 23:59:59 |
| 51 |
dt1 9999-12-31 23:59:59.9 |
| 52 |
dt2 9999-12-31 23:59:59.99 |
| 53 |
dt3 9999-12-31 23:59:59.999 |
| 54 |
dt4 9999-12-31 23:59:59.9999 |
| 55 |
dt5 9999-12-31 23:59:59.99999 |
| 56 |
dt6 9999-12-31 23:59:59.999999 |
| 57 |
dt0 2001-01-01 01:01:01 |
| 58 |
dt1 2001-01-01 01:01:01.1 |
| 59 |
dt2 2001-01-01 01:01:01.11 |
| 60 |
dt3 2001-01-01 01:01:01.111 |
| 61 |
dt4 2001-01-01 01:01:01.1111 |
| 62 |
dt5 2001-01-01 01:01:01.11111 |
| 63 |
dt6 2001-01-01 01:01:01.111111 |
| 64 |
SELECT * FROM mysql56timestamp; |
| 65 |
ts0 1970-01-01 00:00:01 |
| 66 |
ts1 1970-01-01 00:00:01.0 |
| 67 |
ts2 1970-01-01 00:00:01.00 |
| 68 |
ts3 1970-01-01 00:00:01.000 |
| 69 |
ts4 1970-01-01 00:00:01.0000 |
| 70 |
ts5 1970-01-01 00:00:01.00000 |
| 71 |
ts6 1970-01-01 00:00:01.000000 |
| 72 |
ts0 2038-01-19 03:14:07 |
| 73 |
ts1 2038-01-19 03:14:07.9 |
| 74 |
ts2 2038-01-19 03:14:07.99 |
| 75 |
ts3 2038-01-19 03:14:07.999 |
| 76 |
ts4 2038-01-19 03:14:07.9999 |
| 77 |
ts5 2038-01-19 03:14:07.99999 |
| 78 |
ts6 2038-01-19 03:14:07.999999 |
| 79 |
ts0 2001-01-01 01:01:01 |
| 80 |
ts1 2001-01-01 01:01:01.1 |
| 81 |
ts2 2001-01-01 01:01:01.11 |
| 82 |
ts3 2001-01-01 01:01:01.111 |
| 83 |
ts4 2001-01-01 01:01:01.1111 |
| 84 |
ts5 2001-01-01 01:01:01.11111 |
| 85 |
ts6 2001-01-01 01:01:01.111111 |
| 86 |
connection master; |
| 87 |
DROP TABLE mysql56time; |
| 88 |
DROP TABLE mysql56datetime; |
| 89 |
DROP TABLE mysql56timestamp; |
| 90 |
include/rpl_end.inc |