diff options
Diffstat (limited to 'mysql-test/r/rpl_stm_000001.result')
-rw-r--r-- | mysql-test/r/rpl_stm_000001.result | 82 |
1 files changed, 0 insertions, 82 deletions
diff --git a/mysql-test/r/rpl_stm_000001.result b/mysql-test/r/rpl_stm_000001.result deleted file mode 100644 index 3b4cd05f640..00000000000 --- a/mysql-test/r/rpl_stm_000001.result +++ /dev/null @@ -1,82 +0,0 @@ -stop slave; -drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; -reset master; -reset slave; -drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; -start slave; -create table t1 (word char(20) not null); -load data infile '../std_data_ln/words.dat' into table t1; -load data local infile 'MYSQL_TEST_DIR/std_data/words.dat' into table t1; -select * from t1 limit 10; -word -Aarhus -Aaron -Ababa -aback -abaft -abandon -abandoned -abandoning -abandonment -abandons -stop slave; -set password for root@"localhost" = password('foo'); -start slave; -set password for root@"localhost" = password(''); -create table t3(n int); -insert into t3 values(1),(2); -select * from t3; -n -1 -2 -select sum(length(word)) from t1; -sum(length(word)) -1022 -drop table t1,t3; -create table t1 (n int) engine=myisam; -reset master; -stop slave; -reset slave; -lock tables t1 read; -start slave; -unlock tables; -create table t2(id int); -insert into t2 values(connection_id()); -create temporary table t3(n int); -insert into t3 select get_lock('crash_lock%20C', 1) from t2; -update t1 set n = n + get_lock('crash_lock%20C', 2); -select (@id := id) - id from t2; -(@id := id) - id -0 -kill @id; -drop table t2; -Got one of the listed errors -set global sql_slave_skip_counter=1; -start slave; -select count(*) from t1; -count(*) -5000 -drop table t1; -create table t1 (n int); -insert into t1 values(3456); -insert into mysql.user (Host, User, Password) -VALUES ("10.10.10.%", "blafasel2", password("blafasel2")); -Warnings: -Warning 1364 Field 'ssl_cipher' doesn't have a default value -Warning 1364 Field 'x509_issuer' doesn't have a default value -Warning 1364 Field 'x509_subject' doesn't have a default value -select select_priv,user from mysql.user where user = _binary'blafasel2'; -select_priv user -N blafasel2 -update mysql.user set Select_priv = "Y" where User= _binary"blafasel2"; -select select_priv,user from mysql.user where user = _binary'blafasel2'; -select_priv user -Y blafasel2 -select n from t1; -n -3456 -select select_priv,user from mysql.user where user = _binary'blafasel2'; -select_priv user -Y blafasel2 -drop table t1; -delete from mysql.user where user="blafasel2"; |