List:Commits« Previous MessageNext Message »
From:Chuck Bell Date:July 21 2008 8:22pm
Subject:RE: bzr commit into mysql-6.0-backup branch (hema:2650) WL#4227
View as plain text  
Hema,

Why a new suite? I think these tests need to be in the backup suite, not a
new suite. If I want to run our backup tests I want to be able to say "run
all backup tests" which I cannot do (or won't remember to) if they are
spread out over several suites. Can you please forward magnus, lars, and
others' emails on the subject because I just don't see the need to separate
the tests from the normal backup suite. 

>  2650 Hema Sridharan	2008-07-08
>       WL#4227(Test of identifiers for character sets). The 
> test included are test of partitions and different datatypes.
> added:
>   mysql-test/suite/backup_charsets/
>   mysql-test/suite/backup_charsets/combinations
>   mysql-test/suite/backup_charsets/include/
>   mysql-test/suite/backup_charsets/include/charset.inc
>   mysql-test/suite/backup_charsets/include/not_have_falcon.inc
>   mysql-test/suite/backup_charsets/r/
>   mysql-test/suite/backup_charsets/r/backup_datatypes.result
>   mysql-test/suite/backup_charsets/r/backup_partitions.result
>   mysql-test/suite/backup_charsets/t/
>   mysql-test/suite/backup_charsets/t/backup_datatypes.test
>   mysql-test/suite/backup_charsets/t/backup_partitions.test

When I applied this patch and ran the tests using
./mysql-test-run.pl --suite=backup_charsets I got this error:

TEST                           RESULT         TIME (ms)
-------------------------------------------------------

backup_charsets.backup_datatypes 'myisam big5 big5_chinese_ci' [ fail ]

mysqltest: At line 9: Could not open
'.\suite\backup\include\backup_engine.inc'
for reading

It seems this patch is reliant on WL#4222. This is normally ok, but you
_must_ specify this in the patch comments as well as the worklog. As it so
happens, I have the patch for WL#4222 so I was able to continue.

When I applied the WL#4222 patch and ran the tests, I got lots of test
failures. Have you ran these tests on Windows? I have attached the test
results, but here are some things I noticed:

* The crashes were frequent and severe
* I did not run all of the test as it was getting > 30 minutes and it seemed
no end was in sight.
* Falcon tests are passing but I didn't build with Falcon -- this is very
wrong. See my comments to WL#4222 review.

backup_charsets.backup_datatypes 'falcon big5 big5_bin' [ pass ]
453
                                  ??????????????????????  NO! Skipped if not
compiled with Falcon.

* The crash generates this dump nearly every time:

080721 22:57:32 - mysqld got exception 0xc0000005 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help
diagnose
the problem, but since we have already crashed, something is definitely
wrong
and this may fail.

key_buffer_size=1048576
read_buffer_size=131072
max_used_connections=3
max_threads=151
thread_count=3
connection_count=3
It is possible that mysqld could use up to 
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 59984
K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

thd: 0x32f1c58
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
006858A9    mysqld.exe!write_log_dropped_partitions()[sql_partition.cc:5347]
00685D7E
mysqld.exe!write_log_add_change_partition()[sql_partition.cc:5628]
5A5A5A5A    
5A5A5A5A    
5A5A5A5A    
5A5A5A5A    
5A5A5A5A    
5A5A5A5A    
5A5A5A5A    
5A5A5A5A    
5A5A5A5A    
5A5A5A5A    
5A5A5A5A    
5A5A5A5A    
5A5A5A5A    
5A5A5A5A    
5A5A5A5A    
5A5A5A5A    
5A5A5A5A    
5A5A5A5A    
5A5A5A5A    
5A5A5A5A    
5A5A5A5A    
5A5A5A5A    
5A5A5A5A    
5A5A5A5A    
5A5A5A5A    
5A5A5A5A    
5A5A5A5A    
5A5A5A5A    
5A5A5A5A    
5A5A5A5A    
5A5A5A5A    
5A5A5A5A    
5A5A5A5A    
5A5A5A5A    
5A5A5A5A    
5A5A5A5A    
5A5A5A5A    
5A5A5A5A    
5A5A5A5A    
5A5A5A5A    
5A5A5A5A    
5A5A5A5A    
5A5A5A5A    
5A5A5A5A    
5A5A5A5A    
5A5A5A5A    
5A5A5A5A    
5A5A5A5A    
5A5A5A5A    
5A5A5A5A    
5A5A5A5A    
5A5A5A5A    
5A5A5A5A    
5A5A5A5A    
CCCC5A5A    
CCCCCCCC    
CCCCCCCC    
CCCCCCCC    
CCCCCCCC    
CCCCCCCC    
CCCCCCCC    
CCCCCCCC    
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 032E6CA8=ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES
IN (10,20,30))
thd->thread_id=7
thd->killed=NOT_KILLED
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.

So clearly something is very wrong with partitions on Windows. You need to
research this and test the partition test on Windows to ensure you aren't
trying something that is platform restrictive. 

...

Now a few notes about the tests:

