eval create table t9 (a int not null auto_increment, b char(16) not null, primary key (a)) engine=myisam data directory="$MYSQLTEST_VARDIR/tmp" index directory="$MYSQLTEST_VARDIR/run";
42
eval create temporary table t9 (a int not null auto_increment, b char(16) not null, primary key (a)) engine=myisam data directory="$MYSQLTEST_VARDIR/tmp" index directory="$MYSQLTEST_VARDIR/run";
43
43
44
44
insert into t9 select * from t1;
45
45
check table t9;
54
54
# Test renames
55
55
alter table t9 rename t8, add column d int not null;
56
56
alter table t8 rename t7;
57
rename table t7 to t9;
57
# because "rename table t7 to t9" should obviously not support temp tables. GAH
58
alter table t7 rename t9;
58
59
# Drop old t1 table, keep t9
59
60
drop table t1;
60
61
74
75
create database mysqltest;
75
76
76
77
--error 1,1
77
create table mysqltest.t9 (a int not null auto_increment, b char(16) not null, primary key (a)) engine=myisam index directory="/this-dir-does-not-exist";
78
create temporary table mysqltest.t9 (a int not null auto_increment, b char(16) not null, primary key (a)) engine=myisam index directory="/this-dir-does-not-exist";
78
79
79
80
--error 1103,1103
80
create table mysqltest.t9 (a int not null auto_increment, b char(16) not null, primary key (a)) engine=myisam index directory="not-hard-path";
81
82
# Should fail becasue the file t9.MYI already exist in 'run'
eval create table mysqltest.t9 (a int not null auto_increment, b char(16) not null, primary key (a)) engine=myisam index directory="$MYSQLTEST_VARDIR/run";
86
87
# Should fail becasue the file t9.MYD already exist in 'tmp'
eval create table mysqltest.t9 (a int not null auto_increment, b char(16) not null, primary key (a)) engine=myisam data directory="$MYSQLTEST_VARDIR/tmp";
81
create temporary table mysqltest.t9 (a int not null auto_increment, b char(16) not null, primary key (a)) engine=myisam index directory="not-hard-path";
91
82
92
83
# Check moving table t9 from default database to mysqltest;
93
84
# In this case the symlinks should be removed.
102
93
# Test changing data dir (Bug #1662)
103
94
#
104
95
105
create table t1 (a int not null) engine=myisam;
96
create temporary table t1 (a int not null) engine=myisam;