diff options
| author | bell@sanja.is.com.ua <> | 2005-09-14 11:07:04 +0300 |
|---|---|---|
| committer | bell@sanja.is.com.ua <> | 2005-09-14 11:07:04 +0300 |
| commit | 914b961d010082d79692c60a75d9f604daeb64ae (patch) | |
| tree | fce4b18c473720fa7cbd61bd4bf4ac04214f27be /mysql-test/r/sql_mode.result | |
| parent | 0726bb62424c1212a0fabc763e84d9c4f2259683 (diff) | |
| parent | 71ffbbf81b992da42497d30511eba37cee94c27e (diff) | |
| download | mariadb-git-914b961d010082d79692c60a75d9f604daeb64ae.tar.gz | |
Merge sanja.is.com.ua:/home/bell/mysql/bk/mysql-5.0
into sanja.is.com.ua:/home/bell/mysql/bk/work-owner2-5.0
Diffstat (limited to 'mysql-test/r/sql_mode.result')
| -rw-r--r-- | mysql-test/r/sql_mode.result | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/r/sql_mode.result b/mysql-test/r/sql_mode.result index 33ab83bbd11..c35c88b993b 100644 --- a/mysql-test/r/sql_mode.result +++ b/mysql-test/r/sql_mode.result @@ -449,11 +449,11 @@ create table t2 (a int); create view v1 as select a from t1; show create view v1; View Create View -v1 CREATE ALGORITHM=UNDEFINED VIEW `v1` AS select `t1`.`a` AS `a` from `t1` +v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `test`.`v1` AS select `test`.`t1`.`a` AS `a` from `test`.`t1` SET @@SQL_MODE='ANSI_QUOTES'; show create view v1; View Create View -v1 CREATE ALGORITHM=UNDEFINED VIEW "v1" AS select "t1"."a" AS "a" from "t1" +v1 CREATE ALGORITHM=UNDEFINED DEFINER="root"@"localhost" SQL SECURITY DEFINER VIEW "test"."v1" AS select "test"."t1"."a" AS "a" from "test"."t1" create view v2 as select a from t2 where a in (select a from v1); drop view v2, v1; drop table t1, t2; |