~drizzle-trunk/drizzle/development : contents of tests/r/mysqldump-max.result at revision 795

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

drop table if exists t1, t2, t3, t4, t5, t6;
create table t1 (id int, name varchar(32));
create table t2 (id int, name varchar(32)) ENGINE="MyISAM";
create table t3 (id int, name varchar(32)) ENGINE="MEMORY";
create table t4 (id int, name varchar(32)) ENGINE="HEAP";
create table t6 (id int, name varchar(32)) ENGINE="InnoDB";
insert into t1 values (1, 'first value');
insert into t1 values (2, 'first value');
insert into t1 values (3, 'first value');
insert into t1 values (4, 'first value');
insert into t1 values (5, 'first value');
insert into t2 values (1, 'first value');
insert into t2 values (2, 'first value');
insert into t2 values (3, 'first value');
insert into t2 values (4, 'first value');
insert into t2 values (5, 'first value');
insert into t3 values (1, 'first value');
insert into t3 values (2, 'first value');
insert into t3 values (3, 'first value');
insert into t3 values (4, 'first value');
insert into t3 values (5, 'first value');
insert into t4 values (1, 'first value');
insert into t4 values (2, 'first value');
insert into t4 values (3, 'first value');
insert into t4 values (4, 'first value');
insert into t4 values (5, 'first value');
insert into t6 values (1, 'first value');
insert into t6 values (2, 'first value');
insert into t6 values (3, 'first value');
insert into t6 values (4, 'first value');
insert into t6 values (5, 'first value');
select * from t1;
id	name
1	first value
2	first value
3	first value
4	first value
5	first value
select * from t2;
id	name
1	first value
2	first value
3	first value
4	first value
5	first value
select * from t3;
id	name
1	first value
2	first value
3	first value
4	first value
5	first value
select * from t4;
id	name
1	first value
2	first value
3	first value
4	first value
5	first value
select * from t6;
id	name
1	first value
2	first value
3	first value
4	first value
5	first value
SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;

CREATE DATABASE IF NOT EXISTS `test`;

USE `test`;
DROP TABLE IF EXISTS `t1`;
CREATE TABLE `t1` (
  `id` int,
  `name` varchar(32)
) ENGINE=InnoDB;

ALTER TABLE `t1` DISABLE KEYS;
INSERT  IGNORE INTO `t1` VALUES ('1','first value'),('2','first value'),('3','first value'),('4','first value'),('5','first value');
ALTER TABLE `t1` ENABLE KEYS;
DROP TABLE IF EXISTS `t2`;
CREATE TABLE `t2` (
  `id` int,
  `name` varchar(32)
) ENGINE=MyISAM;

ALTER TABLE `t2` DISABLE KEYS;
INSERT  DELAYED IGNORE INTO `t2` VALUES ('1','first value'),('2','first value'),('3','first value'),('4','first value'),('5','first value');
ALTER TABLE `t2` ENABLE KEYS;
DROP TABLE IF EXISTS `t3`;
CREATE TABLE `t3` (
  `id` int,
  `name` varchar(32)
) ENGINE=MEMORY;

ALTER TABLE `t3` DISABLE KEYS;
INSERT  DELAYED IGNORE INTO `t3` VALUES ('1','first value'),('2','first value'),('3','first value'),('4','first value'),('5','first value');
ALTER TABLE `t3` ENABLE KEYS;
DROP TABLE IF EXISTS `t4`;
CREATE TABLE `t4` (
  `id` int,
  `name` varchar(32)
) ENGINE=MEMORY;

ALTER TABLE `t4` DISABLE KEYS;
INSERT  DELAYED IGNORE INTO `t4` VALUES ('1','first value'),('2','first value'),('3','first value'),('4','first value'),('5','first value');
ALTER TABLE `t4` ENABLE KEYS;
DROP TABLE IF EXISTS `t6`;
CREATE TABLE `t6` (
  `id` int,
  `name` varchar(32)
) ENGINE=InnoDB;

ALTER TABLE `t6` DISABLE KEYS;
INSERT  IGNORE INTO `t6` VALUES ('1','first value'),('2','first value'),('3','first value'),('4','first value'),('5','first value');
ALTER TABLE `t6` ENABLE KEYS;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;

CREATE DATABASE IF NOT EXISTS `test`;

