summaryrefslogtreecommitdiff
path: root/mysql-test/r/mysqlslap.result
diff options
context:
space:
mode:
authorunknown <brian@zim.(none)>2007-03-26 02:24:49 -0700
committerunknown <brian@zim.(none)>2007-03-26 02:24:49 -0700
commit1517e2c45680c4f92d05b7903e9469dcea995660 (patch)
tree7b4198d0547b3b43933b1a867437fa4ea766dadb /mysql-test/r/mysqlslap.result
parentd5915675f67ce5beb4f6118ff8d121da36d19b52 (diff)
downloadmariadb-git-1517e2c45680c4f92d05b7903e9469dcea995660.tar.gz
Added pre and post option to test run (allows me to adjust an engine once all of the data has been loaded).
Kinda obvious that this was going to come up ;) client/client_priv.h: New options client/mysqlslap.c: Added option for pre/post run mysql-test/r/mysqlslap.result: Updated tests mysql-test/t/mysqlslap.test: Updated test
Diffstat (limited to 'mysql-test/r/mysqlslap.result')
-rw-r--r--mysql-test/r/mysqlslap.result24
1 files changed, 24 insertions, 0 deletions
diff --git a/mysql-test/r/mysqlslap.result b/mysql-test/r/mysqlslap.result
index 1a8b77fde1c..bca7919d78c 100644
--- a/mysql-test/r/mysqlslap.result
+++ b/mysql-test/r/mysqlslap.result
@@ -143,3 +143,27 @@ select * from t1;
select * from t2;
select * from t1;
DROP SCHEMA IF EXISTS `mysqlslap`;
+DROP SCHEMA IF EXISTS `mysqlslap`;
+CREATE SCHEMA `mysqlslap`;
+use mysqlslap;
+set storage_engine=`heap`;
+CREATE TABLE t1 (id int, name varchar(64));
+create table t2(foo1 varchar(32), foo2 varchar(32));
+INSERT INTO t1 VALUES (1, 'This is a test');
+insert into t2 values ('test', 'test2');
+SHOW TABLES;
+select * from t1;
+SHOW TABLES;
+DROP SCHEMA IF EXISTS `mysqlslap`;
+DROP SCHEMA IF EXISTS `mysqlslap`;
+CREATE SCHEMA `mysqlslap`;
+use mysqlslap;
+set storage_engine=`myisam`;
+CREATE TABLE t1 (id int, name varchar(64));
+create table t2(foo1 varchar(32), foo2 varchar(32));
+INSERT INTO t1 VALUES (1, 'This is a test');
+insert into t2 values ('test', 'test2');
+SHOW TABLES;
+select * from t1;
+SHOW TABLES;
+DROP SCHEMA IF EXISTS `mysqlslap`;