summaryrefslogtreecommitdiff
path: root/mysql-test/r/mysqlslap.result
diff options
context:
space:
mode:
authorunknown <brian@zim.(none)>2007-06-15 17:22:57 -0700
committerunknown <brian@zim.(none)>2007-06-15 17:22:57 -0700
commitc862dab1551859d32385309de4b1cffcd17a3309 (patch)
tree89ab9ccb96ad0622bd9265010dd763bf2adfcee6 /mysql-test/r/mysqlslap.result
parentf6a7490c387c5752df6b10007efe19f993f64e43 (diff)
downloadmariadb-git-c862dab1551859d32385309de4b1cffcd17a3309.tar.gz
Added a test for pre-statement call, and fixed connection/deconnect code so that the rest of bbench can be ran by others.
client/client_priv.h: Clean up of options. client/mysqlslap.c: Cleanup of the connection and reconnect code. mysql-test/r/mysqlslap.result: Add of new test. mysql-test/t/mysqlslap.test: Additional test.
Diffstat (limited to 'mysql-test/r/mysqlslap.result')
-rw-r--r--mysql-test/r/mysqlslap.result44
1 files changed, 44 insertions, 0 deletions
diff --git a/mysql-test/r/mysqlslap.result b/mysql-test/r/mysqlslap.result
index bca7919d78c..cc8bc3dac31 100644
--- a/mysql-test/r/mysqlslap.result
+++ b/mysql-test/r/mysqlslap.result
@@ -167,3 +167,47 @@ 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=`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');
+SET AUTOCOMMIT=0;
+SHOW TABLES;
+select * from t1;
+select * from t2;
+COMMIT;
+select * from t1;
+select * from t2;
+COMMIT;
+select * from t1;
+select * from t2;
+COMMIT;
+COMMIT;
+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');
+SET AUTOCOMMIT=0;
+SHOW TABLES;
+select * from t1;
+select * from t2;
+COMMIT;
+select * from t1;
+select * from t2;
+COMMIT;
+select * from t1;
+select * from t2;
+COMMIT;
+COMMIT;
+SHOW TABLES;
+DROP SCHEMA IF EXISTS `mysqlslap`;