← Back to branch summary

~ubuntu-branches/ubuntu/trusty/mysql-5.6/trusty

« back to all changes in this revision

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

  • Committer: Package Import Robot
  • Author(s): James Page
  • Date: 2014-02-12 11:54:27 UTC
  • Revision ID: package-import@ubuntu.com-20140212115427-oq6tfsqxl1wuwehi
Tags: upstream-5.6.15
Import upstream version 5.6.15

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/rpl/r/rpl_gtid_empty_group.result
 
1
include/master-slave.inc
 
2
Warnings:
 
3
Note    ####    Sending passwords in plain text without SSL/TLS is extremely insecure.
 
4
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.
 
5
[connection master]
 
6
SET @save.binlog_format= @@global.binlog_format;
 
7
SET @@global.binlog_format= row;
 
8
include/restart_slave.inc
 
9
SET @save.binlog_format= @@session.binlog_format;
 
10
SET @@session.binlog_format= statement;
 
11
CREATE TABLE t1(id INTEGER) ENGINE= Innodb /* group one */;
 
12
UPDATE t1 SET id= 1 WHERE id = 0          /* group two */;
 
13
CREATE TABLE t_ignore(id INTEGER) ENGINE= Innodb /* group three */;
 
14
must be *three* groups logged, where the two last empty:
 
15
include/show_binlog_events.inc
 
16
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
 
17
slave-bin.000001        #       Previous_gtids  #       #       
 
18
slave-bin.000001        #       Gtid    #       #       SET @@SESSION.GTID_NEXT= 'Gtid_set'
 
19
slave-bin.000001        #       Query   #       #       use `test`; CREATE TABLE t1(id INTEGER) ENGINE= Innodb /* group one */
 
20
slave-bin.000001        #       Gtid    #       #       SET @@SESSION.GTID_NEXT= 'Gtid_set'
 
21
slave-bin.000001        #       Query   #       #       BEGIN
 
22
slave-bin.000001        #       Query   #       #       COMMIT
 
23
slave-bin.000001        #       Gtid    #       #       SET @@SESSION.GTID_NEXT= 'Gtid_set'
 
24
slave-bin.000001        #       Query   #       #       BEGIN
 
25
slave-bin.000001        #       Query   #       #       COMMIT
 
26
FLUSH LOGS;
 
27
DROP TABLE t2;
 
28
ERROR 42S02: Unknown table 'test.t2'
 
29
INSERT INTO t1 VALUES (1, 1);
 
30
ERROR 21S01: Column count doesn't match value count at row 1
 
31
BEGIN;
 
32
INSERT INTO t1 VALUES (2);
 
33
ROLLBACK;
 
34
*** must be empty log ***
 
35
include/show_binlog_events.inc
 
36
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
 
37
master-bin.000002       #       Previous_gtids  #       #       Gtid_set
 
38
DROP TABLE t1;
 
39
DROP TABLE t_ignore;
 
40
SET @@global.binlog_format= @save.binlog_format;
 
41
include/rpl_end.inc