~drizzle-trunk/drizzle/development : contents of tests/r/mysqlslap.result at revision 332

~drizzle-trunk/drizzle/development : (revision 332)

DROP SCHEMA IF EXISTS `mysqlslap`;
CREATE SCHEMA `mysqlslap`;
use mysqlslap;
CREATE TABLE t1 (id int, name varchar(64));
INSERT INTO t1 VALUES (1, 'This is a test');
select * from t1;
DROP SCHEMA IF EXISTS `mysqlslap`;
CREATE SCHEMA `mysqlslap`;
use mysqlslap;
CREATE TABLE t1 (id int, name varchar(64));
INSERT INTO t1 VALUES (1, 'This is a test');
select * from t1;
DROP SCHEMA IF EXISTS `mysqlslap`;
CREATE SCHEMA `mysqlslap`;
use mysqlslap;
CREATE TABLE t1 (id int, name varchar(64));
INSERT INTO t1 VALUES (1, 'This is a test');
select * from t1;
DROP SCHEMA IF EXISTS `mysqlslap`;
CREATE SCHEMA `mysqlslap`;
use mysqlslap;
CREATE TABLE t1 (id int, name varchar(64));
INSERT INTO t1 VALUES (1, 'This is a test');
select * from t1;
DROP SCHEMA IF EXISTS `mysqlslap`;
CREATE SCHEMA `mysqlslap`;
use mysqlslap;
CREATE TABLE t1 (id int, name varchar(64));
INSERT INTO t1 VALUES (1, 'This is a test');
select * from t1;
DROP SCHEMA IF EXISTS `mysqlslap`;
CREATE SCHEMA `mysqlslap`;
use mysqlslap;
CREATE TABLE t1 (id int, name varchar(64));
INSERT INTO t1 VALUES (1, 'This is a test');
select * from t1;
DROP SCHEMA IF EXISTS `mysqlslap`;
CREATE SCHEMA `mysqlslap`;
use mysqlslap;
CREATE TABLE t1 (id int, name varchar(64));
INSERT INTO t1 VALUES (1, 'This is a test');
select * from t1;
DROP SCHEMA IF EXISTS `mysqlslap`;
CREATE SCHEMA `mysqlslap`;
use mysqlslap;
CREATE TABLE t1 (id int, name varchar(64));
INSERT INTO t1 VALUES (1, 'This is a test');
select * from t1;
DROP SCHEMA IF EXISTS `mysqlslap`;
CREATE SCHEMA `mysqlslap`;
use mysqlslap;
CREATE TABLE t1 (id int, name varchar(64));
INSERT INTO t1 VALUES (1, 'This is a test');
select * from t1;
DROP SCHEMA IF EXISTS `mysqlslap`;
CREATE SCHEMA `mysqlslap`;
use mysqlslap;
CREATE TABLE t1 (id int, name varchar(64));
INSERT INTO t1 VALUES (1, 'This is a test');
select * from t1;
DROP SCHEMA IF EXISTS `mysqlslap`;
CREATE SCHEMA `mysqlslap`;
use mysqlslap;
CREATE TABLE t1 (id int, name varchar(64));
INSERT INTO t1 VALUES (1, 'This is a test');
select * from t1;
DROP SCHEMA IF EXISTS `mysqlslap`;
CREATE SCHEMA `mysqlslap`;
use mysqlslap;
CREATE TABLE t1 (id int, name varchar(64));
INSERT INTO t1 VALUES (1, 'This is a test');
select * from t1;
DROP SCHEMA IF EXISTS `mysqlslap`;
CREATE SCHEMA `mysqlslap`;
use mysqlslap;
CREATE TABLE t1 (id int, name varchar(64));
INSERT INTO t1 VALUES (1, 'This is a test');
select * from t1;
DROP SCHEMA IF EXISTS `mysqlslap`;
CREATE SCHEMA `mysqlslap`;
use mysqlslap;
CREATE TABLE t1 (id int, name varchar(64));
INSERT INTO t1 VALUES (1, 'This is a test');
select * from t1;
DROP SCHEMA IF EXISTS `mysqlslap`;
CREATE SCHEMA `mysqlslap`;
use mysqlslap;
CREATE TABLE t1 (id int, name varchar(64));
INSERT INTO t1 VALUES (1, 'This is a test');
select * from t1;
DROP SCHEMA IF EXISTS `mysqlslap`;
CREATE SCHEMA `mysqlslap`;
use mysqlslap;
CREATE TABLE t1 (id int, name varchar(64));
INSERT INTO t1 VALUES (1, 'This is a test');
select * from t1;
DROP SCHEMA IF EXISTS `mysqlslap`;
CREATE SCHEMA `mysqlslap`;
use mysqlslap;
CREATE TABLE t1 (id int, name varchar(64));
INSERT INTO t1 VALUES (1, 'This is a test');
select * from t1;
DROP SCHEMA IF EXISTS `mysqlslap`;
CREATE SCHEMA `mysqlslap`;
use mysqlslap;
CREATE TABLE t1 (id int, name varchar(64));
INSERT INTO t1 VALUES (1, 'This is a test');
select * from t1;
DROP SCHEMA IF EXISTS `mysqlslap`;
CREATE SCHEMA `mysqlslap`;
use mysqlslap;
CREATE TABLE t1 (id int, name varchar(64));
INSERT INTO t1 VALUES (1, 'This is a test');
select * from t1;
DROP SCHEMA IF EXISTS `mysqlslap`;
CREATE SCHEMA `mysqlslap`;
use mysqlslap;
CREATE TABLE t1 (id int, name varchar(64));
INSERT INTO t1 VALUES (1, 'This is a test');
select * from t1;
DROP SCHEMA IF EXISTS `mysqlslap`;
DROP SCHEMA IF EXISTS `mysqlslap`;
CREATE SCHEMA `mysqlslap`;
use mysqlslap;
set storage_engine=`heap`;
CREATE TABLE t1 (id int, name varchar(64));
create table t2(foo1 varchar(32), foo2 varchar(32));
INSERT INTO t1 VALUES (1, 'This is a test');
insert into t2 values ('test', 'test2');
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`;
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');
select * from t1;
select * from t2;
DROP SCHEMA IF EXISTS `mysqlslap`;
DROP SCHEMA IF EXISTS `mysqlslap`;
CREATE SCHEMA `mysqlslap`;
use mysqlslap;
set storage_engine=`heap`;
CREATE TABLE t1 (id int, name varchar(64));
create table t2(foo1 varchar(32), foo2 varchar(32));
INSERT INTO t1 VALUES (1, 'This is a test');
insert into t2 values ('test', 'test2');
SHOW TABLES;
select * from t1;
select * from t2;
SHOW TABLES;
DROP SCHEMA IF EXISTS `mysqlslap`;
DROP SCHEMA IF EXISTS `mysqlslap`;
CREATE SCHEMA `mysqlslap`;
use mysqlslap;
set storage_engine=`myisam`;
CREATE TABLE t1 (id int, name varchar(64));
create table t2(foo1 varchar(32), foo2 varchar(32));
INSERT INTO t1 VALUES (1, 'This is a test');
insert into t2 values ('test', 'test2');
SHOW TABLES;
select * from t1;
select * from t2;
SHOW TABLES;
DROP SCHEMA IF EXISTS `mysqlslap`;
DROP SCHEMA IF EXISTS `mysqlslap`;
CREATE SCHEMA `mysqlslap`;
use mysqlslap;
set storage_engine=`heap`;
CREATE TABLE t1 (id int, name varchar(64));
create table t2(foo1 varchar(32), foo2 varchar(32));
INSERT INTO t1 VALUES (1, 'This is a test');
insert into t2 values ('test', 'test2');
SET AUTOCOMMIT=0;
SHOW TABLES;
SET AUTOCOMMIT=0;
select * from t1;
COMMIT;
select * from t2;
COMMIT;
select * from t1;
COMMIT;
select * from t2;
COMMIT;
select * from t1;
COMMIT;
select * from t2;
COMMIT;
COMMIT;
SHOW TABLES;
DROP SCHEMA IF EXISTS `mysqlslap`;
DROP SCHEMA IF EXISTS `mysqlslap`;
CREATE SCHEMA `mysqlslap`;
use mysqlslap;
set storage_engine=`myisam`;
CREATE TABLE t1 (id int, name varchar(64));
create table t2(foo1 varchar(32), foo2 varchar(32));
INSERT INTO t1 VALUES (1, 'This is a test');
insert into t2 values ('test', 'test2');
SET AUTOCOMMIT=0;
SHOW TABLES;
SET AUTOCOMMIT=0;
select * from t1;
COMMIT;
select * from t2;
COMMIT;
select * from t1;
COMMIT;
select * from t2;
COMMIT;
select * from t1;
COMMIT;
select * from t2;
COMMIT;
COMMIT;
SHOW TABLES;
DROP SCHEMA IF EXISTS `mysqlslap`;
CREATE SCHEMA mysqlslap;
CREATE TABLE mysqlslap.t1 (id int, name varchar(64));
SELECT count(*) from mysqlslap.t1;
count(*)
20

1 by brian clean slate	1	DROP SCHEMA IF EXISTS `mysqlslap`;
	2	CREATE SCHEMA `mysqlslap`;
	3	use mysqlslap;
	4	CREATE TABLE t1 (id int, name varchar(64));
	5	INSERT INTO t1 VALUES (1, 'This is a test');
	6	select * from t1;
	7	DROP SCHEMA IF EXISTS `mysqlslap`;
	8	CREATE SCHEMA `mysqlslap`;
	9	use mysqlslap;
	10	CREATE TABLE t1 (id int, name varchar(64));
	11	INSERT INTO t1 VALUES (1, 'This is a test');
	12	select * from t1;
	13	DROP SCHEMA IF EXISTS `mysqlslap`;
	14	CREATE SCHEMA `mysqlslap`;
	15	use mysqlslap;
	16	CREATE TABLE t1 (id int, name varchar(64));
	17	INSERT INTO t1 VALUES (1, 'This is a test');
	18	select * from t1;
	19	DROP SCHEMA IF EXISTS `mysqlslap`;
	20	CREATE SCHEMA `mysqlslap`;
	21	use mysqlslap;
	22	CREATE TABLE t1 (id int, name varchar(64));
	23	INSERT INTO t1 VALUES (1, 'This is a test');
	24	select * from t1;
	25	DROP SCHEMA IF EXISTS `mysqlslap`;
	26	CREATE SCHEMA `mysqlslap`;
	27	use mysqlslap;
	28	CREATE TABLE t1 (id int, name varchar(64));
	29	INSERT INTO t1 VALUES (1, 'This is a test');
	30	select * from t1;
	31	DROP SCHEMA IF EXISTS `mysqlslap`;
	32	CREATE SCHEMA `mysqlslap`;
	33	use mysqlslap;
	34	CREATE TABLE t1 (id int, name varchar(64));
	35	INSERT INTO t1 VALUES (1, 'This is a test');
	36	select * from t1;
	37	DROP SCHEMA IF EXISTS `mysqlslap`;
	38	CREATE SCHEMA `mysqlslap`;
	39	use mysqlslap;
	40	CREATE TABLE t1 (id int, name varchar(64));
	41	INSERT INTO t1 VALUES (1, 'This is a test');
	42	select * from t1;
	43	DROP SCHEMA IF EXISTS `mysqlslap`;
	44	CREATE SCHEMA `mysqlslap`;
	45	use mysqlslap;
	46	CREATE TABLE t1 (id int, name varchar(64));
	47	INSERT INTO t1 VALUES (1, 'This is a test');
	48	select * from t1;
	49	DROP SCHEMA IF EXISTS `mysqlslap`;
	50	CREATE SCHEMA `mysqlslap`;
	51	use mysqlslap;
	52	CREATE TABLE t1 (id int, name varchar(64));
	53	INSERT INTO t1 VALUES (1, 'This is a test');
	54	select * from t1;
	55	DROP SCHEMA IF EXISTS `mysqlslap`;
	56	CREATE SCHEMA `mysqlslap`;
	57	use mysqlslap;
	58	CREATE TABLE t1 (id int, name varchar(64));
	59	INSERT INTO t1 VALUES (1, 'This is a test');
	60	select * from t1;
	61	DROP SCHEMA IF EXISTS `mysqlslap`;
	62	CREATE SCHEMA `mysqlslap`;
	63	use mysqlslap;
	64	CREATE TABLE t1 (id int, name varchar(64));
65	INSERT INTO t1 VALUES (1, 'This is a test');
66	select * from t1;
67	DROP SCHEMA IF EXISTS `mysqlslap`;
68	CREATE SCHEMA `mysqlslap`;
69	use mysqlslap;
70	CREATE TABLE t1 (id int, name varchar(64));
71	INSERT INTO t1 VALUES (1, 'This is a test');
72	select * from t1;
73	DROP SCHEMA IF EXISTS `mysqlslap`;
74	CREATE SCHEMA `mysqlslap`;
75	use mysqlslap;
76	CREATE TABLE t1 (id int, name varchar(64));
77	INSERT INTO t1 VALUES (1, 'This is a test');
78	select * from t1;
79	DROP SCHEMA IF EXISTS `mysqlslap`;
80	CREATE SCHEMA `mysqlslap`;
81	use mysqlslap;
82	CREATE TABLE t1 (id int, name varchar(64));
83	INSERT INTO t1 VALUES (1, 'This is a test');
84	select * from t1;
85	DROP SCHEMA IF EXISTS `mysqlslap`;
86	CREATE SCHEMA `mysqlslap`;
87	use mysqlslap;
88	CREATE TABLE t1 (id int, name varchar(64));
89	INSERT INTO t1 VALUES (1, 'This is a test');
90	select * from t1;
91	DROP SCHEMA IF EXISTS `mysqlslap`;
92	CREATE SCHEMA `mysqlslap`;
93	use mysqlslap;
94	CREATE TABLE t1 (id int, name varchar(64));
95	INSERT INTO t1 VALUES (1, 'This is a test');
96	select * from t1;
97	DROP SCHEMA IF EXISTS `mysqlslap`;
98	CREATE SCHEMA `mysqlslap`;
99	use mysqlslap;
100	CREATE TABLE t1 (id int, name varchar(64));
101	INSERT INTO t1 VALUES (1, 'This is a test');
102	select * from t1;
103	DROP SCHEMA IF EXISTS `mysqlslap`;
104	CREATE SCHEMA `mysqlslap`;
105	use mysqlslap;
106	CREATE TABLE t1 (id int, name varchar(64));
107	INSERT INTO t1 VALUES (1, 'This is a test');
108	select * from t1;
109	DROP SCHEMA IF EXISTS `mysqlslap`;
110	CREATE SCHEMA `mysqlslap`;
111	use mysqlslap;
112	CREATE TABLE t1 (id int, name varchar(64));
113	INSERT INTO t1 VALUES (1, 'This is a test');
114	select * from t1;
115	DROP SCHEMA IF EXISTS `mysqlslap`;
116	CREATE SCHEMA `mysqlslap`;
117	use mysqlslap;
118	CREATE TABLE t1 (id int, name varchar(64));
119	INSERT INTO t1 VALUES (1, 'This is a test');
120	select * from t1;
121	DROP SCHEMA IF EXISTS `mysqlslap`;
122	DROP SCHEMA IF EXISTS `mysqlslap`;
123	CREATE SCHEMA `mysqlslap`;
124	use mysqlslap;
125	set storage_engine=`heap`;
126	CREATE TABLE t1 (id int, name varchar(64));
127	create table t2(foo1 varchar(32), foo2 varchar(32));
128	INSERT INTO t1 VALUES (1, 'This is a test');
129	insert into t2 values ('test', 'test2');
130	select * from t1;
131	select * from t2;
132	DROP SCHEMA IF EXISTS `mysqlslap`;
133	DROP SCHEMA IF EXISTS `mysqlslap`;
134	CREATE SCHEMA `mysqlslap`;
135	use mysqlslap;
136	set storage_engine=`myisam`;
137	CREATE TABLE t1 (id int, name varchar(64));
138	create table t2(foo1 varchar(32), foo2 varchar(32));
139	INSERT INTO t1 VALUES (1, 'This is a test');
140	insert into t2 values ('test', 'test2');
141	select * from t1;
142	select * from t2;
143	DROP SCHEMA IF EXISTS `mysqlslap`;
144	DROP SCHEMA IF EXISTS `mysqlslap`;
145	CREATE SCHEMA `mysqlslap`;
146	use mysqlslap;
147	set storage_engine=`heap`;
148	CREATE TABLE t1 (id int, name varchar(64));
149	create table t2(foo1 varchar(32), foo2 varchar(32));
150	INSERT INTO t1 VALUES (1, 'This is a test');
151	insert into t2 values ('test', 'test2');
152	SHOW TABLES;
153	select * from t1;
154	select * from t2;
155	SHOW TABLES;
156	DROP SCHEMA IF EXISTS `mysqlslap`;
157	DROP SCHEMA IF EXISTS `mysqlslap`;
158	CREATE SCHEMA `mysqlslap`;
159	use mysqlslap;
160	set storage_engine=`myisam`;
161	CREATE TABLE t1 (id int, name varchar(64));
162	create table t2(foo1 varchar(32), foo2 varchar(32));
163	INSERT INTO t1 VALUES (1, 'This is a test');
164	insert into t2 values ('test', 'test2');
165	SHOW TABLES;
166	select * from t1;
167	select * from t2;
168	SHOW TABLES;
169	DROP SCHEMA IF EXISTS `mysqlslap`;
170	DROP SCHEMA IF EXISTS `mysqlslap`;
171	CREATE SCHEMA `mysqlslap`;
172	use mysqlslap;
173	set storage_engine=`heap`;
174	CREATE TABLE t1 (id int, name varchar(64));
175	create table t2(foo1 varchar(32), foo2 varchar(32));
176	INSERT INTO t1 VALUES (1, 'This is a test');
177	insert into t2 values ('test', 'test2');
178	SET AUTOCOMMIT=0;
179	SHOW TABLES;
180	SET AUTOCOMMIT=0;
181	select * from t1;
182	COMMIT;
183	select * from t2;
184	COMMIT;
185	select * from t1;
186	COMMIT;
187	select * from t2;
188	COMMIT;
189	select * from t1;
190	COMMIT;
191	select * from t2;
192	COMMIT;
193	COMMIT;
194	SHOW TABLES;
195	DROP SCHEMA IF EXISTS `mysqlslap`;
196	DROP SCHEMA IF EXISTS `mysqlslap`;
197	CREATE SCHEMA `mysqlslap`;
198	use mysqlslap;
199	set storage_engine=`myisam`;
200	CREATE TABLE t1 (id int, name varchar(64));
201	create table t2(foo1 varchar(32), foo2 varchar(32));
202	INSERT INTO t1 VALUES (1, 'This is a test');
203	insert into t2 values ('test', 'test2');
204	SET AUTOCOMMIT=0;
205	SHOW TABLES;
206	SET AUTOCOMMIT=0;
207	select * from t1;
208	COMMIT;
209	select * from t2;
210	COMMIT;
211	select * from t1;
212	COMMIT;
213	select * from t2;
214	COMMIT;
215	select * from t1;
216	COMMIT;
217	select * from t2;
218	COMMIT;
219	COMMIT;
220	SHOW TABLES;
221	DROP SCHEMA IF EXISTS `mysqlslap`;
222	CREATE SCHEMA mysqlslap;
223	CREATE TABLE mysqlslap.t1 (id int, name varchar(64));
224	SELECT count(*) from mysqlslap.t1;
225	count(*)
226	20