← Back to branch summary

~mdcallag/+junk/5.1-map

« back to all changes in this revision

Viewing changes to mysql-test/r/rpl_misc_functions.result

  • Committer: msvensson at pilot
  • Date: 2007-04-24 09:11:45 UTC
  • mfrom: (2469.1.106)
  • Revision ID: sp1r-msvensson@pilot.blaudden-20070424091145-10463
Merge pilot.blaudden:/home/msvensson/mysql/my51-m-mysql_upgrade
into  pilot.blaudden:/home/msvensson/mysql/mysql-5.1-maint

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/r/rpl_misc_functions.result
18
18
load data local infile 'MYSQLTEST_VARDIR/master-data/test/rpl_misc_functions.outfile' into table t2;
19
19
select * from t1, t2 where (t1.id=t2.id) and not(t1.i=t2.i and t1.r1=t2.r1 and t1.r2=t2.r2 and t1.p=t2.p);
20
20
id      i       r1      r2      p       id      i       r1      r2      p
21
 
stop slave;
22
 
drop table t1;
23
 
drop table t1;
 
21
drop table t1;
 
22
DROP TABLE IF EXISTS t1;
 
23
CREATE TABLE t1 (col_a double default NULL);
 
24
CREATE PROCEDURE test_replication_sp1()
 
25
BEGIN
 
26
INSERT INTO t1 VALUES (rand()), (rand());
 
27
INSERT INTO t1 VALUES (rand());
 
28
END|
 
29
CREATE PROCEDURE test_replication_sp2()
 
30
BEGIN
 
31
CALL test_replication_sp1();
 
32
CALL test_replication_sp1();
 
33
END|
 
34
CREATE FUNCTION test_replication_sf() RETURNS DOUBLE DETERMINISTIC
 
35
BEGIN
 
36
RETURN (rand() + rand());
 
37
END|
 
38
CALL test_replication_sp1();
 
39
CALL test_replication_sp2();
 
40
INSERT INTO t1 VALUES (test_replication_sf());
 
41
INSERT INTO t1 VALUES (test_replication_sf());
 
42
INSERT INTO t1 VALUES (test_replication_sf());
 
43
DROP PROCEDURE IF EXISTS test_replication_sp1;
 
44
DROP PROCEDURE IF EXISTS test_replication_sp2;
 
45
DROP FUNCTION IF EXISTS test_replication_sf;
 
46
DROP TABLE IF EXISTS t1;