From 3f619478f796eddbba6e39502fe941b285dd97b1 Mon Sep 17 00:00:00 2001
From: Daniel Baumann <daniel.baumann@progress-linux.org>
Date: Sat, 4 May 2024 20:00:34 +0200
Subject: Adding upstream version 1:10.11.6.

Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
---
 mysql-test/suite/engines/funcs/r/rpl_view.result | 138 +++++++++++++++++++++++
 1 file changed, 138 insertions(+)
 create mode 100644 mysql-test/suite/engines/funcs/r/rpl_view.result

(limited to 'mysql-test/suite/engines/funcs/r/rpl_view.result')

diff --git a/mysql-test/suite/engines/funcs/r/rpl_view.result b/mysql-test/suite/engines/funcs/r/rpl_view.result
new file mode 100644
index 00000000..68a14972
--- /dev/null
+++ b/mysql-test/suite/engines/funcs/r/rpl_view.result
@@ -0,0 +1,138 @@
+include/master-slave.inc
+[connection master]
+drop table if exists t1,v1;
+drop view if exists t1,v1;
+connection slave;
+reset master;
+connection master;
+create table t1 (a int);
+insert into t1 values (1);
+create view v1 as select a from t1;
+insert into v1 values (2);
+select * from v1 order by a;
+a
+1
+2
+connection slave;
+select * from v1 order by a;
+a
+1
+2
+connection master;
+update v1 set a=3 where a=1;
+select * from v1 order by a;
+a
+2
+3
+connection slave;
+select * from v1 order by a;
+a
+2
+3
+connection master;
+delete from v1 where a=2;
+select * from v1 order by a;
+a
+3
+connection slave;
+select * from v1 order by a;
+a
+3
+connection master;
+alter view v1 as select a as b from t1;
+connection slave;
+select * from v1 order by 1;
+b
+3
+connection master;
+drop view v1;
+connection slave;
+select * from v1 order by a;
+ERROR 42S02: Table 'test.v1' doesn't exist
+connection master;
+drop table t1;
+connection slave;
+
+---> Test for BUG#20438
+
+---> Preparing environment...
+connection master;
+DROP TABLE IF EXISTS t1;
+DROP VIEW IF EXISTS v1;
+
+---> Synchronizing slave with master...
+connection slave;
+
+connection master;
+
+---> Creating objects...
+CREATE TABLE t1(c INT);
+/*!50003 CREATE VIEW v1 AS SELECT * FROM t1 */;
+
+---> Inserting value...
+INSERT INTO t1 VALUES(1);
+
+---> Checking on master...
+SELECT * FROM t1;
+c
+1
+
+---> Synchronizing slave with master...
+connection slave;
+SELECT * FROM t1;
+c
+1
+connection master;
+
+---> Cleaning up...
+DROP VIEW v1;
+DROP TABLE t1;
+connection slave;
+connection master;
+connection master;
+create table t1(a int, b int);
+insert into t1 values (1, 1), (1, 2), (1, 3);
+create view  v1(a, b) as select a, sum(b) from t1 group by a;
+connection slave;
+explain v1;
+Field	Type	Null	Key	Default	Extra
+a	int(11)	YES		NULL	
+b	decimal(32,0)	YES		NULL	
+show create table v1;
+View	Create View	character_set_client	collation_connection
+v1	CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select `t1`.`a` AS `a`,sum(`t1`.`b`) AS `b` from `t1` group by `t1`.`a`	latin1	latin1_swedish_ci
+select * from v1;
+a	b
+1	6
+connection master;
+drop table t1;
+drop view v1;
+connection slave;
+connection master;
+CREATE TABLE t1(a INT);
+CREATE VIEW v1 AS SELECT * FROM t1;
+CREATE VIEW v1 AS SELECT * FROM t1;
+ERROR 42S01: Table 'v1' already exists
+DROP VIEW v1;
+DROP TABLE t1;
+connection slave;
+connection master;
+CREATE TABLE t1 (a INT);
+# create view as output from mysqldump 10.11 (5.0.62)
+/*!50001 CREATE ALGORITHM=UNDEFINED */
+/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
+/*!50001 VIEW `v1` AS select `t1`.`a` AS `a` from `t1` where (`t1`.`a` < 3) */
+/*!50002 WITH CASCADED CHECK OPTION */;
+SHOW CREATE VIEW v1;
+View	Create View	character_set_client	collation_connection
+v1	CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select `t1`.`a` AS `a` from `t1` where `t1`.`a` < 3 WITH CASCADED CHECK OPTION	latin1	latin1_swedish_ci
+connection slave;
+SHOW CREATE VIEW v1;
+View	Create View	character_set_client	collation_connection
+v1	CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select `t1`.`a` AS `a` from `t1` where `t1`.`a` < 3 WITH CASCADED CHECK OPTION	latin1	latin1_swedish_ci
+connection master;
+DROP VIEW v1;
+DROP TABLE t1;
+connection slave;
+End of 5.0 tests
+include/rpl_end.inc
-- 
cgit v1.2.3