EVOLUTION-MANAGER

Edit File: basic_sql.result

for master_1
for child2
child2_1
child2_2
child2_3
for child3
child3_1
child3_2
child3_3

drop and create databases
DROP DATABASE IF EXISTS auto_test_local;
CREATE DATABASE auto_test_local;
USE auto_test_local;
DROP DATABASE IF EXISTS auto_test_remote;
CREATE DATABASE auto_test_remote;
USE auto_test_remote;
DROP DATABASE IF EXISTS auto_test_remote2;
CREATE DATABASE auto_test_remote2;
USE auto_test_remote2;

test select 1
SELECT 1;
1
1

create table select test
DROP TABLE IF EXISTS tb_l;
CREATE TABLE tb_l (
a INT,
b CHAR(1),
c DATETIME,
PRIMARY KEY(a)
) MASTER_1_ENGINE2 MASTER_1_CHARSET2
INSERT INTO tb_l (a, b, c) VALUES
(1, 'a', '2008-08-01 10:21:39'),
(2, 'b', '2000-01-01 00:00:00'),
(3, 'e', '2007-06-04 20:03:11'),
(4, 'd', '2003-11-30 05:01:03'),
(5, 'c', '2001-12-31 23:59:59');
DROP TABLE IF EXISTS ta_l;
CREATE TABLE ta_l (
PRIMARY KEY(a)
) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT_2_1
SELECT a, b, c FROM tb_l
SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l ORDER BY a;
a	b	date_format(c, '%Y-%m-%d %H:%i:%s')
1	a	2008-08-01 10:21:39
2	b	2000-01-01 00:00:00
3	e	2007-06-04 20:03:11
4	d	2003-11-30 05:01:03
5	c	2001-12-31 23:59:59

create table ignore select test
DROP TABLE IF EXISTS ta_l;
DROP TABLE IF EXISTS tb_l;
CREATE TABLE tb_l (
a INT,
b CHAR(1),
c DATETIME,
PRIMARY KEY(a)
) MASTER_1_ENGINE2 MASTER_1_CHARSET2
INSERT INTO tb_l (a, b, c) VALUES
(1, 'f', '2008-07-01 10:21:39'),
(2, 'g', '2000-02-01 00:00:00'),
(3, 'j', '2007-05-04 20:03:11'),
(4, 'i', '2003-10-30 05:01:03'),
(5, 'h', '2001-10-31 23:59:59');
CREATE TABLE ta_l (
PRIMARY KEY(a)
) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT_2_1
IGNORE SELECT a, b, c FROM tb_l
Warnings:
Warning	1062	Duplicate entry '1' for key 'PRIMARY'
Warning	1062	Duplicate entry '2' for key 'PRIMARY'
Warning	1062	Duplicate entry '3' for key 'PRIMARY'
Warning	1062	Duplicate entry '4' for key 'PRIMARY'
Warning	1062	Duplicate entry '5' for key 'PRIMARY'
SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l ORDER BY a;
a	b	date_format(c, '%Y-%m-%d %H:%i:%s')
1	a	2008-08-01 10:21:39
2	b	2000-01-01 00:00:00
3	e	2007-06-04 20:03:11
4	d	2003-11-30 05:01:03
5	c	2001-12-31 23:59:59

create table ignore select test
DROP TABLE IF EXISTS ta_l;
CREATE TABLE ta_l (
PRIMARY KEY(a)
) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT_2_1
REPLACE SELECT a, b, c FROM tb_l
SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l ORDER BY a;
a	b	date_format(c, '%Y-%m-%d %H:%i:%s')
1	f	2008-07-01 10:21:39
2	g	2000-02-01 00:00:00
3	j	2007-05-04 20:03:11
4	i	2003-10-30 05:01:03
5	h	2001-10-31 23:59:59

create no index table
DROP TABLE IF EXISTS ta_l_no_idx;
CREATE TABLE ta_l_no_idx
MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT2_2_1
SELECT a, b, c FROM tb_l
SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l_no_idx ORDER BY a;
a	b	date_format(c, '%Y-%m-%d %H:%i:%s')
1	f	2008-07-01 10:21:39
2	g	2000-02-01 00:00:00
3	j	2007-05-04 20:03:11
4	i	2003-10-30 05:01:03
5	h	2001-10-31 23:59:59

