Merge lp:~tsarev/percona-server/5.5_bug_838725_fix into lp:percona-server/5.5

[Oleg Tsarev]

1) move tests from mysql-test/ to patches
2) remove install_tests script and call of script from Makefile

[Oleg Tsarev (tsarev)]

I checked by
bzr update -r 158 && make all && mv Percona-Server-*-* 158
bzr update -r 159 && make all && mv Percona-Server-*-* 159
diff -ruN 158 159

[Laurynas Biveinis (laurynas-biveinis)]

LGTM

review: Approve

=== modified file 'Makefile'
--- Makefile	2011-08-22 17:26:45 +0000
+++ Makefile	2011-09-03 15:21:28 +0000
@@ -22,7 +22,7 @@
 REVS = $(shell bzr log | grep rev | head -1   )
 REV  = $(word 2, $(REVS) )
 
-all: main handlersocket maatkit-udf install-lic tests misc
+all: main handlersocket maatkit-udf install-lic misc
 	@echo ""
 	@echo "Percona Server source code is ready"
 	@echo "Now change directory to $(PERCONA_SERVER) define variables as show below"
@@ -92,9 +92,6 @@
 	@echo "Downloading MySQL sources from $(MASTER_SITE)"
 	$(FETCH_CMD) $(MASTER_SITE)/mysql-$(MYSQL_VERSION).tar.gz
 
-tests:
-	PERCONA_SERVER=${PERCONA_SERVER} sh install_tests
-
 misc:
 	@echo "Installing other files"
 	install -m 644 lrusort.py $(PERCONA_SERVER)/scripts
 
=== removed file 'install_tests'
--- install_tests	2011-07-27 11:13:05 +0000
+++ install_tests	1970-01-01 00:00:00 +0000
@@ -1,37 +0,0 @@
-#!/bin/sh
-
-set -u
-
-MYSQL_VERSION="$(grep ^MYSQL_VERSION= "Makefile" \
-    | cut -d = -f 2)"
-PERCONA_SERVER_VERSION="$(grep ^PERCONA_SERVER_VERSION= "Makefile" \
-    | cut -d = -f 2)"
-PERCONA_SERVER="Percona-Server-${MYSQL_VERSION}-${PERCONA_SERVER_VERSION}"
-
-install_file_type()
-{
-    for file in `ls $1/*.$2 2>/dev/null`; do
-	test -f $file && install -m 644 $file ${PERCONA_SERVER}/mysql-test/$3
-    done;
-}
-do_install_path()
-{
-    install_file_type $1 test t
-    install_file_type $1 opt t
-    install_file_type $1 result r
-    install_file_type $1 require r
-    install_file_type $1 inc include
-}
-install_path()
-{
-    echo "[$3/$4] Installing mysql-test files: $2"
-    test -d $1 && do_install_path $1 $2
-}
-current=0;
-count=`wc -l patches/series`;
-install_path mysql-test "global" $current $count
-for test_name in `cat patches/series`; do
-    current=$((current+1));
-    install_path mysql-test/$test_name $test_name $current $count
-done
-echo "Done"
 
=== removed directory 'mysql-test'
=== removed file 'mysql-test/have_response_time_distribution.inc'
--- mysql-test/have_response_time_distribution.inc	2011-01-17 01:49:51 +0000
+++ mysql-test/have_response_time_distribution.inc	1970-01-01 00:00:00 +0000
@@ -1,4 +0,0 @@
--- require r/have_response_time_distribution.require
-disable_query_log;
-show variables like 'have_response_time_distribution';
-enable_query_log;
 
=== removed file 'mysql-test/have_response_time_distribution.require'
--- mysql-test/have_response_time_distribution.require	2011-01-17 01:49:51 +0000
+++ mysql-test/have_response_time_distribution.require	1970-01-01 00:00:00 +0000
@@ -1,2 +0,0 @@
-Variable_name	Value
-have_response_time_distribution	YES
 
=== removed directory 'mysql-test/innodb_deadlock_count.patch'
=== removed file 'mysql-test/innodb_deadlock_count.patch/percona_innodb_deadlock_count.result'
--- mysql-test/innodb_deadlock_count.patch/percona_innodb_deadlock_count.result	2011-06-22 10:13:43 +0000
+++ mysql-test/innodb_deadlock_count.patch/percona_innodb_deadlock_count.result	1970-01-01 00:00:00 +0000
@@ -1,28 +0,0 @@
-# Establish connection con1 (user=root)
-# Establish connection con2 (user=root)
-# Establish connection con3 (user=root)
-# Drop test table
-drop table if exists t;
-# Create test table
-create table t(a INT PRIMARY KEY, b INT) engine=InnoDB;
-# Insert two rows to test table
-insert into t values(2,1);
-insert into t values(1,2);
-# Switch to connection con1
-BEGIN;
-SELECT b FROM t WHERE a=1 FOR UPDATE;
-# Switch to connection con2
-BEGIN;
-SELECT b FROM t WHERE a=2 FOR UPDATE;
-# Switch to connection con1
-SELECT b FROM t WHERE a=2 FOR UPDATE;
-# Switch to connection con2
-SELECT b FROM t WHERE a=1 FOR UPDATE;
-# Switch to connection con1
-ROLLBACK;
-# Switch to connection con2
-ROLLBACK;
-# Switch to connection con3
-Deadlocks: 1
-# Drop test table
-drop table t;
 
=== removed file 'mysql-test/innodb_deadlock_count.patch/percona_innodb_deadlock_count.test'
--- mysql-test/innodb_deadlock_count.patch/percona_innodb_deadlock_count.test	2011-06-22 10:13:43 +0000
+++ mysql-test/innodb_deadlock_count.patch/percona_innodb_deadlock_count.test	1970-01-01 00:00:00 +0000
@@ -1,61 +0,0 @@
---source include/have_innodb.inc
---echo # Establish connection con1 (user=root)
-connect (con1,localhost,root,,);
---echo # Establish connection con2 (user=root)
-connect (con2,localhost,root,,);
---echo # Establish connection con3 (user=root)
-connect (con3,localhost,root,,);
---echo # Drop test table
---disable_warnings
-drop table if exists t;
---enable_warnings
-
---echo # Create test table
-create table t(a INT PRIMARY KEY, b INT) engine=InnoDB;
---echo # Insert two rows to test table
-insert into t values(2,1);
-insert into t values(1,2);
-
-#--echo # Save current deadlock count
-let $current = `SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'Innodb_deadlocks'`;
-
---disable_result_log
-
---echo # Switch to connection con1
-connection con1;
-BEGIN; SELECT b FROM t WHERE a=1 FOR UPDATE;
-
---echo # Switch to connection con2
-connection con2;
-BEGIN; SELECT b FROM t WHERE a=2 FOR UPDATE;
-
---echo # Switch to connection con1
-connection con1;
-SEND SELECT b FROM t WHERE a=2 FOR UPDATE;
-
---echo # Switch to connection con2
-connection con2;
-SEND SELECT b FROM t WHERE a=1 FOR UPDATE;
-
---echo # Switch to connection con1
-connection con1;
---error 0, ER_LOCK_DEADLOCK
-reap;
-ROLLBACK;
-
---echo # Switch to connection con2
-connection con2;
---error 0, ER_LOCK_DEADLOCK
-reap;
-ROLLBACK;
-
---echo # Switch to connection con3
-connection con3;
-let $result = `SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'Innodb_deadlocks'`;
-
---enable_result_log
-
-let $diff = `SELECT $result - $current`;
-echo Deadlocks: $diff;
---echo # Drop test table
-drop table t;
 
=== removed directory 'mysql-test/log_connection_error.patch'
=== removed file 'mysql-test/log_connection_error.patch/percona_log_connection_error-master.opt'
--- mysql-test/log_connection_error.patch/percona_log_connection_error-master.opt	2010-12-09 18:30:58 +0000
+++ mysql-test/log_connection_error.patch/percona_log_connection_error-master.opt	1970-01-01 00:00:00 +0000
@@ -1,1 +0,0 @@
---log-error
 
=== removed file 'mysql-test/log_connection_error.patch/percona_log_connection_error.result'
--- mysql-test/log_connection_error.patch/percona_log_connection_error.result	2010-12-09 18:30:58 +0000
+++ mysql-test/log_connection_error.patch/percona_log_connection_error.result	1970-01-01 00:00:00 +0000
@@ -1,15 +0,0 @@
-SET @old_max_connections = @@max_connections;
-SET @old_log_warnings = @@log_warnings;
-SET GLOBAL max_connections=2;
-SET GLOBAL LOG_WARNINGS = 0;
-connect(localhost,root,,test,port,socket);
-ERROR HY000: Too many connections
-SET GLOBAL LOG_WARNINGS = 1;
-connect(localhost,root,,test,port,socket);
-ERROR HY000: Too many connections
-SET GLOBAL LOG_WARNINGS = 0;
-connect(localhost,root,,test,port,socket);
-ERROR HY000: Too many connections
-SET GLOBAL max_connections = @old_max_connections;
-SET GLOBAL log_warnings = @old_log_warnings;
-1
 
=== removed file 'mysql-test/log_connection_error.patch/percona_log_connection_error.test'
--- mysql-test/log_connection_error.patch/percona_log_connection_error.test	2011-04-09 15:41:52 +0000
+++ mysql-test/log_connection_error.patch/percona_log_connection_error.test	1970-01-01 00:00:00 +0000
@@ -1,54 +0,0 @@
---source include/not_embedded.inc
-
-connect (main,localhost,root,,);
-connection main;
-SET @old_max_connections = @@max_connections;
-SET @old_log_warnings = @@log_warnings;
-SET GLOBAL max_connections=2;
-let $port=`SELECT Variable_value FROM INFORMATION_SCHEMA.SESSION_VARIABLES WHERE Variable_name LIKE 'port'`;
-let $socket=`SELECT Variable_value FROM INFORMATION_SCHEMA.SESSION_VARIABLES WHERE Variable_name LIKE 'socket'`;
-
-SET GLOBAL LOG_WARNINGS = 0;
---connect (conn0,localhost,root,,)
-connection conn0;
-replace_result $port port $socket socket;
---error 1040
---connect(conn1,localhost,root,,)
-disconnect conn0;
-SLEEP 0.1; # tsarev: hack, but i don't know (and didn't find) how right
-
-connection main;
-SET GLOBAL LOG_WARNINGS = 1;
---connect (conn1,localhost,root,,)
-replace_result $port port $socket socket;
---error 1040
---connect (conn0,localhost,root,,)
-disconnect conn1;
-SLEEP 0.1; # tsarev: hack, but i don't know (and didn't find) how right
-
-connection main;
-SET GLOBAL LOG_WARNINGS = 0;
---connect (conn0,localhost,root,,)
-replace_result $port port $socket socket;
---error 1040
---connect(conn1,localhost,root,,)
-disconnect conn0;
-SLEEP 0.1; # tsarev: hack, but i don't know (and didn't find) how right
-
-connection main;
-SET GLOBAL max_connections = @old_max_connections;
-SET GLOBAL log_warnings = @old_log_warnings;
-let $log_error_= `SELECT @@GLOBAL.log_error`;
-if(!`select LENGTH('$log_error_')`)
-{
-  # MySQL Server on windows is started with --console and thus
-  # does not know the location of its .err log, use default location
-  let $log_error_ = $MYSQLTEST_VARDIR/log/mysqld.1.err;
-}
-# Assign env variable LOG_ERROR
-let LOG_ERROR=$log_error_;
-
---let grep_file = $log_error
---let grep_pattern = Too many connections
---source include/grep.inc
-exec $cmd;
 
=== removed directory 'mysql-test/log_warnings_suppress.patch'
=== removed file 'mysql-test/log_warnings_suppress.patch/percona_log_warnings_suppress-master.opt'
--- mysql-test/log_warnings_suppress.patch/percona_log_warnings_suppress-master.opt	2011-02-21 13:56:22 +0000
+++ mysql-test/log_warnings_suppress.patch/percona_log_warnings_suppress-master.opt	1970-01-01 00:00:00 +0000
@@ -1,1 +0,0 @@
---log-error
 
=== removed file 'mysql-test/log_warnings_suppress.patch/percona_log_warnings_suppress.result'
--- mysql-test/log_warnings_suppress.patch/percona_log_warnings_suppress.result	2011-02-21 13:56:22 +0000
+++ mysql-test/log_warnings_suppress.patch/percona_log_warnings_suppress.result	1970-01-01 00:00:00 +0000
@@ -1,31 +0,0 @@
-SET @old_log_warnings = @@log_warnings;
-SET @old_log_warnings_suppress = @@log_warnings_suppress;
-DROP TABLE IF EXISTS t1;
-CREATE TABLE t1 (a VARCHAR(36), b VARCHAR(20));
-SET GLOBAL log_warnings_suppress='';
-SET GLOBAL LOG_WARNINGS=0;
-SHOW GLOBAL VARIABLES LIKE 'log_warnings_suppress';
-Variable_name	Value
-log_warnings_suppress	
-INSERT INTO t1 VALUES(UUID(), 'suppress_1592');
-Warnings:
-Note	1592	Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the slave.
-SET GLOBAL LOG_WARNINGS=1;
-INSERT INTO t1 VALUES(UUID(), 'suppress_1592');
-Warnings:
-Note	1592	Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the slave.
-SET GLOBAL log_warnings_suppress='1592';
-SET GLOBAL LOG_WARNINGS=0;
-INSERT INTO t1 VALUES(UUID(), 'suppress_1592');
-Warnings:
-Note	1592	Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the slave.
-SET GLOBAL LOG_WARNINGS=1;
-INSERT INTO t1 VALUES(UUID(), 'suppress_1592');
-Warnings:
-Note	1592	Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the slave.
-DROP TABLE t1;
-SET GLOBAL log_warnings = @old_log_warnings;
-SET GLOBAL log_warnings_suppress = @old_log_warnings_suppress;
-# Count the number of times the "Unsafe" message was printed
-# to the error log.
-Occurrences: 1
 
=== removed file 'mysql-test/log_warnings_suppress.patch/percona_log_warnings_suppress.test'
--- mysql-test/log_warnings_suppress.patch/percona_log_warnings_suppress.test	2011-02-21 13:56:22 +0000
+++ mysql-test/log_warnings_suppress.patch/percona_log_warnings_suppress.test	1970-01-01 00:00:00 +0000
@@ -1,47 +0,0 @@
--- source include/have_log_bin.inc
--- source include/have_binlog_format_statement.inc
-
-SET @old_log_warnings = @@log_warnings;
-SET @old_log_warnings_suppress = @@log_warnings_suppress;
-
---disable_warnings
-DROP TABLE IF EXISTS t1;
---enable_warnings
-CREATE TABLE t1 (a VARCHAR(36), b VARCHAR(20));
-SET GLOBAL log_warnings_suppress='';
-SET GLOBAL LOG_WARNINGS=0;
-SHOW GLOBAL VARIABLES LIKE 'log_warnings_suppress';
-INSERT INTO t1 VALUES(UUID(), 'suppress_1592');
-SET GLOBAL LOG_WARNINGS=1;
-INSERT INTO t1 VALUES(UUID(), 'suppress_1592');
-SET GLOBAL log_warnings_suppress='1592';
-SET GLOBAL LOG_WARNINGS=0;
-INSERT INTO t1 VALUES(UUID(), 'suppress_1592');
-SET GLOBAL LOG_WARNINGS=1;
-INSERT INTO t1 VALUES(UUID(), 'suppress_1592');
-DROP TABLE t1;
-
-SET GLOBAL log_warnings = @old_log_warnings;
-SET GLOBAL log_warnings_suppress = @old_log_warnings_suppress;
-
-let $log_error_= `SELECT @@GLOBAL.log_error`;
-if(!`select LENGTH('$log_error_')`)
-{
-  # MySQL Server on windows is started with --console and thus
-  # does not know the location of its .err log, use default location
-  let $log_error_ = $MYSQLTEST_VARDIR/log/mysqld.1.err;
-}
-# Assign env variable LOG_ERROR
-let LOG_ERROR=$log_error_;
-
---echo # Count the number of times the "Unsafe" message was printed
---echo # to the error log.
-
-perl;
-  use strict;
-  my $log_error= $ENV{'LOG_ERROR'} or die "LOG_ERROR not set";
-  open(FILE, "$log_error") or die("Unable to open $log_error: $!\n");
-  my $count = () = grep(/suppress_1592/g,<FILE>);
-  print "Occurrences: $count\n";
-  close(FILE);
-EOF
 
