~drizzle-trunk/drizzle/development : contents of tests/r/drizzleslap.result at revision 1340.1.5

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

DROP SCHEMA IF EXISTS `drizzleslap`;
CREATE SCHEMA `drizzleslap`;
use drizzleslap;
CREATE TABLE t1 (id int, name varchar(64));
INSERT INTO t1 VALUES (1, 'This is a test');
select * from t1;
DROP SCHEMA IF EXISTS `drizzleslap`;
CREATE SCHEMA `drizzleslap`;
use drizzleslap;
CREATE TABLE t1 (id int, name varchar(64));
INSERT INTO t1 VALUES (1, 'This is a test');
select * from t1;
DROP SCHEMA IF EXISTS `drizzleslap`;
CREATE SCHEMA `drizzleslap`;
use drizzleslap;
CREATE TABLE t1 (id int, name varchar(64));
INSERT INTO t1 VALUES (1, 'This is a test');
select * from t1;
DROP SCHEMA IF EXISTS `drizzleslap`;
CREATE SCHEMA `drizzleslap`;
use drizzleslap;
CREATE TABLE t1 (id int, name varchar(64));
INSERT INTO t1 VALUES (1, 'This is a test');
select * from t1;
DROP SCHEMA IF EXISTS `drizzleslap`;
CREATE SCHEMA `drizzleslap`;
use drizzleslap;
CREATE TABLE t1 (id int, name varchar(64));
INSERT INTO t1 VALUES (1, 'This is a test');
select * from t1;
DROP SCHEMA IF EXISTS `drizzleslap`;
CREATE SCHEMA `drizzleslap`;
use drizzleslap;
CREATE TABLE t1 (id int, name varchar(64));
INSERT INTO t1 VALUES (1, 'This is a test');
select * from t1;
DROP SCHEMA IF EXISTS `drizzleslap`;
CREATE SCHEMA `drizzleslap`;
use drizzleslap;
CREATE TABLE t1 (id int, name varchar(64));
INSERT INTO t1 VALUES (1, 'This is a test');
select * from t1;
DROP SCHEMA IF EXISTS `drizzleslap`;
CREATE SCHEMA `drizzleslap`;
use drizzleslap;
CREATE TABLE t1 (id int, name varchar(64));
INSERT INTO t1 VALUES (1, 'This is a test');
select * from t1;
DROP SCHEMA IF EXISTS `drizzleslap`;
CREATE SCHEMA `drizzleslap`;
use drizzleslap;
CREATE TABLE t1 (id int, name varchar(64));
INSERT INTO t1 VALUES (1, 'This is a test');
select * from t1;
DROP SCHEMA IF EXISTS `drizzleslap`;
CREATE SCHEMA `drizzleslap`;
use drizzleslap;
CREATE TABLE t1 (id int, name varchar(64));
INSERT INTO t1 VALUES (1, 'This is a test');
select * from t1;
DROP SCHEMA IF EXISTS `drizzleslap`;
CREATE SCHEMA `drizzleslap`;
use drizzleslap;
CREATE TABLE t1 (id int, name varchar(64));
INSERT INTO t1 VALUES (1, 'This is a test');
select * from t1;
DROP SCHEMA IF EXISTS `drizzleslap`;
CREATE SCHEMA `drizzleslap`;
use drizzleslap;
CREATE TABLE t1 (id int, name varchar(64));
INSERT INTO t1 VALUES (1, 'This is a test');
select * from t1;
DROP SCHEMA IF EXISTS `drizzleslap`;
CREATE SCHEMA `drizzleslap`;
use drizzleslap;
CREATE TABLE t1 (id int, name varchar(64));
INSERT INTO t1 VALUES (1, 'This is a test');
select * from t1;
DROP SCHEMA IF EXISTS `drizzleslap`;
CREATE SCHEMA `drizzleslap`;
use drizzleslap;
CREATE TABLE t1 (id int, name varchar(64));
INSERT INTO t1 VALUES (1, 'This is a test');
select * from t1;
DROP SCHEMA IF EXISTS `drizzleslap`;
CREATE SCHEMA `drizzleslap`;
use drizzleslap;
CREATE TABLE t1 (id int, name varchar(64));
INSERT INTO t1 VALUES (1, 'This is a test');
select * from t1;
DROP SCHEMA IF EXISTS `drizzleslap`;
CREATE SCHEMA `drizzleslap`;
use drizzleslap;
CREATE TABLE t1 (id int, name varchar(64));
INSERT INTO t1 VALUES (1, 'This is a test');
select * from t1;
DROP SCHEMA IF EXISTS `drizzleslap`;
CREATE SCHEMA `drizzleslap`;
use drizzleslap;
CREATE TABLE t1 (id int, name varchar(64));
INSERT INTO t1 VALUES (1, 'This is a test');
select * from t1;
DROP SCHEMA IF EXISTS `drizzleslap`;
CREATE SCHEMA `drizzleslap`;
use drizzleslap;
CREATE TABLE t1 (id int, name varchar(64));
INSERT INTO t1 VALUES (1, 'This is a test');
select * from t1;
DROP SCHEMA IF EXISTS `drizzleslap`;
CREATE SCHEMA `drizzleslap`;
use drizzleslap;
CREATE TABLE t1 (id int, name varchar(64));
INSERT INTO t1 VALUES (1, 'This is a test');
select * from t1;
DROP SCHEMA IF EXISTS `drizzleslap`;
CREATE SCHEMA `drizzleslap`;
use drizzleslap;
CREATE TABLE t1 (id int, name varchar(64));
INSERT INTO t1 VALUES (1, 'This is a test');
select * from t1;
DROP SCHEMA IF EXISTS `drizzleslap`;
DROP SCHEMA IF EXISTS `drizzleslap`;
CREATE SCHEMA `drizzleslap`;
use drizzleslap;
set storage_engine=`MEMORY`;
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 `drizzleslap`;
DROP SCHEMA IF EXISTS `drizzleslap`;
CREATE SCHEMA `drizzleslap`;
use drizzleslap;
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 `drizzleslap`;
DROP SCHEMA IF EXISTS `drizzleslap`;
CREATE SCHEMA `drizzleslap`;
use drizzleslap;
set storage_engine=`MEMORY`;
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 `drizzleslap`;
DROP SCHEMA IF EXISTS `drizzleslap`;
CREATE SCHEMA `drizzleslap`;
use drizzleslap;
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 `drizzleslap`;
DROP SCHEMA IF EXISTS `drizzleslap`;
CREATE SCHEMA `drizzleslap`;
use drizzleslap;
set storage_engine=`MEMORY`;
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 `drizzleslap`;
DROP SCHEMA IF EXISTS `drizzleslap`;
CREATE SCHEMA `drizzleslap`;
use drizzleslap;
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 `drizzleslap`;
CREATE SCHEMA drizzleslap;
CREATE TABLE drizzleslap.t1 (id int, name varchar(64));
SELECT count(*) from drizzleslap.t1;
count(*)
20
drop table drizzleslap.t1;
drop schema drizzleslap;