select table
SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l ORDER BY a;
a	b	date_format(c, '%Y-%m-%d %H:%i:%s')
1	f	2008-07-01 10:21:39
2	g	2000-02-01 00:00:00
3	j	2007-05-04 20:03:11
4	i	2003-10-30 05:01:03
5	h	2001-10-31 23:59:59

select table shared mode
SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l ORDER BY a
LOCK IN SHARE MODE;
a	b	date_format(c, '%Y-%m-%d %H:%i:%s')
1	f	2008-07-01 10:21:39
2	g	2000-02-01 00:00:00
3	j	2007-05-04 20:03:11
4	i	2003-10-30 05:01:03
5	h	2001-10-31 23:59:59

select table for update
SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l ORDER BY a
FOR UPDATE;
a	b	date_format(c, '%Y-%m-%d %H:%i:%s')
1	f	2008-07-01 10:21:39
2	g	2000-02-01 00:00:00
3	j	2007-05-04 20:03:11
4	i	2003-10-30 05:01:03
5	h	2001-10-31 23:59:59

select table join
SELECT a.a, a.b, date_format(b.c, '%Y-%m-%d %H:%i:%s') FROM ta_l a, tb_l b
WHERE a.a = b.a ORDER BY a.a;
a	b	date_format(b.c, '%Y-%m-%d %H:%i:%s')
1	f	2008-07-01 10:21:39
2	g	2000-02-01 00:00:00
3	j	2007-05-04 20:03:11
4	i	2003-10-30 05:01:03
5	h	2001-10-31 23:59:59

select table straight_join
SELECT STRAIGHT_JOIN a.a, a.b, date_format(b.c, '%Y-%m-%d %H:%i:%s')
FROM ta_l a, tb_l b WHERE a.a = b.a ORDER BY a.a;
a	b	date_format(b.c, '%Y-%m-%d %H:%i:%s')
1	f	2008-07-01 10:21:39
2	g	2000-02-01 00:00:00
3	j	2007-05-04 20:03:11
4	i	2003-10-30 05:01:03
5	h	2001-10-31 23:59:59

select sql_small_result
SELECT SQL_SMALL_RESULT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l
ORDER BY a;
a	b	date_format(c, '%Y-%m-%d %H:%i:%s')
1	f	2008-07-01 10:21:39
2	g	2000-02-01 00:00:00
3	j	2007-05-04 20:03:11
4	i	2003-10-30 05:01:03
5	h	2001-10-31 23:59:59

select sql_big_result
SELECT SQL_BIG_RESULT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l
ORDER BY a;
a	b	date_format(c, '%Y-%m-%d %H:%i:%s')
1	f	2008-07-01 10:21:39
2	g	2000-02-01 00:00:00
3	j	2007-05-04 20:03:11
4	i	2003-10-30 05:01:03
5	h	2001-10-31 23:59:59

select sql_buffer_result
SELECT SQL_BUFFER_RESULT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l
ORDER BY a;
a	b	date_format(c, '%Y-%m-%d %H:%i:%s')
1	f	2008-07-01 10:21:39
2	g	2000-02-01 00:00:00
3	j	2007-05-04 20:03:11
4	i	2003-10-30 05:01:03
5	h	2001-10-31 23:59:59

select sql_cache
SELECT SQL_CACHE a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l
ORDER BY a;
a	b	date_format(c, '%Y-%m-%d %H:%i:%s')
1	f	2008-07-01 10:21:39
2	g	2000-02-01 00:00:00
3	j	2007-05-04 20:03:11
4	i	2003-10-30 05:01:03
5	h	2001-10-31 23:59:59

select sql_no_cache
SELECT SQL_NO_CACHE a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l
ORDER BY a;
a	b	date_format(c, '%Y-%m-%d %H:%i:%s')
1	f	2008-07-01 10:21:39
2	g	2000-02-01 00:00:00
3	j	2007-05-04 20:03:11
4	i	2003-10-30 05:01:03
5	h	2001-10-31 23:59:59