=== removed directory 'mysql-test/memory_dynamic_rows.patch'
=== removed file 'mysql-test/memory_dynamic_rows.patch/percona_heap_blob.result'
--- mysql-test/memory_dynamic_rows.patch/percona_heap_blob.result	2011-06-06 10:34:16 +0000
+++ mysql-test/memory_dynamic_rows.patch/percona_heap_blob.result	1970-01-01 00:00:00 +0000
@@ -1,952 +0,0 @@
-SET @old_default_storage_engine=@@default_storage_engine;
-SET default_storage_engine=MEMORY;
-drop table if exists t1,t2,t3,t4,t5,t6,t7;
-CREATE TABLE t1 (a blob, b text, c blob(250), d text(70000), e text(70000000));
-show columns from t1;
-Field	Type	Null	Key	Default	Extra
-a	blob	YES		NULL	
-b	text	YES		NULL	
-c	tinyblob	YES		NULL	
-d	mediumtext	YES		NULL	
-e	longtext	YES		NULL	
-CREATE TABLE t2 (a char(255), b varbinary(70000), c varchar(70000000));
-Warnings:
-Note	1246	Converting column 'b' from VARBINARY to BLOB
-Note	1246	Converting column 'c' from VARCHAR to TEXT
-CREATE TABLE t4 (c varchar(65530) character set utf8 not null);
-Warnings:
-Note	1246	Converting column 'c' from VARCHAR to TEXT
-show columns from t2;
-Field	Type	Null	Key	Default	Extra
-a	char(255)	YES		NULL	
-b	mediumblob	YES		NULL	
-c	longtext	YES		NULL	
-create table t3 (a long, b long byte);
-show create TABLE t3;
-Table	Create Table
-t3	CREATE TABLE `t3` (
-  `a` mediumtext,
-  `b` mediumblob
-) ENGINE=MEMORY DEFAULT CHARSET=latin1
-show create TABLE t4;
-Table	Create Table
-t4	CREATE TABLE `t4` (
-  `c` mediumtext CHARACTER SET utf8 NOT NULL
-) ENGINE=MEMORY DEFAULT CHARSET=latin1
-drop table t1,t2,t3,t4;
-CREATE TABLE t1 (a char(257) default "hello");
-ERROR 42000: Column length too big for column 'a' (max = 255); use BLOB or TEXT instead
-CREATE TABLE t2 (a char(256));
-ERROR 42000: Column length too big for column 'a' (max = 255); use BLOB or TEXT instead
-CREATE TABLE t1 (a varchar(70000) default "hello");
-ERROR 42000: Column length too big for column 'a' (max = 65535); use BLOB or TEXT instead
-CREATE TABLE t2 (a blob default "hello");
-ERROR 42000: BLOB/TEXT column 'a' can't have a default value
-drop table if exists t1,t2;
-create table t1 (nr int(5) not null auto_increment,b blob,str char(10), primary key (nr));
-insert into t1 values (null,"a","A");
-insert into t1 values (null,"bbb","BBB");
-insert into t1 values (null,"ccc","CCC");
-select last_insert_id();
-last_insert_id()
-3
-select * from t1,t1 as t2;
-nr	b	str	nr	b	str
-1	a	A	1	a	A
-2	bbb	BBB	1	a	A
-3	ccc	CCC	1	a	A
-1	a	A	2	bbb	BBB
-2	bbb	BBB	2	bbb	BBB
-3	ccc	CCC	2	bbb	BBB
-1	a	A	3	ccc	CCC
-2	bbb	BBB	3	ccc	CCC
-3	ccc	CCC	3	ccc	CCC
-drop table t1;
-create table t1 (a text);
-insert into t1 values ('where');
-update t1 set a='Where';
-select * from t1;
-a
-Where
-drop table t1;
-create table t1 (t text,c char(10),b blob, d varbinary(10));
-insert into t1 values (NULL,NULL,NULL,NULL);
-insert into t1 values ("","","","");
-insert into t1 values ("hello","hello","hello","hello");
-insert into t1 values ("HELLO","HELLO","HELLO","HELLO");
-insert into t1 values ("HELLO MY","HELLO MY","HELLO MY","HELLO MY");
-insert into t1 values ("a","a","a","a");
-insert into t1 values (1,1,1,1);
-insert into t1 values (NULL,NULL,NULL,NULL);
-update t1 set c="",b=null where c="1";
-lock tables t1 READ;
-show full fields from t1;
-Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
-t	text	latin1_swedish_ci	YES		NULL		#	
-c	char(10)	latin1_swedish_ci	YES		NULL		#	
-b	blob	NULL	YES		NULL		#	
-d	varbinary(10)	NULL	YES		NULL		#	
-lock tables t1 WRITE;
-show full fields from t1;
-Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
-t	text	latin1_swedish_ci	YES		NULL		#	
-c	char(10)	latin1_swedish_ci	YES		NULL		#	
-b	blob	NULL	YES		NULL		#	
-d	varbinary(10)	NULL	YES		NULL		#	
-unlock tables;
-select t from t1 where t like "hello";
-t
-hello
-HELLO
-select c from t1 where c like "hello";
-c
-hello
-HELLO
-select b from t1 where b like "hello";
-b
-hello
-select d from t1 where d like "hello";
-d
-hello
-select c from t1 having c like "hello";
-c
-hello
-HELLO
-select d from t1 having d like "hello";
-d
-hello
-select t from t1 where t like "%HELLO%";
-t
-hello
-HELLO
-HELLO MY
-select c from t1 where c like "%HELLO%";
-c
-hello
-HELLO
-HELLO MY
-select b from t1 where b like "%HELLO%";
-b
-HELLO
-HELLO MY
-select d from t1 where d like "%HELLO%";
-d
-HELLO
-HELLO MY
-select c from t1 having c like "%HELLO%";
-c
-hello
-HELLO
-HELLO MY
-select d from t1 having d like "%HELLO%";
-d
-HELLO
-HELLO MY
-select d from t1 having d like "%HE%LLO%";
-d
-HELLO
-HELLO MY
-select t from t1 order by t;
-t
-NULL
-NULL
-
-1
-a
-hello
-HELLO
-HELLO MY
-select c from t1 order by c;
-c
-NULL
-NULL
-
-
-a
-hello
-HELLO
-HELLO MY
-select b from t1 order by b;
-b
-NULL
-NULL
-NULL
-
-HELLO
-HELLO MY
-a
-hello
-select d from t1 order by d;
-d
-NULL
-NULL
-
-1
-HELLO
-HELLO MY
-a
-hello
-select distinct t from t1;
-t
-NULL
-
-hello
-HELLO MY
-a
-1
-select distinct b from t1;
-b
-NULL
-
-hello
-HELLO
-HELLO MY
-a
-select distinct t from t1 order by t;
-t
-NULL
-
-1
-a
-hello
-HELLO MY
-select distinct b from t1 order by b;
-b
-NULL
-
-HELLO
-HELLO MY
-a
-hello
-select t from t1 group by t;
-t
-NULL
-
-1
-a
-hello
-HELLO MY
-select b from t1 group by b;
-b
-NULL
-
-HELLO
-HELLO MY
-a
-hello
-set option sql_big_tables=1;
-select distinct t from t1;
-t
-NULL
-
-hello
-HELLO MY
-a
-1
-select distinct b from t1;
-b
-NULL
-
-hello
-HELLO
-HELLO MY
-a
-select distinct t from t1 order by t;
-t
-NULL
-
-1
-a
-hello
-HELLO MY
-select distinct b from t1 order by b;
-b
-NULL
-
-HELLO
-HELLO MY
-a
-hello
-select distinct c from t1;
-c
-NULL
-
-hello
-HELLO MY
-a
-select distinct d from t1;
-d
-NULL
-
-hello
-HELLO
-HELLO MY
-a
-1
-select distinct c from t1 order by c;
-c
-NULL
-
-a
-hello
-HELLO MY
-select distinct d from t1 order by d;
-d
-NULL
-
-1
-HELLO
-HELLO MY
-a
-hello
-select c from t1 group by c;
-c
-NULL
-
-a
-hello
-HELLO MY
-select d from t1 group by d;
-d
-NULL
-
-1
-HELLO
-HELLO MY
-a
-hello
-set option sql_big_tables=0;
-select distinct * from t1;
-t	c	b	d
-NULL	NULL	NULL	NULL
-			
-hello	hello	hello	hello
-HELLO	HELLO	HELLO	HELLO
-HELLO MY	HELLO MY	HELLO MY	HELLO MY
-a	a	a	a
-1		NULL	1
-select t,count(*) from t1 group by t;
-t	count(*)
-NULL	2
-	1
-1	1
-a	1
-hello	2
-HELLO MY	1
-select b,count(*) from t1 group by b;
-b	count(*)
-NULL	3
-	1
-HELLO	1
-HELLO MY	1
-a	1
-hello	1
-select c,count(*) from t1 group by c;
-c	count(*)
-NULL	2
-	2
-a	1
-hello	2
-HELLO MY	1
-select d,count(*) from t1 group by d;
-d	count(*)
-NULL	2
-	1
-1	1
-HELLO	1
-HELLO MY	1
-a	1
-hello	1
-drop table t1;
-CREATE TABLE t1 (
-t1_id bigint(21) NOT NULL auto_increment,
-_field_72 varchar(128) DEFAULT '' NOT NULL,
-_field_95 varchar(32),
-_field_115 tinyint(4) DEFAULT '0' NOT NULL,
-_field_122 tinyint(4) DEFAULT '0' NOT NULL,
-_field_126 tinyint(4),
-_field_134 tinyint(4),
-PRIMARY KEY (t1_id),
-UNIQUE _field_72 (_field_72),
-KEY _field_115 (_field_115),
-KEY _field_122 (_field_122)
-);
-INSERT INTO t1 VALUES (1,'admin','21232f297a57a5a743894a0e4a801fc3',0,1,NULL,NULL);
-INSERT INTO t1 VALUES (2,'hroberts','7415275a8c95952901e42b13a6b78566',0,1,NULL,NULL);
-INSERT INTO t1 VALUES (3,'guest','d41d8cd98f00b204e9800998ecf8427e',1,0,NULL,NULL);
-CREATE TABLE t2 (
-seq_0_id bigint(21) DEFAULT '0' NOT NULL,
-seq_1_id bigint(21) DEFAULT '0' NOT NULL,
-PRIMARY KEY (seq_0_id,seq_1_id)
-);
-INSERT INTO t2 VALUES (1,1);
-INSERT INTO t2 VALUES (2,1);
-INSERT INTO t2 VALUES (2,2);
-CREATE TABLE t3 (
-t3_id bigint(21) NOT NULL auto_increment,
-_field_131 varchar(128),
-_field_133 tinyint(4) DEFAULT '0' NOT NULL,
-_field_135 datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
-_field_137 tinyint(4),
-_field_139 datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
-_field_140 blob,
-_field_142 tinyint(4) DEFAULT '0' NOT NULL,
-_field_145 tinyint(4) DEFAULT '0' NOT NULL,
-_field_148 tinyint(4) DEFAULT '0' NOT NULL,
-PRIMARY KEY (t3_id),
-KEY _field_133 (_field_133),
-KEY _field_135 (_field_135),
-KEY _field_139 (_field_139),
-KEY _field_142 (_field_142),
-KEY _field_145 (_field_145),
-KEY _field_148 (_field_148)
-);
-INSERT INTO t3 VALUES (1,'test job 1',0,'0000-00-00 00:00:00',0,'1999-02-25 22:43:32','test\r\njob\r\n1',0,0,0);
-INSERT INTO t3 VALUES (2,'test job 2',0,'0000-00-00 00:00:00',0,'1999-02-26 21:08:04','',0,0,0);
-CREATE TABLE t4 (
-seq_0_id bigint(21) DEFAULT '0' NOT NULL,
-seq_1_id bigint(21) DEFAULT '0' NOT NULL,
-PRIMARY KEY (seq_0_id,seq_1_id)
-);
-INSERT INTO t4 VALUES (1,1);
-INSERT INTO t4 VALUES (2,1);
-CREATE TABLE t5 (
-t5_id bigint(21) NOT NULL auto_increment,
-_field_149 tinyint(4),
-_field_156 varchar(128) DEFAULT '' NOT NULL,
-_field_157 varchar(128) DEFAULT '' NOT NULL,
-_field_158 varchar(128) DEFAULT '' NOT NULL,
-_field_159 varchar(128) DEFAULT '' NOT NULL,
-_field_160 varchar(128) DEFAULT '' NOT NULL,
-_field_161 varchar(128) DEFAULT '' NOT NULL,
-PRIMARY KEY (t5_id),
-KEY _field_156 (_field_156),
-KEY _field_157 (_field_157),
-KEY _field_158 (_field_158),
-KEY _field_159 (_field_159),
-KEY _field_160 (_field_160),
-KEY _field_161 (_field_161)
-);
-INSERT INTO t5 VALUES (1,0,'tomato','','','','','');
-INSERT INTO t5 VALUES (2,0,'cilantro','','','','','');
-CREATE TABLE t6 (
-seq_0_id bigint(21) DEFAULT '0' NOT NULL,
-seq_1_id bigint(21) DEFAULT '0' NOT NULL,
-PRIMARY KEY (seq_0_id,seq_1_id)
-);
-INSERT INTO t6 VALUES (1,1);
-INSERT INTO t6 VALUES (1,2);
-INSERT INTO t6 VALUES (2,2);
-CREATE TABLE t7 (
-t7_id bigint(21) NOT NULL auto_increment,
-_field_143 tinyint(4),
-_field_165 varchar(32),
-_field_166 smallint(6) DEFAULT '0' NOT NULL,
-PRIMARY KEY (t7_id),
-KEY _field_166 (_field_166)
-);
-INSERT INTO t7 VALUES (1,0,'High',1);
-INSERT INTO t7 VALUES (2,0,'Medium',2);
-INSERT INTO t7 VALUES (3,0,'Low',3);
-select replace(t3._field_140, "\r","^M"),t3_id,min(t3._field_131), min(t3._field_135), min(t3._field_139), min(t3._field_137), min(link_alias_142._field_165), min(link_alias_133._field_72), min(t3._field_145), min(link_alias_148._field_156), replace(min(t3._field_140), "\r","^M"),t3.t3_id from t3 left join t4 on t4.seq_0_id = t3.t3_id left join t7 link_alias_142 on t4.seq_1_id = link_alias_142.t7_id left join t6 on t6.seq_0_id = t3.t3_id left join t1 link_alias_133 on t6.seq_1_id = link_alias_133.t1_id left join t2 on t2.seq_0_id = t3.t3_id left join t5 link_alias_148 on t2.seq_1_id = link_alias_148.t5_id where t3.t3_id in (1) group by t3.t3_id order by link_alias_142._field_166, _field_139, link_alias_133._field_72, _field_135, link_alias_148._field_156;
-replace(t3._field_140, "\r","^M")	t3_id	min(t3._field_131)	min(t3._field_135)	min(t3._field_139)	min(t3._field_137)	min(link_alias_142._field_165)	min(link_alias_133._field_72)	min(t3._field_145)	min(link_alias_148._field_156)	replace(min(t3._field_140), "\r","^M")	t3_id
-test^M
-job^M
-1	1	test job 1	0000-00-00 00:00:00	1999-02-25 22:43:32	0	High	admin	0	tomato	test^M
-job^M
-1	1
-drop table t1,t2,t3,t4,t5,t6,t7;
-create table t1 (a blob);
-insert into t1 values ("empty"),("");
-select a,reverse(a) from t1;
-a	reverse(a)
-empty	ytpme
-	
-drop table t1;
-create table t1 (id integer auto_increment unique,imagem LONGBLOB not null default '');
-Warnings:
-Warning	1101	BLOB/TEXT column 'imagem' can't have a default value
-insert into t1 (id) values (1);
-select
-charset(load_file('../../std_data/words.dat')),
-collation(load_file('../../std_data/words.dat')),
-coercibility(load_file('../../std_data/words.dat'));
-charset(load_file('../../std_data/words.dat'))	collation(load_file('../../std_data/words.dat'))	coercibility(load_file('../../std_data/words.dat'))
-binary	binary	4
-explain extended select
-charset(load_file('MYSQLTEST_VARDIR/std_data/words.dat')),
-collation(load_file('MYSQLTEST_VARDIR/std_data/words.dat')),
-coercibility(load_file('MYSQLTEST_VARDIR/std_data/words.dat'));
-id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
-1	SIMPLE	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	No tables used
-Warnings:
-Note	1003	select charset(load_file('MYSQLTEST_VARDIR/std_data/words.dat')) AS `charset(load_file('MYSQLTEST_VARDIR/std_data/words.dat'))`,collation(load_file('MYSQLTEST_VARDIR/std_data/words.dat')) AS `collation(load_file('MYSQLTEST_VARDIR/std_data/words.dat'))`,coercibility(load_file('MYSQLTEST_VARDIR/std_data/words.dat')) AS `coercibility(load_file('MYSQLTEST_VARDIR/std_data/words.dat'))`
-update t1 set imagem=load_file('MYSQLTEST_VARDIR/std_data/words.dat') where id=1;
-select if(imagem is null, "ERROR", "OK"),length(imagem) from t1 where id = 1;
-if(imagem is null, "ERROR", "OK")	length(imagem)
-OK	581
-drop table t1;
-create table t1 select load_file('MYSQLTEST_VARDIR/std_data/words.dat') l;
-show full fields from t1;
-Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
-l	longblob	NULL	YES		NULL		#	
-drop table t1;
-create table t1 (id integer primary key auto_increment, txt text not null);
-insert into t1 (txt) values ('Chevy ');
-select * from t1 where txt='Chevy';
-id	txt
-1	Chevy 
-select * from t1 where txt='Chevy ';
-id	txt
-1	Chevy 
-select * from t1 where txt='Chevy ' or txt='Chevy';
-id	txt
-1	Chevy 
-select * from t1 where txt='Chevy' or txt='Chevy ';
-id	txt
-1	Chevy 
-select * from t1 where id='1' or id='2';
-id	txt
-1	Chevy 
-insert into t1 (txt) values('Ford');
-select * from t1 where txt='Chevy' or txt='Chevy ' or txt='Ford';
-id	txt
-1	Chevy 
-2	Ford
-select * from t1 where txt='Chevy' or txt='Chevy ';
-id	txt
-1	Chevy 
-select * from t1 where txt='Chevy' or txt='Chevy ' or txt=' Chevy';
-id	txt
-1	Chevy 
-select * from t1 where txt in ('Chevy ','Chevy');
-id	txt
-1	Chevy 
-select * from t1 where txt in ('Chevy');
-id	txt
-1	Chevy 
-select * from t1 where txt between 'Chevy' and 'Chevy';
-id	txt
-1	Chevy 
-select * from t1 where txt between 'Chevy' and 'Chevy' or txt='Chevy ';
-id	txt
-1	Chevy 
-select * from t1 where txt between 'Chevy' and 'Chevy ';
-id	txt
-1	Chevy 
-select * from t1 where txt < 'Chevy ';
-id	txt
-select * from t1 where txt <= 'Chevy';
-id	txt
-1	Chevy 
-select * from t1 where txt > 'Chevy';
-id	txt
-2	Ford
-select * from t1 where txt >= 'Chevy';
-id	txt
-1	Chevy 
-2	Ford
-drop table t1;
-create table t1 (id integer primary key auto_increment, txt text);
-insert into t1 (txt) values ('Chevy'), ('Chevy '), (NULL);
-select * from t1 where txt='Chevy' or txt is NULL;
-id	txt
-1	Chevy
-2	Chevy 
-3	NULL
-explain select * from t1 where txt='Chevy' or txt is NULL;
-id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
-1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	3	Using where
-select * from t1 where txt='Chevy ';
-id	txt
-1	Chevy
-2	Chevy 
-select * from t1 where txt='Chevy ' or txt='Chevy';
-id	txt
-1	Chevy
-2	Chevy 
-select * from t1 where txt='Chevy' or txt='Chevy ';
-id	txt
-1	Chevy
-2	Chevy 
-select * from t1 where id='1' or id='2';
-id	txt
-1	Chevy
-2	Chevy 
-insert into t1 (txt) values('Ford');
-select * from t1 where txt='Chevy' or txt='Chevy ' or txt='Ford';
-id	txt
-1	Chevy
-2	Chevy 
-4	Ford
-select * from t1 where txt='Chevy' or txt='Chevy ';
-id	txt
-1	Chevy
-2	Chevy 
-select * from t1 where txt='Chevy' or txt='Chevy ' or txt=' Chevy';
-id	txt
-1	Chevy
-2	Chevy 
-select * from t1 where txt in ('Chevy ','Chevy');
-id	txt
-1	Chevy
-2	Chevy 
-select * from t1 where txt in ('Chevy');
-id	txt
-1	Chevy
-2	Chevy 
-select * from t1 where txt between 'Chevy' and 'Chevy';
-id	txt
-1	Chevy
-2	Chevy 
-select * from t1 where txt between 'Chevy' and 'Chevy' or txt='Chevy ';
-id	txt
-1	Chevy
-2	Chevy 
-select * from t1 where txt between 'Chevy' and 'Chevy ';
-id	txt
-1	Chevy
-2	Chevy 
-select * from t1 where txt < 'Chevy ';
-id	txt
-select * from t1 where txt < 'Chevy ' or txt is NULL;
-id	txt
-3	NULL
-select * from t1 where txt <= 'Chevy';
-id	txt
-1	Chevy
-2	Chevy 
-select * from t1 where txt > 'Chevy';
-id	txt
-4	Ford
-select * from t1 where txt >= 'Chevy';
-id	txt
-1	Chevy
-2	Chevy 
-4	Ford
-alter table t1 modify column txt blob;
-explain select * from t1 where txt='Chevy' or txt is NULL;
-id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
-1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	4	Using where
-select * from t1 where txt='Chevy' or txt is NULL;
-id	txt
-1	Chevy
-3	NULL
-explain select * from t1 where txt='Chevy' or txt is NULL order by txt;
-id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
-1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	4	Using where; Using filesort
-select * from t1 where txt='Chevy' or txt is NULL order by txt;
-id	txt
-3	NULL
-1	Chevy
-drop table t1;
-CREATE TABLE t1 ( i int(11) NOT NULL default '0',    c text NOT NULL, d varchar(1) NOT NULL DEFAULT ' ', PRIMARY KEY  (i));
-INSERT t1 (i, c) VALUES (1,''),(2,''),(3,'asdfh'),(4,'');
-select max(i) from t1 where c = '';
-max(i)
-4
-drop table t1;
-CREATE table t1 (a blob);
-insert into t1 values ('b'),('a\0'),('a'),('a '),('aa'),(NULL);
-select hex(a) from t1 order by a;
-hex(a)
-NULL
-61
-6100
-6120
-6161
-62
-select hex(concat(a,'\0')) as b from t1 order by concat(a,'\0');
-b
-NULL
-6100
-610000
-612000
-616100
-6200
-alter table t1 modify a varbinary(5);
-select hex(a) from t1 order by a;
-hex(a)
-NULL
-61
-6100
-6120
-6161
-62
-select hex(concat(a,'\0')) as b from t1 order by concat(a,'\0');
-b
-NULL
-6100
-610000
-612000
-616100
-6200
-alter table t1 modify a char(5);
-select hex(a) from t1 order by a;
-hex(a)
-NULL
-6100
-61
-61
-6161
-62
-select hex(concat(a,'\0')) as b from t1 order by concat(a,'\0');
-b
-NULL
-610000
-6100
-6100
-616100
-6200
-alter table t1 modify a binary(5);
-select hex(a) from t1 order by a;
-hex(a)
-NULL
-6100000000
-6100000000
-6100000000
-6161000000
-6200000000
-select hex(concat(a,'\0')) as b from t1 order by concat(a,'\0');
-b
-NULL
-610000000000
-610000000000
-610000000000
-616100000000
-620000000000
-drop table t1;
-create table t1 (a text default '');
-Warnings:
-Warning	1101	BLOB/TEXT column 'a' can't have a default value
-show create table t1;
-Table	Create Table
-t1	CREATE TABLE `t1` (
-  `a` text
-) ENGINE=MEMORY DEFAULT CHARSET=latin1
-insert into t1 values (default);
-select * from t1;
-a
-NULL
-drop table t1;
-set @@sql_mode='TRADITIONAL';
-create table t1 (a text default '');
-ERROR 42000: BLOB/TEXT column 'a' can't have a default value
-set @@sql_mode='';
-CREATE TABLE t (c TEXT CHARSET ASCII);
-INSERT INTO t (c) VALUES (REPEAT('1',65537));
-Warnings:
-Warning	1265	Data truncated for column 'c' at row 1
-INSERT INTO t (c) VALUES (REPEAT('2',65536));
-Warnings:
-Warning	1265	Data truncated for column 'c' at row 1
-INSERT INTO t (c) VALUES (REPEAT('3',65535));
-SELECT LENGTH(c), CHAR_LENGTH(c) FROM t;
-LENGTH(c)	CHAR_LENGTH(c)
-65535	65535
-65535	65535
-65535	65535
-DROP TABLE t;
-drop table if exists b15776;
-create table b15776 (data blob(2147483647));
-drop table b15776;
-create table b15776 (data blob(-1));
-ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-1))' at line 1
-create table b15776 (data blob(2147483648));
-drop table b15776;
-create table b15776 (data blob(4294967294));
-drop table b15776;
-create table b15776 (data blob(4294967295));
-drop table b15776;
-create table b15776 (data blob(4294967296));
-ERROR 42000: Display width out of range for column 'data' (max = 4294967295)
-CREATE TABLE b15776 (a blob(2147483647), b blob(2147483648), c blob(4294967295), a1 text(2147483647), b1 text(2147483648), c1 text(4294967295) );
-show columns from b15776;
-Field	Type	Null	Key	Default	Extra
-a	longblob	YES		NULL	
-b	longblob	YES		NULL	
-c	longblob	YES		NULL	
-a1	longtext	YES		NULL	
-b1	longtext	YES		NULL	
-c1	longtext	YES		NULL	
-drop table b15776;
-CREATE TABLE b15776 (a blob(4294967296));
-ERROR 42000: Display width out of range for column 'a' (max = 4294967295)
-CREATE TABLE b15776 (a text(4294967296));
-ERROR 42000: Display width out of range for column 'a' (max = 4294967295)
-CREATE TABLE b15776 (a blob(999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999));
-ERROR 42000: Display width out of range for column 'a' (max = 4294967295)
-CREATE TABLE b15776 (a text(999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999));
-ERROR 42000: Display width out of range for column 'a' (max = 4294967295)
-CREATE TABLE b15776 (a int(0));
-INSERT INTO b15776 values (NULL), (1), (42), (654);
-SELECT * from b15776 ORDER BY a;
-a
-NULL
-1
-42
-654
-DROP TABLE b15776;
-CREATE TABLE b15776 (a int(-1));
-ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-1))' at line 1
-CREATE TABLE b15776 (a int(255));
-DROP TABLE b15776;
-CREATE TABLE b15776 (a int(256));
-ERROR 42000: Display width out of range for column 'a' (max = 255)
-CREATE TABLE b15776 (data blob(-1));
-ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-1))' at line 1
-CREATE TABLE b15776 (a char(2147483647));
-ERROR 42000: Column length too big for column 'a' (max = 255); use BLOB or TEXT instead
-CREATE TABLE b15776 (a char(2147483648));
-ERROR 42000: Column length too big for column 'a' (max = 255); use BLOB or TEXT instead
-CREATE TABLE b15776 (a char(4294967295));
-ERROR 42000: Column length too big for column 'a' (max = 255); use BLOB or TEXT instead
-CREATE TABLE b15776 (a char(4294967296));
-ERROR 42000: Display width out of range for column 'a' (max = 4294967295)
-CREATE TABLE b15776 (a year(4294967295));
-INSERT INTO b15776 VALUES (42);
-SELECT * FROM b15776;
-a
-2042
-DROP TABLE b15776;
-CREATE TABLE b15776 (a year(4294967296));
-ERROR 42000: Display width out of range for column 'a' (max = 4294967295)
-CREATE TABLE b15776 (a year(0));
-DROP TABLE b15776;
-CREATE TABLE b15776 (a year(-2));
-ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-2))' at line 1
-CREATE TABLE b15776 (a int(999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999));
-ERROR 42000: Display width out of range for column 'a' (max = 4294967295)
-CREATE TABLE b15776 (a char(999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999));
-ERROR 42000: Display width out of range for column 'a' (max = 4294967295)
-CREATE TABLE b15776 (a year(999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999));
-ERROR 42000: Display width out of range for column 'a' (max = 4294967295)
-CREATE TABLE b15776 select cast(null as char(4294967295));
-show columns from b15776;
-Field	Type	Null	Key	Default	Extra
-cast(null as char(4294967295))	char(0)	YES		NULL	
-drop table b15776;
-CREATE TABLE b15776 select cast(null as nchar(4294967295));
-show columns from b15776;
-Field	Type	Null	Key	Default	Extra
-cast(null as nchar(4294967295))	char(0)	YES		NULL	
-drop table b15776;
-CREATE TABLE b15776 select cast(null as binary(4294967295));
-show columns from b15776;
-Field	Type	Null	Key	Default	Extra
-cast(null as binary(4294967295))	binary(0)	YES		NULL	
-drop table b15776;
-explain select cast(1 as char(4294967295));
-id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
-1	SIMPLE	NULL	NULL	NULL	NULL	NULL	NULL	NULL	No tables used
-explain select cast(1 as nchar(4294967295));
-id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
-1	SIMPLE	NULL	NULL	NULL	NULL	NULL	NULL	NULL	No tables used
-explain select cast(1 as binary(4294967295));
-id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
-1	SIMPLE	NULL	NULL	NULL	NULL	NULL	NULL	NULL	No tables used
-explain select cast(1 as char(4294967296));
-ERROR 42000: Display width out of range for column 'cast as char' (max = 4294967295)
-explain select cast(1 as nchar(4294967296));
-ERROR 42000: Display width out of range for column 'cast as char' (max = 4294967295)
-explain select cast(1 as binary(4294967296));
-ERROR 42000: Display width out of range for column 'cast as char' (max = 4294967295)
-explain select cast(1 as decimal(-1));
-ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-1))' at line 1
-explain select cast(1 as decimal(64, 30));
-id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
-1	SIMPLE	NULL	NULL	NULL	NULL	NULL	NULL	NULL	No tables used
-explain select cast(1 as decimal(64, 999999999999999999999999999999));
-Got one of the listed errors
-explain select cast(1 as decimal(4294967296));
-Got one of the listed errors
-explain select cast(1 as decimal(999999999999999999999999999999999999));
-Got one of the listed errors
-explain select convert(1, char(4294967295));
-id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
-1	SIMPLE	NULL	NULL	NULL	NULL	NULL	NULL	NULL	No tables used
-explain select convert(1, char(4294967296));
-ERROR 42000: Display width out of range for column 'cast as char' (max = 4294967295)
-explain select convert(1, char(999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999));
-ERROR 42000: Display width out of range for column 'cast as char' (max = 4294967295)
-explain select convert(1, nchar(4294967295));
-id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
-1	SIMPLE	NULL	NULL	NULL	NULL	NULL	NULL	NULL	No tables used
-explain select convert(1, nchar(4294967296));
-ERROR 42000: Display width out of range for column 'cast as char' (max = 4294967295)
-explain select convert(1, nchar(999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999));
-ERROR 42000: Display width out of range for column 'cast as char' (max = 4294967295)
-explain select convert(1, binary(4294967295));
-id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
-1	SIMPLE	NULL	NULL	NULL	NULL	NULL	NULL	NULL	No tables used
-explain select convert(1, binary(4294967296));
-ERROR 42000: Display width out of range for column 'cast as char' (max = 4294967295)
-explain select convert(1, binary(999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999));
-ERROR 42000: Display width out of range for column 'cast as char' (max = 4294967295)
-End of 5.0 tests
-CREATE TABLE t1(id INT NOT NULL);
-CREATE TABLE t2(id INT NOT NULL, c TEXT NOT NULL);
-INSERT INTO t1 VALUES (1);
-INSERT INTO t2 VALUES (1, '');
-UPDATE t2 SET c = REPEAT('1', 70000);
-Warnings:
-Warning	1265	Data truncated for column 'c' at row 1
-SELECT LENGTH(c) FROM t2;
-LENGTH(c)
-65535
-UPDATE t1 LEFT JOIN t2 USING(id) SET t2.c = REPEAT('1', 70000) WHERE t1.id = 1;
-Warnings:
-Warning	1265	Data truncated for column 'c' at row 1
-SELECT LENGTH(c) FROM t2;
-LENGTH(c)
-65535
-DROP TABLE t1, t2;
-# Bug #52160: crash and inconsistent results when grouping
-#             by a function and column
-CREATE FUNCTION f1() RETURNS TINYBLOB RETURN 1;
-CREATE TABLE t1(a CHAR(1));
-INSERT INTO t1 VALUES ('0'), ('0');
-SELECT COUNT(*) FROM t1 GROUP BY f1(), a;
-COUNT(*)
-2
-DROP FUNCTION f1;
-DROP TABLE t1;
-SET default_storage_engine=@old_default_storage_engine;
-SET @old_max_heap_table_size = @@global.max_heap_table_size;
-SET @old_max_allowed_packet = @@global.max_allowed_packet;
-SET GLOBAL max_heap_table_size = 18 * 1024 * 1024;
-SET GLOBAL max_allowed_packet = 24 * 1024 * 1024;
-drop table if exists t1;
-CREATE TABLE t1 (data LONGBLOB) ENGINE=memory;
-INSERT INTO t1 (data) VALUES (NULL);
-UPDATE t1 set data=repeat('a',18*1024*1024);
-select length(data) from t1;
-length(data)
-18874368
-delete from t1 where left(data,1)='a';
-truncate table t1;
-INSERT INTO t1 (data) VALUES (repeat('a',1*1024*1024));
-INSERT INTO t1 (data) VALUES (repeat('b',16*1024*1024-1024));
-delete from t1 where left(data,1)='b';
-UPDATE t1 set data=repeat('c',17*1024*1024);
-delete from t1 where left(data,1)='c';
-INSERT INTO t1 set data=repeat('a',18*1024*1024);
-select length(data) from t1;
-length(data)
-18874368
-alter table t1 modify data blob;
-select length(data) from t1;
-length(data)
-0
-drop table t1;
-CREATE TABLE t1 (data BLOB) ENGINE=myisam;
-INSERT INTO t1 (data) VALUES (NULL);
-UPDATE t1 set data=repeat('a',18*1024*1024);
-Warnings:
-Warning	1265	Data truncated for column 'data' at row 1
-select length(data) from t1;
-length(data)
-65535
-drop table t1;
-SET GLOBAL max_allowed_packet = @old_max_allowed_packet;
-SET GLOBAL max_heap_table_size = @old_max_heap_table_size;
 
