Edit File: rpl_temporal_fractional.result
include/master-slave.inc Warnings: Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. [connection master] SET @@time_zone='+00:00'; SET @@timestamp=25810.123456; CREATE TABLE t1 ( ts0 TIMESTAMP(0), ts1 TIMESTAMP(1), ts2 TIMESTAMP(2), ts3 TIMESTAMP(3), ts4 TIMESTAMP(4), ts5 TIMESTAMP(5), ts6 TIMESTAMP(6) ); SET @ts='2001-01-01 10:10:10.123456'; INSERT INTO t1 VALUES (@ts, @ts, @ts, @ts, @ts, @ts, @ts); INSERT INTO t1 VALUES (NOW(), NOW(), NOW(), NOW(), NOW(), NOW(), NOW()); INSERT INTO t1 VALUES (NOW(6), NOW(6), NOW(6), NOW(6), NOW(6), NOW(6), NOW(6)); SELECT * FROM t1; ts0 2001-01-01 10:10:10 ts1 2001-01-01 10:10:10.1 ts2 2001-01-01 10:10:10.12 ts3 2001-01-01 10:10:10.123 ts4 2001-01-01 10:10:10.1235 ts5 2001-01-01 10:10:10.12346 ts6 2001-01-01 10:10:10.123456 ts0 1970-01-01 07:10:10 ts1 1970-01-01 07:10:10.0 ts2 1970-01-01 07:10:10.00 ts3 1970-01-01 07:10:10.000 ts4 1970-01-01 07:10:10.0000 ts5 1970-01-01 07:10:10.00000 ts6 1970-01-01 07:10:10.000000 ts0 1970-01-01 07:10:10 ts1 1970-01-01 07:10:10.1 ts2 1970-01-01 07:10:10.12 ts3 1970-01-01 07:10:10.123 ts4 1970-01-01 07:10:10.1235 ts5 1970-01-01 07:10:10.12346 ts6 1970-01-01 07:10:10.123456 include/sync_slave_sql_with_master.inc SELECT * FROM t1; ts0 2001-01-01 13:10:10 ts1 2001-01-01 13:10:10.1 ts2 2001-01-01 13:10:10.12 ts3 2001-01-01 13:10:10.123 ts4 2001-01-01 13:10:10.1235 ts5 2001-01-01 13:10:10.12346 ts6 2001-01-01 13:10:10.123456 ts0 1970-01-01 10:10:10 ts1 1970-01-01 10:10:10.0 ts2 1970-01-01 10:10:10.00 ts3 1970-01-01 10:10:10.000 ts4 1970-01-01 10:10:10.0000 ts5 1970-01-01 10:10:10.00000 ts6 1970-01-01 10:10:10.000000 ts0 1970-01-01 10:10:10 ts1 1970-01-01 10:10:10.1 ts2 1970-01-01 10:10:10.12 ts3 1970-01-01 10:10:10.123 ts4 1970-01-01 10:10:10.1235 ts5 1970-01-01 10:10:10.12346 ts6 1970-01-01 10:10:10.123456 DROP TABLE t1; include/sync_slave_sql_with_master.inc CREATE TABLE t1 ( dt0 DATETIME(0), dt1 DATETIME(1), dt2 DATETIME(2), dt3 DATETIME(3), dt4 DATETIME(4), dt5 DATETIME(5), dt6 DATETIME(6) ); SET @ts='2001-01-01 10:10:10.123456'; INSERT INTO t1 VALUES (@ts, @ts, @ts, @ts, @ts, @ts, @ts); INSERT INTO t1 VALUES (NOW(), NOW(), NOW(), NOW(), NOW(), NOW(), NOW()); INSERT INTO t1 VALUES (NOW(6), NOW(6), NOW(6), NOW(6), NOW(6), NOW(6), NOW(6)); SELECT * FROM t1; dt0 2001-01-01 10:10:10 dt1 2001-01-01 10:10:10.1 dt2 2001-01-01 10:10:10.12 dt3 2001-01-01 10:10:10.123 dt4 2001-01-01 10:10:10.1235 dt5 2001-01-01 10:10:10.12346 dt6 2001-01-01 10:10:10.123456 dt0 1970-01-01 07:10:10 dt1 1970-01-01 07:10:10.0 dt2 1970-01-01 07:10:10.00 dt3 1970-01-01 07:10:10.000 dt4 1970-01-01 07:10:10.0000 dt5 1970-01-01 07:10:10.00000 dt6 1970-01-01 07:10:10.000000 dt0 1970-01-01 07:10:10 dt1 1970-01-01 07:10:10.1 dt2 1970-01-01 07:10:10.12 dt3 1970-01-01 07:10:10.123 dt4 1970-01-01 07:10:10.1235 dt5 1970-01-01 07:10:10.12346 dt6 1970-01-01 07:10:10.123456 include/sync_slave_sql_with_master.inc SELECT * FROM t1; dt0 2001-01-01 10:10:10 dt1 2001-01-01 10:10:10.1 dt2 2001-01-01 10:10:10.12 dt3 2001-01-01 10:10:10.123 dt4 2001-01-01 10:10:10.1235 dt5 2001-01-01 10:10:10.12346 dt6 2001-01-01 10:10:10.123456 dt0 1970-01-01 07:10:10 dt1 1970-01-01 07:10:10.0 dt2 1970-01-01 07:10:10.00 dt3 1970-01-01 07:10:10.000 dt4 1970-01-01 07:10:10.0000 dt5 1970-01-01 07:10:10.00000 dt6 1970-01-01 07:10:10.000000 dt0 1970-01-01 07:10:10 dt1 1970-01-01 07:10:10.1 dt2 1970-01-01 07:10:10.12 dt3 1970-01-01 07:10:10.123 dt4 1970-01-01 07:10:10.1235 dt5 1970-01-01 07:10:10.12346 dt6 1970-01-01 07:10:10.123456 DROP TABLE t1; include/sync_slave_sql_with_master.inc CREATE TABLE t1 ( t0 TIME(0), t1 TIME(1), t2 TIME(2), t3 TIME(3), t4 TIME(4), t5 TIME(5), t6 TIME(6) ); SET @t='10:10:10.123456'; INSERT INTO t1 VALUES (@t, @t, @t, @t, @t, @t, @t); INSERT INTO t1 VALUES (CURTIME(), CURTIME(), CURTIME(), CURTIME(), CURTIME(), CURTIME(), CURTIME()); INSERT INTO t1 VALUES (CURTIME(6), CURTIME(6), CURTIME(6), CURTIME(6), CURTIME(6), CURTIME(6), CURTIME(6)); SELECT * FROM t1; t0 10:10:10 t1 10:10:10.1 t2 10:10:10.12 t3 10:10:10.123 t4 10:10:10.1235 t5 10:10:10.12346 t6 10:10:10.123456 t0 07:10:10 t1 07:10:10.0 t2 07:10:10.00 t3 07:10:10.000 t4 07:10:10.0000 t5 07:10:10.00000 t6 07:10:10.000000 t0 07:10:10 t1 07:10:10.1 t2 07:10:10.12 t3 07:10:10.123 t4 07:10:10.1235 t5 07:10:10.12346 t6 07:10:10.123456 include/sync_slave_sql_with_master.inc SELECT * FROM t1; t0 10:10:10 t1 10:10:10.1 t2 10:10:10.12 t3 10:10:10.123 t4 10:10:10.1235 t5 10:10:10.12346 t6 10:10:10.123456 t0 07:10:10 t1 07:10:10.0 t2 07:10:10.00 t3 07:10:10.000 t4 07:10:10.0000 t5 07:10:10.00000 t6 07:10:10.000000 t0 07:10:10 t1 07:10:10.1 t2 07:10:10.12 t3 07:10:10.123 t4 07:10:10.1235 t5 07:10:10.12346 t6 07:10:10.123456 DROP TABLE t1; include/sync_slave_sql_with_master.inc include/rpl_end.inc