> === added directory 'mysql-test/suite/backup_charsets/t'
> === added file 
> 'mysql-test/suite/backup_charsets/t/backup_datatypes.test'
> --- 
> a/mysql-test/suite/backup_charsets/t/backup_datatypes.test	
> 1970-01-01 00:00:00 +0000
> +++ 
> b/mysql-test/suite/backup_charsets/t/backup_datatypes.test	
> 2008-07-07 22:22:55 +0000
> @@ -0,0 +1,122 @@
> +#############################################################
> ###########
> +# Author: Hema
> +# Date: 2008-03-11
> +# Purpose: To test the backup/restore of all datatypes for 
> different storage    
> +# engines.
> +#############################################################
> ############
> +--source include/not_embedded.inc
> +--source include/have_debug.inc
> +--source suite/backup/include/backup_engine.inc
> +--source suite/backup_charsets/include/charset.inc
> +
> +connect (backup,localhost,root,,);
> +connect (breakpoints,localhost,root,,);
> +
> +##############################################################
> +--echo
> +--echo starting the test for backup
> +--echo
> +##############################################################
> +
> +--error 0,1
> +--remove_file $MYSQLTEST_VARDIR/master-data/bup_datatype.bak
> +
> +
> +#Create Database and tables with different datatypes for this test.
> +
> +--disable_warnings
> +DROP DATABASE IF EXISTS bup_datatype;
> +--enable_warnings
> +
> +--replace_result $cset cset
> +eval SET NAMES $cset;
> +CREATE DATABASE bup_datatype;
> +USE bup_datatype;
> +
> +#Bug#37854 Test fails/aborts for collate latin2_czech_cs 
> used with SET 
> +#and ENUM datatypes
> +--replace_result $coll coll
> +if(`SELECT '$coll'='latin2_czech_cs'`)
> +{
> + skip "This test does'nt support latin2_czech_cs collation 
> BUG#37854" ;
> +}
> +
> +#Create table and load with data.
> +
> +--echo Creating table with all storage engines and csets/coll
> +
> +CREATE TABLE d1(
> +rint INT, 
> +tint TINYINT,
> +sint SMALLINT,
> +bint BIGINT,
> +mint MEDIUMINT,
> +name CHAR(100), 
> +city  VARCHAR(100),
> +fl FLOAT(7,4), 
> +pers DECIMAL(8,2), 
> +sal DOUBLE,
> +colours SET('red','blue','yellow'), 
> +continent ENUM('Asia', 'Europe','Africa','Antartica'),
> +ts TIMESTAMP DEFAULT 0, 
> +dob DATE,
> +y YEAR
> +);
> +
> +--echo creating table with blob and text columns
> +CREATE TABLE d2(
> +region TEXT, 
> +summary LONGTEXT, 
> +data BLOB, 
> +details MEDIUMBLOB,
> +queries TINYTEXT, 
> +query2 TINYBLOB, 
> +extract LONGBLOB, 
> +paras MEDIUMTEXT
> +);
> +
> +INSERT INTO d1 VALUES
> +(785,127,7288,278829899,3777,'testing1','sweden','678.299',20
> 0.23,829899.909,
> +'red','Asia','2008-06-01 16:23:30','1984-09-08','1984');
> +
> +INSERT INTO d2 VALUES
> +('xxxxxxxx','Testofonline 
> backup','aaaaaaaaaa','bbbbbbbbbbb','hhhhhhhhhhh',
> +'kkkkkkkkkkkkk','mmmmmmmmmmmm','onlinebackup1');
> +
> +# Bug #37212  Restore crashes if table has longblob of size 1MB
> +UPDATE d2 SET extract=repeat('z',100);
> +--query_vertical SELECT * FROM d1;
> +SELECT * FROM d2;
> +
> +DESCRIBE d1;
> +DESCRIBE d2;
> +
> +--echo **backup data**
> +--echo
> +--replace_column 1 #
> +BACKUP DATABASE bup_datatype TO 'bup_datatype.bak';
> +
> +--echo** dropping  database**
> +DROP DATABASE bup_datatype;
> +
> +--echo **Restore**
> +--replace_column 1 #
> +RESTORE FROM 'bup_datatype.bak';
> +
> +#show data table columns
> +DESCRIBE d1;
> +DESCRIBE d2;
> +
> +--query_vertical SELECT * FROM d1;
> +SELECT * FROM d2;
> +
> +# Test cleanup section
> +
> +--echo
> +--echo ***  DROP bup_datatype DATABASE ****
> +--echo
> +
> +DROP DATABASE bup_datatype;
> +--remove_file $MYSQLTEST_VARDIR/master-data/bup_datatype.bak
> +
> +
> 
> === added file 
> 'mysql-test/suite/backup_charsets/t/backup_partitions.test'
> --- 
> a/mysql-test/suite/backup_charsets/t/backup_partitions.test	
> 1970-01-01 00:00:00 +0000
> +++ 
> b/mysql-test/suite/backup_charsets/t/backup_partitions.test	
> 2008-07-07 22:22:55 +0000
> @@ -0,0 +1,269 @@
> +#############################################################
> ##############
> +# Author: Hema
> +# Date: 2008-03-11
> +# Purpose: To test the backup and Restore of different 
> partitions using
> +# Reserved words as  identifiers for all Character sets
> +#############################################################
> ##################
> +--source include/not_embedded.inc
> +--source include/have_debug.inc
> +--source suite/backup/include/backup_engine.inc
> +--source suite/backup_charsets/include/not_have_falcon.inc