select sql_calc_found_rows
SELECT SQL_CALC_FOUND_ROWS a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l
ORDER BY a LIMIT 4;
a	b	date_format(c, '%Y-%m-%d %H:%i:%s')
1	f	2008-07-01 10:21:39
2	g	2000-02-01 00:00:00
3	j	2007-05-04 20:03:11
4	i	2003-10-30 05:01:03
SELECT found_rows();
found_rows()
5

select high_priority
SELECT HIGH_PRIORITY a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l
ORDER BY a;
a	b	date_format(c, '%Y-%m-%d %H:%i:%s')
1	f	2008-07-01 10:21:39
2	g	2000-02-01 00:00:00
3	j	2007-05-04 20:03:11
4	i	2003-10-30 05:01:03
5	h	2001-10-31 23:59:59

select distinct
SELECT DISTINCT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l
ORDER BY a;
a	b	date_format(c, '%Y-%m-%d %H:%i:%s')
1	f	2008-07-01 10:21:39
2	g	2000-02-01 00:00:00
3	j	2007-05-04 20:03:11
4	i	2003-10-30 05:01:03
5	h	2001-10-31 23:59:59

select count
SELECT count(*) FROM ta_l ORDER BY a;
count(*)
5

select table join not use index
SELECT a.a, a.b, date_format(a.c, '%Y-%m-%d %H:%i:%s') FROM tb_l a WHERE
EXISTS (SELECT * FROM ta_l b WHERE b.b = a.b) ORDER BY a.a;
a	b	date_format(a.c, '%Y-%m-%d %H:%i:%s')
1	f	2008-07-01 10:21:39
2	g	2000-02-01 00:00:00
3	j	2007-05-04 20:03:11
4	i	2003-10-30 05:01:03
5	h	2001-10-31 23:59:59

select using pushdown
SELECT a.a, a.b, date_format(a.c, '%Y-%m-%d %H:%i:%s') FROM ta_l a WHERE
a.b = 'g' ORDER BY a.a;
a	b	date_format(a.c, '%Y-%m-%d %H:%i:%s')
2	g	2000-02-01 00:00:00

select using index and pushdown
SELECT a.a, a.b, date_format(a.c, '%Y-%m-%d %H:%i:%s') FROM ta_l a WHERE
a.a > 0 AND a.b = 'g' ORDER BY a.a;
a	b	date_format(a.c, '%Y-%m-%d %H:%i:%s')
2	g	2000-02-01 00:00:00

insert
TRUNCATE TABLE ta_l;
INSERT INTO ta_l (a, b, c) VALUES (2, 'e', '2008-01-01 23:59:59');
SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l ORDER BY a;
a	b	date_format(c, '%Y-%m-%d %H:%i:%s')
2	e	2008-01-01 23:59:59

insert select
TRUNCATE TABLE ta_l;
INSERT INTO ta_l (a, b, c) SELECT a, b, c FROM tb_l;
SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l ORDER BY a;
a	b	date_format(c, '%Y-%m-%d %H:%i:%s')
1	f	2008-07-01 10:21:39
2	g	2000-02-01 00:00:00
3	j	2007-05-04 20:03:11
4	i	2003-10-30 05:01:03
5	h	2001-10-31 23:59:59

insert select a
TRUNCATE TABLE ta_l;
INSERT INTO ta_l (a, b, c) VALUES ((SELECT a FROM tb_l ORDER BY a LIMIT 1),
'e', '2008-01-01 23:59:59');
SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l ORDER BY a;
a	b	date_format(c, '%Y-%m-%d %H:%i:%s')
1	e	2008-01-01 23:59:59

insert low_priority
TRUNCATE TABLE ta_l;
INSERT LOW_PRIORITY INTO ta_l (a, b, c) values (2, 'e', '2008-01-01 23:59:59');
SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l ORDER BY a;
a	b	date_format(c, '%Y-%m-%d %H:%i:%s')
2	e	2008-01-01 23:59:59

insert high_priority
TRUNCATE TABLE ta_l;
INSERT HIGH_PRIORITY INTO ta_l (a, b, c) VALUES (2, 'e',
'2008-01-01 23:59:59');
SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l ORDER BY a;
a	b	date_format(c, '%Y-%m-%d %H:%i:%s')
2	e	2008-01-01 23:59:59

