• unknown's avatar
    Make it possible to run mysql-test-run.pl with default test suite in different vardir. · d40f7056
    unknown authored
    mysql-test/include/have_outfile.inc:
      Use MYSQLTEST_VARDIR
    mysql-test/include/test_outfile.inc:
      Use MYSQLTEST_VARDIR
    mysql-test/mysql-test-run.pl:
      Create variable $MYSQLTEST_VARDIR that points to  the vardir
      Don't create a symlink from var/ to the physical vardir if it's somewhere else
      Setup a symlink(or copy dir on windows) for std_data so it is available in the physical vardir
      Use "../tmp" as slave-load-tmpdir, since the server is started in var/master-data and slave in var/slave-data they will both find the dumps in "../tmp"
    mysql-test/mysql-test-run.sh:
      Export MYSQLTEST_VARDIR, always pointing at mysql-test/var
    mysql-test/r/backup.result:
      Use MYSQLTEST_VARDIR
    mysql-test/r/blackhole.result:
      Use "../std_data_ln" to find std_data files
    mysql-test/r/loaddata.result:
      Use "../std_data_ln" to find std_data files
    mysql-test/r/mysqlbinlog.result:
      Use "../std_data_ln" to find std_data files
    mysql-test/r/mysqltest.result:
      Use MYSQLTEST_VARDIR
    mysql-test/r/outfile.result:
      Use MYSQLTEST_VARDIR
    mysql-test/r/query_cache.result:
      Add missing drop function
    mysql-test/r/rpl000001.result:
      Use "../std_data_ln" to find std_data files
    mysql-test/r/rpl000004.result:
      Use "../std_data_ln" to find std_data files
    mysql-test/r/rpl_innodb.result:
      Use "../std_data_ln" to find std_data files
    mysql-test/r/rpl_loaddata.result:
      Use "../std_data_ln" to find std_data files
    mysql-test/r/rpl_loaddata_rule_m.result:
      Use "../std_data_ln" to find std_data files
    mysql-test/r/rpl_loaddata_rule_s.result:
      Use "../std_data_ln" to find std_data files
    mysql-test/r/rpl_loaddatalocal.result:
      Use MYSQLTEST_VARDIR
    mysql-test/r/rpl_log.result:
      Use "../std_data_ln" to find std_data files
    mysql-test/r/rpl_misc_functions.result:
      Use MYSQLTEST_VARDIR
    mysql-test/r/rpl_replicate_do.result:
      Use "../std_data_ln" to find std_data files
    mysql-test/r/rpl_rewrite_db.result:
      Use "../std_data_ln" to find std_data files
    mysql-test/r/rpl_timezone.result:
      Use "../std_data_ln" to find std_data files
    mysql-test/r/symlink.result:
      Use MYSQLTEST_VARDIR
    mysql-test/r/trigger.result:
      Use "../std_data_ln" to find std_data files
    mysql-test/r/view.result:
      Use "../std_data_ln" to find std_data files
    mysql-test/r/warnings.result:
      Use "../std_data_ln" to find std_data files
    mysql-test/t/backup-master.sh:
      Use MYSQLTEST_VARDIR
    mysql-test/t/backup.test:
      Use MYSQLTEST_VARDIR
    mysql-test/t/blackhole.test:
      Use "../std_data_ln" to find std_data files
    mysql-test/t/ctype_ucs_binlog.test:
      Use MYSQLTEST_VARDIR
    mysql-test/t/im_daemon_life_cycle-im.opt:
      Use MYSQLTEST_VARDIR
    mysql-test/t/im_options_set.imtest:
      Use MYSQLTEST_VARDIR
    mysql-test/t/im_options_unset.imtest:
      Use MYSQLTEST_VARDIR
    mysql-test/t/loaddata.test:
      Use "../std_data_ln" to find std_data files
    mysql-test/t/myisam.test:
      Use MYSQLTEST_VARDIR
    mysql-test/t/mysqlbinlog.test:
      Use "../std_data_ln" to find std_data files
    mysql-test/t/mysqlbinlog2.test:
      Use MYSQLTEST_VARDIR
    mysql-test/t/mysqldump.test:
      Use MYSQLTEST_VARDIR
    mysql-test/t/mysqltest.test:
      Use MYSQLTEST_VARDIR
    mysql-test/t/ndb_autodiscover.test:
      Use MYSQLTEST_VARDIR
    mysql-test/t/outfile.test:
      Use MYSQLTEST_VARDIR
    mysql-test/t/query_cache.test:
      Add missing drop function
    mysql-test/t/repair.test:
      Use MYSQLTEST_VARDIR
    mysql-test/t/rpl000001.test:
      Use "../std_data_ln" to find std_data files
    mysql-test/t/rpl000004.test:
      Use "../std_data_ln" to find std_data files
    mysql-test/t/rpl000009.test:
      Use MYSQLTEST_VARDIR
    mysql-test/t/rpl000015-slave.sh:
      Use MYSQLTEST_VARDIR
    mysql-test/t/rpl000017-slave.sh:
      Use MYSQLTEST_VARDIR
    mysql-test/t/rpl_EE_error.test:
      Use MYSQLTEST_VARDIR
    mysql-test/t/rpl_charset.test:
      Use MYSQLTEST_VARDIR
    mysql-test/t/rpl_drop_db.test:
      Use MYSQLTEST_VARDIR
    mysql-test/t/rpl_flush_log_loop-master.opt:
      Use MYSQLTEST_VARDIR
    mysql-test/t/rpl_flush_log_loop-master.sh:
      Use MYSQLTEST_VARDIR
    mysql-test/t/rpl_flush_log_loop-slave.opt:
      Use MYSQLTEST_VARDIR
    mysql-test/t/rpl_flush_log_loop-slave.sh:
      Use MYSQLTEST_VARDIR
    mysql-test/t/rpl_innodb.test:
      Use "../std_data_ln" to find std_data files
    mysql-test/t/rpl_loaddata.test:
      Use "../std_data_ln" to find std_data files
    mysql-test/t/rpl_loaddata_rule_m.test:
      Use "../std_data_ln" to find std_data files
    mysql-test/t/rpl_loaddata_rule_s.test:
      Use "../std_data_ln" to find std_data files
    mysql-test/t/rpl_loaddatalocal.test:
      Use MYSQLTEST_VARDIR
    mysql-test/t/rpl_log.test:
      Use "../std_data_ln" to find std_data files
    mysql-test/t/rpl_misc_functions-slave.sh:
      Use MYSQLTEST_VARDIR
    mysql-test/t/rpl_misc_functions.test:
      Use MYSQLTEST_VARDIR
    mysql-test/t/rpl_replicate_do.test:
      Use "../std_data_ln" to find std_data files
    mysql-test/t/rpl_rewrite_db.test:
      Use "../std_data_ln" to find std_data files
    mysql-test/t/rpl_rotate_logs-slave.sh:
      Use MYSQLTEST_VARDIR
    mysql-test/t/rpl_rotate_logs.test:
      Use MYSQLTEST_VARDIR
    mysql-test/t/rpl_timezone.test:
      Use MYSQLTEST_VARDIR
    mysql-test/t/show_check.test:
      Use MYSQLTEST_VARDIR
    mysql-test/t/sp-destruct.test:
      Use MYSQLTEST_VARDIR
    mysql-test/t/symlink.test:
      Use MYSQLTEST_VARDIR
    mysql-test/t/temp_table-master.opt:
      Use MYSQLTEST_VARDIR
    mysql-test/t/trigger-compat.test:
      Use MYSQLTEST_VARDIR
    mysql-test/t/trigger-grant.test:
      Use MYSQLTEST_VARDIR
    mysql-test/t/trigger.test:
      Use "../std_data_ln" to find std_data files
    mysql-test/t/type_varchar.test:
      Use MYSQLTEST_VARDIR
    mysql-test/t/user_var-binlog.test:
      Use MYSQLTEST_VARDIR
    mysql-test/t/view.test:
      Use "../std_data_ln" to find std_data files
    mysql-test/t/warnings.test:
      Use "../std_data_ln" to find std_data files
    mysql-test/include/sourced.inc:
      New BitKeeper file ``mysql-test/include/sourced.inc''
    mysql-test/include/sourced1.inc:
      New BitKeeper file ``mysql-test/include/sourced1.inc''
    d40f7056
