Debian Codegraph @

mysql-test/suite/galera/t/view.test

raw
1 --source include/galera_cluster.inc
2 --source include/have_innodb.inc
3
4 --echo #
5 --echo # MDEV-7222: Cluster Node Crash at CREATE DEFINER statement
6 --echo #
7 USE test;
8 CREATE DEFINER=CURRENT_USER VIEW v1 AS SELECT 1;
9 DROP VIEW v1;
10
11 --echo #
12 --echo # MDEV-8464 : ALTER VIEW not replicated in some cases
13 --echo #
14 --echo # On node_1
15 --connection node_1
16 USE test;
17 CREATE TABLE t1(i INT) ENGINE=INNODB;
18 CREATE DEFINER=CURRENT_USER VIEW v1 AS SELECT * FROM t1;
19 CREATE ALGORITHM=MERGE VIEW v2 AS SELECT * FROM t1;
20 CREATE ALGORITHM=TEMPTABLE VIEW v3 AS SELECT * FROM t1;
21 CREATE ALGORITHM=UNDEFINED DEFINER=CURRENT_USER VIEW v4 AS SELECT * FROM t1;
22
23 --echo # On node_2
24 --connection node_2
25 USE test;
26 SHOW CREATE VIEW v1;
27 SHOW CREATE VIEW v2;
28 SHOW CREATE VIEW v3;
29 SHOW CREATE VIEW v4;
30
31 --echo # On node_1
32 --connection node_1
33 ALTER ALGORITHM=MERGE VIEW v1 AS SELECT * FROM t1;
34 ALTER ALGORITHM=UNDEFINED VIEW v2 AS SELECT * FROM t1;
35 ALTER DEFINER=CURRENT_USER VIEW v3 AS SELECT * FROM t1;
36 ALTER ALGORITHM=TEMPTABLE DEFINER=CURRENT_USER VIEW v4 AS SELECT * FROM t1;
37
38 --echo # On node_2
39 --connection node_2
40 SHOW CREATE VIEW v1;
41 SHOW CREATE VIEW v2;
42 SHOW CREATE VIEW v3;
43 SHOW CREATE VIEW v4;
44
45 --echo # Cleanup
46 DROP VIEW v1, v2, v3, v4;
47 DROP TABLE t1;
48
49 --echo # End of tests