insert ignore
INSERT IGNORE INTO ta_l (a, b, c) VALUES (2, 'd', '2009-02-02 01:01:01');
Warnings:
Warning	1062	Duplicate entry '2' for key 'PRIMARY'
SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l ORDER BY a;
a	b	date_format(c, '%Y-%m-%d %H:%i:%s')
2	e	2008-01-01 23:59:59

insert update (insert)
TRUNCATE TABLE ta_l;
INSERT INTO ta_l (a, b, c) VALUES (2, 'e', '2008-01-01 23:59:59') ON DUPLICATE
KEY UPDATE b = 'f', c = '2005-08-08 11:11:11';
SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l ORDER BY a;
a	b	date_format(c, '%Y-%m-%d %H:%i:%s')
2	e	2008-01-01 23:59:59

insert update (update)
INSERT INTO ta_l (a, b, c) VALUES (2, 'e', '2008-01-01 23:59:59') ON DUPLICATE
KEY UPDATE b = 'f', c = '2005-08-08 11:11:11';
SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l ORDER BY a;
a	b	date_format(c, '%Y-%m-%d %H:%i:%s')
2	f	2005-08-08 11:11:11

replace
TRUNCATE TABLE ta_l;
INSERT INTO ta_l (a, b, c) VALUES (2, 'e', '2008-01-01 23:59:59');
REPLACE INTO ta_l (a, b, c) VALUES (2, 'f', '2008-02-02 02:02:02');
SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l ORDER BY a;
a	b	date_format(c, '%Y-%m-%d %H:%i:%s')
2	f	2008-02-02 02:02:02

replace select
REPLACE INTO ta_l (a, b, c) SELECT a, b, c FROM tb_l;
SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l ORDER BY a;
a	b	date_format(c, '%Y-%m-%d %H:%i:%s')
1	f	2008-07-01 10:21:39
2	g	2000-02-01 00:00:00
3	j	2007-05-04 20:03:11
4	i	2003-10-30 05:01:03
5	h	2001-10-31 23:59:59

replace select a
REPLACE INTO ta_l (a, b, c) VALUES ((SELECT a FROM tb_l ORDER BY a LIMIT 1),
'e', '2008-01-01 23:59:59');
SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l ORDER BY a;
a	b	date_format(c, '%Y-%m-%d %H:%i:%s')
1	e	2008-01-01 23:59:59
2	g	2000-02-01 00:00:00
3	j	2007-05-04 20:03:11
4	i	2003-10-30 05:01:03
5	h	2001-10-31 23:59:59

replace low_priority
REPLACE LOW_PRIORITY INTO ta_l (a, b, c) VALUES (3, 'g',
'2009-03-03 03:03:03');
SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l ORDER BY a;
a	b	date_format(c, '%Y-%m-%d %H:%i:%s')
1	e	2008-01-01 23:59:59
2	g	2000-02-01 00:00:00
3	g	2009-03-03 03:03:03
4	i	2003-10-30 05:01:03
5	h	2001-10-31 23:59:59

update
TRUNCATE TABLE ta_l;
INSERT INTO ta_l (a, b, c) VALUES (1, 'e', '2008-01-01 23:59:59'),
(2, 'e', '2008-01-01 23:59:59');
UPDATE ta_l SET b = 'f', c = '2008-02-02 02:02:02' WHERE a = 2;
SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l ORDER BY a;
a	b	date_format(c, '%Y-%m-%d %H:%i:%s')
1	e	2008-01-01 23:59:59
2	f	2008-02-02 02:02:02

update select
UPDATE ta_l SET b = 'g', c = '2009-03-03 03:03:03' WHERE a IN (SELECT a FROM
tb_l);
SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l ORDER BY a;
a	b	date_format(c, '%Y-%m-%d %H:%i:%s')
1	g	2009-03-03 03:03:03
2	g	2009-03-03 03:03:03

update select a
UPDATE ta_l SET b = 'h', c = '2010-04-04 04:04:04' WHERE a = (SELECT a FROM
tb_l ORDER BY a LIMIT 1);
SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l ORDER BY a;
a	b	date_format(c, '%Y-%m-%d %H:%i:%s')
1	h	2010-04-04 04:04:04
2	g	2009-03-03 03:03:03

