Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 connection master;
4 DROP PROCEDURE IF EXISTS test.p1;
5 DROP TABLE IF EXISTS test.t1;
6 CREATE TABLE test.t1 (a INT, blob_column LONGBLOB, vchar_column VARCHAR(100), PRIMARY KEY(a)) engine=myisam;
7 INSERT INTO test.t1 VALUES(1,UUID(),UUID());
8 create procedure test.p1()
9 begin
10 INSERT INTO test.t1 VALUES(2,UUID(),UUID());
11 INSERT INTO test.t1 VALUES(3,UUID(),UUID());
12 end|
13 CALL test.p1();
14 create function test.fn1(x int)
15 returns int
16 begin
17 insert into t1 values (4+x,UUID(),UUID());
18 insert into t1 values (5+x,UUID(),UUID());
19 return 0;
20 end|
21 select fn1(0);
22 fn1(0)
23 0
24 create table t2 (a int) engine=myisam;
25 insert into t2 values(fn1(2));
26 connection slave;
27 SHOW CREATE TABLE test.t1;
28 Table Create Table
29 t1 CREATE TABLE `t1` (
30 `a` int(11) NOT NULL,
31 `blob_column` longblob DEFAULT NULL,
32 `vchar_column` varchar(100) DEFAULT NULL,
33 PRIMARY KEY (`a`)
34 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
35 connection master;
36 DROP PROCEDURE test.p1;
37 DROP FUNCTION test.fn1;
38 DROP TABLE test.t1;
39 DROP TABLE test.t2;
40 include/rpl_end.inc