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/r/view.result | |
| 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/r/view.result')
| -rw-r--r-- | mysql-test/r/view.result | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/mysql-test/r/view.result b/mysql-test/r/view.result index b7660dbcbd8..487ce54203d 100644 --- a/mysql-test/r/view.result +++ b/mysql-test/r/view.result @@ -3954,6 +3954,7 @@ drop procedure p; CREATE TABLE t1 (a INT); CREATE VIEW v1 AS SELECT a FROM t1; ALTER TABLE v1; +ERROR HY000: 'test.v1' is not BASE TABLE DROP VIEW v1; DROP TABLE t1; # |