=== removed file 'mysql-test/memory_dynamic_rows.patch/percona_heap_blob.test'
--- mysql-test/memory_dynamic_rows.patch/percona_heap_blob.test	2011-08-22 11:28:27 +0000
+++ mysql-test/memory_dynamic_rows.patch/percona_heap_blob.test	1970-01-01 00:00:00 +0000
@@ -1,642 +0,0 @@
-########################################################################
-# Test blobs with the HEAP/MEMORY storage engine
-########################################################################
-
-########################################################################
-# Modified tests from type_blob.test
-########################################################################
-
-SET @old_default_storage_engine=@@default_storage_engine;
-SET default_storage_engine=MEMORY;
-
-#
-# Basic cleanup
-#
---disable_warnings
-drop table if exists t1,t2,t3,t4,t5,t6,t7;
---enable_warnings
-
-
-#
-# Check syntax for creating BLOB/TEXT
-#
-
-CREATE TABLE t1 (a blob, b text, c blob(250), d text(70000), e text(70000000));
-show columns from t1;
-# PS doesn't give errors on prepare yet
-CREATE TABLE t2 (a char(255), b varbinary(70000), c varchar(70000000));
-CREATE TABLE t4 (c varchar(65530) character set utf8 not null);
-show columns from t2;
-create table t3 (a long, b long byte);
-show create TABLE t3;
-show create TABLE t4;
-drop table t1,t2,t3,t4;
-
-#
-# Check errors with blob
-#
-
---error 1074
-CREATE TABLE t1 (a char(257) default "hello");
---error 1074
-CREATE TABLE t2 (a char(256));
---error 1074
-CREATE TABLE t1 (a varchar(70000) default "hello");
---error 1101
-CREATE TABLE t2 (a blob default "hello");
-
-# Safety to be able to continue with other tests if above fails
---disable_warnings
-drop table if exists t1,t2;
---enable_warnings
-
-#
-# test of full join with blob
-#
-
-create table t1 (nr int(5) not null auto_increment,b blob,str char(10), primary key (nr));
-insert into t1 values (null,"a","A");
-insert into t1 values (null,"bbb","BBB");
-insert into t1 values (null,"ccc","CCC");
-select last_insert_id();
-select * from t1,t1 as t2;
-
-drop table t1;
-
-#
-# Test of changing TEXT column
-#
-
-create table t1 (a text);
-insert into t1 values ('where');
-update t1 set a='Where'; 
-select * from t1;
-drop table t1;
-
-#
-# test of blob, text, char and varbinary
-#
-create table t1 (t text,c char(10),b blob, d varbinary(10));
-insert into t1 values (NULL,NULL,NULL,NULL);
-insert into t1 values ("","","","");
-insert into t1 values ("hello","hello","hello","hello");
-insert into t1 values ("HELLO","HELLO","HELLO","HELLO");
-insert into t1 values ("HELLO MY","HELLO MY","HELLO MY","HELLO MY");
-insert into t1 values ("a","a","a","a");
-insert into t1 values (1,1,1,1);
-insert into t1 values (NULL,NULL,NULL,NULL);
-update t1 set c="",b=null where c="1";
-
-lock tables t1 READ;
-# We mask out the Privileges column because it differs for embedded server
---replace_column 8 #
-show full fields from t1;
-lock tables t1 WRITE;
---replace_column 8 #
-show full fields from t1;
-unlock tables;
-
-select t from t1 where t like "hello";
-select c from t1 where c like "hello";
-select b from t1 where b like "hello";
-select d from t1 where d like "hello";
-select c from t1 having c like "hello";
-select d from t1 having d like "hello";
-select t from t1 where t like "%HELLO%";
-select c from t1 where c like "%HELLO%";
-select b from t1 where b like "%HELLO%";
-select d from t1 where d like "%HELLO%";
-select c from t1 having c like "%HELLO%";
-select d from t1 having d like "%HELLO%";
-select d from t1 having d like "%HE%LLO%";
-select t from t1 order by t;
-select c from t1 order by c;
-select b from t1 order by b;
-select d from t1 order by d;
-select distinct t from t1;
-select distinct b from t1;
-select distinct t from t1 order by t;
-select distinct b from t1 order by b;
-select t from t1 group by t;
-select b from t1 group by b;
-set option sql_big_tables=1;
-select distinct t from t1;
-select distinct b from t1;
-select distinct t from t1 order by t;
-select distinct b from t1 order by b;
-select distinct c from t1;
-select distinct d from t1;
-select distinct c from t1 order by c;
-select distinct d from t1 order by d;
-select c from t1 group by c;
-select d from t1 group by d;
-set option sql_big_tables=0;
-select distinct * from t1;
-select t,count(*) from t1 group by t;
-select b,count(*) from t1 group by b;
-select c,count(*) from t1 group by c;
-select d,count(*) from t1 group by d;
-drop table t1;
-
-
-#
-# Test of join with blobs and min
-#
-
-CREATE TABLE t1 (
-  t1_id bigint(21) NOT NULL auto_increment,
-  _field_72 varchar(128) DEFAULT '' NOT NULL,
-  _field_95 varchar(32),
-  _field_115 tinyint(4) DEFAULT '0' NOT NULL,
-  _field_122 tinyint(4) DEFAULT '0' NOT NULL,
-  _field_126 tinyint(4),
-  _field_134 tinyint(4),
-  PRIMARY KEY (t1_id),
-  UNIQUE _field_72 (_field_72),
-  KEY _field_115 (_field_115),
-  KEY _field_122 (_field_122)
-);
-
-
-INSERT INTO t1 VALUES (1,'admin','21232f297a57a5a743894a0e4a801fc3',0,1,NULL,NULL);
-INSERT INTO t1 VALUES (2,'hroberts','7415275a8c95952901e42b13a6b78566',0,1,NULL,NULL);
-INSERT INTO t1 VALUES (3,'guest','d41d8cd98f00b204e9800998ecf8427e',1,0,NULL,NULL);
-
-
-CREATE TABLE t2 (
-  seq_0_id bigint(21) DEFAULT '0' NOT NULL,
-  seq_1_id bigint(21) DEFAULT '0' NOT NULL,
-  PRIMARY KEY (seq_0_id,seq_1_id)
-);
-
-
-INSERT INTO t2 VALUES (1,1);
-INSERT INTO t2 VALUES (2,1);
-INSERT INTO t2 VALUES (2,2);
-
-CREATE TABLE t3 (
-  t3_id bigint(21) NOT NULL auto_increment,
-  _field_131 varchar(128),
-  _field_133 tinyint(4) DEFAULT '0' NOT NULL,
-  _field_135 datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
-  _field_137 tinyint(4),
-  _field_139 datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
-  _field_140 blob,
-  _field_142 tinyint(4) DEFAULT '0' NOT NULL,
-  _field_145 tinyint(4) DEFAULT '0' NOT NULL,
-  _field_148 tinyint(4) DEFAULT '0' NOT NULL,
-  PRIMARY KEY (t3_id),
-  KEY _field_133 (_field_133),
-  KEY _field_135 (_field_135),
-  KEY _field_139 (_field_139),
-  KEY _field_142 (_field_142),
-  KEY _field_145 (_field_145),
-  KEY _field_148 (_field_148)
-);
-
-
-INSERT INTO t3 VALUES (1,'test job 1',0,'0000-00-00 00:00:00',0,'1999-02-25 22:43:32','test\r\njob\r\n1',0,0,0);
-INSERT INTO t3 VALUES (2,'test job 2',0,'0000-00-00 00:00:00',0,'1999-02-26 21:08:04','',0,0,0);
-
-
-CREATE TABLE t4 (
-  seq_0_id bigint(21) DEFAULT '0' NOT NULL,
-  seq_1_id bigint(21) DEFAULT '0' NOT NULL,
-  PRIMARY KEY (seq_0_id,seq_1_id)
-);
-
-
-INSERT INTO t4 VALUES (1,1);
-INSERT INTO t4 VALUES (2,1);
-
-CREATE TABLE t5 (
-  t5_id bigint(21) NOT NULL auto_increment,
-  _field_149 tinyint(4),
-  _field_156 varchar(128) DEFAULT '' NOT NULL,
-  _field_157 varchar(128) DEFAULT '' NOT NULL,
-  _field_158 varchar(128) DEFAULT '' NOT NULL,
-  _field_159 varchar(128) DEFAULT '' NOT NULL,
-  _field_160 varchar(128) DEFAULT '' NOT NULL,
-  _field_161 varchar(128) DEFAULT '' NOT NULL,
-  PRIMARY KEY (t5_id),
-  KEY _field_156 (_field_156),
-  KEY _field_157 (_field_157),
-  KEY _field_158 (_field_158),
-  KEY _field_159 (_field_159),
-  KEY _field_160 (_field_160),
-  KEY _field_161 (_field_161)
-);
-
-
-INSERT INTO t5 VALUES (1,0,'tomato','','','','','');
-INSERT INTO t5 VALUES (2,0,'cilantro','','','','','');
-
-CREATE TABLE t6 (
-  seq_0_id bigint(21) DEFAULT '0' NOT NULL,
-  seq_1_id bigint(21) DEFAULT '0' NOT NULL,
-  PRIMARY KEY (seq_0_id,seq_1_id)
-);
-
-INSERT INTO t6 VALUES (1,1);
-INSERT INTO t6 VALUES (1,2);
-INSERT INTO t6 VALUES (2,2);
-
-CREATE TABLE t7 (
-  t7_id bigint(21) NOT NULL auto_increment,
-  _field_143 tinyint(4),
-  _field_165 varchar(32),
-  _field_166 smallint(6) DEFAULT '0' NOT NULL,
-  PRIMARY KEY (t7_id),
-  KEY _field_166 (_field_166)
-);
-
-
-INSERT INTO t7 VALUES (1,0,'High',1);
-INSERT INTO t7 VALUES (2,0,'Medium',2);
-INSERT INTO t7 VALUES (3,0,'Low',3);
-
-select replace(t3._field_140, "\r","^M"),t3_id,min(t3._field_131), min(t3._field_135), min(t3._field_139), min(t3._field_137), min(link_alias_142._field_165), min(link_alias_133._field_72), min(t3._field_145), min(link_alias_148._field_156), replace(min(t3._field_140), "\r","^M"),t3.t3_id from t3 left join t4 on t4.seq_0_id = t3.t3_id left join t7 link_alias_142 on t4.seq_1_id = link_alias_142.t7_id left join t6 on t6.seq_0_id = t3.t3_id left join t1 link_alias_133 on t6.seq_1_id = link_alias_133.t1_id left join t2 on t2.seq_0_id = t3.t3_id left join t5 link_alias_148 on t2.seq_1_id = link_alias_148.t5_id where t3.t3_id in (1) group by t3.t3_id order by link_alias_142._field_166, _field_139, link_alias_133._field_72, _field_135, link_alias_148._field_156;
-
-drop table t1,t2,t3,t4,t5,t6,t7;
-
-#
-# Test of reverse with empty blob
-#
-
-create table t1 (a blob);
-insert into t1 values ("empty"),("");
-select a,reverse(a) from t1;
-drop table t1;
-
-#
-# Bug when blob is updated
-#
-
-create table t1 (id integer auto_increment unique,imagem LONGBLOB not null default '');
-insert into t1 (id) values (1);
-# We have to clean up the path in the results for safe comparison
-eval select
-  charset(load_file('../../std_data/words.dat')),
-  collation(load_file('../../std_data/words.dat')),
-  coercibility(load_file('../../std_data/words.dat'));
---replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
-eval explain extended select
-  charset(load_file('$MYSQLTEST_VARDIR/std_data/words.dat')),
-  collation(load_file('$MYSQLTEST_VARDIR/std_data/words.dat')),
-  coercibility(load_file('$MYSQLTEST_VARDIR/std_data/words.dat'));
---replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
-eval update t1 set imagem=load_file('$MYSQLTEST_VARDIR/std_data/words.dat') where id=1;
-select if(imagem is null, "ERROR", "OK"),length(imagem) from t1 where id = 1;
-drop table t1;
---replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
-eval create table t1 select load_file('$MYSQLTEST_VARDIR/std_data/words.dat') l;
-# We mask out the Privileges column because it differs for embedded server
---replace_column 8 #
-show full fields from t1;
-drop table t1;
-
-#
-# Test blob's with end space (Bug #1651)
-# This is a bit changed since we now have true varchar
-#
-
-create table t1 (id integer primary key auto_increment, txt text not null);
-insert into t1 (txt) values ('Chevy ');
-select * from t1 where txt='Chevy';
-select * from t1 where txt='Chevy ';
-select * from t1 where txt='Chevy ' or txt='Chevy';
-select * from t1 where txt='Chevy' or txt='Chevy ';
-select * from t1 where id='1' or id='2';
-insert into t1 (txt) values('Ford');
-select * from t1 where txt='Chevy' or txt='Chevy ' or txt='Ford';
-select * from t1 where txt='Chevy' or txt='Chevy ';
-select * from t1 where txt='Chevy' or txt='Chevy ' or txt=' Chevy';
-select * from t1 where txt in ('Chevy ','Chevy');
-select * from t1 where txt in ('Chevy');
-select * from t1 where txt between 'Chevy' and 'Chevy';
-select * from t1 where txt between 'Chevy' and 'Chevy' or txt='Chevy ';
-select * from t1 where txt between 'Chevy' and 'Chevy ';
-select * from t1 where txt < 'Chevy ';
-select * from t1 where txt <= 'Chevy';
-select * from t1 where txt > 'Chevy';
-select * from t1 where txt >= 'Chevy';
-drop table t1;
-
-create table t1 (id integer primary key auto_increment, txt text);
-insert into t1 (txt) values ('Chevy'), ('Chevy '), (NULL);
-select * from t1 where txt='Chevy' or txt is NULL;
-explain select * from t1 where txt='Chevy' or txt is NULL;
-select * from t1 where txt='Chevy ';
-select * from t1 where txt='Chevy ' or txt='Chevy';
-select * from t1 where txt='Chevy' or txt='Chevy ';
-select * from t1 where id='1' or id='2';
-insert into t1 (txt) values('Ford');
-select * from t1 where txt='Chevy' or txt='Chevy ' or txt='Ford';
-select * from t1 where txt='Chevy' or txt='Chevy ';
-select * from t1 where txt='Chevy' or txt='Chevy ' or txt=' Chevy';
-select * from t1 where txt in ('Chevy ','Chevy');
-select * from t1 where txt in ('Chevy');
-select * from t1 where txt between 'Chevy' and 'Chevy';
-select * from t1 where txt between 'Chevy' and 'Chevy' or txt='Chevy ';
-select * from t1 where txt between 'Chevy' and 'Chevy ';
-select * from t1 where txt < 'Chevy ';
-select * from t1 where txt < 'Chevy ' or txt is NULL;
-select * from t1 where txt <= 'Chevy';
-select * from t1 where txt > 'Chevy';
-select * from t1 where txt >= 'Chevy';
-alter table t1 modify column txt blob;
-explain select * from t1 where txt='Chevy' or txt is NULL;
-select * from t1 where txt='Chevy' or txt is NULL;
-explain select * from t1 where txt='Chevy' or txt is NULL order by txt;
-select * from t1 where txt='Chevy' or txt is NULL order by txt;
-drop table t1;
-
-CREATE TABLE t1 ( i int(11) NOT NULL default '0',    c text NOT NULL, d varchar(1) NOT NULL DEFAULT ' ', PRIMARY KEY  (i));
-INSERT t1 (i, c) VALUES (1,''),(2,''),(3,'asdfh'),(4,'');
-select max(i) from t1 where c = '';
-drop table t1;
-
-# End of 4.1 tests
-
-#
-# Test that blob's and varbinary are sorted according to length
-#
-
-CREATE table t1 (a blob);
-insert into t1 values ('b'),('a\0'),('a'),('a '),('aa'),(NULL);
-select hex(a) from t1 order by a;
-select hex(concat(a,'\0')) as b from t1 order by concat(a,'\0');
-alter table t1 modify a varbinary(5);
-select hex(a) from t1 order by a;
-select hex(concat(a,'\0')) as b from t1 order by concat(a,'\0');
-alter table t1 modify a char(5);
-select hex(a) from t1 order by a;
-select hex(concat(a,'\0')) as b from t1 order by concat(a,'\0');
-alter table t1 modify a binary(5);
-select hex(a) from t1 order by a;
-select hex(concat(a,'\0')) as b from t1 order by concat(a,'\0');
-drop table t1;
-
-#
-# Bug #19489: Inconsistent support for DEFAULT in TEXT columns
-#
-create table t1 (a text default '');
-show create table t1;
-insert into t1 values (default);
-select * from t1;
-drop table t1;
-set @@sql_mode='TRADITIONAL';
---error ER_BLOB_CANT_HAVE_DEFAULT
-create table t1 (a text default '');
-set @@sql_mode='';
-
-#
-# Bug #32282: TEXT silently truncates when value is exactly 65536 bytes
-#
-
-CREATE TABLE t (c TEXT CHARSET ASCII);
-INSERT INTO t (c) VALUES (REPEAT('1',65537));
-INSERT INTO t (c) VALUES (REPEAT('2',65536));
-INSERT INTO t (c) VALUES (REPEAT('3',65535));
-SELECT LENGTH(c), CHAR_LENGTH(c) FROM t;
-DROP TABLE t;
-# Bug#15776: 32-bit signed int used for length of blob
-# """LONGBLOB:  A BLOB column with a maximum length of 4,294,967,295 or 4GB."""
-#
-# Conditions should be in this order:
-# A size is not in the allowed bounds.
-# If the type is char-ish AND size is within the max blob size:
-#   raise ER_TOO_BIG_FIELDLENGTH  (suggest using BLOB)
-# If size is too small:
-#   raise ER_PARSE_ERROR
-# raise ER_TOO_BIG_DISPLAYWIDTH
-
-# BLOB and TEXT types
---disable_warnings
-drop table if exists b15776;
---enable_warnings
-create table b15776 (data blob(2147483647));
-drop table b15776;
---error ER_PARSE_ERROR
-create table b15776 (data blob(-1));
-create table b15776 (data blob(2147483648));
-drop table b15776;
-create table b15776 (data blob(4294967294));
-drop table b15776;
-create table b15776 (data blob(4294967295));
-drop table b15776;
---error ER_TOO_BIG_DISPLAYWIDTH
-create table b15776 (data blob(4294967296));
-
-CREATE TABLE b15776 (a blob(2147483647), b blob(2147483648), c blob(4294967295), a1 text(2147483647), b1 text(2147483648), c1 text(4294967295) );
-show columns from b15776;
-drop table b15776;
-
---error ER_TOO_BIG_DISPLAYWIDTH
-CREATE TABLE b15776 (a blob(4294967296));
---error ER_TOO_BIG_DISPLAYWIDTH
-CREATE TABLE b15776 (a text(4294967296));
---error ER_TOO_BIG_DISPLAYWIDTH
-CREATE TABLE b15776 (a blob(999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999));
---error ER_TOO_BIG_DISPLAYWIDTH
-CREATE TABLE b15776 (a text(999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999));
-
-# Int types
-# "Another extension is supported by MySQL for optionally specifying the
-# display width of integer data types in parentheses following the base keyword
-# for the type (for example, INT(4)). This optional display width is used to
-# display integer values having a width less than the width specified for the
-# column by left-padding them with spaces."   § Numeric Types
-CREATE TABLE b15776 (a int(0)); # 0 is special case, means default size
-INSERT INTO b15776 values (NULL), (1), (42), (654);
-SELECT * from b15776 ORDER BY a;
-DROP TABLE b15776;
---error ER_PARSE_ERROR
-CREATE TABLE b15776 (a int(-1));
-CREATE TABLE b15776 (a int(255));
-DROP TABLE b15776;
---error ER_TOO_BIG_DISPLAYWIDTH
-CREATE TABLE b15776 (a int(256));
---error ER_PARSE_ERROR
-CREATE TABLE b15776 (data blob(-1));
-
-# Char types
-# Recommend BLOB
---error ER_TOO_BIG_FIELDLENGTH
-CREATE TABLE b15776 (a char(2147483647));
---error ER_TOO_BIG_FIELDLENGTH
-CREATE TABLE b15776 (a char(2147483648));
---error ER_TOO_BIG_FIELDLENGTH
-CREATE TABLE b15776 (a char(4294967295));
-# Even BLOB won't hold
---error ER_TOO_BIG_DISPLAYWIDTH
-CREATE TABLE b15776 (a char(4294967296));
-
-
-# Other numeric-ish types
-## For year, widths not "2" or "4" are silently rewritten to "4".  But
-## When we complain about it, we say that the max is 255.  We may be 
-## talking about different things.  It's confusing.
-CREATE TABLE b15776 (a year(4294967295));
-INSERT INTO b15776 VALUES (42);
-SELECT * FROM b15776;
-DROP TABLE b15776;
---error ER_TOO_BIG_DISPLAYWIDTH
-CREATE TABLE b15776 (a year(4294967296));
-CREATE TABLE b15776 (a year(0));  # 0 is special case, means default size
-DROP TABLE b15776;
---error ER_PARSE_ERROR
-CREATE TABLE b15776 (a year(-2));
-
-
-# We've already tested the case, but this should visually show that 
-# widths that are too large to be interpreted cause DISPLAYWIDTH errors.
---error ER_TOO_BIG_DISPLAYWIDTH
-CREATE TABLE b15776 (a int(999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999));
---error ER_TOO_BIG_DISPLAYWIDTH
-CREATE TABLE b15776 (a char(999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999));
---error ER_TOO_BIG_DISPLAYWIDTH
-CREATE TABLE b15776 (a year(999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999));
-
-## Do not select, too much memory needed.
-CREATE TABLE b15776 select cast(null as char(4294967295));
-show columns from b15776;
-drop table b15776;
-CREATE TABLE b15776 select cast(null as nchar(4294967295));
-show columns from b15776;
-drop table b15776;
-CREATE TABLE b15776 select cast(null as binary(4294967295));
-show columns from b15776;
-drop table b15776;
-
-explain select cast(1 as char(4294967295));
-explain select cast(1 as nchar(4294967295));
-explain select cast(1 as binary(4294967295));
-
---error ER_TOO_BIG_DISPLAYWIDTH
-explain select cast(1 as char(4294967296));
---error ER_TOO_BIG_DISPLAYWIDTH
-explain select cast(1 as nchar(4294967296));
---error ER_TOO_BIG_DISPLAYWIDTH
-explain select cast(1 as binary(4294967296));
-
---error ER_PARSE_ERROR
-explain select cast(1 as decimal(-1));
-explain select cast(1 as decimal(64, 30));
-# It's not as important which errors are raised for these, since the 
-# limit is nowhere near 2**32.  We may fix these eventually to take
-# 4294967295 and still reject it because it's greater than 64 or 30, 
-# but that's not a high priority and the parser needn't worry about 
-# such a weird case.
---error ER_TOO_BIG_SCALE,ER_PARSE_ERROR
-explain select cast(1 as decimal(64, 999999999999999999999999999999));
---error ER_TOO_BIG_PRECISION,ER_PARSE_ERROR
-explain select cast(1 as decimal(4294967296));
---error ER_TOO_BIG_PRECISION,ER_PARSE_ERROR
-explain select cast(1 as decimal(999999999999999999999999999999999999));
-
-explain select convert(1, char(4294967295));
---error ER_TOO_BIG_DISPLAYWIDTH
-explain select convert(1, char(4294967296));
---error ER_TOO_BIG_DISPLAYWIDTH
-explain select convert(1, char(999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999));
-explain select convert(1, nchar(4294967295));
---error ER_TOO_BIG_DISPLAYWIDTH
-explain select convert(1, nchar(4294967296));
---error ER_TOO_BIG_DISPLAYWIDTH
-explain select convert(1, nchar(999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999));
-explain select convert(1, binary(4294967295));
---error ER_TOO_BIG_DISPLAYWIDTH
-explain select convert(1, binary(4294967296));
---error ER_TOO_BIG_DISPLAYWIDTH
-explain select convert(1, binary(999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999));
-
---echo End of 5.0 tests
-
-#
-# Bug #33969: Updating a text field via a left join
-#
-
-CREATE TABLE t1(id INT NOT NULL);
-CREATE TABLE t2(id INT NOT NULL, c TEXT NOT NULL);
-
-INSERT INTO t1 VALUES (1);
-INSERT INTO t2 VALUES (1, '');
-
-UPDATE t2 SET c = REPEAT('1', 70000);
-SELECT LENGTH(c) FROM t2;
-
-UPDATE t1 LEFT JOIN t2 USING(id) SET t2.c = REPEAT('1', 70000) WHERE t1.id = 1;
-SELECT LENGTH(c) FROM t2;
-
-DROP TABLE t1, t2;
-
---echo # Bug #52160: crash and inconsistent results when grouping
---echo #             by a function and column
-
-CREATE FUNCTION f1() RETURNS TINYBLOB RETURN 1;
-
-CREATE TABLE t1(a CHAR(1));
-INSERT INTO t1 VALUES ('0'), ('0');
-
-SELECT COUNT(*) FROM t1 GROUP BY f1(), a;
-
-DROP FUNCTION f1;
-DROP TABLE t1;
-
-
-
-SET default_storage_engine=@old_default_storage_engine;
-
-
-########################################################################
-# Modified test from myisam-blob.test
-########################################################################
-
-SET @old_max_heap_table_size = @@global.max_heap_table_size;
-SET @old_max_allowed_packet = @@global.max_allowed_packet;
-SET GLOBAL max_heap_table_size = 18 * 1024 * 1024;
-SET GLOBAL max_allowed_packet = 24 * 1024 * 1024;
-
-connect(con1, localhost, root,,);
-connection con1;
-
---disable_warnings
-drop table if exists t1;
---enable_warnings
-
-# Bug #2159 (Problem with update of blob to > 16M)
-
-CREATE TABLE t1 (data LONGBLOB) ENGINE=memory;
-INSERT INTO t1 (data) VALUES (NULL);
-UPDATE t1 set data=repeat('a',18*1024*1024);
-select length(data) from t1;
-delete from t1 where left(data,1)='a';
-truncate table t1;
-INSERT INTO t1 (data) VALUES (repeat('a',1*1024*1024));
-INSERT INTO t1 (data) VALUES (repeat('b',16*1024*1024-1024));
-delete from t1 where left(data,1)='b';
-
-# now we have two blocks in the table, first is a 1M record and second is
-# a 16M delete block.
-
-UPDATE t1 set data=repeat('c',17*1024*1024);
-delete from t1 where left(data,1)='c';
-
-INSERT INTO t1 set data=repeat('a',18*1024*1024);
-select length(data) from t1;
-alter table t1 modify data blob;
-select length(data) from t1;
-drop table t1;
-
-CREATE TABLE t1 (data BLOB) ENGINE=myisam;
-INSERT INTO t1 (data) VALUES (NULL);
-UPDATE t1 set data=repeat('a',18*1024*1024);
-select length(data) from t1;
-drop table t1;
-
-disconnect con1;
-connection default;
-
-SET GLOBAL max_allowed_packet = @old_max_allowed_packet;
-SET GLOBAL max_heap_table_size = @old_max_heap_table_size;
 
=== removed file 'mysql-test/memory_dynamic_rows.patch/percona_heap_bug783366.result'
--- mysql-test/memory_dynamic_rows.patch/percona_heap_bug783366.result	2011-06-06 10:34:16 +0000
+++ mysql-test/memory_dynamic_rows.patch/percona_heap_bug783366.result	1970-01-01 00:00:00 +0000
@@ -1,14 +0,0 @@
-drop table if exists t1;
-CREATE TABLE t1 (
-f1 VARCHAR ( 128 ) ,
-f2 VARCHAR ( 32 ),
-PRIMARY KEY ( f2 ( 2 ) , f1 )
-)
-ENGINE=HEAP KEY_BLOCK_SIZE = 512;
-INSERT IGNORE INTO t1 VALUES ( 'te' , 'm') , ( NULL , 'think' );
-Warnings:
-Warning	1048	Column 'f1' cannot be null
-INSERT IGNORE INTO t1 VALUES ( 'te' , 'm') , ( NULL , 'think' );
-Warnings:
-Warning	1048	Column 'f1' cannot be null
-DROP TABLE t1;
 
=== removed file 'mysql-test/memory_dynamic_rows.patch/percona_heap_bug783366.test'
--- mysql-test/memory_dynamic_rows.patch/percona_heap_bug783366.test	2011-08-22 11:28:27 +0000
+++ mysql-test/memory_dynamic_rows.patch/percona_heap_bug783366.test	1970-01-01 00:00:00 +0000
@@ -1,19 +0,0 @@
-#
-# Test for bug lp:783366
-#
-
---disable_warnings
-drop table if exists t1;
---enable_warnings
-
-CREATE TABLE t1 (
-        f1 VARCHAR ( 128 ) ,
-        f2 VARCHAR ( 32 ),
-        PRIMARY KEY ( f2 ( 2 ) , f1 )
-)
-ENGINE=HEAP KEY_BLOCK_SIZE = 512;
-INSERT IGNORE INTO t1 VALUES ( 'te' , 'm') , ( NULL , 'think' );
-INSERT IGNORE INTO t1 VALUES ( 'te' , 'm') , ( NULL , 'think' );
-
-DROP TABLE t1;
-
 