373.1.9 by Monty Taylor Added back mysqlslap as drizzleslap. Also made it C++ and removed DYNAMIC_STRING.	1	DROP SCHEMA IF EXISTS `drizzleslap`;
	2	CREATE SCHEMA `drizzleslap`;
	3	use drizzleslap;
	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 `drizzleslap`;
	8	CREATE SCHEMA `drizzleslap`;
	9	use drizzleslap;
	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 `drizzleslap`;
	14	CREATE SCHEMA `drizzleslap`;
	15	use drizzleslap;
	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 `drizzleslap`;
	20	CREATE SCHEMA `drizzleslap`;
	21	use drizzleslap;
	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 `drizzleslap`;
	26	CREATE SCHEMA `drizzleslap`;
	27	use drizzleslap;
	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 `drizzleslap`;
	32	CREATE SCHEMA `drizzleslap`;
	33	use drizzleslap;
	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 `drizzleslap`;
	38	CREATE SCHEMA `drizzleslap`;
	39	use drizzleslap;
	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 `drizzleslap`;
	44	CREATE SCHEMA `drizzleslap`;
	45	use drizzleslap;
	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 `drizzleslap`;
	50	CREATE SCHEMA `drizzleslap`;
	51	use drizzleslap;
	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 `drizzleslap`;
	56	CREATE SCHEMA `drizzleslap`;
	57	use drizzleslap;
	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 `drizzleslap`;
	62	CREATE SCHEMA `drizzleslap`;
	63	use drizzleslap;
	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 `drizzleslap`;
