← Back to branch summary

~ubuntu-branches/ubuntu/trusty/mariadb-5.5/trusty-proposed

« back to all changes in this revision

Viewing changes to mysql-test/suite/rpl/r/rpl_bug31076.result

  • Committer: Package Import Robot
  • Author(s): Otto Kekäläinen
  • Date: 2013-12-22 10:27:05 UTC
  • Revision ID: package-import@ubuntu.com-20131222102705-mndw7s12mz0szrcn
Tags: upstream-5.5.32
Import upstream version 5.5.32

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/rpl/r/rpl_bug31076.result
 
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_insert_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 '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
End of 5.1 tests
 
71
include/rpl_end.inc