Debian Codegraph @

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

raw
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 connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 SET SESSION sql_log_bin= 0;
7 call mtr.add_suppression('Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT.');
8 SET SESSION sql_log_bin= 1;
9 drop database if exists test1;
10 create database test1;
11 use test1;
12 CREATE TABLE `t1` (
13 `id` int(10) unsigned NOT NULL auto_increment,
14 `fname` varchar(100) default NULL,
15 PRIMARY KEY (`id`)
16 ) DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
17 Warnings:
18 Warning 1681 Integer display width is deprecated and will be removed in a future release.
19 INSERT INTO `t1` VALUES (1, 'blablabla');
20 CREATE TABLE `t2` (
21 `id` int(10) NOT NULL auto_increment,
22 `comment` varchar(255) NOT NULL default '',
23 PRIMARY KEY (`id`)
24 ) AUTO_INCREMENT=3 ;
25 Warnings:
26 Warning 1681 Integer display width is deprecated and will be removed in a future release.
27 INSERT INTO `t2` VALUES (1, 'testtest 1');
28 INSERT INTO `t2` VALUES (2, 'test 2');
29 CREATE PROCEDURE simpleproc3 ()
30 NOT DETERMINISTIC
31 BEGIN
32 INSERT INTO t1 (fname) (SELECT t2.comment FROM t2 WHERE t2.id = '1');
33 INSERT INTO t1 (fname) VALUES('test');
34 END
35 $
36 CALL simpleproc3();
37 select * from t2;
38 id comment
39 1 testtest 1
40 2 test 2
41 TRUNCATE TABLE `t1`;
42 CALL simpleproc3();
43 select * from t1;
44 id fname
45 1 testtest 1
46 2 test
47 include/sync_slave_sql_with_master.inc
48 SET SESSION sql_log_bin= 0;
49 call mtr.add_suppression('Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT.');
50 SET SESSION sql_log_bin= 1;
51 use test1;
52 select * from t1;
53 id fname
54 1 testtest 1
55 2 test
56 drop database test1;
57 include/rpl_end.inc