USE `test`;
DROP TABLE IF EXISTS `t1`;
CREATE TABLE `t1` (
  `id` int,
  `name` varchar(32)
) ENGINE=InnoDB;

ALTER TABLE `t1` DISABLE KEYS;
INSERT INTO `t1` VALUES ('1','first value'),('2','first value'),('3','first value'),('4','first value'),('5','first value');
ALTER TABLE `t1` ENABLE KEYS;
DROP TABLE IF EXISTS `t2`;
CREATE TABLE `t2` (
  `id` int,
  `name` varchar(32)
) ENGINE=MyISAM;

ALTER TABLE `t2` DISABLE KEYS;
INSERT  DELAYED INTO `t2` VALUES ('1','first value'),('2','first value'),('3','first value'),('4','first value'),('5','first value');
ALTER TABLE `t2` ENABLE KEYS;
DROP TABLE IF EXISTS `t3`;
CREATE TABLE `t3` (
  `id` int,
  `name` varchar(32)
) ENGINE=MEMORY;

ALTER TABLE `t3` DISABLE KEYS;
INSERT  DELAYED INTO `t3` VALUES ('1','first value'),('2','first value'),('3','first value'),('4','first value'),('5','first value');
ALTER TABLE `t3` ENABLE KEYS;
DROP TABLE IF EXISTS `t4`;
CREATE TABLE `t4` (
  `id` int,
  `name` varchar(32)
) ENGINE=MEMORY;

ALTER TABLE `t4` DISABLE KEYS;
INSERT  DELAYED INTO `t4` VALUES ('1','first value'),('2','first value'),('3','first value'),('4','first value'),('5','first value');
ALTER TABLE `t4` ENABLE KEYS;
DROP TABLE IF EXISTS `t6`;
CREATE TABLE `t6` (
  `id` int,
  `name` varchar(32)
) ENGINE=InnoDB;

ALTER TABLE `t6` DISABLE KEYS;
INSERT INTO `t6` VALUES ('1','first value'),('2','first value'),('3','first value'),('4','first value'),('5','first value');
ALTER TABLE `t6` ENABLE KEYS;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
drop table t1;
drop table t2;
drop table t3;
drop table t4;
drop table t6;

1 by brian clean slate	1	drop table if exists t1, t2, t3, t4, t5, t6;
520.1.12 by Brian Aker Adding back more tests.	2	create table t1 (id int, name varchar(32));
	3	create table t2 (id int, name varchar(32)) ENGINE="MyISAM";
	4	create table t3 (id int, name varchar(32)) ENGINE="MEMORY";
	5	create table t4 (id int, name varchar(32)) ENGINE="HEAP";
	6	create table t6 (id int, name varchar(32)) ENGINE="InnoDB";
1 by brian clean slate	7	insert into t1 values (1, 'first value');
	8	insert into t1 values (2, 'first value');
	9	insert into t1 values (3, 'first value');
	10	insert into t1 values (4, 'first value');
	11	insert into t1 values (5, 'first value');
	12	insert into t2 values (1, 'first value');
	13	insert into t2 values (2, 'first value');
	14	insert into t2 values (3, 'first value');
	15	insert into t2 values (4, 'first value');
	16	insert into t2 values (5, 'first value');
	17	insert into t3 values (1, 'first value');
	18	insert into t3 values (2, 'first value');
	19	insert into t3 values (3, 'first value');
	20	insert into t3 values (4, 'first value');
	21	insert into t3 values (5, 'first value');
	22	insert into t4 values (1, 'first value');
	23	insert into t4 values (2, 'first value');
	24	insert into t4 values (3, 'first value');
	25	insert into t4 values (4, 'first value');
	26	insert into t4 values (5, 'first value');
	27	insert into t6 values (1, 'first value');
	28	insert into t6 values (2, 'first value');
	29	insert into t6 values (3, 'first value');
	30	insert into t6 values (4, 'first value');
	31	insert into t6 values (5, 'first value');
	32	select * from t1;
	33	id name
	34	1 first value
	35	2 first value
	36	3 first value
	37	4 first value
	38	5 first value
	39	select * from t2;
	40	id name
	41	1 first value
	42	2 first value
	43	3 first value
	44	4 first value
	45	5 first value
	46	select * from t3;
	47	id name
	48	1 first value
	49	2 first value
	50	3 first value
	51	4 first value
	52	5 first value
	53	select * from t4;
	54	id name
	55	1 first value
	56	2 first value
	57	3 first value
	58	4 first value
	59	5 first value
	60	select * from t6;
	61	id name
	62	1 first value
	63	2 first value
	64	3 first value
	65	4 first value
	66	5 first value
