diff options
| author | Sergei Golubchik <serg@mariadb.org> | 2022-04-08 00:06:53 +0200 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2022-04-09 11:49:11 +0200 |
| commit | d623b5a1dd9196fdeb60d933a51f48967c9d4196 (patch) | |
| tree | a59b6ee78368b611879c9b295c901fce2dee8f01 /mysql-test/main/intersect.result | |
| parent | 3814b04d6b0b87e20cdfa85933221d463ce71515 (diff) | |
| download | mariadb-git-d623b5a1dd9196fdeb60d933a51f48967c9d4196.tar.gz | |
MDEV-22282 When using mysqldump to backup a view that contains derived tables, the database name is prepended to each table in the view
derived tables have db = "", table_name = "*", those aren't real names
to be compared with.
Diffstat (limited to 'mysql-test/main/intersect.result')
| -rw-r--r-- | mysql-test/main/intersect.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/main/intersect.result b/mysql-test/main/intersect.result index 62ab0b7e5de..827d1f4d909 100644 --- a/mysql-test/main/intersect.result +++ b/mysql-test/main/intersect.result @@ -724,7 +724,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 select `__3`.`c` AS `c`,`__3`.`d` AS `d` from ((select `test`.`t2`.`c` AS `c`,`test`.`t2`.`d` AS `d` from `test`.`t2`) intersect (select `test`.`t3`.`e` AS `e`,`test`.`t3`.`f` AS `f` from `test`.`t3`)) `__3` union (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 select `__3`.`c` AS `c`,`__3`.`d` AS `d` from ((select `t2`.`c` AS `c`,`t2`.`d` AS `d` from `t2`) intersect (select `t3`.`e` AS `e`,`t3`.`f` AS `f` from `t3`)) `__3` union (select 4 AS `4`,4 AS `4`) latin1 latin1_swedish_ci drop view v1; drop tables t1,t2,t3; # |