=== removed file 'mysql-test/memory_dynamic_rows.patch/percona_heap_bug783451.result'
--- mysql-test/memory_dynamic_rows.patch/percona_heap_bug783451.result	2011-06-06 10:34:16 +0000
+++ mysql-test/memory_dynamic_rows.patch/percona_heap_bug783451.result	1970-01-01 00:00:00 +0000
@@ -1,132 +0,0 @@
-DROP TABLE IF EXISTS local_1_1;
-CREATE  TABLE IF NOT EXISTS local_1_1 ( f1 VARCHAR ( 32 ) NOT NULL  , f2 VARCHAR ( 128 ) NOT NULL DEFAULT 'cboepfaobilcchabvglgjdbynog' , f3 VARCHAR ( 32 ) NOT NULL  , f4 VARBINARY ( 32 ) NOT NULL  , f5 VARBINARY ( 1024 )  DEFAULT 'ycboepfao' , KEY ( f1 /* ( 2 ) */ , f2 /* ( 2 ) */ ) ) ENGINE=HEAP KEY_BLOCK_SIZE = 512;
-INSERT IGNORE INTO local_1_1 VALUES ( REPEAT( 'ervydbimvmbqmsowdbsa' , 1 ) , 'v' , NULL , NULL , REPEAT( 'mervydbimvmbqms' , 5 ) ) , ( 'p' , 6 , 'n' , REPEAT( 'imervydbimvmbqmsowdbs' , 4 ) , 'do' ) , ( NULL , NULL , REPEAT( 'himervydbimvmbqmsowdbsaybudvwaamvhempuublmia' , 6 ) , REPEAT('X', POW(2, 20) * 2) , REPEAT('X', POW(2, 20) * 2) ) , ( REPEAT('X', POW(2, 20) * 2) , REPEAT( 'Y' , 763 ) , NULL , REPEAT('X', POW(2, 20) * 2) , NULL ) , ( REPEAT('X', POW(2, 20) * 2) , 'time' , 'how' , 2 , REPEAT( 'Y' , 107 ) ) , ( REPEAT( 'hyshimervydbimvmbqmsowdbsaybud' , 5 ) , 2 , 8 , NULL , REPEAT('X', POW(2, 20) * 2) ) , ( 'come' , NULL , 'i' , NULL , REPEAT('X', POW(2, 20) * 2) );
-Warnings:
-Warning	1048	Column 'f3' cannot be null
-Warning	1048	Column 'f4' cannot be null
-Warning	1265	Data truncated for column 'f4' at row 2
-Warning	1048	Column 'f1' cannot be null
-Warning	1048	Column 'f2' cannot be null
-Warning	1265	Data truncated for column 'f3' at row 3
-Warning	1301	Result of repeat() was larger than max_allowed_packet (1048576) - truncated
-Warning	1048	Column 'f4' cannot be null
-Warning	1301	Result of repeat() was larger than max_allowed_packet (1048576) - truncated
-Warning	1301	Result of repeat() was larger than max_allowed_packet (1048576) - truncated
-Warning	1048	Column 'f1' cannot be null
-Warning	1265	Data truncated for column 'f2' at row 4
-Warning	1048	Column 'f3' cannot be null
-Warning	1301	Result of repeat() was larger than max_allowed_packet (1048576) - truncated
-Warning	1048	Column 'f4' cannot be null
-Warning	1301	Result of repeat() was larger than max_allowed_packet (1048576) - truncated
-Warning	1048	Column 'f1' cannot be null
-Warning	1265	Data truncated for column 'f1' at row 6
-Warning	1048	Column 'f4' cannot be null
-Warning	1301	Result of repeat() was larger than max_allowed_packet (1048576) - truncated
-Warning	1048	Column 'f2' cannot be null
-Warning	1048	Column 'f4' cannot be null
-Warning	1301	Result of repeat() was larger than max_allowed_packet (1048576) - truncated
-INSERT IGNORE INTO local_1_1 VALUES ( 'ok' , NULL , REPEAT( 'Y' , 651 ) , 2 , 5 ) , ( REPEAT( 'zylcdzkfrqpihyshimervydbimvmbqmsowdbsaybu' , 3 ) , REPEAT( 'Y' , 282 ) , REPEAT( 'X' , 0 ) , REPEAT( 'Y' , 369 ) , 'g' ) , ( 'think' , REPEAT('X', POW(2, 20) * 2), NULL , NULL , REPEAT('X', POW(2, 20) * 2) ) , ( REPEAT( 'Y' , 468 ) , REPEAT( 'dfvbrzylcd' , 6 ) , REPEAT( 'Y' , 264 ) , NULL , 'c' ) , ( NULL , NULL , REPEAT( 'srdfvbrzylcdzkfrqpihyshimervydbimvmbqms' , 0 ) , REPEAT( 'Y' , 244 ) , 7 ) , ( REPEAT( 'Y' , 0 ) , 'how' , 'going' , 'q' , NULL );
-Warnings:
-Warning	1048	Column 'f2' cannot be null
-Warning	1265	Data truncated for column 'f3' at row 1
-Warning	1265	Data truncated for column 'f1' at row 2
-Warning	1265	Data truncated for column 'f2' at row 2
-Warning	1265	Data truncated for column 'f4' at row 2
-Warning	1301	Result of repeat() was larger than max_allowed_packet (1048576) - truncated
-Warning	1048	Column 'f2' cannot be null
-Warning	1048	Column 'f3' cannot be null
-Warning	1048	Column 'f4' cannot be null
-Warning	1301	Result of repeat() was larger than max_allowed_packet (1048576) - truncated
-Warning	1265	Data truncated for column 'f1' at row 4
-Warning	1265	Data truncated for column 'f3' at row 4
-Warning	1048	Column 'f4' cannot be null
-Warning	1048	Column 'f1' cannot be null
-Warning	1048	Column 'f2' cannot be null
-Warning	1265	Data truncated for column 'f4' at row 5
-INSERT IGNORE INTO local_1_1 VALUES ( REPEAT('X', POW(2, 20) * 2) , NULL , NULL , NULL , REPEAT('X', POW(2, 20) * 2) ) , ( REPEAT('X', POW(2, 20) * 2) , NULL , REPEAT('X', POW(2, 20) * 2) , 'this' , 'e' ) , ( NULL , 'think' , NULL , 'were' , NULL ) , ( 9 , 'l' , 'c' , 3 , REPEAT( 'geysrdfvbrzylcdzkfrqpihyshimervydbi' , 5 ) ) , ( NULL , NULL , NULL , 'h' , 'w' );
-Warnings:
-Warning	1301	Result of repeat() was larger than max_allowed_packet (1048576) - truncated
-Warning	1048	Column 'f1' cannot be null
-Warning	1048	Column 'f2' cannot be null
-Warning	1048	Column 'f3' cannot be null
-Warning	1048	Column 'f4' cannot be null
-Warning	1301	Result of repeat() was larger than max_allowed_packet (1048576) - truncated
-Warning	1301	Result of repeat() was larger than max_allowed_packet (1048576) - truncated
-Warning	1048	Column 'f1' cannot be null
-Warning	1048	Column 'f2' cannot be null
-Warning	1301	Result of repeat() was larger than max_allowed_packet (1048576) - truncated
-Warning	1048	Column 'f3' cannot be null
-Warning	1048	Column 'f1' cannot be null
-Warning	1048	Column 'f3' cannot be null
-Warning	1048	Column 'f1' cannot be null
-Warning	1048	Column 'f2' cannot be null
-Warning	1048	Column 'f3' cannot be null
-INSERT IGNORE INTO local_1_1 SELECT * FROM local_1_1;
-INSERT IGNORE INTO local_1_1 SELECT * FROM local_1_1;
-UPDATE local_1_1 SET f5 = REPEAT ('X', 215566);
-Warnings:
-Warning	1265	Data truncated for column 'f5' at row 1
-Warning	1265	Data truncated for column 'f5' at row 2
-Warning	1265	Data truncated for column 'f5' at row 3
-Warning	1265	Data truncated for column 'f5' at row 4
-Warning	1265	Data truncated for column 'f5' at row 5
-Warning	1265	Data truncated for column 'f5' at row 6
-Warning	1265	Data truncated for column 'f5' at row 7
-Warning	1265	Data truncated for column 'f5' at row 8
-Warning	1265	Data truncated for column 'f5' at row 9
-Warning	1265	Data truncated for column 'f5' at row 10
-Warning	1265	Data truncated for column 'f5' at row 11
-Warning	1265	Data truncated for column 'f5' at row 12
-Warning	1265	Data truncated for column 'f5' at row 13
-Warning	1265	Data truncated for column 'f5' at row 14
-Warning	1265	Data truncated for column 'f5' at row 15
-Warning	1265	Data truncated for column 'f5' at row 16
-Warning	1265	Data truncated for column 'f5' at row 17
-Warning	1265	Data truncated for column 'f5' at row 18
-Warning	1265	Data truncated for column 'f5' at row 19
-Warning	1265	Data truncated for column 'f5' at row 20
-Warning	1265	Data truncated for column 'f5' at row 21
-Warning	1265	Data truncated for column 'f5' at row 22
-Warning	1265	Data truncated for column 'f5' at row 23
-Warning	1265	Data truncated for column 'f5' at row 24
-Warning	1265	Data truncated for column 'f5' at row 25
-Warning	1265	Data truncated for column 'f5' at row 26
-Warning	1265	Data truncated for column 'f5' at row 27
-Warning	1265	Data truncated for column 'f5' at row 28
-Warning	1265	Data truncated for column 'f5' at row 29
-Warning	1265	Data truncated for column 'f5' at row 30
-Warning	1265	Data truncated for column 'f5' at row 31
-Warning	1265	Data truncated for column 'f5' at row 32
-Warning	1265	Data truncated for column 'f5' at row 33
-Warning	1265	Data truncated for column 'f5' at row 34
-Warning	1265	Data truncated for column 'f5' at row 35
-Warning	1265	Data truncated for column 'f5' at row 36
-Warning	1265	Data truncated for column 'f5' at row 37
-Warning	1265	Data truncated for column 'f5' at row 38
-Warning	1265	Data truncated for column 'f5' at row 39
-Warning	1265	Data truncated for column 'f5' at row 40
-Warning	1265	Data truncated for column 'f5' at row 41
-Warning	1265	Data truncated for column 'f5' at row 42
-Warning	1265	Data truncated for column 'f5' at row 43
-Warning	1265	Data truncated for column 'f5' at row 44
-Warning	1265	Data truncated for column 'f5' at row 45
-Warning	1265	Data truncated for column 'f5' at row 46
-Warning	1265	Data truncated for column 'f5' at row 47
-Warning	1265	Data truncated for column 'f5' at row 48
-Warning	1265	Data truncated for column 'f5' at row 49
-Warning	1265	Data truncated for column 'f5' at row 50
-Warning	1265	Data truncated for column 'f5' at row 51
-Warning	1265	Data truncated for column 'f5' at row 52
-Warning	1265	Data truncated for column 'f5' at row 53
-Warning	1265	Data truncated for column 'f5' at row 54
-Warning	1265	Data truncated for column 'f5' at row 55
-Warning	1265	Data truncated for column 'f5' at row 56
-Warning	1265	Data truncated for column 'f5' at row 57
-Warning	1265	Data truncated for column 'f5' at row 58
-Warning	1265	Data truncated for column 'f5' at row 59
-Warning	1265	Data truncated for column 'f5' at row 60
-Warning	1265	Data truncated for column 'f5' at row 61
-Warning	1265	Data truncated for column 'f5' at row 62
-Warning	1265	Data truncated for column 'f5' at row 63
-Warning	1265	Data truncated for column 'f5' at row 64
-DROP TABLE local_1_1;
 
=== removed file 'mysql-test/memory_dynamic_rows.patch/percona_heap_bug783451.test'
--- mysql-test/memory_dynamic_rows.patch/percona_heap_bug783451.test	2011-08-22 11:28:27 +0000
+++ mysql-test/memory_dynamic_rows.patch/percona_heap_bug783451.test	1970-01-01 00:00:00 +0000
@@ -1,16 +0,0 @@
-# Testcase for the bug https://bugs.launchpad.net/percona-projects-qa/+bug/783451
-# With dynamic row format in HEAP and the UPDATE statement that significantly
-# increases the data size, the table scan in-progress desyncs its table position state.
-# Run with Valgrind if it does not crash for you.
---disable_warnings
-DROP TABLE IF EXISTS local_1_1;
---enable_warnings
-CREATE  TABLE IF NOT EXISTS local_1_1 ( f1 VARCHAR ( 32 ) NOT NULL  , f2 VARCHAR ( 128 ) NOT NULL DEFAULT 'cboepfaobilcchabvglgjdbynog' , f3 VARCHAR ( 32 ) NOT NULL  , f4 VARBINARY ( 32 ) NOT NULL  , f5 VARBINARY ( 1024 )  DEFAULT 'ycboepfao' , KEY ( f1 /* ( 2 ) */ , f2 /* ( 2 ) */ ) ) ENGINE=HEAP KEY_BLOCK_SIZE = 512;
-INSERT IGNORE INTO local_1_1 VALUES ( REPEAT( 'ervydbimvmbqmsowdbsa' , 1 ) , 'v' , NULL , NULL , REPEAT( 'mervydbimvmbqms' , 5 ) ) , ( 'p' , 6 , 'n' , REPEAT( 'imervydbimvmbqmsowdbs' , 4 ) , 'do' ) , ( NULL , NULL , REPEAT( 'himervydbimvmbqmsowdbsaybudvwaamvhempuublmia' , 6 ) , REPEAT('X', POW(2, 20) * 2) , REPEAT('X', POW(2, 20) * 2) ) , ( REPEAT('X', POW(2, 20) * 2) , REPEAT( 'Y' , 763 ) , NULL , REPEAT('X', POW(2, 20) * 2) , NULL ) , ( REPEAT('X', POW(2, 20) * 2) , 'time' , 'how' , 2 , REPEAT( 'Y' , 107 ) ) , ( REPEAT( 'hyshimervydbimvmbqmsowdbsaybud' , 5 ) , 2 , 8 , NULL , REPEAT('X', POW(2, 20) * 2) ) , ( 'come' , NULL , 'i' , NULL , REPEAT('X', POW(2, 20) * 2) );
-INSERT IGNORE INTO local_1_1 VALUES ( 'ok' , NULL , REPEAT( 'Y' , 651 ) , 2 , 5 ) , ( REPEAT( 'zylcdzkfrqpihyshimervydbimvmbqmsowdbsaybu' , 3 ) , REPEAT( 'Y' , 282 ) , REPEAT( 'X' , 0 ) , REPEAT( 'Y' , 369 ) , 'g' ) , ( 'think' , REPEAT('X', POW(2, 20) * 2), NULL , NULL , REPEAT('X', POW(2, 20) * 2) ) , ( REPEAT( 'Y' , 468 ) , REPEAT( 'dfvbrzylcd' , 6 ) , REPEAT( 'Y' , 264 ) , NULL , 'c' ) , ( NULL , NULL , REPEAT( 'srdfvbrzylcdzkfrqpihyshimervydbimvmbqms' , 0 ) , REPEAT( 'Y' , 244 ) , 7 ) , ( REPEAT( 'Y' , 0 ) , 'how' , 'going' , 'q' , NULL );
-INSERT IGNORE INTO local_1_1 VALUES ( REPEAT('X', POW(2, 20) * 2) , NULL , NULL , NULL , REPEAT('X', POW(2, 20) * 2) ) , ( REPEAT('X', POW(2, 20) * 2) , NULL , REPEAT('X', POW(2, 20) * 2) , 'this' , 'e' ) , ( NULL , 'think' , NULL , 'were' , NULL ) , ( 9 , 'l' , 'c' , 3 , REPEAT( 'geysrdfvbrzylcdzkfrqpihyshimervydbi' , 5 ) ) , ( NULL , NULL , NULL , 'h' , 'w' );
---enable_warnings
-INSERT IGNORE INTO local_1_1 SELECT * FROM local_1_1;
-INSERT IGNORE INTO local_1_1 SELECT * FROM local_1_1;
-UPDATE local_1_1 SET f5 = REPEAT ('X', 215566);
-DROP TABLE local_1_1;
 
=== removed file 'mysql-test/memory_dynamic_rows.patch/percona_heap_bug784464.result'
--- mysql-test/memory_dynamic_rows.patch/percona_heap_bug784464.result	2011-08-22 11:28:27 +0000
+++ mysql-test/memory_dynamic_rows.patch/percona_heap_bug784464.result	1970-01-01 00:00:00 +0000
@@ -1,58 +0,0 @@
-CREATE TABLE t1 (f1 VARCHAR(32), f2 VARCHAR(32), f3 VARCHAR(32), f4 VARCHAR(32),
-PRIMARY KEY (f1)) ENGINE=HEAP ROW_FORMAT=DYNAMIC;
-SHOW TABLE STATUS LIKE 't1';
-Name	Engine	Version	Row_format	Rows	Avg_row_length	Data_length	Max_data_length	Index_length	Data_free	Auto_increment	Create_time	Update_time	Check_time	Collation	Checksum	Create_options	Comment
-t1	MEMORY	10	Fixed	0	X	0	X	0	0	NULL	NULL	NULL	NULL	latin1_swedish_ci	NULL	row_format=DYNAMIC	
-DROP TABLE t1;
-CREATE TABLE t1 (f1 VARCHAR(32), f2 VARCHAR(32), f3 VARCHAR(32), f4 VARCHAR(32),
-PRIMARY KEY (f1)) KEY_BLOCK_SIZE=33 ENGINE=HEAP ROW_FORMAT=DYNAMIC;
-ERROR 42000: Incorrect usage/placement of 'key_block_size'
-SHOW TABLE STATUS LIKE 't1';
-Name	Engine	Version	Row_format	Rows	Avg_row_length	Data_length	Max_data_length	Index_length	Data_free	Auto_increment	Create_time	Update_time	Check_time	Collation	Checksum	Create_options	Comment
-CREATE TABLE t1 (f1 VARCHAR(32), f2 VARCHAR(32), f3 VARCHAR(32), f4 VARCHAR(32),
-PRIMARY KEY (f1)) KEY_BLOCK_SIZE=34 ENGINE=HEAP ROW_FORMAT=DYNAMIC;
-SHOW TABLE STATUS LIKE 't1';
-Name	Engine	Version	Row_format	Rows	Avg_row_length	Data_length	Max_data_length	Index_length	Data_free	Auto_increment	Create_time	Update_time	Check_time	Collation	Checksum	Create_options	Comment
-t1	MEMORY	10	Dynamic	0	X	0	X	0	0	NULL	NULL	NULL	NULL	latin1_swedish_ci	NULL	row_format=DYNAMIC KEY_BLOCK_SIZE=34	
-DROP TABLE t1;
-CREATE TABLE t1 (f1 VARCHAR(32), f2 VARCHAR(32), f3 VARCHAR(32), f4 VARCHAR(32),
-PRIMARY KEY (f1)) KEY_BLOCK_SIZE=123 ENGINE=HEAP ROW_FORMAT=DYNAMIC;
-SHOW TABLE STATUS LIKE 't1';
-Name	Engine	Version	Row_format	Rows	Avg_row_length	Data_length	Max_data_length	Index_length	Data_free	Auto_increment	Create_time	Update_time	Check_time	Collation	Checksum	Create_options	Comment
-t1	MEMORY	10	Dynamic	0	X	0	X	0	0	NULL	NULL	NULL	NULL	latin1_swedish_ci	NULL	row_format=DYNAMIC KEY_BLOCK_SIZE=123	
-DROP TABLE t1;
-CREATE TABLE t1 (f1 VARCHAR(32), f2 VARCHAR(32), f3 VARCHAR(32), f4 VARCHAR(32),
-PRIMARY KEY (f1)) KEY_BLOCK_SIZE=1000 ENGINE=HEAP ROW_FORMAT=DYNAMIC;
-SHOW TABLE STATUS LIKE 't1';
-Name	Engine	Version	Row_format	Rows	Avg_row_length	Data_length	Max_data_length	Index_length	Data_free	Auto_increment	Create_time	Update_time	Check_time	Collation	Checksum	Create_options	Comment
-t1	MEMORY	10	Fixed	0	X	0	X	0	0	NULL	NULL	NULL	NULL	latin1_swedish_ci	NULL	row_format=DYNAMIC KEY_BLOCK_SIZE=1000	
-DROP TABLE t1;
-CREATE TABLE t1 (f1 VARCHAR(32), f2 VARCHAR(96),
-PRIMARY KEY (f1)) ENGINE=HEAP ROW_FORMAT=DYNAMIC;
-SHOW TABLE STATUS LIKE 't1';
-Name	Engine	Version	Row_format	Rows	Avg_row_length	Data_length	Max_data_length	Index_length	Data_free	Auto_increment	Create_time	Update_time	Check_time	Collation	Checksum	Create_options	Comment
-t1	MEMORY	10	Fixed	0	X	0	X	0	0	NULL	NULL	NULL	NULL	latin1_swedish_ci	NULL	row_format=DYNAMIC	
-DROP TABLE t1;
-CREATE TABLE t1 (f1 VARCHAR(32), f2 VARCHAR(96),
-PRIMARY KEY (f1)) KEY_BLOCK_SIZE=33 ENGINE=HEAP ROW_FORMAT=DYNAMIC;
-ERROR 42000: Incorrect usage/placement of 'key_block_size'
-SHOW TABLE STATUS LIKE 't1';
-Name	Engine	Version	Row_format	Rows	Avg_row_length	Data_length	Max_data_length	Index_length	Data_free	Auto_increment	Create_time	Update_time	Check_time	Collation	Checksum	Create_options	Comment
-CREATE TABLE t1 (f1 VARCHAR(32), f2 VARCHAR(96),
-PRIMARY KEY (f1)) KEY_BLOCK_SIZE=34 ENGINE=HEAP ROW_FORMAT=DYNAMIC;
-SHOW TABLE STATUS LIKE 't1';
-Name	Engine	Version	Row_format	Rows	Avg_row_length	Data_length	Max_data_length	Index_length	Data_free	Auto_increment	Create_time	Update_time	Check_time	Collation	Checksum	Create_options	Comment
-t1	MEMORY	10	Dynamic	0	X	0	X	0	0	NULL	NULL	NULL	NULL	latin1_swedish_ci	NULL	row_format=DYNAMIC KEY_BLOCK_SIZE=34	
-DROP TABLE t1;
-CREATE TABLE t1 (f1 VARCHAR(32), f2 VARCHAR(96),
-PRIMARY KEY (f1)) KEY_BLOCK_SIZE=121 ENGINE=HEAP ROW_FORMAT=DYNAMIC;
-SHOW TABLE STATUS LIKE 't1';
-Name	Engine	Version	Row_format	Rows	Avg_row_length	Data_length	Max_data_length	Index_length	Data_free	Auto_increment	Create_time	Update_time	Check_time	Collation	Checksum	Create_options	Comment
-t1	MEMORY	10	Dynamic	0	X	0	X	0	0	NULL	NULL	NULL	NULL	latin1_swedish_ci	NULL	row_format=DYNAMIC KEY_BLOCK_SIZE=121	
-DROP TABLE t1;
-CREATE TABLE t1 (f1 VARCHAR(32), f2 VARCHAR(96),
-PRIMARY KEY (f1)) KEY_BLOCK_SIZE=1000 ENGINE=HEAP ROW_FORMAT=DYNAMIC;
-SHOW TABLE STATUS LIKE 't1';
-Name	Engine	Version	Row_format	Rows	Avg_row_length	Data_length	Max_data_length	Index_length	Data_free	Auto_increment	Create_time	Update_time	Check_time	Collation	Checksum	Create_options	Comment
-t1	MEMORY	10	Fixed	0	X	0	X	0	0	NULL	NULL	NULL	NULL	latin1_swedish_ci	NULL	row_format=DYNAMIC KEY_BLOCK_SIZE=1000	
-DROP TABLE t1;
 
=== removed file 'mysql-test/memory_dynamic_rows.patch/percona_heap_bug784464.test'
--- mysql-test/memory_dynamic_rows.patch/percona_heap_bug784464.test	2011-08-22 11:28:27 +0000
+++ mysql-test/memory_dynamic_rows.patch/percona_heap_bug784464.test	1970-01-01 00:00:00 +0000
@@ -1,64 +0,0 @@
-#
-# Bug #784464: Silent conversion from Dynamic to Fixed row_format for certain
-# values of key_block_size.
-# Also see percona_heap_bug784464_32bit and percona_heap_bug784464_64bit tests.
-#
-
-CREATE TABLE t1 (f1 VARCHAR(32), f2 VARCHAR(32), f3 VARCHAR(32), f4 VARCHAR(32),
-              	PRIMARY KEY (f1)) ENGINE=HEAP ROW_FORMAT=DYNAMIC;
---replace_column 6 X 8 X
-SHOW TABLE STATUS LIKE 't1';
-DROP TABLE t1;
-
---error ER_CANT_USE_OPTION_HERE
-CREATE TABLE t1 (f1 VARCHAR(32), f2 VARCHAR(32), f3 VARCHAR(32), f4 VARCHAR(32),
-              	PRIMARY KEY (f1)) KEY_BLOCK_SIZE=33 ENGINE=HEAP ROW_FORMAT=DYNAMIC;
-SHOW TABLE STATUS LIKE 't1';
-
-CREATE TABLE t1 (f1 VARCHAR(32), f2 VARCHAR(32), f3 VARCHAR(32), f4 VARCHAR(32),
-              	PRIMARY KEY (f1)) KEY_BLOCK_SIZE=34 ENGINE=HEAP ROW_FORMAT=DYNAMIC;
---replace_column 6 X 8 X
-SHOW TABLE STATUS LIKE 't1';
-DROP TABLE t1;
-
-CREATE TABLE t1 (f1 VARCHAR(32), f2 VARCHAR(32), f3 VARCHAR(32), f4 VARCHAR(32),
-              	PRIMARY KEY (f1)) KEY_BLOCK_SIZE=123 ENGINE=HEAP ROW_FORMAT=DYNAMIC;
---replace_column 6 X 8 X
-SHOW TABLE STATUS LIKE 't1';
-DROP TABLE t1;
-
-CREATE TABLE t1 (f1 VARCHAR(32), f2 VARCHAR(32), f3 VARCHAR(32), f4 VARCHAR(32),
-              	PRIMARY KEY (f1)) KEY_BLOCK_SIZE=1000 ENGINE=HEAP ROW_FORMAT=DYNAMIC;
---replace_column 6 X 8 X
-SHOW TABLE STATUS LIKE 't1';
-DROP TABLE t1;
-
-CREATE TABLE t1 (f1 VARCHAR(32), f2 VARCHAR(96),
-              	PRIMARY KEY (f1)) ENGINE=HEAP ROW_FORMAT=DYNAMIC;
---replace_column 6 X 8 X
-SHOW TABLE STATUS LIKE 't1';
-DROP TABLE t1;
-
---error ER_CANT_USE_OPTION_HERE
-CREATE TABLE t1 (f1 VARCHAR(32), f2 VARCHAR(96),
-              	PRIMARY KEY (f1)) KEY_BLOCK_SIZE=33 ENGINE=HEAP ROW_FORMAT=DYNAMIC;
-SHOW TABLE STATUS LIKE 't1';
-
-CREATE TABLE t1 (f1 VARCHAR(32), f2 VARCHAR(96),
-              	PRIMARY KEY (f1)) KEY_BLOCK_SIZE=34 ENGINE=HEAP ROW_FORMAT=DYNAMIC;
---replace_column 6 X 8 X
-SHOW TABLE STATUS LIKE 't1';
-DROP TABLE t1;
-
-CREATE TABLE t1 (f1 VARCHAR(32), f2 VARCHAR(96),
-              	PRIMARY KEY (f1)) KEY_BLOCK_SIZE=121 ENGINE=HEAP ROW_FORMAT=DYNAMIC;
---replace_column 6 X 8 X
-SHOW TABLE STATUS LIKE 't1';
-DROP TABLE t1;
-
-CREATE TABLE t1 (f1 VARCHAR(32), f2 VARCHAR(96),
-              	PRIMARY KEY (f1)) KEY_BLOCK_SIZE=1000 ENGINE=HEAP ROW_FORMAT=DYNAMIC;
---replace_column 6 X 8 X
-SHOW TABLE STATUS LIKE 't1';
-DROP TABLE t1;
-
 
