diff options
author | ndbdev@dl145b.mysql.com <> | 2005-08-31 20:45:48 +0200 |
---|---|---|
committer | ndbdev@dl145b.mysql.com <> | 2005-08-31 20:45:48 +0200 |
commit | 583979d949bd5bd011b16d415631d41e7ceee529 (patch) | |
tree | df48637e985f4d72268ca92076f8628b73b8f077 /mysql-test/r/alter_table.result | |
parent | 6bf4e15b0836363ea63f156525e0653a4da6534b (diff) | |
parent | 41fc00641cf0bcab8bf52059c4e482c964f261fc (diff) | |
download | mariadb-git-583979d949bd5bd011b16d415631d41e7ceee529.tar.gz |
merge
Diffstat (limited to 'mysql-test/r/alter_table.result')
-rw-r--r-- | mysql-test/r/alter_table.result | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/r/alter_table.result b/mysql-test/r/alter_table.result index 5bb464665a0..3dc44ffb987 100644 --- a/mysql-test/r/alter_table.result +++ b/mysql-test/r/alter_table.result @@ -523,6 +523,10 @@ alter table t1 drop key no_such_key; ERROR 42000: Can't DROP 'no_such_key'; check that column/key exists alter table t1 drop key a; drop table t1; +CREATE TABLE T12207(a int) ENGINE=MYISAM; +ALTER TABLE T12207 DISCARD TABLESPACE; +ERROR HY000: Table storage engine for 'T12207' doesn't have this option +DROP TABLE T12207; create table t1 (a text) character set koi8r; insert into t1 values (_koi8r'ΤΕΣΤ'); select hex(a) from t1; @@ -591,3 +595,18 @@ alter table t1 add unique key (i, v); select * from t1 where i between 2 and 4 and v in ('def','3r4f','lmn'); i v 4 3r4f +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; |