update join
UPDATE ta_l a, tb_l b SET a.b = b.b, a.c = b.c WHERE a.a = b.a;
SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l ORDER BY a;
a	b	date_format(c, '%Y-%m-%d %H:%i:%s')
1	f	2008-07-01 10:21:39
2	g	2000-02-01 00:00:00

update join a
UPDATE ta_l a, tb_l b SET a.b = 'g', a.c = '2009-03-03 03:03:03' WHERE
a.a = b.a;
SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l ORDER BY a;
a	b	date_format(c, '%Y-%m-%d %H:%i:%s')
1	g	2009-03-03 03:03:03
2	g	2009-03-03 03:03:03

update low_priority
UPDATE LOW_PRIORITY ta_l SET b = 'f', c = '2008-02-02 02:02:02' WHERE a = 2;
SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l ORDER BY a;
a	b	date_format(c, '%Y-%m-%d %H:%i:%s')
1	g	2009-03-03 03:03:03
2	f	2008-02-02 02:02:02

update ignore
UPDATE IGNORE ta_l SET a = 1, b = 'g', c = '2009-03-03 03:03:03' WHERE a = 2;
SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l ORDER BY a;
a	b	date_format(c, '%Y-%m-%d %H:%i:%s')
1	g	2009-03-03 03:03:03
2	f	2008-02-02 02:02:02

update pushdown
update ta_l set b = 'j', c = '2009-03-03 03:03:03' where b = 'f';
SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l ORDER BY a;
a	b	date_format(c, '%Y-%m-%d %H:%i:%s')
1	g	2009-03-03 03:03:03
2	j	2009-03-03 03:03:03

update index pushdown
UPDATE ta_l SET b = 'g', c = '2009-03-03 03:03:03' WHERE a > 0 AND b = 'j';
SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l ORDER BY a;
a	b	date_format(c, '%Y-%m-%d %H:%i:%s')
1	g	2009-03-03 03:03:03
2	g	2009-03-03 03:03:03

delete
TRUNCATE TABLE ta_l;
INSERT INTO ta_l (a, b, c) VALUES (1, 'e', '2008-01-01 23:59:59'),
(2, 'e', '2008-01-01 23:59:59'), (3, 'e', '2008-01-01 23:59:59'),
(4, 'e', '2008-01-01 23:59:59'), (5, 'e', '2008-01-01 23:59:59'),
(6, 'e', '2008-01-01 23:59:59'), (7, 'e', '2008-01-01 23:59:59'),
(8, 'e', '2008-01-01 23:59:59'), (9, 'e', '2008-01-01 23:59:59'),
(10, 'j', '2008-01-01 23:59:59');
DELETE FROM ta_l WHERE a = 2;
SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l ORDER BY a;
a	b	date_format(c, '%Y-%m-%d %H:%i:%s')
1	e	2008-01-01 23:59:59
3	e	2008-01-01 23:59:59
4	e	2008-01-01 23:59:59
5	e	2008-01-01 23:59:59
6	e	2008-01-01 23:59:59
7	e	2008-01-01 23:59:59
8	e	2008-01-01 23:59:59
9	e	2008-01-01 23:59:59
10	j	2008-01-01 23:59:59

delete all
DELETE FROM ta_l;
SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l ORDER BY a;
a	b	date_format(c, '%Y-%m-%d %H:%i:%s')

delete select
TRUNCATE TABLE ta_l;
INSERT INTO ta_l (a, b, c) VALUES (1, 'e', '2008-01-01 23:59:59'),
(2, 'e', '2008-01-01 23:59:59'), (3, 'e', '2008-01-01 23:59:59'),
(4, 'e', '2008-01-01 23:59:59'), (5, 'e', '2008-01-01 23:59:59'),
(6, 'e', '2008-01-01 23:59:59'), (7, 'e', '2008-01-01 23:59:59'),
(8, 'e', '2008-01-01 23:59:59'), (9, 'e', '2008-01-01 23:59:59'),
(10, 'j', '2008-01-01 23:59:59');
DELETE FROM ta_l WHERE a IN (SELECT a FROM tb_l);
SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l ORDER BY a;
a	b	date_format(c, '%Y-%m-%d %H:%i:%s')
6	e	2008-01-01 23:59:59
7	e	2008-01-01 23:59:59
8	e	2008-01-01 23:59:59
9	e	2008-01-01 23:59:59
10	j	2008-01-01 23:59:59