=== removed file 'mysql-test/memory_dynamic_rows.patch/percona_heap_bug784464_32bit.result'
--- mysql-test/memory_dynamic_rows.patch/percona_heap_bug784464_32bit.result	2011-08-22 11:28:27 +0000
+++ mysql-test/memory_dynamic_rows.patch/percona_heap_bug784464_32bit.result	1970-01-01 00:00:00 +0000
@@ -1,12 +0,0 @@
-CREATE TABLE t1 (f1 VARCHAR(32), f2 VARCHAR(32), f3 VARCHAR(32), f4 VARCHAR(32),
-PRIMARY KEY (f1)) KEY_BLOCK_SIZE=124 ENGINE=HEAP ROW_FORMAT=DYNAMIC;
-SHOW TABLE STATUS LIKE 't1';
-Name	Engine	Version	Row_format	Rows	Avg_row_length	Data_length	Max_data_length	Index_length	Data_free	Auto_increment	Create_time	Update_time	Check_time	Collation	Checksum	Create_options	Comment
-t1	MEMORY	10	Dynamic	0	X	0	X	0	0	NULL	NULL	NULL	NULL	latin1_swedish_ci	NULL	row_format=DYNAMIC KEY_BLOCK_SIZE=124	
-DROP TABLE t1;
-CREATE TABLE t1 (f1 VARCHAR(32), f2 VARCHAR(96),
-PRIMARY KEY (f1)) KEY_BLOCK_SIZE=122 ENGINE=HEAP ROW_FORMAT=DYNAMIC;
-SHOW TABLE STATUS LIKE 't1';
-Name	Engine	Version	Row_format	Rows	Avg_row_length	Data_length	Max_data_length	Index_length	Data_free	Auto_increment	Create_time	Update_time	Check_time	Collation	Checksum	Create_options	Comment
-t1	MEMORY	10	Dynamic	0	X	0	X	0	0	NULL	NULL	NULL	NULL	latin1_swedish_ci	NULL	row_format=DYNAMIC KEY_BLOCK_SIZE=122	
-DROP TABLE t1;
 
=== removed file 'mysql-test/memory_dynamic_rows.patch/percona_heap_bug784464_32bit.test'
--- mysql-test/memory_dynamic_rows.patch/percona_heap_bug784464_32bit.test	2011-08-22 11:28:27 +0000
+++ mysql-test/memory_dynamic_rows.patch/percona_heap_bug784464_32bit.test	1970-01-01 00:00:00 +0000
@@ -1,15 +0,0 @@
-# 32-bit platform specific parts of tests for LP bug #784464
-
---source include/have_32bit.inc
-
-CREATE TABLE t1 (f1 VARCHAR(32), f2 VARCHAR(32), f3 VARCHAR(32), f4 VARCHAR(32),
-              	PRIMARY KEY (f1)) KEY_BLOCK_SIZE=124 ENGINE=HEAP ROW_FORMAT=DYNAMIC;
---replace_column 6 X 8 X
-SHOW TABLE STATUS LIKE 't1';
-DROP TABLE t1;
-
-CREATE TABLE t1 (f1 VARCHAR(32), f2 VARCHAR(96),
-              	PRIMARY KEY (f1)) KEY_BLOCK_SIZE=122 ENGINE=HEAP ROW_FORMAT=DYNAMIC;
---replace_column 6 X 8 X
-SHOW TABLE STATUS LIKE 't1';
-DROP TABLE t1;
 
=== removed file 'mysql-test/memory_dynamic_rows.patch/percona_heap_bug784464_64bit.result'
--- mysql-test/memory_dynamic_rows.patch/percona_heap_bug784464_64bit.result	2011-08-22 11:28:27 +0000
+++ mysql-test/memory_dynamic_rows.patch/percona_heap_bug784464_64bit.result	1970-01-01 00:00:00 +0000
@@ -1,12 +0,0 @@
-CREATE TABLE t1 (f1 VARCHAR(32), f2 VARCHAR(32), f3 VARCHAR(32), f4 VARCHAR(32),
-PRIMARY KEY (f1)) KEY_BLOCK_SIZE=124 ENGINE=HEAP ROW_FORMAT=DYNAMIC;
-SHOW TABLE STATUS LIKE 't1';
-Name	Engine	Version	Row_format	Rows	Avg_row_length	Data_length	Max_data_length	Index_length	Data_free	Auto_increment	Create_time	Update_time	Check_time	Collation	Checksum	Create_options	Comment
-t1	MEMORY	10	Fixed	0	X	0	X	0	0	NULL	NULL	NULL	NULL	latin1_swedish_ci	NULL	row_format=DYNAMIC KEY_BLOCK_SIZE=124	
-DROP TABLE t1;
-CREATE TABLE t1 (f1 VARCHAR(32), f2 VARCHAR(96),
-PRIMARY KEY (f1)) KEY_BLOCK_SIZE=122 ENGINE=HEAP ROW_FORMAT=DYNAMIC;
-SHOW TABLE STATUS LIKE 't1';
-Name	Engine	Version	Row_format	Rows	Avg_row_length	Data_length	Max_data_length	Index_length	Data_free	Auto_increment	Create_time	Update_time	Check_time	Collation	Checksum	Create_options	Comment
-t1	MEMORY	10	Fixed	0	X	0	X	0	0	NULL	NULL	NULL	NULL	latin1_swedish_ci	NULL	row_format=DYNAMIC KEY_BLOCK_SIZE=122	
-DROP TABLE t1;
 
=== removed file 'mysql-test/memory_dynamic_rows.patch/percona_heap_bug784464_64bit.test'
--- mysql-test/memory_dynamic_rows.patch/percona_heap_bug784464_64bit.test	2011-08-22 11:28:27 +0000
+++ mysql-test/memory_dynamic_rows.patch/percona_heap_bug784464_64bit.test	1970-01-01 00:00:00 +0000
@@ -1,15 +0,0 @@
-# 64-bit platform specific parts of tests for LP bug #784464
-
---source include/have_64bit.inc
-
-CREATE TABLE t1 (f1 VARCHAR(32), f2 VARCHAR(32), f3 VARCHAR(32), f4 VARCHAR(32),
-              	PRIMARY KEY (f1)) KEY_BLOCK_SIZE=124 ENGINE=HEAP ROW_FORMAT=DYNAMIC;
---replace_column 6 X 8 X
-SHOW TABLE STATUS LIKE 't1';
-DROP TABLE t1;
-
-CREATE TABLE t1 (f1 VARCHAR(32), f2 VARCHAR(96),
-              	PRIMARY KEY (f1)) KEY_BLOCK_SIZE=122 ENGINE=HEAP ROW_FORMAT=DYNAMIC;
---replace_column 6 X 8 X
-SHOW TABLE STATUS LIKE 't1';
-DROP TABLE t1;
 
=== removed file 'mysql-test/memory_dynamic_rows.patch/percona_heap_bug784468.result'
--- mysql-test/memory_dynamic_rows.patch/percona_heap_bug784468.result	2011-08-22 11:28:27 +0000
+++ mysql-test/memory_dynamic_rows.patch/percona_heap_bug784468.result	1970-01-01 00:00:00 +0000
@@ -1,15 +0,0 @@
-CREATE TABLE t1 ( f1 VARCHAR(30)) ENGINE=HEAP ROW_FORMAT=DYNAMIC;
-SHOW TABLE STATUS LIKE 't1';
-Name	Engine	Version	Row_format	Rows	Avg_row_length	Data_length	Max_data_length	Index_length	Data_free	Auto_increment	Create_time	Update_time	Check_time	Collation	Checksum	Create_options	Comment
-t1	MEMORY	10	Fixed	0	32	0	X	0	0	NULL	NULL	NULL	NULL	latin1_swedish_ci	NULL	row_format=DYNAMIC	
-DROP TABLE t1;
-CREATE TABLE t1 ( f1 VARCHAR(31)) ENGINE=HEAP ROW_FORMAT=DYNAMIC;
-SHOW TABLE STATUS LIKE 't1';
-Name	Engine	Version	Row_format	Rows	Avg_row_length	Data_length	Max_data_length	Index_length	Data_free	Auto_increment	Create_time	Update_time	Check_time	Collation	Checksum	Create_options	Comment
-t1	MEMORY	10	Fixed	0	33	0	X	0	0	NULL	NULL	NULL	NULL	latin1_swedish_ci	NULL	row_format=DYNAMIC	
-DROP TABLE t1;
-CREATE TABLE t1 ( f1 VARCHAR(32)) ENGINE=HEAP ROW_FORMAT=DYNAMIC;
-SHOW TABLE STATUS LIKE 't1';
-Name	Engine	Version	Row_format	Rows	Avg_row_length	Data_length	Max_data_length	Index_length	Data_free	Auto_increment	Create_time	Update_time	Check_time	Collation	Checksum	Create_options	Comment
-t1	MEMORY	10	Fixed	0	34	0	X	0	0	NULL	NULL	NULL	NULL	latin1_swedish_ci	NULL	row_format=DYNAMIC	
-DROP TABLE t1;
 
=== removed file 'mysql-test/memory_dynamic_rows.patch/percona_heap_bug784468.test'
--- mysql-test/memory_dynamic_rows.patch/percona_heap_bug784468.test	2011-08-22 11:28:27 +0000
+++ mysql-test/memory_dynamic_rows.patch/percona_heap_bug784468.test	1970-01-01 00:00:00 +0000
@@ -1,19 +0,0 @@
-#
-# Bug #784468: Tables with VARCHAR(<31) are created as row_format = Fixed
-#
-
-CREATE TABLE t1 ( f1 VARCHAR(30)) ENGINE=HEAP ROW_FORMAT=DYNAMIC;
---replace_column 8 X
-SHOW TABLE STATUS LIKE 't1';
-DROP TABLE t1;
-
-CREATE TABLE t1 ( f1 VARCHAR(31)) ENGINE=HEAP ROW_FORMAT=DYNAMIC;
---replace_column 8 X
-SHOW TABLE STATUS LIKE 't1';
-DROP TABLE t1;
-
-CREATE TABLE t1 ( f1 VARCHAR(32)) ENGINE=HEAP ROW_FORMAT=DYNAMIC;
---replace_column 8 X
-SHOW TABLE STATUS LIKE 't1';
-DROP TABLE t1;
-
 
=== removed file 'mysql-test/memory_dynamic_rows.patch/percona_heap_bug788544.result'
--- mysql-test/memory_dynamic_rows.patch/percona_heap_bug788544.result	2011-06-06 10:34:16 +0000
+++ mysql-test/memory_dynamic_rows.patch/percona_heap_bug788544.result	1970-01-01 00:00:00 +0000
@@ -1,9 +0,0 @@
-CREATE TABLE t1 (f2 VARCHAR (32), f4 LONGBLOB, f5 TEXT) ENGINE=HEAP;
-INSERT INTO t1 VALUES ('a', NULL, NULL),
-('b' , REPEAT('a' , 593338), REPEAT('a', 800));
-UPDATE t1 SET f2 = 'c' WHERE f4 = 'd';
-SELECT LENGTH(f2), LENGTH(f4), LENGTH(f5) FROM t1;
-LENGTH(f2)	LENGTH(f4)	LENGTH(f5)
-1	NULL	NULL
-1	593338	800
-DROP TABLE t1;
 
=== removed file 'mysql-test/memory_dynamic_rows.patch/percona_heap_bug788544.test'
--- mysql-test/memory_dynamic_rows.patch/percona_heap_bug788544.test	2011-08-22 11:28:27 +0000
+++ mysql-test/memory_dynamic_rows.patch/percona_heap_bug788544.test	1970-01-01 00:00:00 +0000
@@ -1,15 +0,0 @@
-#
-# Bug #788544: Valgrind warnings/crash in mysql-55-eb-blobs in
-#              hp_extract_record / hp_process_field_data_to_chunkset
-#
-
-CREATE TABLE t1 (f2 VARCHAR (32), f4 LONGBLOB, f5 TEXT) ENGINE=HEAP;
-
-INSERT INTO t1 VALUES ('a', NULL, NULL),
-                      ('b' , REPEAT('a' , 593338), REPEAT('a', 800));
-
-UPDATE t1 SET f2 = 'c' WHERE f4 = 'd';
-
-SELECT LENGTH(f2), LENGTH(f4), LENGTH(f5) FROM t1;
-
-DROP TABLE t1;
 
=== removed file 'mysql-test/memory_dynamic_rows.patch/percona_heap_bug788576.result'
--- mysql-test/memory_dynamic_rows.patch/percona_heap_bug788576.result	2011-06-06 10:34:16 +0000
+++ mysql-test/memory_dynamic_rows.patch/percona_heap_bug788576.result	1970-01-01 00:00:00 +0000
@@ -1,19 +0,0 @@
-CREATE TABLE t1 (f1 VARCHAR (32), f2 VARCHAR (128), f3 VARBINARY (128),
-f4 VARBINARY (512), f5 VARBINARY (1024),
-KEY (f2(1))) ENGINE=HEAP ROW_FORMAT=DYNAMIC;
-INSERT IGNORE INTO t1 VALUES (2, NULL, 6, REPEAT('glugcgqk', 5), 'look'),
-(REPEAT( 'kglugcgqkin', 6), 'if', 'was', NULL, NULL),
-(NULL, NULL, NULL, NULL, 7);
-Warnings:
-Warning	1265	Data truncated for column 'f1' at row 2
-SELECT * FROM t1;
-f1	f2	f3	f4	f5
-2	NULL	6	glugcgqkglugcgqkglugcgqkglugcgqkglugcgqk	look
-kglugcgqkinkglugcgqkinkglugcgqki	if	was	NULL	NULL
-NULL	NULL	NULL	NULL	7
-DELETE FROM t1 WHERE f5 <=> NULL;
-SELECT * FROM t1;
-f1	f2	f3	f4	f5
-2	NULL	6	glugcgqkglugcgqkglugcgqkglugcgqkglugcgqk	look
-NULL	NULL	NULL	NULL	7
-DROP TABLE t1;
 
=== removed file 'mysql-test/memory_dynamic_rows.patch/percona_heap_bug788576.test'
--- mysql-test/memory_dynamic_rows.patch/percona_heap_bug788576.test	2011-08-22 11:28:27 +0000
+++ mysql-test/memory_dynamic_rows.patch/percona_heap_bug788576.test	1970-01-01 00:00:00 +0000
@@ -1,19 +0,0 @@
-#
-# Bug #788576: Second crash in hp_movelink with mysql-55-eb
-#
-
-CREATE TABLE t1 (f1 VARCHAR (32), f2 VARCHAR (128), f3 VARBINARY (128),
-                 f4 VARBINARY (512), f5 VARBINARY (1024),
-		 KEY (f2(1))) ENGINE=HEAP ROW_FORMAT=DYNAMIC;
-
-INSERT IGNORE INTO t1 VALUES (2, NULL, 6, REPEAT('glugcgqk', 5), 'look'),
-                             (REPEAT( 'kglugcgqkin', 6), 'if', 'was', NULL, NULL),
-			     (NULL, NULL, NULL, NULL, 7);
-
-SELECT * FROM t1;
-
-DELETE FROM t1 WHERE f5 <=> NULL;
-
-SELECT * FROM t1;
-
-DROP TABLE t1;
 
=== removed file 'mysql-test/memory_dynamic_rows.patch/percona_heap_bug788722.result'
--- mysql-test/memory_dynamic_rows.patch/percona_heap_bug788722.result	2011-06-06 10:34:16 +0000
+++ mysql-test/memory_dynamic_rows.patch/percona_heap_bug788722.result	1970-01-01 00:00:00 +0000
@@ -1,18 +0,0 @@
-CREATE TABLE IF NOT EXISTS local_1_1 (f1 VARCHAR (32) NOT NULL,
-f2 VARCHAR (128) NOT NULL,
-f3 BLOB NOT NULL,
-f4 TEXT,
-f5 BLOB (1024),
-PRIMARY KEY (f1),
-KEY (f1 , f2)
-) ENGINE=HEAP ROW_FORMAT=DYNAMIC KEY_BLOCK_SIZE = 2048;
-INSERT IGNORE INTO local_1_1 VALUES
-(REPEAT('egqeqfxwaejpqixuvvtentruyqadxiybjdfqjspfbyjdjczrrwjnagkzsoagatqookhsgtrvvbxacppljfzaseidqggxvuirm' , 5), NULL, NULL, NULL, REPEAT('hegqeqfxwaejpqixuvvtentruyqadxiy', 1)),
-('you', NULL, 0, REPEAT("X", 2048) , 0);
-Warnings:
-Warning	1265	Data truncated for column 'f1' at row 1
-Warning	1048	Column 'f2' cannot be null
-Warning	1048	Column 'f3' cannot be null
-Warning	1048	Column 'f2' cannot be null
-INSERT IGNORE INTO local_1_1 SELECT * FROM local_1_1;
-DROP TABLE local_1_1;
 
=== removed file 'mysql-test/memory_dynamic_rows.patch/percona_heap_bug788722.test'
--- mysql-test/memory_dynamic_rows.patch/percona_heap_bug788722.test	2011-08-22 11:28:27 +0000
+++ mysql-test/memory_dynamic_rows.patch/percona_heap_bug788722.test	1970-01-01 00:00:00 +0000
@@ -1,20 +0,0 @@
-#
-# Bug #788722: Second valgrind warning around hp_extract_record in mysql-55-eb-blobs 
-#
-
-CREATE TABLE IF NOT EXISTS local_1_1 (f1 VARCHAR (32) NOT NULL,
-                                      f2 VARCHAR (128) NOT NULL,
-				      f3 BLOB NOT NULL,
-				      f4 TEXT,
-				      f5 BLOB (1024),
-				      PRIMARY KEY (f1),
-				      KEY (f1 , f2)
-) ENGINE=HEAP ROW_FORMAT=DYNAMIC KEY_BLOCK_SIZE = 2048;
-
-INSERT IGNORE INTO local_1_1 VALUES
-       (REPEAT('egqeqfxwaejpqixuvvtentruyqadxiybjdfqjspfbyjdjczrrwjnagkzsoagatqookhsgtrvvbxacppljfzaseidqggxvuirm' , 5), NULL, NULL, NULL, REPEAT('hegqeqfxwaejpqixuvvtentruyqadxiy', 1)),
-       ('you', NULL, 0, REPEAT("X", 2048) , 0);
-
-INSERT IGNORE INTO local_1_1 SELECT * FROM local_1_1;
-
-DROP TABLE local_1_1;
 
=== removed file 'mysql-test/memory_dynamic_rows.patch/percona_heap_bug789131.result'
--- mysql-test/memory_dynamic_rows.patch/percona_heap_bug789131.result	2011-06-06 10:34:16 +0000
+++ mysql-test/memory_dynamic_rows.patch/percona_heap_bug789131.result	1970-01-01 00:00:00 +0000
@@ -1,7 +0,0 @@
-CREATE TABLE t1 (f1 VARCHAR (128), f2 VARCHAR (128), f3 VARBINARY (512),
-f4 TEXT (65525), f5 VARCHAR (128), KEY (f1(1))) ENGINE=HEAP;
-INSERT IGNORE INTO t1 VALUES 
-( 'o' , "" , NULL , "" , 0 ) , 
-(NULL, "" , "" , "" , 'f' ) ;
-INSERT IGNORE INTO t1 SELECT * FROM t1;
-DROP TABLE t1;
 
=== removed file 'mysql-test/memory_dynamic_rows.patch/percona_heap_bug789131.test'
--- mysql-test/memory_dynamic_rows.patch/percona_heap_bug789131.test	2011-08-22 11:28:27 +0000
+++ mysql-test/memory_dynamic_rows.patch/percona_heap_bug789131.test	1970-01-01 00:00:00 +0000
@@ -1,14 +0,0 @@
-#
-# Bug #789131: Valgrind warning in MyISAM in mysql-55-eb-blobs
-#
-
-CREATE TABLE t1 (f1 VARCHAR (128), f2 VARCHAR (128), f3 VARBINARY (512),
-       	     	f4 TEXT (65525), f5 VARCHAR (128), KEY (f1(1))) ENGINE=HEAP;
-
-INSERT IGNORE INTO t1 VALUES 
-       ( 'o' , "" , NULL , "" , 0 ) , 
-       (NULL, "" , "" , "" , 'f' ) ;
-
-INSERT IGNORE INTO t1 SELECT * FROM t1;
-
-DROP TABLE t1;
 \ No newline at end of file
 
=== removed file 'mysql-test/memory_dynamic_rows.patch/percona_heap_var.result'
--- mysql-test/memory_dynamic_rows.patch/percona_heap_var.result	2011-08-22 11:28:27 +0000
+++ mysql-test/memory_dynamic_rows.patch/percona_heap_var.result	1970-01-01 00:00:00 +0000
@@ -1,194 +0,0 @@
-drop table if exists t1;
-set @@session.max_heap_table_size=16*1024*1024;
-create table t1 (a int not null, b varchar(400), c int, primary key (a), key (c)) engine=heap comment="testing heaps" key_block_size=128;
-ERROR 42000: Incorrect usage/placement of 'key_block_size'
-create table t1 (a int not null, b int, c varchar(400), primary key (a), key (b)) engine=heap comment="testing heaps" key_block_size=4;
-ERROR 42000: Incorrect usage/placement of 'key_block_size'
-create table t1 (a int not null, b int, c varchar(400), d varchar(400), primary key (a), key (b)) engine=heap comment="testing heaps" key_block_size=24;
-show table status like "t1";
-Name	t1
-Engine	MEMORY
-Version	10
-Row_format	Dynamic
-Rows	0
-Avg_row_length	X
-Data_length	X
-Max_data_length	X
-Index_length	X
-Data_free	X
-Auto_increment	X
-Create_time	X
-Update_time	X
-Check_time	X
-Collation	latin1_swedish_ci
-Checksum	NULL
-Create_options	KEY_BLOCK_SIZE=24
-Comment	testing heaps
-insert into t1 values (1,1,'012',NULL), (2,2,'0123456789',NULL), (3,3,'012345678901234567890123456789',NULL), (4,4,NULL,'0123456789012345678901234567890123456789012345678901234567890123456789');
-select * from t1;
-a	b	c	d
-1	1	012	NULL
-2	2	0123456789	NULL
-3	3	012345678901234567890123456789	NULL
-4	4	NULL	0123456789012345678901234567890123456789012345678901234567890123456789
-delete from t1 where a = 3;
-select * from t1;
-a	b	c	d
-1	1	012	NULL
-2	2	0123456789	NULL
-4	4	NULL	0123456789012345678901234567890123456789012345678901234567890123456789
-insert into t1 values (5,5,NULL,'0123'), (6,6,NULL,'0123');
-select * from t1;
-a	b	c	d
-1	1	012	NULL
-2	2	0123456789	NULL
-6	6	NULL	0123
-5	5	NULL	0123
-4	4	NULL	0123456789012345678901234567890123456789012345678901234567890123456789
-update t1 set c = '012345678901234567890123456789' where a = 2;
-select * from t1;
-a	b	c	d
-1	1	012	NULL
-2	2	012345678901234567890123456789	NULL
-6	6	NULL	0123
-5	5	NULL	0123
-4	4	NULL	0123456789012345678901234567890123456789012345678901234567890123456789
-update t1 set c = '0123456789' where a = 2;
-select * from t1;
-a	b	c	d
-1	1	012	NULL
-2	2	0123456789	NULL
-6	6	NULL	0123
-5	5	NULL	0123
-4	4	NULL	0123456789012345678901234567890123456789012345678901234567890123456789
-insert into t1 values (7,7,'0123',NULL), (8,8,'0123',NULL);
-select * from t1;
-a	b	c	d
-1	1	012	NULL
-2	2	0123456789	NULL
-6	6	NULL	0123
-5	5	NULL	0123
-4	4	NULL	0123456789012345678901234567890123456789012345678901234567890123456789
-7	7	0123	NULL
-8	8	0123	NULL
-show table status like "t1";
-Name	t1
-Engine	MEMORY
-Version	10
-Row_format	Dynamic
-Rows	7
-Avg_row_length	X
-Data_length	X
-Max_data_length	X
-Index_length	X
-Data_free	X
-Auto_increment	X
-Create_time	X
-Update_time	X
-Check_time	X
-Collation	latin1_swedish_ci
-Checksum	NULL
-Create_options	KEY_BLOCK_SIZE=24
-Comment	testing heaps
-alter table t1 key_block_size = 0;
-show table status like "t1";
-Name	t1
-Engine	MEMORY
-Version	10
-Row_format	Dynamic
-Rows	7
-Avg_row_length	X
-Data_length	X
-Max_data_length	X
-Index_length	X
-Data_free	X
-Auto_increment	X
-Create_time	X
-Update_time	X
-Check_time	X
-Collation	latin1_swedish_ci
-Checksum	NULL
-Create_options	
-Comment	testing heaps
-alter table t1 row_format = dynamic;
-show table status like "t1";
-Name	t1
-Engine	MEMORY
-Version	10
-Row_format	Dynamic
-Rows	7
-Avg_row_length	X
-Data_length	X
-Max_data_length	X
-Index_length	X
-Data_free	X
-Auto_increment	X
-Create_time	X
-Update_time	X
-Check_time	X
-Collation	latin1_swedish_ci
-Checksum	NULL
-Create_options	row_format=DYNAMIC KEY_BLOCK_SIZE=X
-Comment	testing heaps
-alter table t1 key_block_size = 128, max_rows = 10001;
-show table status like "t1";
-Name	t1
-Engine	MEMORY
-Version	10
-Row_format	Dynamic
-Rows	7
-Avg_row_length	X
-Data_length	X
-Max_data_length	X
-Index_length	X
-Data_free	X
-Auto_increment	X
-Create_time	X
-Update_time	X
-Check_time	X
-Collation	latin1_swedish_ci
-Checksum	NULL
-Create_options	max_rows=10001 row_format=DYNAMIC KEY_BLOCK_SIZE=128
-Comment	testing heaps
-select * from t1;
-a	b	c	d
-1	1	012	NULL
-2	2	0123456789	NULL
-6	6	NULL	0123
-5	5	NULL	0123
-4	4	NULL	0123456789012345678901234567890123456789012345678901234567890123456789
-7	7	0123	NULL
-8	8	0123	NULL
-delete from t1;
-select * from t1;
-a	b	c	d
-call mtr.add_suppression("The table 't1' is full");
-select count(*) from t1;
-count(*)
-10001
-insert into t1 values (100000,100000,NULL,'0123'), (100000,100000,NULL,'0123');
-ERROR HY000: The table 't1' is full
-show table status like "t1";
-Name	t1
-Engine	MEMORY
-Version	10
-Row_format	Dynamic
-Rows	10001
-Avg_row_length	X
-Data_length	X
-Max_data_length	X
-Index_length	X
-Data_free	X
-Auto_increment	X
-Create_time	X
-Update_time	X
-Check_time	X
-Collation	latin1_swedish_ci
-Checksum	NULL
-Create_options	max_rows=10001 row_format=DYNAMIC KEY_BLOCK_SIZE=128
-Comment	testing heaps
-select count(*) from t1;
-count(*)
-10001
-set @@session.max_heap_table_size=default;
-drop table t1;
 
