diff options
| author | evgen@sunlight.local <> | 2006-08-01 06:42:33 +0400 |
|---|---|---|
| committer | evgen@sunlight.local <> | 2006-08-01 06:42:33 +0400 |
| commit | 6806776eed0eb28c02cd9b8636b630e37e1803ff (patch) | |
| tree | d3aa90ab29cf41c357155a0e0def4163110eb01d /mysql-test | |
| parent | b43b2a2fe0982f0bb89ee4a996cc7729e8215cdc (diff) | |
| parent | 8d4684b6b4eaf541f71630fabc8518a59a824d59 (diff) | |
| download | mariadb-git-6806776eed0eb28c02cd9b8636b630e37e1803ff.tar.gz | |
Merge epotemkin@bk-internal.mysql.com:/home/bk/mysql-5.0-opt
into sunlight.local:/local_work/tmp_merge-5.0-opt-mysql
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/view.result | 11 | ||||
| -rw-r--r-- | mysql-test/t/view.test | 11 |
2 files changed, 22 insertions, 0 deletions
diff --git a/mysql-test/r/view.result b/mysql-test/r/view.result index b2c65423b59..3b5ccad7298 100644 --- a/mysql-test/r/view.result +++ b/mysql-test/r/view.result @@ -2807,6 +2807,17 @@ yadda yad DROP VIEW v1; DROP TABLE t1; +CREATE TABLE t1 (x INT, y INT); +CREATE ALGORITHM=TEMPTABLE SQL SECURITY INVOKER VIEW v1 AS SELECT x FROM t1; +SHOW CREATE VIEW v1; +View Create View +v1 CREATE ALGORITHM=TEMPTABLE DEFINER=`root`@`localhost` SQL SECURITY INVOKER VIEW `v1` AS select `t1`.`x` AS `x` from `t1` +ALTER VIEW v1 AS SELECT x, y FROM t1; +SHOW CREATE VIEW v1; +View Create View +v1 CREATE ALGORITHM=TEMPTABLE DEFINER=`root`@`localhost` SQL SECURITY INVOKER VIEW `v1` AS select `t1`.`x` AS `x`,`t1`.`y` AS `y` from `t1` +DROP VIEW v1; +DROP TABLE t1; CREATE TABLE t1 (s1 char); INSERT INTO t1 VALUES ('Z'); CREATE VIEW v1 AS SELECT s1 collate latin1_german1_ci AS col FROM t1; diff --git a/mysql-test/t/view.test b/mysql-test/t/view.test index 1b930353ca4..fba5f75c32c 100644 --- a/mysql-test/t/view.test +++ b/mysql-test/t/view.test @@ -2669,6 +2669,17 @@ DROP VIEW v1; DROP TABLE t1; # +#Bug #21080: ALTER VIEW makes user restate SQL SECURITY mode, and ALGORITHM +# +CREATE TABLE t1 (x INT, y INT); +CREATE ALGORITHM=TEMPTABLE SQL SECURITY INVOKER VIEW v1 AS SELECT x FROM t1; +SHOW CREATE VIEW v1; + +ALTER VIEW v1 AS SELECT x, y FROM t1; +SHOW CREATE VIEW v1; + +DROP VIEW v1; +DROP TABLE t1; # Bug #21086: server crashes when VIEW defined with a SELECT with COLLATE # clause is called # |