delete select a
TRUNCATE TABLE ta_l;
INSERT INTO ta_l (a, b, c) VALUES (1, 'e', '2008-01-01 23:59:59'),
(2, 'e', '2008-01-01 23:59:59'), (3, 'e', '2008-01-01 23:59:59'),
(4, 'e', '2008-01-01 23:59:59'), (5, 'e', '2008-01-01 23:59:59'),
(6, 'e', '2008-01-01 23:59:59'), (7, 'e', '2008-01-01 23:59:59'),
(8, 'e', '2008-01-01 23:59:59'), (9, 'e', '2008-01-01 23:59:59'),
(10, 'j', '2008-01-01 23:59:59');
DELETE FROM ta_l WHERE a = (SELECT a FROM tb_l ORDER BY a LIMIT 1);
SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l ORDER BY a;
a	b	date_format(c, '%Y-%m-%d %H:%i:%s')
2	e	2008-01-01 23:59:59
3	e	2008-01-01 23:59:59
4	e	2008-01-01 23:59:59
5	e	2008-01-01 23:59:59
6	e	2008-01-01 23:59:59
7	e	2008-01-01 23:59:59
8	e	2008-01-01 23:59:59
9	e	2008-01-01 23:59:59
10	j	2008-01-01 23:59:59

delete join
TRUNCATE TABLE ta_l;
INSERT INTO ta_l (a, b, c) VALUES (1, 'e', '2008-01-01 23:59:59'),
(2, 'e', '2008-01-01 23:59:59'), (3, 'e', '2008-01-01 23:59:59'),
(4, 'e', '2008-01-01 23:59:59'), (5, 'e', '2008-01-01 23:59:59'),
(6, 'e', '2008-01-01 23:59:59'), (7, 'e', '2008-01-01 23:59:59'),
(8, 'e', '2008-01-01 23:59:59'), (9, 'e', '2008-01-01 23:59:59'),
(10, 'j', '2008-01-01 23:59:59');
DELETE a FROM ta_l a, (SELECT a FROM tb_l ORDER BY a) b WHERE a.a = b.a;
SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l ORDER BY a;
a	b	date_format(c, '%Y-%m-%d %H:%i:%s')
6	e	2008-01-01 23:59:59
7	e	2008-01-01 23:59:59
8	e	2008-01-01 23:59:59
9	e	2008-01-01 23:59:59
10	j	2008-01-01 23:59:59

delete low_priority
TRUNCATE TABLE ta_l;
INSERT INTO ta_l (a, b, c) VALUES (1, 'e', '2008-01-01 23:59:59'),
(2, 'e', '2008-01-01 23:59:59'), (3, 'e', '2008-01-01 23:59:59'),
(4, 'e', '2008-01-01 23:59:59'), (5, 'e', '2008-01-01 23:59:59'),
(6, 'e', '2008-01-01 23:59:59'), (7, 'e', '2008-01-01 23:59:59'),
(8, 'e', '2008-01-01 23:59:59'), (9, 'e', '2008-01-01 23:59:59'),
(10, 'j', '2008-01-01 23:59:59');
DELETE LOW_PRIORITY FROM ta_l WHERE a = 2;
SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l ORDER BY a;
a	b	date_format(c, '%Y-%m-%d %H:%i:%s')
1	e	2008-01-01 23:59:59
3	e	2008-01-01 23:59:59
4	e	2008-01-01 23:59:59
5	e	2008-01-01 23:59:59
6	e	2008-01-01 23:59:59
7	e	2008-01-01 23:59:59
8	e	2008-01-01 23:59:59
9	e	2008-01-01 23:59:59
10	j	2008-01-01 23:59:59