=== removed file 'mysql-test/memory_dynamic_rows.patch/percona_heap_var.test'
--- mysql-test/memory_dynamic_rows.patch/percona_heap_var.test	2011-08-22 11:28:27 +0000
+++ mysql-test/memory_dynamic_rows.patch/percona_heap_var.test	1970-01-01 00:00:00 +0000
@@ -1,85 +0,0 @@
-#
-# Test heap tables with variable-sized records.
-#
-
---disable_warnings
-drop table if exists t1;
---enable_warnings
-
-set @@session.max_heap_table_size=16*1024*1024;
-
---error 1234
-create table t1 (a int not null, b varchar(400), c int, primary key (a), key (c)) engine=heap comment="testing heaps" key_block_size=128;
-
---error 1234
-create table t1 (a int not null, b int, c varchar(400), primary key (a), key (b)) engine=heap comment="testing heaps" key_block_size=4;
-
-create table t1 (a int not null, b int, c varchar(400), d varchar(400), primary key (a), key (b)) engine=heap comment="testing heaps" key_block_size=24;
-
---replace_column 6 X 7 X 8 X 9 X 10 X 11 X 12 X 13 X 14 X
---query_vertical show table status like "t1"
-
-insert into t1 values (1,1,'012',NULL), (2,2,'0123456789',NULL), (3,3,'012345678901234567890123456789',NULL), (4,4,NULL,'0123456789012345678901234567890123456789012345678901234567890123456789');
-select * from t1;
-
-delete from t1 where a = 3;
-select * from t1;
-
-insert into t1 values (5,5,NULL,'0123'), (6,6,NULL,'0123');
-select * from t1;
-
-update t1 set c = '012345678901234567890123456789' where a = 2;
-select * from t1;
-
-update t1 set c = '0123456789' where a = 2;
-select * from t1;
-
-insert into t1 values (7,7,'0123',NULL), (8,8,'0123',NULL);
-select * from t1;
-
---replace_column 6 X 7 X 8 X 9 X 10 X 11 X 12 X 13 X 14 X
---query_vertical show table status like "t1"
-alter table t1 key_block_size = 0;
---replace_column 6 X 7 X 8 X 9 X 10 X 11 X 12 X 13 X 14 X
---query_vertical show table status like "t1"
-alter table t1 row_format = dynamic;
---replace_column 6 X 7 X 8 X 9 X 10 X 11 X 12 X 13 X 14 X
---replace_regex /KEY_BLOCK_SIZE=[[:digit:]]+/KEY_BLOCK_SIZE=X/
---query_vertical show table status like "t1"
-alter table t1 key_block_size = 128, max_rows = 10001;
---replace_column 6 X 7 X 8 X 9 X 10 X 11 X 12 X 13 X 14 X
---query_vertical show table status like "t1"
-
-select * from t1;
-
-delete from t1;
-select * from t1;
-
-let $1=10001;
-
-call mtr.add_suppression("The table 't1' is full");
-
-disable_query_log;
-
-while ($1) 
-{
-
-  eval insert into t1 values ($1,$1,$1,$1);
-
-  dec $1;
-
-}
-enable_query_log;
-
-select count(*) from t1;
-
---error 1114
-insert into t1 values (100000,100000,NULL,'0123'), (100000,100000,NULL,'0123');
-
---replace_column 6 X 7 X 8 X 9 X 10 X 11 X 12 X 13 X 14 X
---query_vertical show table status like "t1"
-select count(*) from t1;
-
-set @@session.max_heap_table_size=default;
-
-drop table t1;
 
=== removed file 'mysql-test/percona_innodb_buffer_pool_shm-master.opt'
--- mysql-test/percona_innodb_buffer_pool_shm-master.opt	2010-12-09 18:30:58 +0000
+++ mysql-test/percona_innodb_buffer_pool_shm-master.opt	1970-01-01 00:00:00 +0000
@@ -1,1 +0,0 @@
---innodb_buffer_pool_shm_key=123456
 
=== removed file 'mysql-test/percona_innodb_buffer_pool_shm.result'
--- mysql-test/percona_innodb_buffer_pool_shm.result	2011-06-22 02:59:28 +0000
+++ mysql-test/percona_innodb_buffer_pool_shm.result	1970-01-01 00:00:00 +0000
@@ -1,4 +0,0 @@
-show variables like 'innodb_buffer_pool_shm%';
-Variable_name	Value
-innodb_buffer_pool_shm_checksum	ON
-innodb_buffer_pool_shm_key	123456
 
=== removed file 'mysql-test/percona_innodb_buffer_pool_shm.test'
--- mysql-test/percona_innodb_buffer_pool_shm.test	2011-06-22 02:59:28 +0000
+++ mysql-test/percona_innodb_buffer_pool_shm.test	1970-01-01 00:00:00 +0000
@@ -1,2 +0,0 @@
---source include/have_innodb.inc
-show variables like 'innodb_buffer_pool_shm%';
 
=== removed file 'mysql-test/percona_innodb_doublewrite_file-master.opt'
--- mysql-test/percona_innodb_doublewrite_file-master.opt	2010-12-09 18:30:58 +0000
+++ mysql-test/percona_innodb_doublewrite_file-master.opt	1970-01-01 00:00:00 +0000
@@ -1,1 +0,0 @@
---innodb_doublewrite_file=ib_doublewrite
 
=== removed file 'mysql-test/percona_innodb_doublewrite_file.result'
--- mysql-test/percona_innodb_doublewrite_file.result	2010-12-09 18:30:58 +0000
+++ mysql-test/percona_innodb_doublewrite_file.result	1970-01-01 00:00:00 +0000
@@ -1,4 +0,0 @@
-show variables like 'innodb_doublewrite%';
-Variable_name	Value
-innodb_doublewrite	ON
-innodb_doublewrite_file	ib_doublewrite
 
=== removed file 'mysql-test/percona_innodb_doublewrite_file.test'
--- mysql-test/percona_innodb_doublewrite_file.test	2010-12-09 18:30:58 +0000
+++ mysql-test/percona_innodb_doublewrite_file.test	1970-01-01 00:00:00 +0000
@@ -1,2 +0,0 @@
---source include/have_innodb.inc
-show variables like 'innodb_doublewrite%';
 
=== removed file 'mysql-test/percona_innodb_use_sys_stats_table-master.opt'
--- mysql-test/percona_innodb_use_sys_stats_table-master.opt	2010-12-09 18:30:58 +0000
+++ mysql-test/percona_innodb_use_sys_stats_table-master.opt	1970-01-01 00:00:00 +0000
@@ -1,1 +0,0 @@
---innodb_use_sys_stats_table
 
=== removed file 'mysql-test/percona_innodb_use_sys_stats_table.result'
--- mysql-test/percona_innodb_use_sys_stats_table.result	2010-12-09 18:30:58 +0000
+++ mysql-test/percona_innodb_use_sys_stats_table.result	1970-01-01 00:00:00 +0000
@@ -1,3 +0,0 @@
-show variables like 'innodb_use_sys_stats%';
-Variable_name	Value
-innodb_use_sys_stats_table	ON
 
=== removed file 'mysql-test/percona_innodb_use_sys_stats_table.test'
--- mysql-test/percona_innodb_use_sys_stats_table.test	2010-12-09 18:30:58 +0000
+++ mysql-test/percona_innodb_use_sys_stats_table.test	1970-01-01 00:00:00 +0000
@@ -1,2 +0,0 @@
---source include/have_innodb.inc
-show variables like 'innodb_use_sys_stats%';
 
=== removed file 'mysql-test/percona_server_variables.inc'
--- mysql-test/percona_server_variables.inc	2011-06-23 02:11:07 +0000
+++ mysql-test/percona_server_variables.inc	1970-01-01 00:00:00 +0000
@@ -1,3 +0,0 @@
---source include/have_response_time_distribution.inc
---source include/have_innodb.inc
-SELECT Variable_name FROM INFORMATION_SCHEMA.SESSION_VARIABLES ORDER BY 1;
 
=== removed file 'mysql-test/percona_server_variables_debug.result'
--- mysql-test/percona_server_variables_debug.result	2011-08-04 23:23:45 +0000
+++ mysql-test/percona_server_variables_debug.result	1970-01-01 00:00:00 +0000
@@ -1,372 +0,0 @@
-SELECT Variable_name FROM INFORMATION_SCHEMA.SESSION_VARIABLES ORDER BY 1;
-Variable_name
-AUTOCOMMIT
-AUTOMATIC_SP_PRIVILEGES
-AUTO_INCREMENT_INCREMENT
-AUTO_INCREMENT_OFFSET
-BACK_LOG
-BASEDIR
-BIG_TABLES
-BINLOG_CACHE_SIZE
-BINLOG_DIRECT_NON_TRANSACTIONAL_UPDATES
-BINLOG_FORMAT
-BINLOG_STMT_CACHE_SIZE
-BULK_INSERT_BUFFER_SIZE
-CHARACTER_SETS_DIR
-CHARACTER_SET_CLIENT
-CHARACTER_SET_CONNECTION
-CHARACTER_SET_DATABASE
-CHARACTER_SET_FILESYSTEM
-CHARACTER_SET_RESULTS
-CHARACTER_SET_SERVER
-CHARACTER_SET_SYSTEM
-COLLATION_CONNECTION
-COLLATION_DATABASE
-COLLATION_SERVER
-COMPLETION_TYPE
-CONCURRENT_INSERT
-CONNECT_TIMEOUT
-DATADIR
-DATETIME_FORMAT
-DATE_FORMAT
-DEBUG
-DEBUG_SYNC
-DEFAULT_STORAGE_ENGINE
-DEFAULT_WEEK_FORMAT
-DELAYED_INSERT_LIMIT
-DELAYED_INSERT_TIMEOUT
-DELAYED_QUEUE_SIZE
-DELAY_KEY_WRITE
-DIV_PRECISION_INCREMENT
-ENGINE_CONDITION_PUSHDOWN
-ERROR_COUNT
-EVENT_SCHEDULER
-EXPIRE_LOGS_DAYS
-EXTERNAL_USER
-FAST_INDEX_CREATION
-FLUSH
-FLUSH_TIME
-FOREIGN_KEY_CHECKS
-FT_BOOLEAN_SYNTAX
-FT_MAX_WORD_LEN
-FT_MIN_WORD_LEN
-FT_QUERY_EXPANSION_LIMIT
-FT_STOPWORD_FILE
-GENERAL_LOG
-GENERAL_LOG_FILE
-GROUP_CONCAT_MAX_LEN
-HAVE_COMPRESS
-HAVE_CRYPT
-HAVE_CSV
-HAVE_DYNAMIC_LOADING
-HAVE_GEOMETRY
-HAVE_INNODB
-HAVE_NDBCLUSTER
-HAVE_OPENSSL
-HAVE_PARTITIONING
-HAVE_PROFILING
-HAVE_QUERY_CACHE
-HAVE_RESPONSE_TIME_DISTRIBUTION
-HAVE_RTREE_KEYS
-HAVE_SSL
-HAVE_SYMLINK
-HOSTNAME
-IDENTITY
-IGNORE_BUILTIN_INNODB
-INIT_CONNECT
-INIT_FILE
-INIT_SLAVE
-INNODB_ADAPTIVE_FLUSHING
-INNODB_ADAPTIVE_FLUSHING_METHOD
-INNODB_ADAPTIVE_HASH_INDEX
-INNODB_ADAPTIVE_HASH_INDEX_PARTITIONS
-INNODB_ADDITIONAL_MEM_POOL_SIZE
-INNODB_AUTOEXTEND_INCREMENT
-INNODB_AUTOINC_LOCK_MODE
-INNODB_BUFFER_POOL_INSTANCES
-INNODB_BUFFER_POOL_RESTORE_AT_STARTUP
-INNODB_BUFFER_POOL_SHM_CHECKSUM
-INNODB_BUFFER_POOL_SHM_KEY
-INNODB_BUFFER_POOL_SIZE
-INNODB_CHANGE_BUFFERING
-INNODB_CHANGE_BUFFERING_DEBUG
-INNODB_CHECKPOINT_AGE_TARGET
-INNODB_CHECKSUMS
-INNODB_COMMIT_CONCURRENCY
-INNODB_CONCURRENCY_TICKETS
-INNODB_CORRUPT_TABLE_ACTION
-INNODB_DATA_FILE_PATH
-INNODB_DATA_HOME_DIR
-INNODB_DICT_SIZE_LIMIT
-INNODB_DOUBLEWRITE
-INNODB_DOUBLEWRITE_FILE
-INNODB_FAST_CHECKSUM
-INNODB_FAST_SHUTDOWN
-INNODB_FILE_FORMAT
-INNODB_FILE_FORMAT_CHECK
-INNODB_FILE_FORMAT_MAX
-INNODB_FILE_PER_TABLE
-INNODB_FLUSH_LOG_AT_TRX_COMMIT
-INNODB_FLUSH_METHOD
-INNODB_FLUSH_NEIGHBOR_PAGES
-INNODB_FORCE_RECOVERY
-INNODB_IBUF_ACCEL_RATE
-INNODB_IBUF_ACTIVE_CONTRACT
-INNODB_IBUF_MAX_SIZE
-INNODB_IMPORT_TABLE_FROM_XTRABACKUP
-INNODB_IO_CAPACITY
-INNODB_LARGE_PREFIX
-INNODB_LAZY_DROP_TABLE
-INNODB_LOCKS_UNSAFE_FOR_BINLOG
-INNODB_LOCK_WAIT_TIMEOUT
-INNODB_LOG_BLOCK_SIZE
-INNODB_LOG_BUFFER_SIZE
-INNODB_LOG_FILES_IN_GROUP
-INNODB_LOG_FILE_SIZE
-INNODB_LOG_GROUP_HOME_DIR
-INNODB_MAX_DIRTY_PAGES_PCT
-INNODB_MAX_PURGE_LAG
-INNODB_MIRRORED_LOG_GROUPS
-INNODB_OLD_BLOCKS_PCT
-INNODB_OLD_BLOCKS_TIME
-INNODB_OPEN_FILES
-INNODB_PAGE_SIZE
-INNODB_PURGE_BATCH_SIZE
-INNODB_PURGE_THREADS
-INNODB_READ_AHEAD
-INNODB_READ_AHEAD_THRESHOLD
-INNODB_READ_IO_THREADS
-INNODB_RECOVERY_STATS
-INNODB_RECOVERY_UPDATE_RELAY_LOG
-INNODB_REPLICATION_DELAY
-INNODB_ROLLBACK_ON_TIMEOUT
-INNODB_ROLLBACK_SEGMENTS
-INNODB_SHOW_LOCKS_HELD
-INNODB_SHOW_VERBOSE_LOCKS
-INNODB_SPIN_WAIT_DELAY
-INNODB_STATS_AUTO_UPDATE
-INNODB_STATS_METHOD
-INNODB_STATS_ON_METADATA
-INNODB_STATS_SAMPLE_PAGES
-INNODB_STATS_UPDATE_NEED_LOCK
-INNODB_STRICT_MODE
-INNODB_SUPPORT_XA
-INNODB_SYNC_SPIN_LOOPS
-INNODB_TABLE_LOCKS
-INNODB_THREAD_CONCURRENCY
-INNODB_THREAD_CONCURRENCY_TIMER_BASED
-INNODB_THREAD_SLEEP_DELAY
-INNODB_USE_GLOBAL_FLUSH_LOG_AT_TRX_COMMIT
-INNODB_USE_NATIVE_AIO
-INNODB_USE_SYS_MALLOC
-INNODB_USE_SYS_STATS_TABLE
-INNODB_VERSION
-INNODB_WRITE_IO_THREADS
-INSERT_ID
-INTERACTIVE_TIMEOUT
-JOIN_BUFFER_SIZE
-KEEP_FILES_ON_CREATE
-KEY_BUFFER_SIZE
-KEY_CACHE_AGE_THRESHOLD
-KEY_CACHE_BLOCK_SIZE
-KEY_CACHE_DIVISION_LIMIT
-LARGE_FILES_SUPPORT
-LARGE_PAGES
-LARGE_PAGE_SIZE
-LAST_INSERT_ID
-LC_MESSAGES
-LC_MESSAGES_DIR
-LC_TIME_NAMES
-LICENSE
-LOCAL_INFILE
-LOCKED_IN_MEMORY
-LOCK_WAIT_TIMEOUT
-LOG
-LOG_BIN
-LOG_BIN_TRUST_FUNCTION_CREATORS
-LOG_ERROR
-LOG_OUTPUT
-LOG_QUERIES_NOT_USING_INDEXES
-LOG_SLAVE_UPDATES
-LOG_SLOW_FILTER
-LOG_SLOW_QUERIES
-LOG_SLOW_RATE_LIMIT
-LOG_SLOW_SLAVE_STATEMENTS
-LOG_SLOW_SP_STATEMENTS
-LOG_SLOW_VERBOSITY
-LOG_WARNINGS
-LOG_WARNINGS_SUPPRESS
-LONG_QUERY_TIME
-LOWER_CASE_FILE_SYSTEM
-LOWER_CASE_TABLE_NAMES
-LOW_PRIORITY_UPDATES
-MAX_ALLOWED_PACKET
-MAX_BINLOG_CACHE_SIZE
-MAX_BINLOG_SIZE
-MAX_BINLOG_STMT_CACHE_SIZE
-MAX_CONNECTIONS
-MAX_CONNECT_ERRORS
-MAX_DELAYED_THREADS
-MAX_ERROR_COUNT
-MAX_HEAP_TABLE_SIZE
-MAX_INSERT_DELAYED_THREADS
-MAX_JOIN_SIZE
-MAX_LENGTH_FOR_SORT_DATA
-MAX_LONG_DATA_SIZE
-MAX_PREPARED_STMT_COUNT
-MAX_RELAY_LOG_SIZE
-MAX_SEEKS_FOR_KEY
-MAX_SORT_LENGTH
-MAX_SP_RECURSION_DEPTH
-MAX_TMP_TABLES
-MAX_USER_CONNECTIONS
-MAX_WRITE_LOCK_COUNT
-MIN_EXAMINED_ROW_LIMIT
-MULTI_RANGE_COUNT
-MYISAM_DATA_POINTER_SIZE
-MYISAM_MAX_SORT_FILE_SIZE
-MYISAM_MMAP_SIZE
-MYISAM_RECOVER_OPTIONS
-MYISAM_REPAIR_THREADS
-MYISAM_SORT_BUFFER_SIZE
-MYISAM_STATS_METHOD
-MYISAM_USE_MMAP
-NET_BUFFER_LENGTH
-NET_READ_TIMEOUT
-NET_RETRY_COUNT
-NET_WRITE_TIMEOUT
-NEW
-OLD
-OLD_ALTER_TABLE
-OLD_PASSWORDS
-OPEN_FILES_LIMIT
-OPTIMIZER_FIX
-OPTIMIZER_PRUNE_LEVEL
-OPTIMIZER_SEARCH_DEPTH
-OPTIMIZER_SWITCH
-PERFORMANCE_SCHEMA
-PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_LONG_SIZE
-PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_SIZE
-PERFORMANCE_SCHEMA_MAX_COND_CLASSES
-PERFORMANCE_SCHEMA_MAX_COND_INSTANCES
-PERFORMANCE_SCHEMA_MAX_FILE_CLASSES
-PERFORMANCE_SCHEMA_MAX_FILE_HANDLES
-PERFORMANCE_SCHEMA_MAX_FILE_INSTANCES
-PERFORMANCE_SCHEMA_MAX_MUTEX_CLASSES
-PERFORMANCE_SCHEMA_MAX_MUTEX_INSTANCES
-PERFORMANCE_SCHEMA_MAX_RWLOCK_CLASSES
-PERFORMANCE_SCHEMA_MAX_RWLOCK_INSTANCES
-PERFORMANCE_SCHEMA_MAX_TABLE_HANDLES
-PERFORMANCE_SCHEMA_MAX_TABLE_INSTANCES
-PERFORMANCE_SCHEMA_MAX_THREAD_CLASSES
-PERFORMANCE_SCHEMA_MAX_THREAD_INSTANCES
-PID_FILE
-PLUGIN_DIR
-PORT
-PRELOAD_BUFFER_SIZE
-PROFILING
-PROFILING_HISTORY_SIZE
-PROTOCOL_VERSION
-PROXY_USER
-PSEUDO_THREAD_ID
-QUERY_ALLOC_BLOCK_SIZE
-QUERY_CACHE_LIMIT
-QUERY_CACHE_MIN_RES_UNIT
-QUERY_CACHE_SIZE
-QUERY_CACHE_STRIP_COMMENTS
-QUERY_CACHE_TYPE
-QUERY_CACHE_WLOCK_INVALIDATE
-QUERY_PREALLOC_SIZE
-QUERY_RESPONSE_TIME_RANGE_BASE
-QUERY_RESPONSE_TIME_STATS
-RAND_SEED1
-RAND_SEED2
-RANGE_ALLOC_BLOCK_SIZE
-READ_BUFFER_SIZE
-READ_ONLY
-READ_RND_BUFFER_SIZE
-RELAY_LOG
-RELAY_LOG_INDEX
-RELAY_LOG_INFO_FILE
-RELAY_LOG_PURGE
-RELAY_LOG_RECOVERY
-RELAY_LOG_SPACE_LIMIT
-REPORT_HOST
-REPORT_PASSWORD
-REPORT_PORT
-REPORT_USER
-RPL_RECOVERY_RANK
-SECURE_AUTH
-SECURE_FILE_PRIV
-SERVER_ID
-SKIP_EXTERNAL_LOCKING
-SKIP_NAME_RESOLVE
-SKIP_NETWORKING
-SKIP_SHOW_DATABASE
-SLAVE_COMPRESSED_PROTOCOL
-SLAVE_EXEC_MODE
-SLAVE_LOAD_TMPDIR
-SLAVE_NET_TIMEOUT
-SLAVE_SKIP_ERRORS
-SLAVE_TRANSACTION_RETRIES
-SLAVE_TYPE_CONVERSIONS
-SLOW_LAUNCH_TIME
-SLOW_QUERY_LOG
-SLOW_QUERY_LOG_FILE
-SLOW_QUERY_LOG_TIMESTAMP_ALWAYS
-SLOW_QUERY_LOG_TIMESTAMP_PRECISION
-SLOW_QUERY_LOG_USE_GLOBAL_CONTROL
-SOCKET
-SORT_BUFFER_SIZE
-SQL_AUTO_IS_NULL
-SQL_BIG_SELECTS
-SQL_BIG_TABLES
-SQL_BUFFER_RESULT
-SQL_LOG_BIN
-SQL_LOG_OFF
-SQL_LOW_PRIORITY_UPDATES
-SQL_MAX_JOIN_SIZE
-SQL_MODE
-SQL_NOTES
-SQL_QUOTE_SHOW_CREATE
-SQL_SAFE_UPDATES
-SQL_SELECT_LIMIT
-SQL_SLAVE_SKIP_COUNTER
-SQL_WARNINGS
-SSL_CA
-SSL_CAPATH
-SSL_CERT
-SSL_CIPHER
-SSL_KEY
-STORAGE_ENGINE
-SYNC_BINLOG
-SYNC_FRM
-SYNC_MASTER_INFO
-SYNC_RELAY_LOG
-SYNC_RELAY_LOG_INFO
-SYSTEM_TIME_ZONE
-TABLE_DEFINITION_CACHE
-TABLE_OPEN_CACHE
-THREAD_CACHE_SIZE
-THREAD_CONCURRENCY
-THREAD_HANDLING
-THREAD_STACK
-THREAD_STATISTICS
-TIMED_MUTEXES
-TIMESTAMP
-TIME_FORMAT
-TIME_ZONE
-TMPDIR
-TMP_TABLE_SIZE
-TRANSACTION_ALLOC_BLOCK_SIZE
-TRANSACTION_PREALLOC_SIZE
-TX_ISOLATION
-UNIQUE_CHECKS
-UPDATABLE_VIEWS_WITH_LIMIT
-USERSTAT
-VERSION
-VERSION_COMMENT
-VERSION_COMPILE_MACHINE
-VERSION_COMPILE_OS
-WAIT_TIMEOUT
-WARNING_COUNT
 
=== removed file 'mysql-test/percona_server_variables_debug.test'
--- mysql-test/percona_server_variables_debug.test	2011-06-23 02:11:07 +0000
+++ mysql-test/percona_server_variables_debug.test	1970-01-01 00:00:00 +0000
@@ -1,2 +0,0 @@
---source include/have_debug.inc
---source include/percona_server_variables.inc
 
