diff options
| author | unknown <gkodinov/kgeorge@magare.gmz> | 2007-11-13 19:32:12 +0200 |
|---|---|---|
| committer | unknown <gkodinov/kgeorge@magare.gmz> | 2007-11-13 19:32:12 +0200 |
| commit | c3a4dfd662453e42c43317cd468d9f584518f5f6 (patch) | |
| tree | 6d75c1b7ab2d2220a095c632d902306f8528f105 | |
| parent | ad3e5aa85643cccb0497337a6a3f8c541d08a49d (diff) | |
| download | mariadb-git-c3a4dfd662453e42c43317cd468d9f584518f5f6.tar.gz | |
merge bug 31562 to 5.1 : changed SHOW CREATE VIEW format
| -rw-r--r-- | mysql-test/r/lowercase_view.result | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/r/lowercase_view.result b/mysql-test/r/lowercase_view.result index 3bd03c25fac..c37dc41c495 100644 --- a/mysql-test/r/lowercase_view.result +++ b/mysql-test/r/lowercase_view.result @@ -141,8 +141,8 @@ a CREATE OR REPLACE VIEW v1 AS select X.a from t1 AS X group by X.b having (X.a = 1); SHOW CREATE VIEW v1; -View Create View -v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select `x`.`a` AS `a` from `t1` `x` group by `x`.`b` having (`x`.`a` = 1) +View Create View character_set_client collation_connection +v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select `x`.`a` AS `a` from `t1` `x` group by `x`.`b` having (`x`.`a` = 1) latin1 latin1_swedish_ci SELECT * FROM v1; a DROP VIEW v1; |