1include/master-slave.inc 2[connection master] 3connection master; 4SET @@global.mysql56_temporal_format=true;; 5connection slave; 6SET @@global.mysql56_temporal_format=false;; 7connection master; 8SELECT @@global.mysql56_temporal_format AS on_master; 9on_master 101 11connection slave; 12SELECT @@global.mysql56_temporal_format AS on_slave; 13on_slave 140 15connection master; 16CREATE TABLE t1 17( 18c0 TIME(0), 19c1 TIME(1), 20c2 TIME(2), 21c3 TIME(3), 22c4 TIME(4), 23c5 TIME(5), 24c6 TIME(6) 25); 26CREATE TABLE t2 27( 28c0 TIMESTAMP(0), 29c1 TIMESTAMP(1), 30c2 TIMESTAMP(2), 31c3 TIMESTAMP(3), 32c4 TIMESTAMP(4), 33c5 TIMESTAMP(5), 34c6 TIMESTAMP(6) 35); 36CREATE TABLE t3 37( 38c0 DATETIME(0), 39c1 DATETIME(1), 40c2 DATETIME(2), 41c3 DATETIME(3), 42c4 DATETIME(4), 43c5 DATETIME(5), 44c6 DATETIME(6) 45); 46INSERT INTO t1 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'); 47INSERT INTO t2 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'); 48INSERT INTO t3 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'); 49SELECT TABLE_NAME, TABLE_ROWS, AVG_ROW_LENGTH,DATA_LENGTH FROM INFORMATION_SCHEMA.TABLES 50WHERE TABLE_NAME RLIKE 't[1-3]' ORDER BY TABLE_NAME; 51TABLE_NAME TABLE_ROWS AVG_ROW_LENGTH DATA_LENGTH 52t1 1 34 34 53t2 1 41 41 54t3 1 48 48 55connection slave; 56connection slave; 57SELECT * FROM t1;; 58c0 01:01:01 59c1 01:01:01.1 60c2 01:01:01.11 61c3 01:01:01.111 62c4 01:01:01.1111 63c5 01:01:01.11111 64c6 01:01:01.111111 65SELECT * FROM t2;; 66c0 2001-01-01 01:01:01 67c1 2001-01-01 01:01:01.1 68c2 2001-01-01 01:01:01.11 69c3 2001-01-01 01:01:01.111 70c4 2001-01-01 01:01:01.1111 71c5 2001-01-01 01:01:01.11111 72c6 2001-01-01 01:01:01.111111 73SELECT * FROM t3;; 74c0 2001-01-01 01:01:01 75c1 2001-01-01 01:01:01.1 76c2 2001-01-01 01:01:01.11 77c3 2001-01-01 01:01:01.111 78c4 2001-01-01 01:01:01.1111 79c5 2001-01-01 01:01:01.11111 80c6 2001-01-01 01:01:01.111111 81SELECT TABLE_NAME, TABLE_ROWS, AVG_ROW_LENGTH,DATA_LENGTH FROM INFORMATION_SCHEMA.TABLES 82WHERE TABLE_NAME RLIKE 't[1-3]' ORDER BY TABLE_NAME; 83TABLE_NAME TABLE_ROWS AVG_ROW_LENGTH DATA_LENGTH 84t1 1 33 33 85t2 1 41 41 86t3 1 50 50 87connection master; 88DROP TABLE t1; 89DROP TABLE t2; 90DROP TABLE t3; 91connection slave; 92SET @@global.mysql56_temporal_format=DEFAULT; 93connection master; 94SET @@global.mysql56_temporal_format=DEFAULT; 95include/rpl_end.inc 96