Debian Codegraph @

mysql-test/suite/galera/r/view.result

raw
1 connection node_2;
2 connection node_1;
3 #
4 # MDEV-7222: Cluster Node Crash at CREATE DEFINER statement
5 #
6 USE test;
7 CREATE DEFINER=CURRENT_USER VIEW v1 AS SELECT 1;
8 DROP VIEW v1;
9 #
10 # MDEV-8464 : ALTER VIEW not replicated in some cases
11 #
12 # On node_1
13 connection node_1;
14 USE test;
15 CREATE TABLE t1(i INT) ENGINE=INNODB;
16 CREATE DEFINER=CURRENT_USER VIEW v1 AS SELECT * FROM t1;
17 CREATE ALGORITHM=MERGE VIEW v2 AS SELECT * FROM t1;
18 CREATE ALGORITHM=TEMPTABLE VIEW v3 AS SELECT * FROM t1;
19 CREATE ALGORITHM=UNDEFINED DEFINER=CURRENT_USER VIEW v4 AS SELECT * FROM t1;
20 # On node_2
21 connection node_2;
22 USE test;
23 SHOW CREATE VIEW v1;
24 View Create View character_set_client collation_connection
25 v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select `t1`.`i` AS `i` from `t1` latin1 latin1_swedish_ci
26 SHOW CREATE VIEW v2;
27 View Create View character_set_client collation_connection
28 v2 CREATE ALGORITHM=MERGE DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v2` AS select `t1`.`i` AS `i` from `t1` latin1 latin1_swedish_ci
29 SHOW CREATE VIEW v3;
30 View Create View character_set_client collation_connection
31 v3 CREATE ALGORITHM=TEMPTABLE DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v3` AS select `t1`.`i` AS `i` from `t1` latin1 latin1_swedish_ci
32 SHOW CREATE VIEW v4;
33 View Create View character_set_client collation_connection
34 v4 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v4` AS select `t1`.`i` AS `i` from `t1` latin1 latin1_swedish_ci
35 # On node_1
36 connection node_1;
37 ALTER ALGORITHM=MERGE VIEW v1 AS SELECT * FROM t1;
38 ALTER ALGORITHM=UNDEFINED VIEW v2 AS SELECT * FROM t1;
39 ALTER DEFINER=CURRENT_USER VIEW v3 AS SELECT * FROM t1;
40 ALTER ALGORITHM=TEMPTABLE DEFINER=CURRENT_USER VIEW v4 AS SELECT * FROM t1;
41 # On node_2
42 connection node_2;
43 SHOW CREATE VIEW v1;
44 View Create View character_set_client collation_connection
45 v1 CREATE ALGORITHM=MERGE DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select `t1`.`i` AS `i` from `t1` latin1 latin1_swedish_ci
46 SHOW CREATE VIEW v2;
47 View Create View character_set_client collation_connection
48 v2 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v2` AS select `t1`.`i` AS `i` from `t1` latin1 latin1_swedish_ci
49 SHOW CREATE VIEW v3;
50 View Create View character_set_client collation_connection
51 v3 CREATE ALGORITHM=TEMPTABLE DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v3` AS select `t1`.`i` AS `i` from `t1` latin1 latin1_swedish_ci
52 SHOW CREATE VIEW v4;
53 View Create View character_set_client collation_connection
54 v4 CREATE ALGORITHM=TEMPTABLE DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v4` AS select `t1`.`i` AS `i` from `t1` latin1 latin1_swedish_ci
55 # Cleanup
56 DROP VIEW v1, v2, v3, v4;
57 DROP TABLE t1;
58 # End of tests