This is clearly not working. Please fix.

> +--source suite/backup_charsets/include/charset.inc
> +
> +connect (backup,localhost,root,,);
> +connect (breakpoints,localhost,root,,);
> +
> +##############################################################
> +--echo
> +--echo starting the test for backup
> +--echo
> +##############################################################
> +
> +--error 0,1
> +--remove_file $MYSQLTEST_VARDIR/master-data/partitions.bak
> +
> +#Create Database and and tables with different types of partitions.
> +
> +--disable_warnings
> +DROP DATABASE IF EXISTS partitions;
> +--enable_warnings
> +
> +--echo Bug #34391 Character sets: crash if char(), utf32, innodb
> +--echo Bug #33566 Backup: crash with partitions and Falcon
> +--echo Bug #37551 Junk detected in data contents sometimes 
> when utf8mb3
> +--echo character set is used.
> +--echo Bug #37554 Use of character set and collate as 
> 'filename' shows 
> +--echo unusual behaviour.
> +--echo Bug #35499 View when created with swe7 character set fails.
> +
> +--replace_result $cset cset
> +eval SET NAMES $cset;
> +
> +CREATE DATABASE partitions;
> +USE partitions;
> +
> +#Create table and load with data.
> +
> +--echo *****Creating table with range partition*********
> +
> +CREATE TABLE `range`(
> + ID INT NOT NULL,
> +NAME CHAR(20),
> +AGE TINYINT,
> +DOB DATE,
> +SAL FLOAT,
> +PRIMARY KEY(DOB)) PARTITION BY RANGE(Year(DOB))(
> +        PARTITION P0 values less than (1970),
> +        PARTITION P1 values less than (1980),
> +        PARTITION P2 values less than (1990),
> +        PARTITION P3 values less than (2000),
> +        PARTITION P4 values less than maxvalue);
> +
> +--echo loading data
> +
> +INSERT INTO `range`VALUES
> +(10,'aa','20','1988-12-19',2345.89),(11,'bb',31,'1977-10-19',
> 6009.89),
> +(12,'cc',78,'1945-09-12',3897),(13,'dd',12,'1994-09-18',7892.78),
> +(14,'ee',45,'1960-12-23',7845.90),(15,'ff',25,'1984-02-07',3500.89);
> +
> +--echo select data
> +
> +SELECT * FROM `range` ORDER BY DOB;
> +SELECT COUNT(*) FROM `range`;
> +
> +--echo
> +--echo ******Creating table partition with List**************
> +
> +CREATE TABLE `left`(`numeric` INT, `char` CHAR(20))  
> +PARTITION BY LIST (`numeric`)
> +(
> +   PARTITION p0 VALUES IN (1,3,5),
> +   PARTITION p1 VALUES IN (2,4,6)
> +);
> +--echo insert data
> +
> +INSERT INTO `left` VALUES(1,'a'),(6,'c'),(5,'j'),(2,'l');
> +
> +--echo selecting data
> +
> +SELECT * FROM `left` ORDER BY `numeric`;
> +SELECT COUNT(*) FROM `left`;
> +
> +--echo
> +--echo *******Creating table partition with Hash***********
> +
> +CREATE TABLE `modifies`(
> +col1 INT,
> +col2 CHAR(20),
> +col3 DATE)
> +PARTITION BY HASH (YEAR(col3))
> +PARTITIONS 4;
> +
> +--echo Insert data
> +
> +INSERT INTO `modifies` VALUES
> +(1,'a','1942-10-09'),(2,'b','1950-08-07'),
> +(3,'c','1952-10-10'),(4,'d','1954-10-04');
> +
> +--echo selecting data
> +
> +SELECT * FROM `modifies` ORDER BY col3;
> +SELECT COUNT(*) FROM `modifies`;
> +--echo ********Creating table partition with keys*******
> +
> +CREATE TABLE `key`(id INT) 
> +PARTITION BY KEY(id)
> +PARTITIONS 2;
> +
> +--echo insert data
> +
> +INSERT INTO `key` VALUES(1),(2),(3),(4);
> +
> +--echo selecting the data
> +
> +SELECT * FROM `key`;
> +SELECT COUNT(*) FROM `key`;
> +
> +--echo ***Creating views from partitoned Tables****
> +
> +CREATE VIEW `values` AS SELECT * FROM `range`;
> +
> +# We mask some of the columns in Explain Partitions command 
> because of 
> +# Bug #37532 Explain command shows incorrect rows, 
> +# when table is partitioned and innodb.
> +
> +--echo Obtaining information about Partitions
> +SHOW FULL TABLES;
> +--replace_column 1 # 10 #
> +--query_vertical EXPLAIN PARTITIONS SELECT * FROM `key`;
> +--replace_column 1 # 10 #
> +--query_vertical EXPLAIN PARTITIONS SELECT * FROM `modifies`;
> +--replace_column 1 # 10 #
> +--query_vertical EXPLAIN PARTITIONS SELECT * FROM `left`;
> +--replace_column 1 # 10 #
> +--query_vertical EXPLAIN PARTITIONS SELECT * FROM `range`;
> +
> +--echo backup data
> +--replace_column 1 #
> +BACKUP DATABASE partitions TO 'partitions.bak';
> +
> +--echo dropping  database.
> +
> +DROP DATABASE partitions;
> +
> +--echo Restore
> +--replace_column 1 #
> +RESTORE FROM 'partitions.bak';
> +--remove_file $MYSQLTEST_VARDIR/master-data/partitions.bak
> +
> +--echo
> +--echo ** RESULTS AFTER RESTORE **
> +--echo
> +
> +#show data and create statements
> +--echo Obtaining Information about Partitions
> +--query_vertical SHOW FULL TABLES;
> +--replace_column 1 # 10 #
> +--query_vertical EXPLAIN PARTITIONS SELECT * FROM `key`;
> +--replace_column 1 # 10 #
> +--query_vertical EXPLAIN PARTITIONS SELECT * FROM `modifies`;
> +--replace_column 1 # 10 #
> +--query_vertical EXPLAIN PARTITIONS SELECT * FROM `left`;
> +--replace_column 1 # 10 #
> +--query_vertical EXPLAIN PARTITIONS SELECT * FROM `range`;
> +
> +# Make some changes to existing partitions, take backup and 
> then perform
> +# Restore
> +
> +ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
> +ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));
> +INSERT INTO `left` VALUES(10,'h'),(3,'b'),(10,'s'),(5,'l');
> +SELECT * FROM `left`;
> +SELECT COUNT(*) FROM `left`;
> +
> +INSERT INTO `values` VALUES(17,'kk','90','2020-12-19',2000);
> +SELECT COUNT(*) FROM `values`;
> +SELECT COUNT(*) FROM  `range`;
> +
> +--echo 
> +--echo **Creating table with subpartitions**
> +
> +CREATE TABLE `change` (`int` INT)
> +PARTITION BY range (`int`)
> +SUBPARTITION BY key (`int`)
> +(PARTITION p0 VALUES LESS THAN (2));
> +
> +INSERT INTO `change` VALUES(0),(1);
> +
> +#show data and create statements
> +SHOW FULL TABLES;
> +--replace_column 1 # 10 #
> +--query_vertical EXPLAIN PARTITIONS SELECT * FROM `left`;
> +--replace_column 1 # 10 #
> +--query_vertical EXPLAIN PARTITIONS SELECT * FROM `range`;
> +--replace_column 1 # 10 #
> +--query_vertical EXPLAIN PARTITIONS SELECT * FROM `change`;
> +
> +--replace_column 1 #
> +BACKUP DATABASE partitions TO 'partitions.bak';
> +DROP DATABASE partitions;
> +--replace_column 1 #
> +RESTORE FROM 'partitions.bak';
> +--remove_file $MYSQLTEST_VARDIR/master-data/partitions.bak
> +
> +#show data and create statements
> +--echo showing objects and create statements
> +--replace_column 1 # 10 #
> +--query_vertical EXPLAIN PARTITIONS SELECT * FROM `key`;
> +--replace_column 1 # 10 #
> +--query_vertical EXPLAIN PARTITIONS SELECT * FROM `modifies`;
> +--replace_column 1 # 10 #
> +--query_vertical EXPLAIN PARTITIONS SELECT * FROM `left`;
> +--replace_column 1 # 10 #
> +--query_vertical EXPLAIN PARTITIONS SELECT * FROM `range`;
> +
> +SELECT * FROM `left` ORDER BY `numeric`;
> +SELECT * FROM `key`;
> +SELECT * FROM `modifies` ORDER BY col3;
> +SELECT * FROM `range`  ORDER BY DOB;
> +SELECT * FROM `change`;
> +
> +--echo **creating view from view***
> +CREATE VIEW v2 AS SELECT * FROM `values`;
> +INSERT INTO v2 VALUES(18,'pp',51,'1990-10-19',6009.89);
> +
> +
> +SELECT COUNT(*) FROM `values`;
> +SELECT COUNT(*) FROM  `range`;
> +
> +--echo Make some changes and then perform Restore.
> +
> +ALTER TABLE `change` ADD PARTITION (PARTITION p1 VALUES LESS 
> THAN (4));
> +INSERT INTO `change` VALUES(2),(3),(1);
> +--replace_column 1 # 10 #
> +--query_vertical EXPLAIN PARTITIONS SELECT * FROM `change`;
> +SHOW FULL TABLES;
> +
> +--replace_column 1 #
> +BACKUP DATABASE partitions to 'partitions.bak';
> +
> +DROP DATABASE partitions;
> +--replace_column 1 #
> +RESTORE FROM 'partitions.bak';
> +
> +SHOW FULL TABLES;
> +SELECT * FROM `change`;
> +--replace_column 1 # 10 #
> +--query_vertical EXPLAIN PARTITIONS SELECT * FROM `change`;
> +SELECT * FROM `values` ORDER BY DOB;
> +SELECT COUNT(*) FROM  `range`;
> +
> +# Test cleanup section
> +
> +--echo
> +--echo ***  DROP partitions DATABASE ****
> +--echo
> +DROP DATABASE partitions;
> +
> +--remove_file $MYSQLTEST_VARDIR/master-data/partitions.bak
> +