=== removed file 'mysql-test/percona_server_variables_release.result'
--- mysql-test/percona_server_variables_release.result	2011-08-04 19:16:18 +0000
+++ mysql-test/percona_server_variables_release.result	1970-01-01 00:00:00 +0000
@@ -1,369 +0,0 @@
-SELECT Variable_name FROM INFORMATION_SCHEMA.SESSION_VARIABLES ORDER BY 1;
-Variable_name
-AUTOCOMMIT
-AUTOMATIC_SP_PRIVILEGES
-AUTO_INCREMENT_INCREMENT
-AUTO_INCREMENT_OFFSET
-BACK_LOG
-BASEDIR
-BIG_TABLES
-BINLOG_CACHE_SIZE
-BINLOG_DIRECT_NON_TRANSACTIONAL_UPDATES
-BINLOG_FORMAT
-BINLOG_STMT_CACHE_SIZE
-BULK_INSERT_BUFFER_SIZE
-CHARACTER_SETS_DIR
-CHARACTER_SET_CLIENT
-CHARACTER_SET_CONNECTION
-CHARACTER_SET_DATABASE
-CHARACTER_SET_FILESYSTEM
-CHARACTER_SET_RESULTS
-CHARACTER_SET_SERVER
-CHARACTER_SET_SYSTEM
-COLLATION_CONNECTION
-COLLATION_DATABASE
-COLLATION_SERVER
-COMPLETION_TYPE
-CONCURRENT_INSERT
-CONNECT_TIMEOUT
-DATADIR
-DATETIME_FORMAT
-DATE_FORMAT
-DEFAULT_STORAGE_ENGINE
-DEFAULT_WEEK_FORMAT
-DELAYED_INSERT_LIMIT
-DELAYED_INSERT_TIMEOUT
-DELAYED_QUEUE_SIZE
-DELAY_KEY_WRITE
-DIV_PRECISION_INCREMENT
-ENGINE_CONDITION_PUSHDOWN
-ERROR_COUNT
-EVENT_SCHEDULER
-EXPIRE_LOGS_DAYS
-EXTERNAL_USER
-FAST_INDEX_CREATION
-FLUSH
-FLUSH_TIME
-FOREIGN_KEY_CHECKS
-FT_BOOLEAN_SYNTAX
-FT_MAX_WORD_LEN
-FT_MIN_WORD_LEN
-FT_QUERY_EXPANSION_LIMIT
-FT_STOPWORD_FILE
-GENERAL_LOG
-GENERAL_LOG_FILE
-GROUP_CONCAT_MAX_LEN
-HAVE_COMPRESS
-HAVE_CRYPT
-HAVE_CSV
-HAVE_DYNAMIC_LOADING
-HAVE_GEOMETRY
-HAVE_INNODB
-HAVE_NDBCLUSTER
-HAVE_OPENSSL
-HAVE_PARTITIONING
-HAVE_PROFILING
-HAVE_QUERY_CACHE
-HAVE_RESPONSE_TIME_DISTRIBUTION
-HAVE_RTREE_KEYS
-HAVE_SSL
-HAVE_SYMLINK
-HOSTNAME
-IDENTITY
-IGNORE_BUILTIN_INNODB
-INIT_CONNECT
-INIT_FILE
-INIT_SLAVE
-INNODB_ADAPTIVE_FLUSHING
-INNODB_ADAPTIVE_FLUSHING_METHOD
-INNODB_ADAPTIVE_HASH_INDEX
-INNODB_ADAPTIVE_HASH_INDEX_PARTITIONS
-INNODB_ADDITIONAL_MEM_POOL_SIZE
-INNODB_AUTOEXTEND_INCREMENT
-INNODB_AUTOINC_LOCK_MODE
-INNODB_BUFFER_POOL_INSTANCES
-INNODB_BUFFER_POOL_RESTORE_AT_STARTUP
-INNODB_BUFFER_POOL_SHM_CHECKSUM
-INNODB_BUFFER_POOL_SHM_KEY
-INNODB_BUFFER_POOL_SIZE
-INNODB_CHANGE_BUFFERING
-INNODB_CHECKPOINT_AGE_TARGET
-INNODB_CHECKSUMS
-INNODB_COMMIT_CONCURRENCY
-INNODB_CONCURRENCY_TICKETS
-INNODB_CORRUPT_TABLE_ACTION
-INNODB_DATA_FILE_PATH
-INNODB_DATA_HOME_DIR
-INNODB_DICT_SIZE_LIMIT
-INNODB_DOUBLEWRITE
-INNODB_DOUBLEWRITE_FILE
-INNODB_FAST_CHECKSUM
-INNODB_FAST_SHUTDOWN
-INNODB_FILE_FORMAT
-INNODB_FILE_FORMAT_CHECK
-INNODB_FILE_FORMAT_MAX
-INNODB_FILE_PER_TABLE
-INNODB_FLUSH_LOG_AT_TRX_COMMIT
-INNODB_FLUSH_METHOD
-INNODB_FLUSH_NEIGHBOR_PAGES
-INNODB_FORCE_RECOVERY
-INNODB_IBUF_ACCEL_RATE
-INNODB_IBUF_ACTIVE_CONTRACT
-INNODB_IBUF_MAX_SIZE
-INNODB_IMPORT_TABLE_FROM_XTRABACKUP
-INNODB_IO_CAPACITY
-INNODB_LARGE_PREFIX
-INNODB_LAZY_DROP_TABLE
-INNODB_LOCKS_UNSAFE_FOR_BINLOG
-INNODB_LOCK_WAIT_TIMEOUT
-INNODB_LOG_BLOCK_SIZE
-INNODB_LOG_BUFFER_SIZE
-INNODB_LOG_FILES_IN_GROUP
-INNODB_LOG_FILE_SIZE
-INNODB_LOG_GROUP_HOME_DIR
-INNODB_MAX_DIRTY_PAGES_PCT
-INNODB_MAX_PURGE_LAG
-INNODB_MIRRORED_LOG_GROUPS
-INNODB_OLD_BLOCKS_PCT
-INNODB_OLD_BLOCKS_TIME
-INNODB_OPEN_FILES
-INNODB_PAGE_SIZE
-INNODB_PURGE_BATCH_SIZE
-INNODB_PURGE_THREADS
-INNODB_READ_AHEAD
-INNODB_READ_AHEAD_THRESHOLD
-INNODB_READ_IO_THREADS
-INNODB_RECOVERY_STATS
-INNODB_RECOVERY_UPDATE_RELAY_LOG
-INNODB_REPLICATION_DELAY
-INNODB_ROLLBACK_ON_TIMEOUT
-INNODB_ROLLBACK_SEGMENTS
-INNODB_SHOW_LOCKS_HELD
-INNODB_SHOW_VERBOSE_LOCKS
-INNODB_SPIN_WAIT_DELAY
-INNODB_STATS_AUTO_UPDATE
-INNODB_STATS_METHOD
-INNODB_STATS_ON_METADATA
-INNODB_STATS_SAMPLE_PAGES
-INNODB_STATS_UPDATE_NEED_LOCK
-INNODB_STRICT_MODE
-INNODB_SUPPORT_XA
-INNODB_SYNC_SPIN_LOOPS
-INNODB_TABLE_LOCKS
-INNODB_THREAD_CONCURRENCY
-INNODB_THREAD_CONCURRENCY_TIMER_BASED
-INNODB_THREAD_SLEEP_DELAY
-INNODB_USE_GLOBAL_FLUSH_LOG_AT_TRX_COMMIT
-INNODB_USE_NATIVE_AIO
-INNODB_USE_SYS_MALLOC
-INNODB_USE_SYS_STATS_TABLE
-INNODB_VERSION
-INNODB_WRITE_IO_THREADS
-INSERT_ID
-INTERACTIVE_TIMEOUT
-JOIN_BUFFER_SIZE
-KEEP_FILES_ON_CREATE
-KEY_BUFFER_SIZE
-KEY_CACHE_AGE_THRESHOLD
-KEY_CACHE_BLOCK_SIZE
-KEY_CACHE_DIVISION_LIMIT
-LARGE_FILES_SUPPORT
-LARGE_PAGES
-LARGE_PAGE_SIZE
-LAST_INSERT_ID
-LC_MESSAGES
-LC_MESSAGES_DIR
-LC_TIME_NAMES
-LICENSE
-LOCAL_INFILE
-LOCKED_IN_MEMORY
-LOCK_WAIT_TIMEOUT
-LOG
-LOG_BIN
-LOG_BIN_TRUST_FUNCTION_CREATORS
-LOG_ERROR
-LOG_OUTPUT
-LOG_QUERIES_NOT_USING_INDEXES
-LOG_SLAVE_UPDATES
-LOG_SLOW_FILTER
-LOG_SLOW_QUERIES
-LOG_SLOW_RATE_LIMIT
-LOG_SLOW_SLAVE_STATEMENTS
-LOG_SLOW_SP_STATEMENTS
-LOG_SLOW_VERBOSITY
-LOG_WARNINGS
-LOG_WARNINGS_SUPPRESS
-LONG_QUERY_TIME
-LOWER_CASE_FILE_SYSTEM
-LOWER_CASE_TABLE_NAMES
-LOW_PRIORITY_UPDATES
-MAX_ALLOWED_PACKET
-MAX_BINLOG_CACHE_SIZE
-MAX_BINLOG_SIZE
-MAX_BINLOG_STMT_CACHE_SIZE
-MAX_CONNECTIONS
-MAX_CONNECT_ERRORS
-MAX_DELAYED_THREADS
-MAX_ERROR_COUNT
-MAX_HEAP_TABLE_SIZE
-MAX_INSERT_DELAYED_THREADS
-MAX_JOIN_SIZE
-MAX_LENGTH_FOR_SORT_DATA
-MAX_LONG_DATA_SIZE
-MAX_PREPARED_STMT_COUNT
-MAX_RELAY_LOG_SIZE
-MAX_SEEKS_FOR_KEY
-MAX_SORT_LENGTH
-MAX_SP_RECURSION_DEPTH
-MAX_TMP_TABLES
-MAX_USER_CONNECTIONS
-MAX_WRITE_LOCK_COUNT
-MIN_EXAMINED_ROW_LIMIT
-MULTI_RANGE_COUNT
-MYISAM_DATA_POINTER_SIZE
-MYISAM_MAX_SORT_FILE_SIZE
-MYISAM_MMAP_SIZE
-MYISAM_RECOVER_OPTIONS
-MYISAM_REPAIR_THREADS
-MYISAM_SORT_BUFFER_SIZE
-MYISAM_STATS_METHOD
-MYISAM_USE_MMAP
-NET_BUFFER_LENGTH
-NET_READ_TIMEOUT
-NET_RETRY_COUNT
-NET_WRITE_TIMEOUT
-NEW
-OLD
-OLD_ALTER_TABLE
-OLD_PASSWORDS
-OPEN_FILES_LIMIT
-OPTIMIZER_FIX
-OPTIMIZER_PRUNE_LEVEL
-OPTIMIZER_SEARCH_DEPTH
-OPTIMIZER_SWITCH
-PERFORMANCE_SCHEMA
-PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_LONG_SIZE
-PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_SIZE
-PERFORMANCE_SCHEMA_MAX_COND_CLASSES
-PERFORMANCE_SCHEMA_MAX_COND_INSTANCES
-PERFORMANCE_SCHEMA_MAX_FILE_CLASSES
-PERFORMANCE_SCHEMA_MAX_FILE_HANDLES
-PERFORMANCE_SCHEMA_MAX_FILE_INSTANCES
-PERFORMANCE_SCHEMA_MAX_MUTEX_CLASSES
-PERFORMANCE_SCHEMA_MAX_MUTEX_INSTANCES
-PERFORMANCE_SCHEMA_MAX_RWLOCK_CLASSES
-PERFORMANCE_SCHEMA_MAX_RWLOCK_INSTANCES
-PERFORMANCE_SCHEMA_MAX_TABLE_HANDLES
-PERFORMANCE_SCHEMA_MAX_TABLE_INSTANCES
-PERFORMANCE_SCHEMA_MAX_THREAD_CLASSES
-PERFORMANCE_SCHEMA_MAX_THREAD_INSTANCES
-PID_FILE
-PLUGIN_DIR
-PORT
-PRELOAD_BUFFER_SIZE
-PROFILING
-PROFILING_HISTORY_SIZE
-PROTOCOL_VERSION
-PROXY_USER
-PSEUDO_THREAD_ID
-QUERY_ALLOC_BLOCK_SIZE
-QUERY_CACHE_LIMIT
-QUERY_CACHE_MIN_RES_UNIT
-QUERY_CACHE_SIZE
-QUERY_CACHE_STRIP_COMMENTS
-QUERY_CACHE_TYPE
-QUERY_CACHE_WLOCK_INVALIDATE
-QUERY_PREALLOC_SIZE
-QUERY_RESPONSE_TIME_RANGE_BASE
-QUERY_RESPONSE_TIME_STATS
-RAND_SEED1
-RAND_SEED2
-RANGE_ALLOC_BLOCK_SIZE
-READ_BUFFER_SIZE
-READ_ONLY
-READ_RND_BUFFER_SIZE
-RELAY_LOG
-RELAY_LOG_INDEX
-RELAY_LOG_INFO_FILE
-RELAY_LOG_PURGE
-RELAY_LOG_RECOVERY
-RELAY_LOG_SPACE_LIMIT
-REPORT_HOST
-REPORT_PASSWORD
-REPORT_PORT
-REPORT_USER
-RPL_RECOVERY_RANK
-SECURE_AUTH
-SECURE_FILE_PRIV
-SERVER_ID
-SKIP_EXTERNAL_LOCKING
-SKIP_NAME_RESOLVE
-SKIP_NETWORKING
-SKIP_SHOW_DATABASE
-SLAVE_COMPRESSED_PROTOCOL
-SLAVE_EXEC_MODE
-SLAVE_LOAD_TMPDIR
-SLAVE_NET_TIMEOUT
-SLAVE_SKIP_ERRORS
-SLAVE_TRANSACTION_RETRIES
-SLAVE_TYPE_CONVERSIONS
-SLOW_LAUNCH_TIME
-SLOW_QUERY_LOG
-SLOW_QUERY_LOG_FILE
-SLOW_QUERY_LOG_TIMESTAMP_ALWAYS
-SLOW_QUERY_LOG_TIMESTAMP_PRECISION
-SLOW_QUERY_LOG_USE_GLOBAL_CONTROL
-SOCKET
-SORT_BUFFER_SIZE
-SQL_AUTO_IS_NULL
-SQL_BIG_SELECTS
-SQL_BIG_TABLES
-SQL_BUFFER_RESULT
-SQL_LOG_BIN
-SQL_LOG_OFF
-SQL_LOW_PRIORITY_UPDATES
-SQL_MAX_JOIN_SIZE
-SQL_MODE
-SQL_NOTES
-SQL_QUOTE_SHOW_CREATE
-SQL_SAFE_UPDATES
-SQL_SELECT_LIMIT
-SQL_SLAVE_SKIP_COUNTER
-SQL_WARNINGS
-SSL_CA
-SSL_CAPATH
-SSL_CERT
-SSL_CIPHER
-SSL_KEY
-STORAGE_ENGINE
-SYNC_BINLOG
-SYNC_FRM
-SYNC_MASTER_INFO
-SYNC_RELAY_LOG
-SYNC_RELAY_LOG_INFO
-SYSTEM_TIME_ZONE
-TABLE_DEFINITION_CACHE
-TABLE_OPEN_CACHE
-THREAD_CACHE_SIZE
-THREAD_CONCURRENCY
-THREAD_HANDLING
-THREAD_STACK
-THREAD_STATISTICS
-TIMED_MUTEXES
-TIMESTAMP
-TIME_FORMAT
-TIME_ZONE
-TMPDIR
-TMP_TABLE_SIZE
-TRANSACTION_ALLOC_BLOCK_SIZE
-TRANSACTION_PREALLOC_SIZE
-TX_ISOLATION
-UNIQUE_CHECKS
-UPDATABLE_VIEWS_WITH_LIMIT
-USERSTAT
-VERSION
-VERSION_COMMENT
-VERSION_COMPILE_MACHINE
-VERSION_COMPILE_OS
-WAIT_TIMEOUT
-WARNING_COUNT
 
=== removed file 'mysql-test/percona_server_variables_release.test'
--- mysql-test/percona_server_variables_release.test	2011-06-23 02:11:07 +0000
+++ mysql-test/percona_server_variables_release.test	1970-01-01 00:00:00 +0000
@@ -1,2 +0,0 @@
---source include/have_nodebug.inc
---source include/percona_server_variables.inc
 
=== removed file 'mysql-test/percona_show_temp_tables.result'
--- mysql-test/percona_show_temp_tables.result	2010-12-09 18:30:58 +0000
+++ mysql-test/percona_show_temp_tables.result	1970-01-01 00:00:00 +0000
@@ -1,58 +0,0 @@
-drop table if exists t1,t2,t3;
-drop database if exists showtemp;
-create database if not exists showtemp;
-use test;
-create temporary table t1(id int);
-create temporary table t2(id int);
-create temporary table showtemp.t3(id int);
-insert into t1 values(10),(20),(30),(40);
-insert into showtemp.t3 values(999);
-show temporary tables;
-Temp_tables_in_test
-t2
-t1
-show temporary tables from test;
-Temp_tables_in_test
-t2
-t1
-show temporary tables in showtemp;
-Temp_tables_in_showtemp
-t3
-select table_schema, table_name, engine, table_rows from Information_schema.temporary_tables;
-table_schema	table_name	engine	table_rows
-showtemp	t3	MyISAM	1
-test	t2	MyISAM	0
-test	t1	MyISAM	4
-select table_schema, table_name, engine, table_rows from Information_schema.global_temporary_tables;
-table_schema	table_name	engine	table_rows
-showtemp	t3	MyISAM	1
-test	t2	MyISAM	0
-test	t1	MyISAM	4
-select table_schema, table_name, engine, table_rows from Information_schema.global_temporary_tables where table_schema='showtemp';
-table_schema	table_name	engine	table_rows
-showtemp	t3	MyISAM	1
-select table_schema, table_name, engine, table_rows from Information_schema.global_temporary_tables where table_schema='temp';
-table_schema	table_name	engine	table_rows
-drop table if exists showtemp.t2;
-create temporary table t1(id int);
-create temporary table showtemp.t2(id int);
-show temporary tables;
-Temp_tables_in_test
-t1
-select table_schema, table_name, engine, table_rows from Information_schema.global_temporary_tables;
-table_schema	table_name	engine	table_rows
-showtemp	t2	MyISAM	0
-test	t1	MyISAM	0
-showtemp	t3	MyISAM	1
-test	t2	MyISAM	0
-test	t1	MyISAM	4
-drop table showtemp.t2;
-drop table t1;
-select table_schema, table_name, engine, table_rows from Information_schema.global_temporary_tables;
-table_schema	table_name	engine	table_rows
-showtemp	t3	MyISAM	1
-test	t2	MyISAM	0
-test	t1	MyISAM	4
-drop table t1, t2;
-drop table showtemp.t3;
-drop database showtemp;
 
=== removed file 'mysql-test/percona_show_temp_tables.test'
--- mysql-test/percona_show_temp_tables.test	2010-12-09 18:30:58 +0000
+++ mysql-test/percona_show_temp_tables.test	1970-01-01 00:00:00 +0000
@@ -1,65 +0,0 @@
-# Uses GRANT commands that usually disabled in embedded server
--- source include/not_embedded.inc
-
-# Save the initial number of concurrent sessions
---source include/count_sessions.inc
-
-#
-# Test of SHOW [GLOBAL] TEMPORARY TABLES [FROM/IN] DB and 
-# Information_schema.temporary_tables and global_temporary_tables
-#
-
-connect(stcon1,localhost,root,,test);
-connect(stcon2,localhost,root,,test);
-
-connection stcon1;
-
---disable_warnings
-drop table if exists t1,t2,t3;
-drop database if exists showtemp;
-create database if not exists showtemp;
---enable_warnings
-
-use test;
-create temporary table t1(id int);
-create temporary table t2(id int);
-create temporary table showtemp.t3(id int);
-insert into t1 values(10),(20),(30),(40);
-insert into showtemp.t3 values(999);
-
-show temporary tables;
-# "Session" is not same value always. mysql-test cannot test it always.
-#show global temporary tables;
-show temporary tables from test;
-show temporary tables in showtemp;
-select table_schema, table_name, engine, table_rows from Information_schema.temporary_tables;
-select table_schema, table_name, engine, table_rows from Information_schema.global_temporary_tables;
-select table_schema, table_name, engine, table_rows from Information_schema.global_temporary_tables where table_schema='showtemp';
-select table_schema, table_name, engine, table_rows from Information_schema.global_temporary_tables where table_schema='temp';
-
-connection stcon2;
-
---disable_warnings
-drop table if exists showtemp.t2;
---enable_warnings
-create temporary table t1(id int);
-create temporary table showtemp.t2(id int);
-show temporary tables;
-select table_schema, table_name, engine, table_rows from Information_schema.global_temporary_tables;
-drop table showtemp.t2;
-drop table t1;
-
-disconnect stcon2;
-
-connection stcon1;
-select table_schema, table_name, engine, table_rows from Information_schema.global_temporary_tables;
-
-drop table t1, t2;
-drop table showtemp.t3;
-drop database showtemp;
-
-connection default;
-disconnect stcon1;
-
-# Wait till all disconnects are completed
---source include/wait_until_count_sessions.inc
 
=== removed file 'mysql-test/percona_xtradb_admin_command.result'
--- mysql-test/percona_xtradb_admin_command.result	2010-12-09 18:30:58 +0000
+++ mysql-test/percona_xtradb_admin_command.result	1970-01-01 00:00:00 +0000
@@ -1,6 +0,0 @@
-select * from information_schema.XTRADB_ADMIN_COMMAND;
-result_message
-No XTRA_* command in the SQL statement. Please add /*!XTRA_xxxx*/ to the SQL.
-select * from information_schema.XTRADB_ADMIN_COMMAND /*!XTRA_HELLO*/;
-result_message
-Hello!
 
=== removed file 'mysql-test/percona_xtradb_admin_command.test'
--- mysql-test/percona_xtradb_admin_command.test	2010-12-09 18:30:58 +0000
+++ mysql-test/percona_xtradb_admin_command.test	1970-01-01 00:00:00 +0000
@@ -1,3 +0,0 @@
---source include/have_innodb.inc
-select * from information_schema.XTRADB_ADMIN_COMMAND;
-select * from information_schema.XTRADB_ADMIN_COMMAND /*!XTRA_HELLO*/;
 
=== removed file 'mysql-test/percona_xtradb_bug317074.result'
--- mysql-test/percona_xtradb_bug317074.result	2011-01-13 04:34:53 +0000
+++ mysql-test/percona_xtradb_bug317074.result	1970-01-01 00:00:00 +0000
@@ -1,5 +0,0 @@
-SET @old_innodb_file_format=@@innodb_file_format;
-SET @old_innodb_file_format_max=@@innodb_file_format_max;
-SET @old_innodb_file_per_table=@@innodb_file_per_table;
-SET GLOBAL innodb_file_format='Barracuda';
-SET GLOBAL innodb_file_per_table=ON;
 
=== removed file 'mysql-test/percona_xtradb_bug317074.test'
--- mysql-test/percona_xtradb_bug317074.test	2011-01-13 04:34:53 +0000
+++ mysql-test/percona_xtradb_bug317074.test	1970-01-01 00:00:00 +0000
@@ -1,47 +0,0 @@
--- source include/have_innodb.inc
-
-SET @old_innodb_file_format=@@innodb_file_format;
-SET @old_innodb_file_format_max=@@innodb_file_format_max;
-SET @old_innodb_file_per_table=@@innodb_file_per_table;
-SET GLOBAL innodb_file_format='Barracuda';
-SET GLOBAL innodb_file_per_table=ON;
-
--- disable_query_log
--- disable_result_log
-
-DROP TABLE IF EXISTS `test1`;
-CREATE TABLE IF NOT EXISTS `test1` (
- `a` int primary key auto_increment,
- `b` int default 0,
- `c` char(100) default 'testtest'
-) ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8;
-
-delimiter |;
-CREATE PROCEDURE insert_many(p1 int)
-BEGIN
-SET @x = 0;
-SET @y = 0;
-start transaction;
-REPEAT
-  insert into test1 set b=1;
-  SET @x = @x + 1;
-  SET @y = @y + 1;
-  IF @y >= 1000 THEN
-    commit;
-    start transaction;
-    SET @y = 0;
-  END IF;
-UNTIL @x >= p1 END REPEAT;
-commit;
-END|
-delimiter ;|
-call insert_many(100000);
-DROP PROCEDURE insert_many;
-
-# The bug is hangup at the following statement
-ALTER TABLE test1 ENGINE=MyISAM;
-
-DROP TABLE test1;
-SET GLOBAL innodb_file_format=@old_innodb_file_format;
-SET GLOBAL innodb_file_format_max=@old_innodb_file_format_max;
-SET GLOBAL innodb_file_per_table=@old_innodb_file_per_table;
 
=== removed directory 'mysql-test/processlist_row_stats.patch'
=== removed file 'mysql-test/processlist_row_stats.patch/percona_processlist_row_stats.result'
--- mysql-test/processlist_row_stats.patch/percona_processlist_row_stats.result	2011-08-03 16:08:46 +0000
+++ mysql-test/processlist_row_stats.patch/percona_processlist_row_stats.result	1970-01-01 00:00:00 +0000
@@ -1,70 +0,0 @@
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
-CREATE TABLE t2 (a INT);
-INSERT INTO t2 VALUES(10);
-INSERT INTO t2 VALUES(10);
-INSERT INTO t2 VALUES(20);
-INSERT INTO t2 VALUES(10);
-INSERT INTO t2 VALUES(20);
-SET DEBUG_SYNC= 'locked_table_name SIGNAL thread1_ready WAIT_FOR threads_dumped';
-CREATE TABLE t1 (a INT);
-SET DEBUG_SYNC= 'now WAIT_FOR thread1_ready';
-SET DEBUG_SYNC= 'execute_command_after_close_tables SIGNAL thread2_ready WAIT_FOR threads_dumped';
-SELECT a FROM t2 WHERE a > 15;
-SET DEBUG_SYNC= 'now WAIT_FOR thread2_ready';
-SHOW PROCESSLIST;
-Id	User	Host	db	Command	Time	State	Info	Rows_sent	Rows_examined	Rows_read
-###	root	###	test	Query	###	###	SHOW PROCESSLIST	0	0	2
-###	root	###	test	Query	###	###	CREATE TABLE t1 (a INT)	0	0	1
-###	root	###	test	Query	###	###	SELECT a FROM t2 WHERE a > 15	2	5	6
-SELECT id, info, rows_sent, rows_examined, rows_read FROM INFORMATION_SCHEMA.PROCESSLIST ORDER BY id;
-id	info	rows_sent	rows_examined	rows_read
-###	SELECT id, info, rows_sent, rows_examined, rows_read FROM INFORMATION_SCHEMA.PROCESSLIST ORDER BY id	0	0	1
-###	CREATE TABLE t1 (a INT)	0	0	1
-###	SELECT a FROM t2 WHERE a > 15	2	5	6
-SET DEBUG_SYNC= 'now SIGNAL threads_dumped';
-a
-20
-20
-SET DEBUG_SYNC= 'sent_row SIGNAL thread1_ready WAIT_FOR threads_dumped';
-SELECT a FROM t2 WHERE a < 15;
-SET DEBUG_SYNC= 'now WAIT_FOR thread1_ready';
-SET DEBUG_SYNC= 'sent_row SIGNAL thread2_ready WAIT_FOR threads_dumped';
-SELECT a FROM t2 WHERE a > 15;
-SET DEBUG_SYNC= 'now WAIT_FOR thread2_ready';
-SHOW PROCESSLIST;
-Id	User	Host	db	Command	Time	State	Info	Rows_sent	Rows_examined	Rows_read
-###	root	###	test	Query	###	###	SHOW PROCESSLIST	0	0	4
-###	root	###	test	Query	###	###	SELECT a FROM t2 WHERE a < 15	1	0	1
-###	root	###	test	Query	###	###	SELECT a FROM t2 WHERE a > 15	1	0	3
-SELECT id, info, rows_sent, rows_examined, rows_read FROM INFORMATION_SCHEMA.PROCESSLIST ORDER BY id;
-id	info	rows_sent	rows_examined	rows_read
-###	SELECT id, info, rows_sent, rows_examined, rows_read FROM INFORMATION_SCHEMA.PROCESSLIST ORDER BY id	0	0	1
-###	SELECT a FROM t2 WHERE a < 15	1	0	1
-###	SELECT a FROM t2 WHERE a > 15	1	0	3
-SET DEBUG_SYNC= 'now SIGNAL threads_dumped';
-a
-10
-10
-10
-a
-20
-20
-SET DEBUG_SYNC= 'execute_command_after_close_tables SIGNAL thread1_ready WAIT_FOR threads_dumped';
-UPDATE t2 SET a = 15 WHERE a = 20;
-SET DEBUG_SYNC= 'now WAIT_FOR thread1_ready';
-SET DEBUG_SYNC= 'execute_command_after_close_tables SIGNAL thread2_ready WAIT_FOR threads_dumped';
-UPDATE t2 SET a = 15 WHERE a = 10;
-SET DEBUG_SYNC= 'now WAIT_FOR thread2_ready';
-SHOW PROCESSLIST;
-Id	User	Host	db	Command	Time	State	Info	Rows_sent	Rows_examined	Rows_read
-###	root	###	test	Query	###	###	SHOW PROCESSLIST	0	0	4
-###	root	###	test	Query	###	###	UPDATE t2 SET a = 15 WHERE a = 20	0	5	6
-###	root	###	test	Query	###	###	UPDATE t2 SET a = 15 WHERE a = 10	0	5	6
-SELECT id, info, rows_sent, rows_examined, rows_read FROM INFORMATION_SCHEMA.PROCESSLIST ORDER BY id;
-id	info	rows_sent	rows_examined	rows_read
-###	SELECT id, info, rows_sent, rows_examined, rows_read FROM INFORMATION_SCHEMA.PROCESSLIST ORDER BY id	0	0	1
-###	UPDATE t2 SET a = 15 WHERE a = 20	0	5	6
-###	UPDATE t2 SET a = 15 WHERE a = 10	0	5	6
-SET DEBUG_SYNC= 'now SIGNAL threads_dumped';
-DROP TABLES t1, t2;
 