758.2.4 by Andrew Hutchings Fix tests for modified code	67	SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
758.2.4 by Andrew Hutchings Fix tests for modified code	68	SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
520.1.12 by Brian Aker Adding back more tests.	69
758.2.4 by Andrew Hutchings Fix tests for modified code	70	CREATE DATABASE IF NOT EXISTS `test`;
520.1.12 by Brian Aker Adding back more tests.	71
520.1.12 by Brian Aker Adding back more tests.	72	USE `test`;
760 by Brian Aker Cleanup around UTf8 code.	73	DROP TABLE IF EXISTS `t1`;
	74	CREATE TABLE `t1` (
	75	`id` int,
	76	`name` varchar(32)
	77	) ENGINE=InnoDB;
	78
758.2.4 by Andrew Hutchings Fix tests for modified code	79	ALTER TABLE `t1` DISABLE KEYS;
760 by Brian Aker Cleanup around UTf8 code.	80	INSERT IGNORE INTO `t1` VALUES ('1','first value'),('2','first value'),('3','first value'),('4','first value'),('5','first value');
758.2.4 by Andrew Hutchings Fix tests for modified code	81	ALTER TABLE `t1` ENABLE KEYS;
760 by Brian Aker Cleanup around UTf8 code.	82	DROP TABLE IF EXISTS `t2`;
	83	CREATE TABLE `t2` (
	84	`id` int,
	85	`name` varchar(32)
	86	) ENGINE=MyISAM;
	87
758.2.4 by Andrew Hutchings Fix tests for modified code	88	ALTER TABLE `t2` DISABLE KEYS;
760 by Brian Aker Cleanup around UTf8 code.	89	INSERT DELAYED IGNORE INTO `t2` VALUES ('1','first value'),('2','first value'),('3','first value'),('4','first value'),('5','first value');
758.2.4 by Andrew Hutchings Fix tests for modified code	90	ALTER TABLE `t2` ENABLE KEYS;
760 by Brian Aker Cleanup around UTf8 code.	91	DROP TABLE IF EXISTS `t3`;
	92	CREATE TABLE `t3` (
	93	`id` int,
	94	`name` varchar(32)
	95	) ENGINE=MEMORY;
	96
758.2.4 by Andrew Hutchings Fix tests for modified code	97	ALTER TABLE `t3` DISABLE KEYS;
760 by Brian Aker Cleanup around UTf8 code.	98	INSERT DELAYED IGNORE INTO `t3` VALUES ('1','first value'),('2','first value'),('3','first value'),('4','first value'),('5','first value');
758.2.4 by Andrew Hutchings Fix tests for modified code	99	ALTER TABLE `t3` ENABLE KEYS;
760 by Brian Aker Cleanup around UTf8 code.	100	DROP TABLE IF EXISTS `t4`;
	101	CREATE TABLE `t4` (
	102	`id` int,
	103	`name` varchar(32)
	104	) ENGINE=MEMORY;
	105
758.2.4 by Andrew Hutchings Fix tests for modified code	106	ALTER TABLE `t4` DISABLE KEYS;
760 by Brian Aker Cleanup around UTf8 code.	107	INSERT DELAYED IGNORE INTO `t4` VALUES ('1','first value'),('2','first value'),('3','first value'),('4','first value'),('5','first value');
758.2.4 by Andrew Hutchings Fix tests for modified code	108	ALTER TABLE `t4` ENABLE KEYS;
760 by Brian Aker Cleanup around UTf8 code.	109	DROP TABLE IF EXISTS `t6`;
	110	CREATE TABLE `t6` (
	111	`id` int,
	112	`name` varchar(32)
	113	) ENGINE=InnoDB;
	114
758.2.4 by Andrew Hutchings Fix tests for modified code	115	ALTER TABLE `t6` DISABLE KEYS;
760 by Brian Aker Cleanup around UTf8 code.	116	INSERT IGNORE INTO `t6` VALUES ('1','first value'),('2','first value'),('3','first value'),('4','first value'),('5','first value');
758.2.4 by Andrew Hutchings Fix tests for modified code	117	ALTER TABLE `t6` ENABLE KEYS;
	118	SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
	119	SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
	120	SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
	121	SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