Chuck

Logging: ./mysql-test-run.pl --suite=backup_charsets --force
MySQL Version 6.0.6
Using dynamic switching of binlog format
Skipping ndbcluster, mysqld not compiled with ndbcluster
Setting mysqld to support SSL connections
Binaries are debug compiled
Using MTR_BUILD_THREAD      = 0
Using MASTER_MYPORT         = 9306
Using MASTER_MYPORT1        = 9307
Using SLAVE_MYPORT          = 9308
Using SLAVE_MYPORT1         = 9309
Using SLAVE_MYPORT2         = 9310
 - adding combinations
Killing Possible Leftover Processes
Removing Stale Files
Creating Directories
Installing Master Database
Saving snapshot of installed databases
=======================================================

TEST                           RESULT         TIME (ms)
-------------------------------------------------------

backup_charsets.backup_datatypes 'myisam big5 big5_chinese_ci' [ pass ]            421
backup_charsets.backup_partitions 'myisam big5 big5_chinese_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'innodb big5 big5_chinese_ci' [ pass ]           4041
backup_charsets.backup_partitions 'innodb big5 big5_chinese_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'falcon big5 big5_chinese_ci' [ pass ]            437
backup_charsets.backup_partitions 'falcon big5 big5_chinese_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'myisam big5 big5_bin' [ pass ]            468
backup_charsets.backup_partitions 'myisam big5 big5_bin' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'innodb big5 big5_bin' [ pass ]            421
backup_charsets.backup_partitions 'innodb big5 big5_bin' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'falcon big5 big5_bin' [ pass ]            453
backup_charsets.backup_partitions 'falcon big5 big5_bin' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'myisam dec8 dec8_swedish_ci' [ pass ]            530
backup_charsets.backup_partitions 'myisam dec8 dec8_swedish_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'innodb dec8 dec8_swedish_ci' [ pass ]            484
backup_charsets.backup_partitions 'innodb dec8 dec8_swedish_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'falcon dec8 dec8_swedish_ci' [ pass ]            437
backup_charsets.backup_partitions 'falcon dec8 dec8_swedish_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'myisam dec8 dec8_bin' [ pass ]            452
backup_charsets.backup_partitions 'myisam dec8 dec8_bin' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'innodb dec8 dec8_bin' [ pass ]            421
backup_charsets.backup_partitions 'innodb dec8 dec8_bin' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'falcon dec8 dec8_bin' [ pass ]            436
backup_charsets.backup_partitions 'falcon dec8 dec8_bin' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'myisam cp850 cp850_general_ci' [ pass ]            452
backup_charsets.backup_partitions 'myisam cp850 cp850_general_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'innodb cp850 cp850_general_ci' [ pass ]            421
backup_charsets.backup_partitions 'innodb cp850 cp850_general_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'falcon cp850 cp850_general_ci' [ pass ]            452
backup_charsets.backup_partitions 'falcon cp850 cp850_general_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'myisam cp850 cp850_bin' [ pass ]            421
backup_charsets.backup_partitions 'myisam cp850 cp850_bin' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'innodb cp850 cp850_bin' [ pass ]           2777
backup_charsets.backup_partitions 'innodb cp850 cp850_bin' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'falcon cp850 cp850_bin' [ pass ]            437
backup_charsets.backup_partitions 'falcon cp850 cp850_bin' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'myisam hp8 hp8_english_ci' [ pass ]            436
backup_charsets.backup_partitions 'myisam hp8 hp8_english_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'innodb hp8 hp8_english_ci' [ pass ]            422
backup_charsets.backup_partitions 'innodb hp8 hp8_english_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'falcon hp8 hp8_english_ci' [ pass ]            531
backup_charsets.backup_partitions 'falcon hp8 hp8_english_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'myisam hp8 hp8_bin' [ pass ]            437
backup_charsets.backup_partitions 'myisam hp8 hp8_bin' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'innodb hp8 hp8_bin' [ pass ]           2293
backup_charsets.backup_partitions 'innodb hp8 hp8_bin' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'falcon hp8 hp8_bin' [ pass ]            452
backup_charsets.backup_partitions 'falcon hp8 hp8_bin' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'myisam koi8r koi8r_general_ci' [ pass ]            468
backup_charsets.backup_partitions 'myisam koi8r koi8r_general_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'innodb koi8r koi8r_general_ci' [ pass ]            546
backup_charsets.backup_partitions 'innodb koi8r koi8r_general_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'falcon koi8r koi8r_general_ci' [ pass ]           3183
backup_charsets.backup_partitions 'falcon koi8r koi8r_general_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'myisam koi8r koi8r_bin' [ pass ]          14586
backup_charsets.backup_partitions 'myisam koi8r koi8r_bin' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'innodb koi8r koi8r_bin' [ pass ]            452
backup_charsets.backup_partitions 'innodb koi8r koi8r_bin' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'falcon koi8r koi8r_bin' [ pass ]            421
backup_charsets.backup_partitions 'falcon koi8r koi8r_bin' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'myisam latin1 latin1_german1_ci' [ pass ]           
421
backup_charsets.backup_partitions 'myisam latin1 latin1_german1_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'innodb latin1 latin1_german1_ci' [ pass ]           
452
backup_charsets.backup_partitions 'innodb latin1 latin1_german1_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'falcon latin1 latin1_german1_ci' [ pass ]           
421
backup_charsets.backup_partitions 'falcon latin1 latin1_german1_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'myisam latin1 latin1_swedish_ci' [ pass ]           
437
backup_charsets.backup_partitions 'myisam latin1 latin1_swedish_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'innodb latin1 latin1_swedish_ci' [ pass ]           
452
backup_charsets.backup_partitions 'innodb latin1 latin1_swedish_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'falcon latin1 latin1_swedish_ci' [ pass ]           
483
backup_charsets.backup_partitions 'falcon latin1 latin1_swedish_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'myisam latin1 latin1_danish_ci' [ pass ]            421
backup_charsets.backup_partitions 'myisam latin1 latin1_danish_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'innodb latin1 latin1_danish_ci' [ pass ]            421
backup_charsets.backup_partitions 'innodb latin1 latin1_danish_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'falcon latin1 latin1_danish_ci' [ pass ]            436
backup_charsets.backup_partitions 'falcon latin1 latin1_danish_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'myisam latin1 latin1_german2_ci' [ pass ]           
499
backup_charsets.backup_partitions 'myisam latin1 latin1_german2_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'innodb latin1 latin1_german2_ci' [ pass ]           
422
backup_charsets.backup_partitions 'innodb latin1 latin1_german2_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'falcon latin1 latin1_german2_ci' [ pass ]           
452
backup_charsets.backup_partitions 'falcon latin1 latin1_german2_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'myisam latin1 latin1_bin' [ pass ]            421
backup_charsets.backup_partitions 'myisam latin1 latin1_bin' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'innodb latin1 latin1_bin' [ pass ]           2948
backup_charsets.backup_partitions 'innodb latin1 latin1_bin' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'falcon latin1 latin1_bin' [ pass ]            452
backup_charsets.backup_partitions 'falcon latin1 latin1_bin' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'myisam latin1 latin1_general_ci' [ pass ]           
421
backup_charsets.backup_partitions 'myisam latin1 latin1_general_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'innodb latin1 latin1_general_ci' [ pass ]           
484
backup_charsets.backup_partitions 'innodb latin1 latin1_general_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'falcon latin1 latin1_general_ci' [ pass ]           
437
backup_charsets.backup_partitions 'falcon latin1 latin1_general_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'myisam latin1 latin1_general_cs' [ pass ]           
437
backup_charsets.backup_partitions 'myisam latin1 latin1_general_cs' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'innodb latin1 latin1_general_cs' [ pass ]           
453
backup_charsets.backup_partitions 'innodb latin1 latin1_general_cs' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'falcon latin1 latin1_general_cs' [ pass ]           
515
backup_charsets.backup_partitions 'falcon latin1 latin1_general_cs' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'myisam latin1 latin1_spanish_ci' [ pass ]           
437
backup_charsets.backup_partitions 'myisam latin1 latin1_spanish_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'innodb latin1 latin1_spanish_ci' [ pass ]           
422
backup_charsets.backup_partitions 'innodb latin1 latin1_spanish_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'falcon latin1 latin1_spanish_ci' [ pass ]           
421
backup_charsets.backup_partitions 'falcon latin1 latin1_spanish_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'myisam latin2 latin2_czech_cs' [ skipped ]   "This test
does'nt support latin2_czech_cs collation BUG#37854" 
backup_charsets.backup_partitions 'myisam latin2 latin2_czech_cs' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'innodb latin2 latin2_czech_cs' [ skipped ]   "This test
does'nt support latin2_czech_cs collation BUG#37854" 
backup_charsets.backup_partitions 'innodb latin2 latin2_czech_cs' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'falcon latin2 latin2_czech_cs' [ skipped ]   "This test
does'nt support latin2_czech_cs collation BUG#37854" 
backup_charsets.backup_partitions 'falcon latin2 latin2_czech_cs' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'myisam latin2 latin2_general_ci' [ pass ]           
452
backup_charsets.backup_partitions 'myisam latin2 latin2_general_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'innodb latin2 latin2_general_ci' [ pass ]           
437
backup_charsets.backup_partitions 'innodb latin2 latin2_general_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'falcon latin2 latin2_general_ci' [ pass ]           
422
backup_charsets.backup_partitions 'falcon latin2 latin2_general_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'myisam latin2 latin2_hungarian_ci' [ pass ]           
561
backup_charsets.backup_partitions 'myisam latin2 latin2_hungarian_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'innodb latin2 latin2_hungarian_ci' [ pass ]           
452
backup_charsets.backup_partitions 'innodb latin2 latin2_hungarian_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'falcon latin2 latin2_hungarian_ci' [ pass ]           
421
backup_charsets.backup_partitions 'falcon latin2 latin2_hungarian_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'myisam latin2 latin2_croatian_ci' [ pass ]           
452
backup_charsets.backup_partitions 'myisam latin2 latin2_croatian_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'innodb latin2 latin2_croatian_ci' [ pass ]           
437
backup_charsets.backup_partitions 'innodb latin2 latin2_croatian_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'falcon latin2 latin2_croatian_ci' [ pass ]           
437
backup_charsets.backup_partitions 'falcon latin2 latin2_croatian_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'myisam latin2 latin2_bin' [ pass ]            421
backup_charsets.backup_partitions 'myisam latin2 latin2_bin' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'innodb latin2 latin2_bin' [ pass ]            436
backup_charsets.backup_partitions 'innodb latin2 latin2_bin' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'falcon latin2 latin2_bin' [ pass ]            437
backup_charsets.backup_partitions 'falcon latin2 latin2_bin' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'myisam ascii ascii_general_ci' [ pass ]            421
backup_charsets.backup_partitions 'myisam ascii ascii_general_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'innodb ascii ascii_general_ci' [ pass ]            452
backup_charsets.backup_partitions 'innodb ascii ascii_general_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'falcon ascii ascii_general_ci' [ pass ]            421
backup_charsets.backup_partitions 'falcon ascii ascii_general_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'myisam ascii ascii_bin' [ pass ]            437
backup_charsets.backup_partitions 'myisam ascii ascii_bin' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'innodb ascii ascii_bin' [ pass ]            437
backup_charsets.backup_partitions 'innodb ascii ascii_bin' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'falcon ascii ascii_bin' [ pass ]            437
backup_charsets.backup_partitions 'falcon ascii ascii_bin' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'myisam ujis ujis_japanese_ci' [ pass ]            437
backup_charsets.backup_partitions 'myisam ujis ujis_japanese_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'innodb ujis ujis_japanese_ci' [ pass ]            468
backup_charsets.backup_partitions 'innodb ujis ujis_japanese_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'falcon ujis ujis_japanese_ci' [ pass ]            421
backup_charsets.backup_partitions 'falcon ujis ujis_japanese_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'myisam ujis ujis_bin' [ pass ]            437
backup_charsets.backup_partitions 'myisam ujis ujis_bin' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'innodb ujis ujis_bin' [ pass ]            437
backup_charsets.backup_partitions 'innodb ujis ujis_bin' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'falcon ujis ujis_bin' [ pass ]            453
backup_charsets.backup_partitions 'falcon ujis ujis_bin' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'myisam sjis sjis_japanese_ci' [ pass ]            437
backup_charsets.backup_partitions 'myisam sjis sjis_japanese_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'innodb sjis sjis_japanese_ci' [ pass ]            452
backup_charsets.backup_partitions 'innodb sjis sjis_japanese_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'falcon sjis sjis_japanese_ci' [ pass ]            453
backup_charsets.backup_partitions 'falcon sjis sjis_japanese_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'myisam sjis sjis_bin' [ pass ]            436
backup_charsets.backup_partitions 'myisam sjis sjis_bin' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'innodb sjis sjis_bin' [ pass ]            437
backup_charsets.backup_partitions 'innodb sjis sjis_bin' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'falcon sjis sjis_bin' [ pass ]           3214
backup_charsets.backup_partitions 'falcon sjis sjis_bin' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'myisam hebrew hebrew_general_ci' [ pass ]           
406
backup_charsets.backup_partitions 'myisam hebrew hebrew_general_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'innodb hebrew hebrew_general_ci' [ pass ]           
437
backup_charsets.backup_partitions 'innodb hebrew hebrew_general_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'falcon hebrew hebrew_general_ci' [ pass ]           
422
backup_charsets.backup_partitions 'falcon hebrew hebrew_general_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'myisam hebrew hebrew_bin' [ pass ]            437
backup_charsets.backup_partitions 'myisam hebrew hebrew_bin' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'innodb hebrew hebrew_bin' [ pass ]            468
backup_charsets.backup_partitions 'innodb hebrew hebrew_bin' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'falcon hebrew hebrew_bin' [ pass ]            453
backup_charsets.backup_partitions 'falcon hebrew hebrew_bin' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'myisam tis620 tis620_thai_ci' [ pass ]            436
backup_charsets.backup_partitions 'myisam tis620 tis620_thai_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'innodb tis620 tis620_thai_ci' [ pass ]            452
backup_charsets.backup_partitions 'innodb tis620 tis620_thai_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'falcon tis620 tis620_thai_ci' [ pass ]            437
backup_charsets.backup_partitions 'falcon tis620 tis620_thai_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'myisam tis620 tis620_bin' [ pass ]            452
backup_charsets.backup_partitions 'myisam tis620 tis620_bin' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'innodb tis620 tis620_bin' [ pass ]            452
backup_charsets.backup_partitions 'innodb tis620 tis620_bin' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'falcon tis620 tis620_bin' [ pass ]            452
backup_charsets.backup_partitions 'falcon tis620 tis620_bin' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'myisam euckr euckr_korean_ci' [ pass ]            421
backup_charsets.backup_partitions 'myisam euckr euckr_korean_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'innodb euckr euckr_korean_ci' [ pass ]            468
backup_charsets.backup_partitions 'innodb euckr euckr_korean_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'falcon euckr euckr_korean_ci' [ pass ]            453
backup_charsets.backup_partitions 'falcon euckr euckr_korean_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'myisam euckr euckr_bin' [ pass ]            421
backup_charsets.backup_partitions 'myisam euckr euckr_bin' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'innodb euckr euckr_bin' [ pass ]            484
backup_charsets.backup_partitions 'innodb euckr euckr_bin' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'falcon euckr euckr_bin' [ pass ]            453
backup_charsets.backup_partitions 'falcon euckr euckr_bin' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'myisam koi8u koi8u_general_ci' [ pass ]            468
backup_charsets.backup_partitions 'myisam koi8u koi8u_general_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'innodb koi8u koi8u_general_ci' [ pass ]            468
backup_charsets.backup_partitions 'innodb koi8u koi8u_general_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'falcon koi8u koi8u_general_ci' [ pass ]            421
backup_charsets.backup_partitions 'falcon koi8u koi8u_general_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'myisam koi8u koi8u_bin' [ pass ]            452
backup_charsets.backup_partitions 'myisam koi8u koi8u_bin' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'innodb koi8u koi8u_bin' [ pass ]            468
backup_charsets.backup_partitions 'innodb koi8u koi8u_bin' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'falcon koi8u koi8u_bin' [ pass ]            421
backup_charsets.backup_partitions 'falcon koi8u koi8u_bin' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'myisam gb2312 gb2312_chinese_ci' [ pass ]           
437
backup_charsets.backup_partitions 'myisam gb2312 gb2312_chinese_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'innodb gb2312 gb2312_chinese_ci' [ pass ]           
437
backup_charsets.backup_partitions 'innodb gb2312 gb2312_chinese_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'falcon gb2312 gb2312_chinese_ci' [ pass ]           
436
backup_charsets.backup_partitions 'falcon gb2312 gb2312_chinese_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'myisam gb2312 gb2312_bin' [ pass ]            468
backup_charsets.backup_partitions 'myisam gb2312 gb2312_bin' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'innodb gb2312 gb2312_bin' [ pass ]            437
backup_charsets.backup_partitions 'innodb gb2312 gb2312_bin' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'falcon gb2312 gb2312_bin' [ pass ]            468
backup_charsets.backup_partitions 'falcon gb2312 gb2312_bin' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'myisam greek greek_general_ci' [ pass ]            499
backup_charsets.backup_partitions 'myisam greek greek_general_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'innodb greek greek_general_ci' [ pass ]            468
backup_charsets.backup_partitions 'innodb greek greek_general_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'falcon greek greek_general_ci' [ pass ]            468
backup_charsets.backup_partitions 'falcon greek greek_general_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'myisam greek greek_bin' [ pass ]            452
backup_charsets.backup_partitions 'myisam greek greek_bin' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'innodb greek greek_bin' [ pass ]            437
backup_charsets.backup_partitions 'innodb greek greek_bin' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'falcon greek greek_bin' [ pass ]            437
backup_charsets.backup_partitions 'falcon greek greek_bin' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'myisam cp1250 cp1250_general_ci' [ pass ]          
3198
backup_charsets.backup_partitions 'myisam cp1250 cp1250_general_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'innodb cp1250 cp1250_general_ci' [ pass ]          
2777
backup_charsets.backup_partitions 'innodb cp1250 cp1250_general_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'falcon cp1250 cp1250_general_ci' [ pass ]           
578
backup_charsets.backup_partitions 'falcon cp1250 cp1250_general_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'myisam cp1250 cp1250_czech_cs' [ pass ]            483
backup_charsets.backup_partitions 'myisam cp1250 cp1250_czech_cs' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'innodb cp1250 cp1250_czech_cs' [ pass ]            437
backup_charsets.backup_partitions 'innodb cp1250 cp1250_czech_cs' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'falcon cp1250 cp1250_czech_cs' [ pass ]            437
backup_charsets.backup_partitions 'falcon cp1250 cp1250_czech_cs' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

