Debian Codegraph @

mysql-test/suite/rpl/t/rpl_stmt_default_as_expr_alter.test

raw
1 # ==== Purpose ====
2 #
3 # Test warnings for Unsafe statement generated inside DEFAULT expression
4 #
5 # ==== Requirements ====
6 #
7 # R1. `ALTER TABLE` with a non-deterministic function as a `DEFAULT` expression
8 # for an added column should always succeed and log a warning for
9 # `BINLOG_FORMAT=STATEMENT`, specifically an unsafe statement warning -
10 # ER_BINLOG_UNSAFE_SYSTEM_FUNCTION
11 #
12 # R2. `ALTER TABLE` with a deterministic function as a `DEFAULT` expression for
13 # an added column should always succeed with `BINLOG_FORMAT=STATEMENT`.
14 #
15 # ==== Implementation ====
16 #
17 # Test `ALTER TABLE ... ADD COLUMN ... DEFAULT` statement with both a
18 # deterministic and non-deterministic function as the `DEFAULT` expression
19 #
20 # ==== References ====
21 # WL#9418 Permit default value to be a function or expression, support for LOBs
22 # BUG#28799939 DISALLOW ALTER TABLE ADD COLUMN WITH NONDETERMINISTIC DEFAULT, IF BINLOG ENABLED
23 #
24
25 --source include/have_binlog_format_statement.inc
26 --source include/master-slave.inc
27
28 CALL mtr.add_suppression('.statement is unsafe because it uses a system function that may return a different value on the replica.');
29
30 --echo # Create tables on master
31 CREATE TABLE t1 (z VARCHAR(36));
32
33 ALTER TABLE t1 ADD COLUMN a char(36) DEFAULT (PI());
34 ALTER TABLE t1 ADD COLUMN b char(36) DEFAULT (RAND());
35 --let $assert_text = Found 1 warning in the error log
36 --let $assert_file = $MYSQLTEST_VARDIR/log/mysqld.1.err
37 --let $assert_select = statement is unsafe because it uses a system function that may return a different value on the replica
38 --let $assert_count = 1
39 --source include/assert_grep.inc
40
41 # Clean up
42 DROP TABLE t1;
43 --source include/rpl_end.inc