| 1 |
# Applies BINLOG statements equivalent to a binlog generated with GTID_MODE=OFF |
| 2 |
source include/have_binlog_format_mixed_or_row.inc; |
| 3 |
source include/master-slave.inc; |
| 4 |
|
| 5 |
SET @saved_replica_type_conversions = @@replica_type_conversions; |
| 6 |
SET GLOBAL REPLICA_TYPE_CONVERSIONS = 'ALL_NON_LOSSY'; |
| 7 |
|
| 8 |
CREATE DATABASE track; |
| 9 |
USE track; |
| 10 |
|
| 11 |
SET sql_mode = 'NO_ENGINE_SUBSTITUTION'; |
| 12 |
|
| 13 |
CREATE TABLE `visits` ( |
| 14 |
`visits_id` int(11) unsigned NOT NULL AUTO_INCREMENT, |
| 15 |
`myid` varchar(32) NOT NULL DEFAULT '', |
| 16 |
`src` varchar(64) NOT NULL DEFAULT '', |
| 17 |
`ip` int(10) unsigned NOT NULL DEFAULT '0', |
| 18 |
`cc` char(2) NOT NULL DEFAULT '', |
| 19 |
`org` varchar(80) DEFAULT NULL, |
| 20 |
`ref` varchar(255) NOT NULL DEFAULT '', |
| 21 |
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, |
| 22 |
`host` varchar(30) NOT NULL DEFAULT '', |
| 23 |
`entry` varchar(255) NOT NULL DEFAULT '', |
| 24 |
`visit_exit` varchar(255) NOT NULL DEFAULT '', |
| 25 |
`user_id` int(11) unsigned NOT NULL DEFAULT '0', |
| 26 |
`visit_start` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', |
| 27 |
PRIMARY KEY (`visits_id`), |
| 28 |
KEY `ip` (`ip`), |
| 29 |
KEY `time` (`time`), |
| 30 |
KEY `user_id` (`user_id`) |
| 31 |
) AUTO_INCREMENT=21293381 DEFAULT CHARSET=latin1; |
| 32 |
|
| 33 |
SET sql_mode = default; |
| 34 |
|
| 35 |
CREATE TABLE `visits_events` ( |
| 36 |
`event_id` mediumint(8) unsigned NOT NULL DEFAULT '0', |
| 37 |
`visit_id` int(11) unsigned NOT NULL DEFAULT '0', |
| 38 |
`timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, |
| 39 |
`src` varchar(64) NOT NULL DEFAULT '', |
| 40 |
`data` varchar(255) NOT NULL DEFAULT '', |
| 41 |
`visits_events_id` int(11) unsigned NOT NULL AUTO_INCREMENT, |
| 42 |
PRIMARY KEY (`visits_events_id`), |
| 43 |
KEY `event_id` (`event_id`), |
| 44 |
KEY `visit_id` (`visit_id`), |
| 45 |
KEY `data` (`data`) |
| 46 |
) AUTO_INCREMENT=33900731 DEFAULT CHARSET=latin1; |
| 47 |
|
| 48 |
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; |
| 49 |
/*!40019 SET @@session.max_insert_delayed_threads=0*/; |
| 50 |
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; |
| 51 |
--delimiter /*!*/; |
| 52 |
|
| 53 |
# at 4 (0x4) |
| 54 |
#071204 14:29:31 server id 1 end_log_pos 106 |
| 55 |
# Position Timestamp Type Master ID Size Master Pos Flags |
| 56 |
# 4 3b 56 55 47 0f 01 00 00 00 66 00 00 00 6a 00 00 00 00 00 |
| 57 |
# 17 04 00 35 2e 31 2e 32 33 2d 72 63 2d 64 65 62 75 |..5.1.23.rc.debu| |
| 58 |
# 27 67 2d 6c 6f 67 00 00 00 00 00 00 00 00 00 00 00 |g.log...........| |
| 59 |
# 37 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |................| |
| 60 |
# 47 00 00 00 00 3b 56 55 47 13 38 0d 00 08 00 12 00 |.....VUG.8......| |
| 61 |
# 57 04 04 04 04 12 00 00 53 00 04 1a 08 00 00 00 08 |.......S........| |
| 62 |
# 67 08 08 02 |...| |
| 63 |
# Start: binlog v 4, server v 5.1.23-rc-debug-log created 071204 14:29:31 at startup |
| 64 |
|
| 65 |
BINLOG ' |
| 66 |
O1ZVRw8BAAAAZgAAAGoAAAAAAAQANS4xLjIzLXJjLWRlYnVnLWxvZwAAAAAAAAAAAAAAAAAAAAAA |
| 67 |
AAAAAAAAAAAAAAAAAAA7VlVHEzgNAAgAEgAEBAQEEgAAUwAEGggAAAAICAgC |
| 68 |
'/*!*/; |
| 69 |
|
| 70 |
# at 164170623 |
| 71 |
# at 164170679 |
| 72 |
#7918 3:59:2 server id 436 end_log_pos 164170679 |
| 73 |
# 9c90b7f 06 4d ef 46 13 b4 01 00 00 38 00 00 00 b7 0b c9 |.M.F.....8......| |
| 74 |
# 9c90b8f 09 00 00 99 57 17 02 00 00 00 00 05 74 72 61 63 |....W.......trac| |
| 75 |
# 9c90b9f 6b 00 0d 76 69 |k..vi| |
| 76 |
# Table_map: `track`.`visits_events` mapped to number 35084185 |
| 77 |
#7918 3:59:2 server id 436 end_log_pos 164170769 |
| 78 |
# 9c90bb7 06 4d ef 46 17 b4 01 00 00 5a 00 00 00 11 0c c9 |.M.F.....Z......| |
| 79 |
# 9c90bc7 09 10 00 99 57 17 02 00 00 01 00 06 ff c0 20 4e |....W..........N| |
| 80 |
# 9c90bd7 00 be f5 43 01 06 4d ef 46 00 2b 44 6f 77 6e 6c |...C..M.F..Downl| |
| 81 |
# 9c90be7 6f 61 64 73 2f 4d 79 53 51 4c 2d 34 2e 31 2f 6d |oads.MySQL.4.1.m| |
| 82 |
# 9c90bf7 79 73 71 6c 2d 34 2e |ysql.4.| |
| 83 |
# Write_rows: table id 35084185 flags: STMT_END_F |
| 84 |
|
| 85 |
BINLOG ' |
| 86 |
Bk3vRhO0AQAAOAAAALcLyQkAAJlXFwIAAAAABXRyYWNrAA12aXNpdHNfZXZlbnRzAAYJAwcPDwM= |
| 87 |
Bk3vRhe0AQAAWgAAABEMyQkQAJlXFwIAAAEABv/AIE4AvvVDAQZN70YAK0Rvd25sb2Fkcy9NeVNR |
| 88 |
TC00LjEvbXlzcWwtNC4xLjEyYS13aW4zMi56aXBPaAIC |
| 89 |
'/*!*/; |
| 90 |
# at 164170769 |
| 91 |
#7918 3:59:2 server id 436 end_log_pos 164170797 |
| 92 |
# 9c90c11 06 4d ef 46 05 b4 01 00 00 |.M.F.....| |
| 93 |
# Intvar |
| 94 |
SET INSERT_ID=21231039/*!*/; |
| 95 |
# at 164170797 |
| 96 |
#7918 3:59:2 server id 436 end_log_pos 164171293 |
| 97 |
# 9c90c2d 06 4d ef 46 02 b4 01 00 00 f0 01 00 00 1d 0e c9 |.M.F............| |
| 98 |
# 9c90c3d 09 10 00 28 80 af 01 00 00 00 00 05 00 00 1f 00 |................| |
| 99 |
# 9c90c4d 00 00 40 00 00 01 00 00 00 00 00 00 00 00 06 03 |................| |
| 100 |
# 9c90c5d 73 74 64 04 08 00 08 00 08 00 05 03 55 54 43 74 |std.........UTCt| |
| 101 |
# 9c90c6d 72 61 63 6b 00 49 4e 53 45 52 54 20 49 4e 54 4f |rack.INSERT.INTO| |
| 102 |
# 9c90c7d 20 76 69 73 69 74 73 20 28 6d 79 69 64 2c 20 75 |.visits..myid..u| |
| 103 |
# 9c90c8d 73 65 72 5f 69 64 2c 20 73 72 63 2c 20 69 70 2c |ser.id..src..ip.| |
| 104 |
# 9c90c9d 20 63 63 2c 20 6f 72 67 2c 20 72 65 66 2c 20 74 |.cc..org..ref..t| |
| 105 |
# 9c90cad 69 6d 65 2c 20 68 6f 73 74 2c 20 65 6e 74 72 79 |ime..host..entry| |
| 106 |
# 9c90cbd 2c 20 76 69 73 69 74 5f 65 78 69 74 2c 20 76 69 |..visit.exit..vi| |
| 107 |
# 9c90ccd 73 69 74 5f 73 74 61 72 74 29 0a 09 09 09 56 41 |sit.start.....VA| |
| 108 |
# 9c90cdd 4c 55 45 53 20 28 27 33 6d 33 6c 34 72 68 73 36 |LUES...3m3l4rhs6| |
| 109 |
# 9c90ced 64 6f 30 73 66 35 70 31 69 39 6c 72 39 34 67 39 |do0sf5p1i9lr94g9| |
| 110 |
# 9c90cfd 32 38 61 32 37 32 76 27 2c 20 27 27 2c 20 27 27 |28a272v.........| |
| 111 |
# 9c90d0d 2c 20 49 4e 45 54 5f 41 54 4f 4e 28 27 37 31 2e |..INET.ATON..71.| |
| 112 |
# 9c90d1d 31 31 38 2e 31 32 34 2e 39 38 27 29 2c 20 27 27 |118.124.98......| |
| 113 |
# 9c90d2d 2c 20 27 27 2c 20 27 68 74 74 70 3a 2f 2f 64 65 |.......http...de| |
| 114 |
# 9c90d3d 76 2e 6d 79 73 71 6c 2e 63 6f 6d 2f 64 6f 77 6e |v.mysql.com.down| |
| 115 |
# 9c90d4d 6c 6f 61 64 73 2f 63 6f 6e 6e 65 63 74 6f 72 2f |loads.connector.| |
| 116 |
# 9c90d5d 6a 2f 33 2e 30 2e 68 74 6d 6c 27 2c 20 4e 55 4c |j.3.0.html...NUL| |
| 117 |
# 9c90d6d 4c 2c 20 27 64 65 76 2e 6d 79 73 71 6c 2e 63 6f |L...dev.mysql.co| |
| 118 |
# 9c90d7d 6d 27 2c 20 27 2f 67 65 74 2f 44 6f 77 6e 6c 6f |m.....get.Downlo| |
| 119 |
# 9c90d8d 61 64 73 2f 43 6f 6e 6e 65 63 74 6f 72 2d 4a 2f |ads.Connector.J.| |
| 120 |
# 9c90d9d 6d 79 73 71 6c 2d 63 6f 6e 6e 65 63 74 6f 72 2d |mysql.connector.| |
| 121 |
# 9c90dad 6a 61 76 61 2d 33 2e 30 2e 31 37 2d 67 61 2e 7a |java.3.0.17.ga.z| |
| 122 |
# 9c90dbd 69 70 2f 66 72 6f 6d 2f 70 69 63 6b 27 2c 20 27 |ip.from.pick....| |
| 123 |
# 9c90dcd 2f 67 65 74 2f 44 6f 77 6e 6c 6f 61 64 73 2f 43 |.get.Downloads.C| |
| 124 |
# 9c90ddd 6f 6e 6e 65 63 74 6f 72 2d 4a 2f 6d 79 73 71 6c |onnector.J.mysql| |
| 125 |
# 9c90ded 2d 63 6f 6e 6e 65 63 74 6f 72 2d 6a 61 76 61 2d |.connector.java.| |
| 126 |
# 9c90dfd 33 2e 30 2e 31 37 2d 67 61 2e 7a 69 70 |3.0.17.ga.zip| |
| 127 |
# Query thread_id=28278824 exec_time=0 error_code=0 |
| 128 |
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; |
| 129 |
use track/*!*/; |
| 130 |
SET TIMESTAMP=1190087942/*!*/; |
| 131 |
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@session.unique_checks=1/*!*/; |
| 132 |
SET @@session.sql_mode=0/*!*/; |
| 133 |
SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; |
| 134 |
SET @@session.time_zone='UTC'/*!*/; |
| 135 |
INSERT INTO visits (myid, user_id, src, ip, cc, org, ref, time, host, entry, visit_exit, visit_start) |
| 136 |
VALUES ('3m3l4rhs6do0sf5p1i9lr94g928a272v', '', '', INET_ATON('71.118.124.98'), '', '', 'http://dev.mysql.com/downloads/connector/j/3.0.html', CURRENT_TIMESTAMP , 'dev.mysql.com', '/get/Downloads/Connector-J/mysql-connector-java-3.0.17-ga.zip/from/pick', '/get/Downloads/Connector-J/mysql-connector-java-3.0.17-ga.zip/from/pick', NOW())/*!*/; |
| 137 |
# at 164171293 |
| 138 |
|
| 139 |
--delimiter ; |
| 140 |
|
| 141 |
--replace_column 8 CURRENT_TIMESTAMP |
| 142 |
SELECT * FROM visits; |
| 143 |
SELECT * FROM visits_events; |
| 144 |
|
| 145 |
SET GLOBAL REPLICA_TYPE_CONVERSIONS = @saved_replica_type_conversions; |
| 146 |
|
| 147 |
# Cleanup |
| 148 |
DROP DATABASE track; |
| 149 |
--source include/sync_slave_sql_with_master.inc |
| 150 |
|
| 151 |
--echo End of 5.1 tests |
| 152 |
--source include/rpl_end.inc |