backup_charsets.backup_datatypes 'myisam cp1250 cp1250_croatian_ci' [ pass ]           
436
backup_charsets.backup_partitions 'myisam cp1250 cp1250_croatian_ci' [ fail ]

mysqltest: At line 179: query 'ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN
(10,20,30))' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
EXPLAIN PARTITIONS SELECT * FROM `range`;;
id	#
select_type	SIMPLE
table	range
partitions	P0,P1,P2,P3,P4
type	ALL
possible_keys	NULL
key	NULL
key_len	NULL
ref	NULL
rows	#
Extra	
ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));

More results from queries before failure can be found in
d:\source\bzr\mysql-6.0-wl-4227\mysql-test\var\log\backup_partitions.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

Stopping All Servers

Thread
bzr commit into mysql-6.0-backup branch (hema:2650) WL#4227Hema Sridharan8 Jul
  • Re: bzr commit into mysql-6.0-backup branch (hema:2650) WL#4227Rafal Somla17 Jul
    • RE: bzr commit into mysql-6.0-backup branch (hema:2650) WL#4227Hema Sridharan17 Jul
      • Re: bzr commit into mysql-6.0-backup branch (hema:2650) WL#4227Rafal Somla21 Jul
        • RE: bzr commit into mysql-6.0-backup branch (hema:2650) WL#4227Hema Sridharan26 Jul
  • RE: bzr commit into mysql-6.0-backup branch (hema:2650) WL#4227Chuck Bell21 Jul