Debian Codegraph @

mysql-test/suite/rpl/r/rpl_bug31076.result

raw
1 include/master-slave.inc
2 [connection master]
3 SET @saved_slave_type_conversions = @@slave_type_conversions;
4 SET GLOBAL SLAVE_TYPE_CONVERSIONS = 'ALL_NON_LOSSY';
5 CREATE DATABASE track;
6 USE track;
7 CREATE TABLE `visits` (
8 `visits_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
9 `myid` varchar(32) NOT NULL DEFAULT '',
10 `src` varchar(64) NOT NULL DEFAULT '',
11 `ip` int(10) unsigned NOT NULL DEFAULT '0',
12 `cc` char(2) NOT NULL DEFAULT '',
13 `org` varchar(80) DEFAULT NULL,
14 `ref` varchar(255) NOT NULL DEFAULT '',
15 `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
16 `host` varchar(30) NOT NULL DEFAULT '',
17 `entry` varchar(255) NOT NULL DEFAULT '',
18 `visit_exit` varchar(255) NOT NULL DEFAULT '',
19 `user_id` int(11) unsigned NOT NULL DEFAULT '0',
20 `visit_start` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
21 PRIMARY KEY (`visits_id`),
22 KEY `ip` (`ip`),
23 KEY `time` (`time`),
24 KEY `user_id` (`user_id`)
25 ) ENGINE=MyISAM AUTO_INCREMENT=21293381 DEFAULT CHARSET=latin1;
26 CREATE TABLE `visits_events` (
27 `event_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
28 `visit_id` int(11) unsigned NOT NULL DEFAULT '0',
29 `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
30 `src` varchar(64) NOT NULL DEFAULT '',
31 `data` varchar(255) NOT NULL DEFAULT '',
32 `visits_events_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
33 PRIMARY KEY (`visits_events_id`),
34 KEY `event_id` (`event_id`),
35 KEY `visit_id` (`visit_id`),
36 KEY `data` (`data`)
37 ) ENGINE=MyISAM AUTO_INCREMENT=33900731 DEFAULT CHARSET=latin1;
38 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
39 /*!40019 SET @@session.max_delayed_threads=0*/;
40 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
41 BINLOG '
42 O1ZVRw8BAAAAZgAAAGoAAAAAAAQANS4xLjIzLXJjLWRlYnVnLWxvZwAAAAAAAAAAAAAAAAAAAAAA
43 AAAAAAAAAAAAAAAAAAA7VlVHEzgNAAgAEgAEBAQEEgAAUwAEGggAAAAICAgC
44 '/*!*/;
45 BINLOG '
46 Bk3vRhO0AQAAOAAAALcLyQkAAJlXFwIAAAAABXRyYWNrAA12aXNpdHNfZXZlbnRzAAYJAwcPDwM=
47 Bk3vRhe0AQAAWgAAABEMyQkQAJlXFwIAAAEABv/AIE4AvvVDAQZN70YAK0Rvd25sb2Fkcy9NeVNR
48 TC00LjEvbXlzcWwtNC4xLjEyYS13aW4zMi56aXBPaAIC
49 '/*!*/;
50 SET INSERT_ID=21231039/*!*/;
51 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
52 use track/*!*/;
53 SET TIMESTAMP=1190087942/*!*/;
54 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@session.unique_checks=1/*!*/;
55 SET @@session.sql_mode=0/*!*/;
56 SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/;
57 SET @@session.time_zone='UTC'/*!*/;
58 INSERT INTO visits (myid, user_id, src, ip, cc, org, ref, time, host, entry, visit_exit, visit_start)
59 VALUES ('3m3l4rhs6do0sf5p1i9lr94g928a272v', '', '', INET_ATON('71.118.124.98'), '', '', 'http://dev.mysql.com/downloads/connector/j/3.0.html', NULL, '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())/*!*/;
60 Warnings:
61 Warning 1366 Incorrect integer value: '' for column `track`.`visits`.`user_id` at row 1
62 SELECT * FROM visits;
63 visits_id myid src ip cc org ref time host entry visit_exit user_id visit_start
64 21231039 3m3l4rhs6do0sf5p1i9lr94g928a272v 1198947426 http://dev.mysql.com/downloads/connector/j/3.0.html 2007-09-18 03:59:02 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 0 2007-09-18 03:59:02
65 SELECT * FROM visits_events;
66 event_id visit_id timestamp src data visits_events_id
67 20000 21231038 2007-09-18 03:59:02 Downloads/MySQL-4.1/mysql-4.1.12a-win32.zip 33712207
68 SET GLOBAL SLAVE_TYPE_CONVERSIONS = @saved_slave_type_conversions;
69 DROP DATABASE track;
70 connection slave;
71 End of 5.1 tests
72 include/rpl_end.inc