diff options
| author | unknown <elliot@mysql.com> | 2005-09-14 16:27:55 -0400 |
|---|---|---|
| committer | unknown <elliot@mysql.com> | 2005-09-14 16:27:55 -0400 |
| commit | 11e0bdd70b2bed07ede9f67b244087c97059af2f (patch) | |
| tree | b2752ec5e931107c3f827b846e5f2d76c42e9a17 /mysql-test | |
| parent | 92e4aa67f513de1fc6e791dfb10055bd9862aed1 (diff) | |
| download | mariadb-git-11e0bdd70b2bed07ede9f67b244087c97059af2f.tar.gz | |
Updated test results for view test.
mysql-test/r/view.result:
Updated test results
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/view.result | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/r/view.result b/mysql-test/r/view.result index 1bf97421060..4cb3db2e4aa 100644 --- a/mysql-test/r/view.result +++ b/mysql-test/r/view.result @@ -2210,15 +2210,15 @@ INSERT INTO t1 VALUES ('2005-09-06'); CREATE VIEW v1 AS SELECT DAYNAME(date) FROM t1; SHOW CREATE VIEW v1; View Create View -v1 CREATE ALGORITHM=UNDEFINED VIEW `v1` AS select dayname(`t1`.`date`) AS `DAYNAME(date)` from `t1` +v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select dayname(`t1`.`date`) AS `DAYNAME(date)` from `t1` CREATE VIEW v2 AS SELECT DAYOFWEEK(date) FROM t1; SHOW CREATE VIEW v2; View Create View -v2 CREATE ALGORITHM=UNDEFINED VIEW `v2` AS select dayofweek(`t1`.`date`) AS `DAYOFWEEK(date)` from `t1` +v2 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v2` AS select dayofweek(`t1`.`date`) AS `DAYOFWEEK(date)` from `t1` CREATE VIEW v3 AS SELECT WEEKDAY(date) FROM t1; SHOW CREATE VIEW v3; View Create View -v3 CREATE ALGORITHM=UNDEFINED VIEW `v3` AS select weekday(`t1`.`date`) AS `WEEKDAY(date)` from `t1` +v3 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v3` AS select weekday(`t1`.`date`) AS `WEEKDAY(date)` from `t1` SELECT DAYNAME('2005-09-06'); DAYNAME('2005-09-06') Tuesday |