diff options
| author | Marko Mäkelä <marko.makela@mariadb.com> | 2022-04-27 10:43:00 +0300 |
|---|---|---|
| committer | Marko Mäkelä <marko.makela@mariadb.com> | 2022-04-27 10:43:00 +0300 |
| commit | 133c2129cdbb77d8fd55fb303d6f73e1cd3c025c (patch) | |
| tree | 3a4fe134a4db2511d6081cdfc6fdff550c25c620 /mysql-test/main/intersect_all.result | |
| parent | 6948abb94c6739101320d12ddec1d2daae929cc2 (diff) | |
| parent | 638afc4acf86b32b74b3b37314f2dbd048062814 (diff) | |
| download | mariadb-git-133c2129cdbb77d8fd55fb303d6f73e1cd3c025c.tar.gz | |
Merge 10.7 into 10.8
Diffstat (limited to 'mysql-test/main/intersect_all.result')
| -rw-r--r-- | mysql-test/main/intersect_all.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/main/intersect_all.result b/mysql-test/main/intersect_all.result index 243497ffc4f..4589d226fa3 100644 --- a/mysql-test/main/intersect_all.result +++ b/mysql-test/main/intersect_all.result @@ -829,7 +829,7 @@ a b drop procedure p1; 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 `test`.`t1`.`a` AS `a`,`test`.`t1`.`b` AS `b` from `test`.`t1`) union all select `__6`.`c` AS `c`,`__6`.`d` AS `d` from ((select `test`.`t2`.`c` AS `c`,`test`.`t2`.`d` AS `d` from `test`.`t2`) intersect all (select `test`.`t3`.`e` AS `e`,`test`.`t3`.`f` AS `f` from `test`.`t3`)) `__6` union all (select 4 AS `4`,4 AS `4`) latin1 latin1_swedish_ci +v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS (select `t1`.`a` AS `a`,`t1`.`b` AS `b` from `t1`) union all select `__6`.`c` AS `c`,`__6`.`d` AS `d` from ((select `t2`.`c` AS `c`,`t2`.`d` AS `d` from `t2`) intersect all (select `t3`.`e` AS `e`,`t3`.`f` AS `f` from `t3`)) `__6` union all (select 4 AS `4`,4 AS `4`) latin1 latin1_swedish_ci drop view v1; drop tables t1,t2,t3; CREATE TABLE t (i INT); |