summaryrefslogtreecommitdiff
path: root/mysql-test/r/alter_table.result
diff options
context:
space:
mode:
authoringo@mysql.com <>2005-08-29 18:18:30 +0200
committeringo@mysql.com <>2005-08-29 18:18:30 +0200
commit5d41d5e0f4b547fd84126f836cccfd08862cb05a (patch)
treed775a19ce336b9046b4bba8758999a325c8182fe /mysql-test/r/alter_table.result
parent5845a6e55311f4189983aa1780225f91c3eecfbf (diff)
parent330eb045364a1079815c58a12ef9685b2c437b75 (diff)
downloadmariadb-git-5d41d5e0f4b547fd84126f836cccfd08862cb05a.tar.gz
Merge mysql.com:/home/mydev/mysql-4.1-4100
into mysql.com:/home/mydev/mysql-5.0-5000
Diffstat (limited to 'mysql-test/r/alter_table.result')
-rw-r--r--mysql-test/r/alter_table.result15
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/r/alter_table.result b/mysql-test/r/alter_table.result
index 9f127181fc2..5723ae115f2 100644
--- a/mysql-test/r/alter_table.result
+++ b/mysql-test/r/alter_table.result
@@ -537,3 +537,18 @@ create table t1 ( a timestamp );
alter table t1 add unique ( a(1) );
ERROR HY000: Incorrect sub part key; the used key part isn't a string, the used length is longer than the key part, or the storage engine doesn't support unique sub keys
drop table t1;
+create database mysqltest1;
+create table t1 (c1 int);
+alter table t1 rename mysqltest1.t1;
+drop table t1;
+ERROR 42S02: Unknown table 't1'
+alter table mysqltest1.t1 rename t1;
+drop table t1;
+create table t1 (c1 int);
+use mysqltest1;
+drop database mysqltest1;
+alter table test.t1 rename t1;
+ERROR 3D000: No database selected
+alter table test.t1 rename test.t1;
+use test;
+drop table t1;