68	CREATE SCHEMA `drizzleslap`;
69	use drizzleslap;
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 `drizzleslap`;
74	CREATE SCHEMA `drizzleslap`;
75	use drizzleslap;
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 `drizzleslap`;
80	CREATE SCHEMA `drizzleslap`;
81	use drizzleslap;
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 `drizzleslap`;
86	CREATE SCHEMA `drizzleslap`;
87	use drizzleslap;
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 `drizzleslap`;
92	CREATE SCHEMA `drizzleslap`;
93	use drizzleslap;
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 `drizzleslap`;
98	CREATE SCHEMA `drizzleslap`;
99	use drizzleslap;
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 `drizzleslap`;
104	CREATE SCHEMA `drizzleslap`;
105	use drizzleslap;
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 `drizzleslap`;
110	CREATE SCHEMA `drizzleslap`;
111	use drizzleslap;
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 `drizzleslap`;
116	CREATE SCHEMA `drizzleslap`;
117	use drizzleslap;
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 `drizzleslap`;
122	DROP SCHEMA IF EXISTS `drizzleslap`;
123	CREATE SCHEMA `drizzleslap`;
124	use drizzleslap;
1233.2.1 by Monty Taylor Renamed instances of HEAP engine to MEMORY. Removed the alias.	125	set storage_engine=`MEMORY`;
	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 `drizzleslap`;
	133	DROP SCHEMA IF EXISTS `drizzleslap`;
	134	CREATE SCHEMA `drizzleslap`;
	135	use drizzleslap;
	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 `drizzleslap`;
	144	DROP SCHEMA IF EXISTS `drizzleslap`;
	145	CREATE SCHEMA `drizzleslap`;
	146	use drizzleslap;
	147	set storage_engine=`MEMORY`;
	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 `drizzleslap`;
	157	DROP SCHEMA IF EXISTS `drizzleslap`;
	158	CREATE SCHEMA `drizzleslap`;
	159	use drizzleslap;
	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 `drizzleslap`;
	170	DROP SCHEMA IF EXISTS `drizzleslap`;
	171	CREATE SCHEMA `drizzleslap`;
	172	use drizzleslap;
	173	set storage_engine=`MEMORY`;
373.1.9 by Monty Taylor Added back mysqlslap as drizzleslap. Also made it C++ and removed DYNAMIC_STRING.	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 `drizzleslap`;
	196	DROP SCHEMA IF EXISTS `drizzleslap`;
	197	CREATE SCHEMA `drizzleslap`;
	198	use drizzleslap;
	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 `drizzleslap`;
	222	CREATE SCHEMA drizzleslap;
	223	CREATE TABLE drizzleslap.t1 (id int, name varchar(64));
	224	SELECT count(*) from drizzleslap.t1;
1 by brian clean slate	225	count(*)
1 by brian clean slate	226	20
520.1.18 by Brian Aker A bunch more test fixes.	227	drop table drizzleslap.t1;
520.1.18 by Brian Aker A bunch more test fixes.	228	drop schema drizzleslap;