diff options
| author | unknown <holyfoot/hf@hfmain.(none)> | 2007-07-28 00:50:17 +0500 |
|---|---|---|
| committer | unknown <holyfoot/hf@hfmain.(none)> | 2007-07-28 00:50:17 +0500 |
| commit | baf24e69daf32141dda59b6d7fe817cc688b9f88 (patch) | |
| tree | 6f49804f252b4bc23bbc6ed88ec06302a3d5a08d /mysql-test/suite | |
| parent | c40dabb64de3c1d9e860f0dc72ac6cbfa4f9f9b9 (diff) | |
| parent | 8feaed2ae75ea20a6f6e94aac7dd404fd2953835 (diff) | |
| download | mariadb-git-baf24e69daf32141dda59b6d7fe817cc688b9f88.tar.gz | |
Merge bk@192.168.21.1:mysql-5.1-opt
into mysql.com:/home/hf/work/29878/my51-29878
Diffstat (limited to 'mysql-test/suite')
| -rw-r--r-- | mysql-test/suite/rpl/r/rpl_session_var.result | 10 | ||||
| -rw-r--r-- | mysql-test/suite/rpl/t/rpl_session_var.test | 22 |
2 files changed, 32 insertions, 0 deletions
diff --git a/mysql-test/suite/rpl/r/rpl_session_var.result b/mysql-test/suite/rpl/r/rpl_session_var.result index b5b4b815ade..787899932d6 100644 --- a/mysql-test/suite/rpl/r/rpl_session_var.result +++ b/mysql-test/suite/rpl/r/rpl_session_var.result @@ -41,3 +41,13 @@ select * from t2 order by b; b a 1 1 drop table t1,t2; +CREATE TABLE t1 ( +`id` int(11) NOT NULL auto_increment, +`data` varchar(100), +PRIMARY KEY (`id`) +) ENGINE=MyISAM; +INSERT INTO t1(data) VALUES(SESSION_USER()); +SELECT * FROM t1; +id data +1 +drop table t1; diff --git a/mysql-test/suite/rpl/t/rpl_session_var.test b/mysql-test/suite/rpl/t/rpl_session_var.test index a6f4b496a23..8231a0dbefd 100644 --- a/mysql-test/suite/rpl/t/rpl_session_var.test +++ b/mysql-test/suite/rpl/t/rpl_session_var.test @@ -40,3 +40,25 @@ drop table t1,t2; save_master_pos; connection slave; sync_with_master; + +# +# Bug #29878 Garbage data generation when executing SESSION_USER() on a slave. +# + +connection master; +CREATE TABLE t1 ( + `id` int(11) NOT NULL auto_increment, + `data` varchar(100), + PRIMARY KEY (`id`) + ) ENGINE=MyISAM; + +INSERT INTO t1(data) VALUES(SESSION_USER()); +save_master_pos; +connection slave; +sync_with_master; +SELECT * FROM t1; +connection master; +drop table t1; +save_master_pos; +connection slave; +sync_with_master; |