diff options
| author | Dmitry Lenev <dlenev@mysql.com> | 2010-05-28 09:25:11 +0400 |
|---|---|---|
| committer | Dmitry Lenev <dlenev@mysql.com> | 2010-05-28 09:25:11 +0400 |
| commit | 1fbdf160b4f24fd81f9009d1f3312bc676e63732 (patch) | |
| tree | d0e33df4f5e96e3d70da6800c01809e25edd9999 /mysql-test/t/view.test | |
| parent | a3d61b0bb28070f60867de5d748850edd6054ff6 (diff) | |
| download | mariadb-git-1fbdf160b4f24fd81f9009d1f3312bc676e63732.tar.gz | |
Patch that addresses bug #53976 "ALTER TABLE RENAME
is allowed on views (not documented, broken)".
Remove support of ALTER TABLE RENAME for views as:
a) this feature was not documented,
c) does not add any compatibility with other databases,
b) its implementation doesn't follow metadata locking
protocol by accessing .FRM without holding any
metadata lock,
c) its implementation complicates ALTER TABLE's code
by introducing yet another separate branch to it.
After this patch one can rename a view by using the
documented way - RENAME TABLE statement.
Diffstat (limited to 'mysql-test/t/view.test')
| -rw-r--r-- | mysql-test/t/view.test | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/mysql-test/t/view.test b/mysql-test/t/view.test index d1a4d78e58f..360bbc1552d 100644 --- a/mysql-test/t/view.test +++ b/mysql-test/t/view.test @@ -3902,6 +3902,7 @@ drop procedure p; --echo # CREATE TABLE t1 (a INT); CREATE VIEW v1 AS SELECT a FROM t1; +--error ER_WRONG_OBJECT ALTER TABLE v1; DROP VIEW v1; DROP TABLE t1; |