Debian Codegraph @

mysql-test/suite/rpl_nogtid/t/rpl_nogtid_mix_row_default_as_expr.test

raw
1 # ==== Purpose ====
2 #
3 # Test errors/warnings for Unsafe statement generated inside DEFAULT expression
4 #
5 # ==== Implementation ====
6 #
7 # CREATE TABLE with DEFAULT expression defined by a non-deterministic function
8 #
9 # ==== References ====
10 # WL#9418 Permit default value to be a function or expression, support for LOBs
11 #
12
13 --source include/have_binlog_format_mixed_or_row.inc
14 --source include/master-slave.inc
15
16 --echo # Create tables on master
17 CREATE TABLE v1 (i VARCHAR(36) DEFAULT (RAND()), j VARCHAR(36) DEFAULT (PI()));
18 INSERT INTO v1(i, j) VALUES ("a","b");
19 INSERT INTO v1 VALUES ("a","b");
20 INSERT INTO v1(i) VALUES ("a");
21 INSERT INTO v1(i,j) VALUES ("a",DEFAULT);
22 INSERT INTO v1(j) VALUES ("b");
23 INSERT INTO v1(i,j) VALUES (DEFAULT,"b");
24 INSERT INTO v1() VALUES();
25 DROP TABLE v1;
26
27 CREATE TABLE t1(
28 id INTEGER NOT NULL AUTO_INCREMENT,
29 token VARCHAR(255) DEFAULT (UUID()),
30 PRIMARY KEY (id),
31 KEY token (token)
32 );
33 INSERT INTO t1 VALUES (3, "abc"), (DEFAULT, DEFAULT);
34 INSERT INTO t1 VALUES (1, "abc"), (2, "def");
35 DROP TABLE t1;
36
37
38 CREATE TABLE t2 (i VARCHAR(36) DEFAULT (UUID()));
39
40 INSERT INTO t2(i) VALUES('MySQL');
41 INSERT INTO t2(i) VALUES(DEFAULT);
42 INSERT INTO t2() VALUES();
43
44 # random values
45 SELECT COUNT(*) from t2;
46
47 SET @start_enforce_gtid_consistency = @@GLOBAL.ENFORCE_GTID_CONSISTENCY;
48 SET GLOBAL ENFORCE_GTID_CONSISTENCY = WARN;
49 ALTER TABLE t2 ADD COLUMN c char(36) DEFAULT (PI());
50 SET GLOBAL ENFORCE_GTID_CONSISTENCY = @start_enforce_gtid_consistency;
51
52 --source include/sync_slave_sql_with_master.inc
53 --echo [ slave connection ]
54
55 SHOW TABLES;
56 SHOW CREATE TABLE t2 ;
57 SELECT COUNT(*) from t2;
58
59 --echo # clean up
60 --source include/rpl_connection_master.inc
61 DROP TABLE t2;
62 --source include/rpl_end.inc