=== removed file 'mysql-test/processlist_row_stats.patch/percona_processlist_row_stats.test'
--- mysql-test/processlist_row_stats.patch/percona_processlist_row_stats.test	2011-08-03 16:08:46 +0000
+++ mysql-test/processlist_row_stats.patch/percona_processlist_row_stats.test	1970-01-01 00:00:00 +0000
@@ -1,79 +0,0 @@
-# Testing of INFORMATION_SCHEMA.PROCESSLIST fields ROWS_SENT, ROWS_EXAMINED, ROWS_READ
---source include/have_debug_sync.inc
-
---disable_warnings
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
---enable_warnings
-
-CREATE TABLE t2 (a INT);
-INSERT INTO t2 VALUES(10);
-INSERT INTO t2 VALUES(10);
-INSERT INTO t2 VALUES(20);
-INSERT INTO t2 VALUES(10);
-INSERT INTO t2 VALUES(20);
-
---connect (conn1, localhost, root, ,)
---connect (conn2, localhost, root, ,)
-
---connection conn1
-SET DEBUG_SYNC= 'locked_table_name SIGNAL thread1_ready WAIT_FOR threads_dumped';
-send CREATE TABLE t1 (a INT);
---connection default
-SET DEBUG_SYNC= 'now WAIT_FOR thread1_ready';
-
---connection conn2
-SET DEBUG_SYNC= 'execute_command_after_close_tables SIGNAL thread2_ready WAIT_FOR threads_dumped';
-send SELECT a FROM t2 WHERE a > 15;
---connection default
-SET DEBUG_SYNC= 'now WAIT_FOR thread2_ready';
-
---source include/percona_processlist_row_stats_show.inc
-
---connection conn1
-reap;
---connection conn2
-reap;
-
---connection conn1
-SET DEBUG_SYNC= 'sent_row SIGNAL thread1_ready WAIT_FOR threads_dumped';
-send SELECT a FROM t2 WHERE a < 15;
---connection default
-SET DEBUG_SYNC= 'now WAIT_FOR thread1_ready';
-
---connection conn2
-SET DEBUG_SYNC= 'sent_row SIGNAL thread2_ready WAIT_FOR threads_dumped';
-send SELECT a FROM t2 WHERE a > 15;
---connection default
-SET DEBUG_SYNC= 'now WAIT_FOR thread2_ready';
-
---source include/percona_processlist_row_stats_show.inc
-
---connection conn1
-reap;
---connection conn2
-reap;
-
---connection conn1
-SET DEBUG_SYNC= 'execute_command_after_close_tables SIGNAL thread1_ready WAIT_FOR threads_dumped';
-send UPDATE t2 SET a = 15 WHERE a = 20;
---connection default
-SET DEBUG_SYNC= 'now WAIT_FOR thread1_ready';
-
---connection conn2
-SET DEBUG_SYNC= 'execute_command_after_close_tables SIGNAL thread2_ready WAIT_FOR threads_dumped';
-send UPDATE t2 SET a = 15 WHERE a = 10;
---connection default
-SET DEBUG_SYNC= 'now WAIT_FOR thread2_ready';
-
---source include/percona_processlist_row_stats_show.inc
-
---connection conn1
-reap;
---connection conn2
-reap;
-
---connection default
-disconnect conn1;
-disconnect conn2;
-DROP TABLES t1, t2;
 
=== removed file 'mysql-test/processlist_row_stats.patch/percona_processlist_row_stats_show.inc'
--- mysql-test/processlist_row_stats.patch/percona_processlist_row_stats_show.inc	2011-08-03 16:08:46 +0000
+++ mysql-test/processlist_row_stats.patch/percona_processlist_row_stats_show.inc	1970-01-01 00:00:00 +0000
@@ -1,7 +0,0 @@
---replace_column 1 ### 3 ### 6 ### 7 ###
-SHOW PROCESSLIST;
-
---replace_column 1 ###
-SELECT id, info, rows_sent, rows_examined, rows_read FROM INFORMATION_SCHEMA.PROCESSLIST ORDER BY id;
-
-SET DEBUG_SYNC= 'now SIGNAL threads_dumped';
 
=== removed directory 'mysql-test/query_cache_enhance.patch'
=== removed file 'mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments.inc'
--- mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments.inc	2010-12-09 18:30:58 +0000
+++ mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments.inc	1970-01-01 00:00:00 +0000
@@ -1,95 +0,0 @@
---source include/percona_query_cache_with_comments_clear.inc
-let $query=/* with comment first */select * from t1;
-eval $query;
---source include/percona_query_cache_with_comments_eval.inc
-
-let $query=# with comment first
-select * from t1;
---source include/percona_query_cache_with_comments_eval.inc
-
-let $query=-- with comment first
-select * from t1;
---source include/percona_query_cache_with_comments_eval.inc
-
-let $query=/* with comment first and "quote" */select * from t1;
---source include/percona_query_cache_with_comments_eval.inc
-
-let $query=# with comment first and "quote"
-select * from t1;
---source include/percona_query_cache_with_comments_eval.inc
-
-let $query=-- with comment first and "quote" 
-select * from t1;
---source include/percona_query_cache_with_comments_eval.inc
-
-let $query=
-    /* with comment and whitespaces first */select * from t1;
---source include/percona_query_cache_with_comments_eval.inc
-
-let $query= 
-    # with comment and whitespaces first
-select * from t1;
---source include/percona_query_cache_with_comments_eval.inc
-
-let $query=
-    -- with comment and whitespaces first
-select * from t1;
---source include/percona_query_cache_with_comments_eval.inc
-
-let $internal=* internal comment *;
-
-let $query=select * /$internal/ from t1;
---source include/percona_query_cache_with_comments_eval.inc
-let $query=select */$internal/ from t1;
---source include/percona_query_cache_with_comments_eval.inc
-let $query=select */$internal/from t1;
---source include/percona_query_cache_with_comments_eval.inc
-
-let $internal=* internal comment with "quote" *;
-
-let $query=select * /$internal/ from t1;
---source include/percona_query_cache_with_comments_eval.inc
-let $query=select */$internal/ from t1;
---source include/percona_query_cache_with_comments_eval.inc
-let $query=select */$internal/from t1;
---source include/percona_query_cache_with_comments_eval.inc
-
-let $query=select * from t1
-;
---source include/percona_query_cache_with_comments_eval.inc
-
-let $query=select * from t1 ;
---source include/percona_query_cache_with_comments_eval.inc
-
-let $query=select * from t1	;
---source include/percona_query_cache_with_comments_eval.inc
-
-let $query=select * from t1
-/* comment in the end */;
---source include/percona_query_cache_with_comments_eval.inc
-
-let $query=select * from t1
-/* *\/ */;
---source include/percona_query_cache_with_comments_eval.inc
-
-let $query=select * from t1
-/* comment in the end */
-;
---source include/percona_query_cache_with_comments_eval.inc
-
-let $query=select * from t1 #comment in the end;
---source include/percona_query_cache_with_comments_eval.inc
-
-let $query=select * from t1 #comment in the end
-;
---source include/percona_query_cache_with_comments_eval.inc
-
-let $query=select * from t1 -- comment in the end;
---source include/percona_query_cache_with_comments_eval.inc
-
-let $query=select * from t1 -- comment in the end
-;
---source include/percona_query_cache_with_comments_eval.inc
-
-let $query=select ' \'  ' from t1;
---source include/percona_query_cache_with_comments_eval.inc
 
=== removed file 'mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments.inc.backup'
--- mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments.inc.backup	2010-12-09 18:30:58 +0000
+++ mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments.inc.backup	1970-01-01 00:00:00 +0000
@@ -1,88 +0,0 @@
---source include/percona_query_cache_with_comments_clear.inc
-let $query=/* with comment first */select * from t1;
-eval $query;
---source include/percona_query_cache_with_comments_eval.inc
-
-let $query=# with comment first
-select * from t1;
---source include/percona_query_cache_with_comments_eval.inc
-
-let $query=-- with comment first
-select * from t1;
---source include/percona_query_cache_with_comments_eval.inc
-
-let $query=/* with comment first and "quote" */select * from t1;
---source include/percona_query_cache_with_comments_eval.inc
-
-let $query=# with comment first and "quote"
-select * from t1;
---source include/percona_query_cache_with_comments_eval.inc
-
-let $query=-- with comment first and "quote" 
-select * from t1;
---source include/percona_query_cache_with_comments_eval.inc
-
-let $query=
-    /* with comment and whitespaces first */select * from t1;
---source include/percona_query_cache_with_comments_eval.inc
-
-let $query= 
-    # with comment and whitespaces first
-select * from t1;
---source include/percona_query_cache_with_comments_eval.inc
-
-let $query=
-    -- with comment and whitespaces first
-select * from t1;
---source include/percona_query_cache_with_comments_eval.inc
-
-let $internal=* internal comment *;
-
-let $query=select * /$internal/ from t1;
---source include/percona_query_cache_with_comments_eval.inc
-let $query=select */$internal/ from t1;
---source include/percona_query_cache_with_comments_eval.inc
-let $query=select */$internal/from t1;
---source include/percona_query_cache_with_comments_eval.inc
-
-let $internal=* internal comment with "quote" *;
-
-let $query=select * /$internal/ from t1;
---source include/percona_query_cache_with_comments_eval.inc
-let $query=select */$internal/ from t1;
---source include/percona_query_cache_with_comments_eval.inc
-let $query=select */$internal/from t1;
---source include/percona_query_cache_with_comments_eval.inc
-
-let $query=select * from t1
-;
---source include/percona_query_cache_with_comments_eval.inc
-
-let $query=select * from t1 ;
---source include/percona_query_cache_with_comments_eval.inc
-
-let $query=select * from t1	;
---source include/percona_query_cache_with_comments_eval.inc
-
-let $query=select * from t1
-/* comment in the end */;
---source include/percona_query_cache_with_comments_eval.inc
-
-let $query=select * from t1
-/* comment in the end */
-;
---source include/percona_query_cache_with_comments_eval.inc
-
-let $query=select * from t1 #comment in the end;
---source include/percona_query_cache_with_comments_eval.inc
-
-let $query=select * from t1 #comment in the end
-;
---source include/percona_query_cache_with_comments_eval.inc
-
-let $query=select * from t1 -- comment in the end;
---source include/percona_query_cache_with_comments_eval.inc
-
-let $query=select * from t1 -- comment in the end
-;
---source include/percona_query_cache_with_comments_eval.inc
 
=== removed file 'mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments.result'
--- mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments.result	2010-12-09 18:30:58 +0000
+++ mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments.result	1970-01-01 00:00:00 +0000
@@ -1,866 +0,0 @@
-set global query_cache_strip_comments=ON;
-set GLOBAL query_cache_size=1355776;
-drop table if exists t1;
-create table t1 (a int not null);
-insert into t1 values (1),(2),(3);
-flush query cache;
-flush query cache;
-reset query cache;
-flush status;
-flush query cache;
-flush query cache;
-reset query cache;
-flush status;
-/* with comment first */select * from t1;
-a
-1
-2
-3
------------------------------------------------------
-/* with comment first */select * from t1
------------------------------------------------------
-show status like "Qcache_queries_in_cache";
-Variable_name	Value
-Qcache_queries_in_cache	1
-show status like "Qcache_inserts";
-Variable_name	Value
-Qcache_inserts	1
-show status like "Qcache_hits";
-Variable_name	Value
-Qcache_hits	0
-/* with comment first */select * from t1;
-a
-1
-2
-3
-/* with comment first */select * from t1;
-a
-1
-2
-3
-show status like "Qcache_queries_in_cache";
-Variable_name	Value
-Qcache_queries_in_cache	1
-show status like "Qcache_inserts";
-Variable_name	Value
-Qcache_inserts	1
-show status like "Qcache_hits";
-Variable_name	Value
-Qcache_hits	2
------------------------------------------------------
-# with comment first
-select * from t1
------------------------------------------------------
-show status like "Qcache_queries_in_cache";
-Variable_name	Value
-Qcache_queries_in_cache	1
-show status like "Qcache_inserts";
-Variable_name	Value
-Qcache_inserts	1
-show status like "Qcache_hits";
-Variable_name	Value
-Qcache_hits	2
-# with comment first
-select * from t1;
-a
-1
-2
-3
-# with comment first
-select * from t1;
-a
-1
-2
-3
-show status like "Qcache_queries_in_cache";
-Variable_name	Value
-Qcache_queries_in_cache	1
-show status like "Qcache_inserts";
-Variable_name	Value
-Qcache_inserts	1
-show status like "Qcache_hits";
-Variable_name	Value
-Qcache_hits	4
------------------------------------------------------
--- with comment first
-select * from t1
------------------------------------------------------
-show status like "Qcache_queries_in_cache";
-Variable_name	Value
-Qcache_queries_in_cache	1
-show status like "Qcache_inserts";
-Variable_name	Value
-Qcache_inserts	1
-show status like "Qcache_hits";
-Variable_name	Value
-Qcache_hits	4
--- with comment first
-select * from t1;
-a
-1
-2
-3
--- with comment first
-select * from t1;
-a
-1
-2
-3
-show status like "Qcache_queries_in_cache";
-Variable_name	Value
-Qcache_queries_in_cache	1
-show status like "Qcache_inserts";
-Variable_name	Value
-Qcache_inserts	1
-show status like "Qcache_hits";
-Variable_name	Value
-Qcache_hits	6
------------------------------------------------------
-/* with comment first and "quote" */select * from t1
------------------------------------------------------
-show status like "Qcache_queries_in_cache";
-Variable_name	Value
-Qcache_queries_in_cache	1
-show status like "Qcache_inserts";
-Variable_name	Value
-Qcache_inserts	1
-show status like "Qcache_hits";
-Variable_name	Value
-Qcache_hits	6
-/* with comment first and "quote" */select * from t1;
-a
-1
-2
-3
-/* with comment first and "quote" */select * from t1;
-a
-1
-2
-3
-show status like "Qcache_queries_in_cache";
-Variable_name	Value
-Qcache_queries_in_cache	1
-show status like "Qcache_inserts";
-Variable_name	Value
-Qcache_inserts	1
-show status like "Qcache_hits";
-Variable_name	Value
-Qcache_hits	8
------------------------------------------------------
-# with comment first and "quote"
-select * from t1
------------------------------------------------------
-show status like "Qcache_queries_in_cache";
-Variable_name	Value
-Qcache_queries_in_cache	1
-show status like "Qcache_inserts";
-Variable_name	Value
-Qcache_inserts	1
-show status like "Qcache_hits";
-Variable_name	Value
-Qcache_hits	8
-# with comment first and "quote"
-select * from t1;
-a
-1
-2
-3
-# with comment first and "quote"
-select * from t1;
-a
-1
-2
-3
-show status like "Qcache_queries_in_cache";
-Variable_name	Value
-Qcache_queries_in_cache	1
-show status like "Qcache_inserts";
-Variable_name	Value
-Qcache_inserts	1
-show status like "Qcache_hits";
-Variable_name	Value
-Qcache_hits	10
------------------------------------------------------
--- with comment first and "quote" 
-select * from t1
------------------------------------------------------
-show status like "Qcache_queries_in_cache";
-Variable_name	Value
-Qcache_queries_in_cache	1
-show status like "Qcache_inserts";
-Variable_name	Value
-Qcache_inserts	1
-show status like "Qcache_hits";
-Variable_name	Value
-Qcache_hits	10
--- with comment first and "quote" 
-select * from t1;
-a
-1
-2
-3
--- with comment first and "quote" 
-select * from t1;
-a
-1
-2
-3
-show status like "Qcache_queries_in_cache";
-Variable_name	Value
-Qcache_queries_in_cache	1
-show status like "Qcache_inserts";
-Variable_name	Value
-Qcache_inserts	1
-show status like "Qcache_hits";
-Variable_name	Value
-Qcache_hits	12
------------------------------------------------------
-/* with comment and whitespaces first */select * from t1
------------------------------------------------------
-show status like "Qcache_queries_in_cache";
-Variable_name	Value
-Qcache_queries_in_cache	1
-show status like "Qcache_inserts";
-Variable_name	Value
-Qcache_inserts	1
-show status like "Qcache_hits";
-Variable_name	Value
-Qcache_hits	12
-/* with comment and whitespaces first */select * from t1;
-a
-1
-2
-3
-/* with comment and whitespaces first */select * from t1;
-a
-1
-2
-3
-show status like "Qcache_queries_in_cache";
-Variable_name	Value
-Qcache_queries_in_cache	1
-show status like "Qcache_inserts";
-Variable_name	Value
-Qcache_inserts	1
-show status like "Qcache_hits";
-Variable_name	Value
-Qcache_hits	14
------------------------------------------------------
-# with comment and whitespaces first
-select * from t1
------------------------------------------------------
-show status like "Qcache_queries_in_cache";
-Variable_name	Value
-Qcache_queries_in_cache	1
-show status like "Qcache_inserts";
-Variable_name	Value
-Qcache_inserts	1
-show status like "Qcache_hits";
-Variable_name	Value
-Qcache_hits	14
-# with comment and whitespaces first
-select * from t1;
-a
-1
-2
-3
-# with comment and whitespaces first
-select * from t1;
-a
-1
-2
-3
-show status like "Qcache_queries_in_cache";
-Variable_name	Value
-Qcache_queries_in_cache	1
-show status like "Qcache_inserts";
-Variable_name	Value
-Qcache_inserts	1
-show status like "Qcache_hits";
-Variable_name	Value
-Qcache_hits	16
------------------------------------------------------
--- with comment and whitespaces first
-select * from t1
------------------------------------------------------
-show status like "Qcache_queries_in_cache";
-Variable_name	Value
-Qcache_queries_in_cache	1
-show status like "Qcache_inserts";
-Variable_name	Value
-Qcache_inserts	1
-show status like "Qcache_hits";
-Variable_name	Value
-Qcache_hits	16
--- with comment and whitespaces first
-select * from t1;
-a
-1
-2
-3
--- with comment and whitespaces first
-select * from t1;
-a
-1
-2
-3
-show status like "Qcache_queries_in_cache";
-Variable_name	Value
-Qcache_queries_in_cache	1
-show status like "Qcache_inserts";
-Variable_name	Value
-Qcache_inserts	1
-show status like "Qcache_hits";
-Variable_name	Value
-Qcache_hits	18
------------------------------------------------------
-select * /* internal comment */ from t1
------------------------------------------------------
-show status like "Qcache_queries_in_cache";
-Variable_name	Value
-Qcache_queries_in_cache	1
-show status like "Qcache_inserts";
-Variable_name	Value
-Qcache_inserts	1
-show status like "Qcache_hits";
-Variable_name	Value
-Qcache_hits	18
-select * /* internal comment */ from t1;
-a
-1
-2
-3
-select * /* internal comment */ from t1;
-a
-1
-2
-3
-show status like "Qcache_queries_in_cache";
-Variable_name	Value
-Qcache_queries_in_cache	1
-show status like "Qcache_inserts";
-Variable_name	Value
-Qcache_inserts	1
-show status like "Qcache_hits";
-Variable_name	Value
-Qcache_hits	20
------------------------------------------------------
-select */* internal comment */ from t1
------------------------------------------------------
-show status like "Qcache_queries_in_cache";
-Variable_name	Value
-Qcache_queries_in_cache	1
-show status like "Qcache_inserts";
-Variable_name	Value
-Qcache_inserts	1
-show status like "Qcache_hits";
-Variable_name	Value
-Qcache_hits	20
-select */* internal comment */ from t1;
-a
-1
-2
-3
-select */* internal comment */ from t1;
-a
-1
-2
-3
-show status like "Qcache_queries_in_cache";
-Variable_name	Value
-Qcache_queries_in_cache	1
-show status like "Qcache_inserts";
-Variable_name	Value
-Qcache_inserts	1
-show status like "Qcache_hits";
-Variable_name	Value
-Qcache_hits	22
------------------------------------------------------
-select */* internal comment */from t1
------------------------------------------------------
-show status like "Qcache_queries_in_cache";
-Variable_name	Value
-Qcache_queries_in_cache	1
-show status like "Qcache_inserts";
-Variable_name	Value
-Qcache_inserts	1
-show status like "Qcache_hits";
-Variable_name	Value
-Qcache_hits	22
-select */* internal comment */from t1;
-a
-1
-2
-3
-select */* internal comment */from t1;
-a
-1
-2
-3
-show status like "Qcache_queries_in_cache";
-Variable_name	Value
-Qcache_queries_in_cache	1
-show status like "Qcache_inserts";
-Variable_name	Value
-Qcache_inserts	1
-show status like "Qcache_hits";
-Variable_name	Value
-Qcache_hits	24
------------------------------------------------------
-select * /* internal comment with "quote" */ from t1
------------------------------------------------------
-show status like "Qcache_queries_in_cache";
-Variable_name	Value
-Qcache_queries_in_cache	1
-show status like "Qcache_inserts";
-Variable_name	Value
-Qcache_inserts	1
-show status like "Qcache_hits";
-Variable_name	Value
-Qcache_hits	24
-select * /* internal comment with "quote" */ from t1;
-a
-1
-2
-3
-select * /* internal comment with "quote" */ from t1;
-a
-1
-2
-3
-show status like "Qcache_queries_in_cache";
-Variable_name	Value
-Qcache_queries_in_cache	1
-show status like "Qcache_inserts";
-Variable_name	Value
-Qcache_inserts	1
-show status like "Qcache_hits";
-Variable_name	Value
-Qcache_hits	26
------------------------------------------------------
-select */* internal comment with "quote" */ from t1
------------------------------------------------------
-show status like "Qcache_queries_in_cache";
-Variable_name	Value
-Qcache_queries_in_cache	1
-show status like "Qcache_inserts";
-Variable_name	Value
-Qcache_inserts	1
-show status like "Qcache_hits";
-Variable_name	Value
-Qcache_hits	26
-select */* internal comment with "quote" */ from t1;
-a
-1
-2
-3
-select */* internal comment with "quote" */ from t1;
-a
-1
-2
-3
-show status like "Qcache_queries_in_cache";
-Variable_name	Value
-Qcache_queries_in_cache	1
-show status like "Qcache_inserts";
-Variable_name	Value
-Qcache_inserts	1
-show status like "Qcache_hits";
-Variable_name	Value
-Qcache_hits	28
------------------------------------------------------
-select */* internal comment with "quote" */from t1
------------------------------------------------------
-show status like "Qcache_queries_in_cache";
-Variable_name	Value
-Qcache_queries_in_cache	1
-show status like "Qcache_inserts";
-Variable_name	Value
-Qcache_inserts	1
-show status like "Qcache_hits";
-Variable_name	Value
-Qcache_hits	28
-select */* internal comment with "quote" */from t1;
-a
-1
-2
-3
-select */* internal comment with "quote" */from t1;
-a
-1
-2
-3
-show status like "Qcache_queries_in_cache";
-Variable_name	Value
-Qcache_queries_in_cache	1
-show status like "Qcache_inserts";
-Variable_name	Value
-Qcache_inserts	1
-show status like "Qcache_hits";
-Variable_name	Value
-Qcache_hits	30
------------------------------------------------------
-select * from t1
-
------------------------------------------------------
-show status like "Qcache_queries_in_cache";
-Variable_name	Value
-Qcache_queries_in_cache	1
-show status like "Qcache_inserts";
-Variable_name	Value
-Qcache_inserts	1
-show status like "Qcache_hits";
-Variable_name	Value
-Qcache_hits	30
-select * from t1
-;
-a
-1
-2
-3
-select * from t1
-;
-a
-1
-2
-3
-show status like "Qcache_queries_in_cache";
-Variable_name	Value
-Qcache_queries_in_cache	1
-show status like "Qcache_inserts";
-Variable_name	Value
-Qcache_inserts	1
-show status like "Qcache_hits";
-Variable_name	Value
-Qcache_hits	32
------------------------------------------------------
-select * from t1 
------------------------------------------------------
-show status like "Qcache_queries_in_cache";
-Variable_name	Value
-Qcache_queries_in_cache	1
-show status like "Qcache_inserts";
-Variable_name	Value
-Qcache_inserts	1
-show status like "Qcache_hits";
-Variable_name	Value
-Qcache_hits	32
-select * from t1 ;
-a
-1
-2
-3
-select * from t1 ;
-a
-1
-2
-3
-show status like "Qcache_queries_in_cache";
-Variable_name	Value
-Qcache_queries_in_cache	1
-show status like "Qcache_inserts";
-Variable_name	Value
-Qcache_inserts	1
-show status like "Qcache_hits";
-Variable_name	Value
-Qcache_hits	34
------------------------------------------------------
-select * from t1	
------------------------------------------------------
-show status like "Qcache_queries_in_cache";
-Variable_name	Value
-Qcache_queries_in_cache	1
-show status like "Qcache_inserts";
-Variable_name	Value
-Qcache_inserts	1
-show status like "Qcache_hits";
-Variable_name	Value
-Qcache_hits	34
-select * from t1	;
-a
-1
-2
-3
-select * from t1	;
-a
-1
-2
-3
-show status like "Qcache_queries_in_cache";
-Variable_name	Value
-Qcache_queries_in_cache	1
-show status like "Qcache_inserts";
-Variable_name	Value
-Qcache_inserts	1
-show status like "Qcache_hits";
-Variable_name	Value
-Qcache_hits	36
------------------------------------------------------
-select * from t1
-/* comment in the end */
------------------------------------------------------
-show status like "Qcache_queries_in_cache";
-Variable_name	Value
-Qcache_queries_in_cache	1
-show status like "Qcache_inserts";
-Variable_name	Value
-Qcache_inserts	1
-show status like "Qcache_hits";
-Variable_name	Value
-Qcache_hits	36
-select * from t1
-/* comment in the end */;
-a
-1
-2
-3
-select * from t1
-/* comment in the end */;
-a
-1
-2
-3
-show status like "Qcache_queries_in_cache";
-Variable_name	Value
-Qcache_queries_in_cache	1
-show status like "Qcache_inserts";
-Variable_name	Value
-Qcache_inserts	1
-show status like "Qcache_hits";
-Variable_name	Value
-Qcache_hits	38
------------------------------------------------------
-select * from t1
-/* *\/ */
------------------------------------------------------
-show status like "Qcache_queries_in_cache";
-Variable_name	Value
-Qcache_queries_in_cache	1
-show status like "Qcache_inserts";
-Variable_name	Value
-Qcache_inserts	1
-show status like "Qcache_hits";
-Variable_name	Value
-Qcache_hits	38
-select * from t1
-/* *\/ */;
-a
-1
-2
-3
-select * from t1
-/* *\/ */;
-a
-1
-2
-3
-show status like "Qcache_queries_in_cache";
-Variable_name	Value
-Qcache_queries_in_cache	1
-show status like "Qcache_inserts";
-Variable_name	Value
-Qcache_inserts	1
-show status like "Qcache_hits";
-Variable_name	Value
-Qcache_hits	40
------------------------------------------------------
-select * from t1
-/* comment in the end */
-
------------------------------------------------------
-show status like "Qcache_queries_in_cache";
-Variable_name	Value
-Qcache_queries_in_cache	1
-show status like "Qcache_inserts";
-Variable_name	Value
-Qcache_inserts	1
-show status like "Qcache_hits";
-Variable_name	Value
-Qcache_hits	40
-select * from t1
-/* comment in the end */
-;
-a
-1
-2
-3
-select * from t1
-/* comment in the end */
-;
-a
-1
-2
-3
-show status like "Qcache_queries_in_cache";
-Variable_name	Value
-Qcache_queries_in_cache	1
-show status like "Qcache_inserts";
-Variable_name	Value
-Qcache_inserts	1
-show status like "Qcache_hits";
-Variable_name	Value
-Qcache_hits	42
------------------------------------------------------
-select * from t1 #comment in the end
------------------------------------------------------
-show status like "Qcache_queries_in_cache";
-Variable_name	Value
-Qcache_queries_in_cache	1