symlink.result 3.31 KB
drop table if exists t1,t2,t7,t8,t9;
drop database if exists mysqltest;
create table t1 (a int not null auto_increment, b char(16) not null, primary key (a));
create table t2 (a int not null auto_increment, b char(16) not null, primary key (a));
insert into t1 (b) values ("test"),("test1"),("test2"),("test3");
insert into t2 (b) select b from t1;
insert into t1 (b) select b from t2;
insert into t2 (b) select b from t1;
insert into t1 (b) select b from t2;
insert into t2 (b) select b from t1;
insert into t1 (b) select b from t2;
insert into t2 (b) select b from t1;
insert into t1 (b) select b from t2;
insert into t2 (b) select b from t1;
insert into t1 (b) select b from t2;
insert into t2 (b) select b from t1;
insert into t1 (b) select b from t2;
insert into t2 (b) select b from t1;
insert into t1 (b) select b from t2;
insert into t2 (b) select b from t1;
insert into t1 (b) select b from t2;
insert into t2 (b) select b from t1;
insert into t1 (b) select b from t2;
drop table t2;
insert into t9 select * from t1;
check table t9;
Table	Op	Msg_type	Msg_text
test.t9	check	status	OK
optimize table t9;
Table	Op	Msg_type	Msg_text
test.t9	optimize	status	OK
repair table t9;
Table	Op	Msg_type	Msg_text
test.t9	repair	status	OK
alter table t9 add column c int not null;
show create table t9;
Table	Create Table
t9	CREATE TABLE `t9` (
  `a` int(11) NOT NULL auto_increment,
  `b` char(16) NOT NULL,
  `c` int(11) NOT NULL,
  PRIMARY KEY  (`a`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 DATA DIRECTORY='MYSQLTEST_VARDIR/tmp/' INDEX DIRECTORY='MYSQLTEST_VARDIR/run/'
alter table t9 rename t8, add column d int not null;
alter table t8 rename t7;
rename table t7 to t9;
drop table t1;
SHOW CREATE TABLE t9;
Table	Create Table
t9	CREATE TABLE `t9` (
  `a` int(11) NOT NULL auto_increment,
  `b` char(16) NOT NULL,
  `c` int(11) NOT NULL,
  `d` int(11) NOT NULL,
  PRIMARY KEY  (`a`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 DATA DIRECTORY='MYSQLTEST_VARDIR/tmp/' INDEX DIRECTORY='MYSQLTEST_VARDIR/run/'
Got one of the listed errors
Got one of the listed errors
Got one of the listed errors
Got one of the listed errors
Got one of the listed errors
alter table t9 rename mysqltest.t9;
select count(*) from mysqltest.t9;
count(*)
16724
show create table mysqltest.t9;
Table	Create Table
t9	CREATE TABLE `t9` (
  `a` int(11) NOT NULL auto_increment,
  `b` char(16) NOT NULL,
  `c` int(11) NOT NULL,
  `d` int(11) NOT NULL,
  PRIMARY KEY  (`a`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 DATA DIRECTORY='MYSQLTEST_VARDIR/tmp/' INDEX DIRECTORY='MYSQLTEST_VARDIR/run/'
drop database mysqltest;
create table t1 (a int not null) engine=myisam;
show create table t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `a` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1
alter table t1 add b int;
show create table t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `a` int(11) NOT NULL,
  `b` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1
show create table t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `a` int(11) NOT NULL,
  `b` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1
drop table t1;
show create table t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `i` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1
drop table t1;
show create table t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `i` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1
drop table t1;