diff options
| author | evgen@moonbone.local <> | 2006-10-13 21:59:52 +0400 |
|---|---|---|
| committer | evgen@moonbone.local <> | 2006-10-13 21:59:52 +0400 |
| commit | 2b474898dc133885fb883847cee6a5370cf3c12e (patch) | |
| tree | 7bd36ea523de49e01ecb5afa66beded74a185380 /mysql-test/r/rename.result | |
| parent | ea8a646dc0fcf2cd36475e932f29348ce04dc120 (diff) | |
| download | mariadb-git-2b474898dc133885fb883847cee6a5370cf3c12e.tar.gz | |
Bug#14959: ALTER TABLE isn't able to rename a view
The mysql_alter_table() was able to rename only a table.
The view/table renaming code is moved from the function rename_tables
to the new function called do_rename().
The mysql_alter_table() function calls it when it needs to rename a view.
Diffstat (limited to 'mysql-test/r/rename.result')
| -rw-r--r-- | mysql-test/r/rename.result | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/r/rename.result b/mysql-test/r/rename.result index 76c0f4422fe..345270231ef 100644 --- a/mysql-test/r/rename.result +++ b/mysql-test/r/rename.result @@ -54,3 +54,13 @@ Tables_in_test t2 t4 drop table t2, t4; +create table t1(f1 int); +create view v1 as select * from t1; +alter table v1 rename to v2; +alter table v1 rename to v2; +ERROR 42S02: Table 'test.v1' doesn't exist +rename table v2 to v1; +rename table v2 to v1; +ERROR 42S01: Table 'v1' already exists +drop view v1; +drop table t1; |