520.1.12 by Brian Aker Adding back more tests.	122
758.2.4 by Andrew Hutchings Fix tests for modified code	123	CREATE DATABASE IF NOT EXISTS `test`;
520.1.12 by Brian Aker Adding back more tests.	124
520.1.12 by Brian Aker Adding back more tests.	125	USE `test`;
760 by Brian Aker Cleanup around UTf8 code.	126	DROP TABLE IF EXISTS `t1`;
	127	CREATE TABLE `t1` (
	128	`id` int,
	129	`name` varchar(32)
	130	) ENGINE=InnoDB;
	131
758.2.4 by Andrew Hutchings Fix tests for modified code	132	ALTER TABLE `t1` DISABLE KEYS;
760 by Brian Aker Cleanup around UTf8 code.	133	INSERT INTO `t1` VALUES ('1','first value'),('2','first value'),('3','first value'),('4','first value'),('5','first value');
758.2.4 by Andrew Hutchings Fix tests for modified code	134	ALTER TABLE `t1` ENABLE KEYS;
760 by Brian Aker Cleanup around UTf8 code.	135	DROP TABLE IF EXISTS `t2`;
	136	CREATE TABLE `t2` (
	137	`id` int,
	138	`name` varchar(32)
	139	) ENGINE=MyISAM;
	140
758.2.4 by Andrew Hutchings Fix tests for modified code	141	ALTER TABLE `t2` DISABLE KEYS;
760 by Brian Aker Cleanup around UTf8 code.	142	INSERT DELAYED INTO `t2` VALUES ('1','first value'),('2','first value'),('3','first value'),('4','first value'),('5','first value');
758.2.4 by Andrew Hutchings Fix tests for modified code	143	ALTER TABLE `t2` ENABLE KEYS;
760 by Brian Aker Cleanup around UTf8 code.	144	DROP TABLE IF EXISTS `t3`;
	145	CREATE TABLE `t3` (
	146	`id` int,
	147	`name` varchar(32)
	148	) ENGINE=MEMORY;
	149
758.2.4 by Andrew Hutchings Fix tests for modified code	150	ALTER TABLE `t3` DISABLE KEYS;
760 by Brian Aker Cleanup around UTf8 code.	151	INSERT DELAYED INTO `t3` VALUES ('1','first value'),('2','first value'),('3','first value'),('4','first value'),('5','first value');
758.2.4 by Andrew Hutchings Fix tests for modified code	152	ALTER TABLE `t3` ENABLE KEYS;
760 by Brian Aker Cleanup around UTf8 code.	153	DROP TABLE IF EXISTS `t4`;
	154	CREATE TABLE `t4` (
	155	`id` int,
	156	`name` varchar(32)
	157	) ENGINE=MEMORY;
	158
758.2.4 by Andrew Hutchings Fix tests for modified code	159	ALTER TABLE `t4` DISABLE KEYS;
760 by Brian Aker Cleanup around UTf8 code.	160	INSERT DELAYED INTO `t4` VALUES ('1','first value'),('2','first value'),('3','first value'),('4','first value'),('5','first value');
758.2.4 by Andrew Hutchings Fix tests for modified code	161	ALTER TABLE `t4` ENABLE KEYS;
760 by Brian Aker Cleanup around UTf8 code.	162	DROP TABLE IF EXISTS `t6`;
	163	CREATE TABLE `t6` (
	164	`id` int,
	165	`name` varchar(32)
	166	) ENGINE=InnoDB;
	167
758.2.4 by Andrew Hutchings Fix tests for modified code	168	ALTER TABLE `t6` DISABLE KEYS;
760 by Brian Aker Cleanup around UTf8 code.	169	INSERT INTO `t6` VALUES ('1','first value'),('2','first value'),('3','first value'),('4','first value'),('5','first value');
758.2.4 by Andrew Hutchings Fix tests for modified code	170	ALTER TABLE `t6` ENABLE KEYS;
	171	SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
	172	SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
1 by brian clean slate	173	drop table t1;
	174	drop table t2;
	175	drop table t3;
	176	drop table t4;
	177	drop table t6;