diff options
author | unknown <brian@zim.(none)> | 2005-12-25 02:03:53 -0800 |
---|---|---|
committer | unknown <brian@zim.(none)> | 2005-12-25 02:03:53 -0800 |
commit | 4348dc672fa4a5690bd9adb954fe5988b7593dd9 (patch) | |
tree | 75ecbdd0a94e874a8f5b289dcfcc25ea24e7de03 /mysql-test/r/mysqlslap.result | |
parent | a6ef1dc3a8e173e909d325d2067ebfbdae2e6006 (diff) | |
download | mariadb-git-4348dc672fa4a5690bd9adb954fe5988b7593dd9.tar.gz |
New option to run multiple engines through the same test:
--engine="myisam,archive"
--number-of-rows has been removed for the time being and replaced with
option to allow you to just repeat multiple time all of the inserts you specifed with data. When number-of-rows-returns it will be instead used for averaging rows while growing concurrency.
Returned stats now has accurent row and query counts since it includes a multiple for the rows and queries added.
Parser is now a touch smarter and understands end of file issues if you have a delimiter at the end of the file.
client/client_priv.h:
New options
client/mysqlslap.c:
Modifications for doing repeated tests.
mysql-test/r/mysqlslap.result:
New result file
mysql-test/t/mysqlslap.test:
Changes in tests to make sure concurrency failures would not occur.
Diffstat (limited to 'mysql-test/r/mysqlslap.result')
-rw-r--r-- | mysql-test/r/mysqlslap.result | 2993 |
1 files changed, 2560 insertions, 433 deletions
diff --git a/mysql-test/r/mysqlslap.result b/mysql-test/r/mysqlslap.result index 1999466669d..e1741402b35 100644 --- a/mysql-test/r/mysqlslap.result +++ b/mysql-test/r/mysqlslap.result @@ -4,199 +4,71 @@ use mysqlslap; set storage_engine=`MYISAM`; CREATE TABLE t1 (id int, name varchar(64)); INSERT INTO t1 VALUES (1, 'This is a test'); -INSERT INTO t1 VALUES (1, 'This is a test'); -INSERT INTO t1 VALUES (1, 'This is a test'); -INSERT INTO t1 VALUES (1, 'This is a test'); -INSERT INTO t1 VALUES (1, 'This is a test'); -INSERT INTO t1 VALUES (1, 'This is a test'); -INSERT INTO t1 VALUES (1, 'This is a test'); -INSERT INTO t1 VALUES (1, 'This is a test'); -INSERT INTO t1 VALUES (1, 'This is a test'); -INSERT INTO t1 VALUES (1, 'This is a test'); DROP SCHEMA IF EXISTS `mysqlslap`; CREATE SCHEMA `mysqlslap`; use mysqlslap; set storage_engine=`MYISAM`; CREATE TABLE t1 (id int, name varchar(64)); -INSERT INTO t1 VALUES (1, 'This is a test'); -INSERT INTO t1 VALUES (1, 'This is a test'); -INSERT INTO t1 VALUES (1, 'This is a test'); -INSERT INTO t1 VALUES (1, 'This is a test'); -INSERT INTO t1 VALUES (1, 'This is a test'); -INSERT INTO t1 VALUES (1, 'This is a test'); -INSERT INTO t1 VALUES (1, 'This is a test'); -INSERT INTO t1 VALUES (1, 'This is a test'); -INSERT INTO t1 VALUES (1, 'This is a test'); -INSERT INTO t1 VALUES (1, 'This is a test'); +select * from t1; DROP SCHEMA IF EXISTS `mysqlslap`; CREATE SCHEMA `mysqlslap`; use mysqlslap; set storage_engine=`MYISAM`; CREATE TABLE t1 (id int, name varchar(64)); -INSERT INTO t1 VALUES (1, 'This is a test'); -INSERT INTO t1 VALUES (1, 'This is a test'); -INSERT INTO t1 VALUES (1, 'This is a test'); -INSERT INTO t1 VALUES (1, 'This is a test'); -INSERT INTO t1 VALUES (1, 'This is a test'); -INSERT INTO t1 VALUES (1, 'This is a test'); -INSERT INTO t1 VALUES (1, 'This is a test'); -INSERT INTO t1 VALUES (1, 'This is a test'); -INSERT INTO t1 VALUES (1, 'This is a test'); -INSERT INTO t1 VALUES (1, 'This is a test'); +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)); INSERT INTO t1 VALUES (1, 'This is a test'); -INSERT INTO t1 VALUES (1, 'This is a test'); -INSERT INTO t1 VALUES (1, 'This is a test'); -INSERT INTO t1 VALUES (1, 'This is a test'); -INSERT INTO t1 VALUES (1, 'This is a test'); -INSERT INTO t1 VALUES (1, 'This is a test'); -INSERT INTO t1 VALUES (1, 'This is a test'); -INSERT INTO t1 VALUES (1, 'This is a test'); -INSERT INTO t1 VALUES (1, 'This is a test'); -INSERT INTO t1 VALUES (1, 'This is a test'); DROP SCHEMA IF EXISTS `mysqlslap`; CREATE SCHEMA `mysqlslap`; use mysqlslap; set storage_engine=`MYISAM`; CREATE TABLE t1 (id int, name varchar(64)); -INSERT INTO t1 VALUES (1, 'This is a test'); -INSERT INTO t1 VALUES (1, 'This is a test'); -INSERT INTO t1 VALUES (1, 'This is a test'); -INSERT INTO t1 VALUES (1, 'This is a test'); -INSERT INTO t1 VALUES (1, 'This is a test'); -INSERT INTO t1 VALUES (1, 'This is a test'); -INSERT INTO t1 VALUES (1, 'This is a test'); -INSERT INTO t1 VALUES (1, 'This is a test'); -INSERT INTO t1 VALUES (1, 'This is a test'); -INSERT INTO t1 VALUES (1, 'This is a test'); +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)); select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; DROP SCHEMA IF EXISTS `mysqlslap`; CREATE SCHEMA `mysqlslap`; use mysqlslap; set storage_engine=`MYISAM`; CREATE TABLE t1 (id int, name varchar(64)); -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; +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)); -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; +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)); -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; +INSERT INTO t1 VALUES (1, 'This is a test'); +DROP SCHEMA IF EXISTS `mysqlslap`; +CREATE SCHEMA `mysqlslap`; +use mysqlslap; +set storage_engine=`MYISAM`; +CREATE TABLE t1 (id int, name varchar(64)); +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)); +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)); -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; -select * from t1; select * from t1; DROP SCHEMA IF EXISTS `mysqlslap`; CREATE SCHEMA `mysqlslap`; @@ -209,365 +81,2620 @@ 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'); -INSERT INTO t1 VALUES (1, 'This is a test'); -insert into t2 values ('test', 'test2'); -INSERT INTO t1 VALUES (1, 'This is a test'); -insert into t2 values ('test', 'test2'); -INSERT INTO t1 VALUES (1, 'This is a test'); -insert into t2 values ('test', 'test2'); -INSERT INTO t1 VALUES (1, 'This is a test'); -insert into t2 values ('test', 'test2'); -INSERT INTO t1 VALUES (1, 'This is a test'); -insert into t2 values ('test', 'test2'); -INSERT INTO t1 VALUES (1, 'This is a test'); -insert into t2 values ('test', 'test2'); -INSERT INTO t1 VALUES (1, 'This is a test'); -insert into t2 values ('test', 'test2'); -INSERT INTO t1 VALUES (1, 'This is a test'); -insert into t2 values ('test', 'test2'); -INSERT INTO t1 VALUES (1, 'This is a test'); -insert into t2 values ('test', 'test2'); +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'); -INSERT INTO t1 VALUES (1, 'This is a test'); -insert into t2 values ('test', 'test2'); -INSERT INTO t1 VALUES (1, 'This is a test'); -insert into t2 values ('test', 'test2'); -INSERT INTO t1 VALUES (1, 'This is a test'); -insert into t2 values ('test', 'test2'); -INSERT INTO t1 VALUES (1, 'This is a test'); -insert into t2 values ('test', 'test2'); -INSERT INTO t1 VALUES (1, 'This is a test'); -insert into t2 values ('test', 'test2'); -INSERT INTO t1 VALUES (1, 'This is a test'); -insert into t2 values ('test', 'test2'); -INSERT INTO t1 VALUES (1, 'This is a test'); -insert into t2 values ('test', 'test2'); -INSERT INTO t1 VALUES (1, 'This is a test'); -insert into t2 values ('test', 'test2'); -INSERT INTO t1 VALUES (1, 'This is a test'); -insert into t2 values ('test', 'test2'); +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'); INSERT INTO t1 VALUES (1, 'This is a test'); -insert into t2 values ('test', 'test2'); -INSERT INTO t1 VALUES (1, 'This is a test'); -insert into t2 values ('test', 'test2'); -INSERT INTO t1 VALUES (1, 'This is a test'); -insert into t2 values ('test', 'test2'); +DROP SCHEMA IF EXISTS `mysqlslap`; +CREATE SCHEMA `mysqlslap`; +use mysqlslap; +set storage_engine=`MYISAM`; +CREATE TABLE t1 (id int, name varchar(64)); +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)); +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)); +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)); +select * from t1; +DROP SCHEMA IF EXISTS `mysqlslap`; +CREATE SCHEMA `mysqlslap`; +use mysqlslap; +set storage_engine=`MYISAM`; +CREATE TABLE t1 (id int, name varchar(64)); +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)); +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)); +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)); +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)); INSERT INTO t1 VALUES (1, 'This is a test'); -insert into t2 values ('test', 'test2'); +DROP SCHEMA IF EXISTS `mysqlslap`; +CREATE SCHEMA `mysqlslap`; +use mysqlslap; +set storage_engine=`MYISAM`; +CREATE TABLE t1 (id int, name varchar(64)); +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)); +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)); +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)); +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)); +select * from t1; +DROP SCHEMA IF EXISTS `mysqlslap`; +CREATE SCHEMA `mysqlslap`; +use mysqlslap; +set storage_engine=`MYISAM`; +CREATE TABLE t1 (id int, name varchar(64)); +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)); +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)); +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)); +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)); +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)); INSERT INTO t1 VALUES (1, 'This is a test'); -insert into t2 values ('test', 'test2'); +DROP SCHEMA IF EXISTS `mysqlslap`; +CREATE SCHEMA `mysqlslap`; +use mysqlslap; +set storage_engine=`MYISAM`; +CREATE TABLE t1 (id int, name varchar(64)); +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)); +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)); +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)); +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)); +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)); +select * from t1; +DROP SCHEMA IF EXISTS `mysqlslap`; +CREATE SCHEMA `mysqlslap`; +use mysqlslap; +set storage_engine=`MYISAM`; +CREATE TABLE t1 (id int, name varchar(64)); +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)); +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)); +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)); +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)); +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)); +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)); INSERT INTO t1 VALUES (1, 'This is a test'); -insert into t2 values ('test', 'test2'); +DROP SCHEMA IF EXISTS `mysqlslap`; +CREATE SCHEMA `mysqlslap`; +use mysqlslap; +set storage_engine=`MYISAM`; +CREATE TABLE t1 (id int, name varchar(64)); +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)); +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)); +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)); +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)); +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)); +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)); +select * from t1; +DROP SCHEMA IF EXISTS `mysqlslap`; +CREATE SCHEMA `mysqlslap`; +use mysqlslap; +set storage_engine=`MYISAM`; +CREATE TABLE t1 (id int, name varchar(64)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); INSERT INTO t1 VALUES (1, 'This is a test'); -insert into t2 values ('test', 'test2'); +DROP SCHEMA IF EXISTS `mysqlslap`; +CREATE SCHEMA `mysqlslap`; +use mysqlslap; +set storage_engine=`MYISAM`; +CREATE TABLE t1 (id int, name varchar(64)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +select * from t1; +DROP SCHEMA IF EXISTS `mysqlslap`; +CREATE SCHEMA `mysqlslap`; +use mysqlslap; +set storage_engine=`MYISAM`; +CREATE TABLE t1 (id int, name varchar(64)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); INSERT INTO t1 VALUES (1, 'This is a test'); -insert into t2 values ('test', 'test2'); +DROP SCHEMA IF EXISTS `mysqlslap`; +CREATE SCHEMA `mysqlslap`; +use mysqlslap; +set storage_engine=`MYISAM`; +CREATE TABLE t1 (id int, name varchar(64)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +select * from t1; +DROP SCHEMA IF EXISTS `mysqlslap`; +CREATE SCHEMA `mysqlslap`; +use mysqlslap; +set storage_engine=`MYISAM`; +CREATE TABLE t1 (id int, name varchar(64)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); INSERT INTO t1 VALUES (1, 'This is a test'); -insert into t2 values ('test', 'test2'); 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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +select * from t1; +DROP SCHEMA IF EXISTS `mysqlslap`; +CREATE SCHEMA `mysqlslap`; +use mysqlslap; +set storage_engine=`MYISAM`; +CREATE TABLE t1 (id int, name varchar(64)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); INSERT INTO t1 VALUES (1, 'This is a test'); -insert into t2 values ('test', 'test2'); +DROP SCHEMA IF EXISTS `mysqlslap`; +CREATE SCHEMA `mysqlslap`; +use mysqlslap; +set storage_engine=`MYISAM`; +CREATE TABLE t1 (id int, name varchar(64)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +select * from t1; +DROP SCHEMA IF EXISTS `mysqlslap`; +CREATE SCHEMA `mysqlslap`; +use mysqlslap; +set storage_engine=`MYISAM`; +CREATE TABLE t1 (id int, name varchar(64)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); INSERT INTO t1 VALUES (1, 'This is a test'); -insert into t2 values ('test', 'test2'); +DROP SCHEMA IF EXISTS `mysqlslap`; +CREATE SCHEMA `mysqlslap`; +use mysqlslap; +set storage_engine=`MYISAM`; +CREATE TABLE t1 (id int, name varchar(64)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +select * from t1; +DROP SCHEMA IF EXISTS `mysqlslap`; +CREATE SCHEMA `mysqlslap`; +use mysqlslap; +set storage_engine=`MYISAM`; +CREATE TABLE t1 (id int, name varchar(64)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); INSERT INTO t1 VALUES (1, 'This is a test'); -insert into t2 values ('test', 'test2'); +DROP SCHEMA IF EXISTS `mysqlslap`; +CREATE SCHEMA `mysqlslap`; +use mysqlslap; +set storage_engine=`MYISAM`; +CREATE TABLE t1 (id int, name varchar(64)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +select * from t1; +DROP SCHEMA IF EXISTS `mysqlslap`; +CREATE SCHEMA `mysqlslap`; +use mysqlslap; +set storage_engine=`MYISAM`; +CREATE TABLE t1 (id int, name varchar(64)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); INSERT INTO t1 VALUES (1, 'This is a test'); -insert into t2 values ('test', 'test2'); +DROP SCHEMA IF EXISTS `mysqlslap`; +CREATE SCHEMA `mysqlslap`; +use mysqlslap; +set storage_engine=`MYISAM`; +CREATE TABLE t1 (id int, name varchar(64)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +select * from t1; +DROP SCHEMA IF EXISTS `mysqlslap`; +CREATE SCHEMA `mysqlslap`; +use mysqlslap; +set storage_engine=`MYISAM`; +CREATE TABLE t1 (id int, name varchar(64)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); INSERT INTO t1 VALUES (1, 'This is a test'); -insert into t2 values ('test', 'test2'); +DROP SCHEMA IF EXISTS `mysqlslap`; +CREATE SCHEMA `mysqlslap`; +use mysqlslap; +set storage_engine=`MYISAM`; +CREATE TABLE t1 (id int, name varchar(64)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +select * from t1; +DROP SCHEMA IF EXISTS `mysqlslap`; +CREATE SCHEMA `mysqlslap`; +use mysqlslap; +set storage_engine=`MYISAM`; +CREATE TABLE t1 (id int, name varchar(64)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); INSERT INTO t1 VALUES (1, 'This is a test'); -insert into t2 values ('test', 'test2'); +DROP SCHEMA IF EXISTS `mysqlslap`; +CREATE SCHEMA `mysqlslap`; +use mysqlslap; +set storage_engine=`MYISAM`; +CREATE TABLE t1 (id int, name varchar(64)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +select * from t1; +DROP SCHEMA IF EXISTS `mysqlslap`; +CREATE SCHEMA `mysqlslap`; +use mysqlslap; +set storage_engine=`MYISAM`; +CREATE TABLE t1 (id int, name varchar(64)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); INSERT INTO t1 VALUES (1, 'This is a test'); -insert into t2 values ('test', 'test2'); +DROP SCHEMA IF EXISTS `mysqlslap`; +CREATE SCHEMA `mysqlslap`; +use mysqlslap; +set storage_engine=`MYISAM`; +CREATE TABLE t1 (id int, name varchar(64)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +select * from t1; +DROP SCHEMA IF EXISTS `mysqlslap`; +CREATE SCHEMA `mysqlslap`; +use mysqlslap; +set storage_engine=`MYISAM`; +CREATE TABLE t1 (id int, name varchar(64)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); INSERT INTO t1 VALUES (1, 'This is a test'); -insert into t2 values ('test', 'test2'); +DROP SCHEMA IF EXISTS `mysqlslap`; +CREATE SCHEMA `mysqlslap`; +use mysqlslap; +set storage_engine=`MYISAM`; +CREATE TABLE t1 (id int, name varchar(64)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +select * from t1; +DROP SCHEMA IF EXISTS `mysqlslap`; +CREATE SCHEMA `mysqlslap`; +use mysqlslap; +set storage_engine=`MYISAM`; +CREATE TABLE t1 (id int, name varchar(64)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); INSERT INTO t1 VALUES (1, 'This is a test'); -insert into t2 values ('test', 'test2'); +DROP SCHEMA IF EXISTS `mysqlslap`; +CREATE SCHEMA `mysqlslap`; +use mysqlslap; +set storage_engine=`MYISAM`; +CREATE TABLE t1 (id int, name varchar(64)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +select * from t1; +DROP SCHEMA IF EXISTS `mysqlslap`; +CREATE SCHEMA `mysqlslap`; +use mysqlslap; +set storage_engine=`MYISAM`; +CREATE TABLE t1 (id int, name varchar(64)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); INSERT INTO t1 VALUES (1, 'This is a test'); -insert into t2 values ('test', 'test2'); DROP SCHEMA IF EXISTS `mysqlslap`; CREATE SCHEMA `mysqlslap`; use mysqlslap; set storage_engine=`MYISAM`; CREATE TABLE t1 (id int, name varchar(64)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +select * from t1; +DROP SCHEMA IF EXISTS `mysqlslap`; +CREATE SCHEMA `mysqlslap`; +use mysqlslap; +set storage_engine=`MYISAM`; +CREATE TABLE t1 (id int, name varchar(64)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +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)); +DROP SCHEMA IF EXISTS `mysqlslap`; +DROP SCHEMA IF EXISTS `mysqlslap`; +CREATE SCHEMA `mysqlslap`; +use mysqlslap; +set storage_engine=`archive`; +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'); -INSERT INTO t1 VALUES (1, 'This is a test'); -insert into t2 values ('test', 'test2'); -INSERT INTO t1 VALUES (1, 'This is a test'); -insert into t2 values ('test', 'test2'); -INSERT INTO t1 VALUES (1, 'This is a test'); -insert into t2 values ('test', 'test2'); -INSERT INTO t1 VALUES (1, 'This is a test'); -insert into t2 values ('test', 'test2'); -INSERT INTO t1 VALUES (1, 'This is a test'); -insert into t2 values ('test', 'test2'); -INSERT INTO t1 VALUES (1, 'This is a test'); -insert into t2 values ('test', 'test2'); -INSERT INTO t1 VALUES (1, 'This is a test'); -insert into t2 values ('test', 'test2'); -INSERT INTO t1 VALUES (1, 'This is a test'); -insert into t2 values ('test', 'test2'); -INSERT INTO t1 VALUES (1, 'This is a test'); -insert into t2 values ('test', 'test2'); DROP SCHEMA IF EXISTS `mysqlslap`; CREATE SCHEMA `mysqlslap`; use mysqlslap; -set storage_engine=`MYISAM`; +set storage_engine=`archive`; CREATE TABLE t1 (id int, name varchar(64)); create table t2(foo1 varchar(32), foo2 varchar(32)); select * from t1; select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; DROP SCHEMA IF EXISTS `mysqlslap`; CREATE SCHEMA `mysqlslap`; use mysqlslap; -set storage_engine=`MYISAM`; +set storage_engine=`archive`; CREATE TABLE t1 (id int, name varchar(64)); create table t2(foo1 varchar(32), foo2 varchar(32)); -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; +DROP SCHEMA IF EXISTS `mysqlslap`; DROP SCHEMA IF EXISTS `mysqlslap`; CREATE SCHEMA `mysqlslap`; use mysqlslap; -set storage_engine=`MYISAM`; +set storage_engine=`myisam`; CREATE TABLE t1 (id int, name varchar(64)); create table t2(foo1 varchar(32), foo2 varchar(32)); -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; +INSERT INTO t1 VALUES (1, 'This is a test'); +insert into t2 values ('test', 'test2'); DROP SCHEMA IF EXISTS `mysqlslap`; CREATE SCHEMA `mysqlslap`; use mysqlslap; -set storage_engine=`MYISAM`; +set storage_engine=`archive`; CREATE TABLE t1 (id int, name varchar(64)); create table t2(foo1 varchar(32), foo2 varchar(32)); -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; +DROP SCHEMA IF EXISTS `mysqlslap`; DROP SCHEMA IF EXISTS `mysqlslap`; CREATE SCHEMA `mysqlslap`; use mysqlslap; -set storage_engine=`MYISAM`; +set storage_engine=`myisam`; CREATE TABLE t1 (id int, name varchar(64)); create table t2(foo1 varchar(32), foo2 varchar(32)); select * from t1; select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; -select * from t1; -select * from t2; DROP SCHEMA IF EXISTS `mysqlslap`; CREATE SCHEMA `mysqlslap`; use mysqlslap; -set storage_engine=`MYISAM`; +set storage_engine=`archive`; +CREATE TABLE t1 (id int, name varchar(64)); +create table t2(foo1 varchar(32), foo2 varchar(32)); +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)); DROP SCHEMA IF EXISTS `mysqlslap`; |