delete ignore
TRUNCATE TABLE ta_l;
INSERT INTO ta_l (a, b, c) VALUES (1, 'e', '2008-01-01 23:59:59'),
(2, 'e', '2008-01-01 23:59:59'), (3, 'e', '2008-01-01 23:59:59'),
(4, 'e', '2008-01-01 23:59:59'), (5, 'e', '2008-01-01 23:59:59'),
(6, 'e', '2008-01-01 23:59:59'), (7, 'e', '2008-01-01 23:59:59'),
(8, 'e', '2008-01-01 23:59:59'), (9, 'e', '2008-01-01 23:59:59'),
(10, 'j', '2008-01-01 23:59:59');
DELETE IGNORE FROM ta_l WHERE a = 2;
SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l ORDER BY a;
a	b	date_format(c, '%Y-%m-%d %H:%i:%s')
1	e	2008-01-01 23:59:59
3	e	2008-01-01 23:59:59
4	e	2008-01-01 23:59:59
5	e	2008-01-01 23:59:59
6	e	2008-01-01 23:59:59
7	e	2008-01-01 23:59:59
8	e	2008-01-01 23:59:59
9	e	2008-01-01 23:59:59
10	j	2008-01-01 23:59:59

delete quick
TRUNCATE TABLE ta_l;
INSERT INTO ta_l (a, b, c) VALUES (1, 'e', '2008-01-01 23:59:59'),
(2, 'e', '2008-01-01 23:59:59'), (3, 'e', '2008-01-01 23:59:59'),
(4, 'e', '2008-01-01 23:59:59'), (5, 'e', '2008-01-01 23:59:59'),
(6, 'e', '2008-01-01 23:59:59'), (7, 'e', '2008-01-01 23:59:59'),
(8, 'e', '2008-01-01 23:59:59'), (9, 'e', '2008-01-01 23:59:59'),
(10, 'j', '2008-01-01 23:59:59');
DELETE QUICK FROM ta_l WHERE a = 2;
SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l ORDER BY a;
a	b	date_format(c, '%Y-%m-%d %H:%i:%s')
1	e	2008-01-01 23:59:59
3	e	2008-01-01 23:59:59
4	e	2008-01-01 23:59:59
5	e	2008-01-01 23:59:59
6	e	2008-01-01 23:59:59
7	e	2008-01-01 23:59:59
8	e	2008-01-01 23:59:59
9	e	2008-01-01 23:59:59
10	j	2008-01-01 23:59:59

delete pushdown
TRUNCATE TABLE ta_l;
INSERT INTO ta_l (a, b, c) VALUES (1, 'e', '2008-01-01 23:59:59'),
(2, 'e', '2008-01-01 23:59:59'), (3, 'e', '2008-01-01 23:59:59'),
(4, 'e', '2008-01-01 23:59:59'), (5, 'e', '2008-01-01 23:59:59'),
(6, 'e', '2008-01-01 23:59:59'), (7, 'e', '2008-01-01 23:59:59'),
(8, 'e', '2008-01-01 23:59:59'), (9, 'e', '2008-01-01 23:59:59'),
(10, 'j', '2008-01-01 23:59:59');
DELETE FROM ta_l WHERE b = 'e';
SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l ORDER BY a;
a	b	date_format(c, '%Y-%m-%d %H:%i:%s')
10	j	2008-01-01 23:59:59

delete index pushdown
TRUNCATE TABLE ta_l;
INSERT INTO ta_l (a, b, c) VALUES (1, 'e', '2008-01-01 23:59:59'),
(2, 'e', '2008-01-01 23:59:59'), (3, 'e', '2008-01-01 23:59:59'),
(4, 'e', '2008-01-01 23:59:59'), (5, 'e', '2008-01-01 23:59:59'),
(6, 'e', '2008-01-01 23:59:59'), (7, 'e', '2008-01-01 23:59:59'),
(8, 'e', '2008-01-01 23:59:59'), (9, 'e', '2008-01-01 23:59:59'),
(10, 'j', '2008-01-01 23:59:59');
DELETE FROM ta_l WHERE a > 0 AND b = 'e';
SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l ORDER BY a;
a	b	date_format(c, '%Y-%m-%d %H:%i:%s')
10	j	2008-01-01 23:59:59

truncate
TRUNCATE TABLE ta_l;
SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l ORDER BY a;
a	b	date_format(c, '%Y-%m-%d %H:%i:%s')

deinit
DROP DATABASE IF EXISTS auto_test_local;
DROP DATABASE IF EXISTS auto_test_remote;
DROP DATABASE IF EXISTS auto_test_remote2;
for master_1
for child2
child2_1
child2_2
child2_3
for child3
child3_1
child3_2
child3_3

end of test