2 +++ b/mysql-test/r/percona_xtradb_bug317074.result
4 +SET @old_innodb_file_format=@@innodb_file_format;
5 +SET @old_innodb_file_format_max=@@innodb_file_format_max;
6 +SET @old_innodb_file_per_table=@@innodb_file_per_table;
7 +SET GLOBAL innodb_file_format='Barracuda';
8 +SET GLOBAL innodb_file_per_table=ON;
10 +++ b/mysql-test/t/percona_xtradb_bug317074.test
12 +-- source include/have_innodb.inc
14 +SET @old_innodb_file_format=@@innodb_file_format;
15 +SET @old_innodb_file_format_max=@@innodb_file_format_max;
16 +SET @old_innodb_file_per_table=@@innodb_file_per_table;
17 +SET GLOBAL innodb_file_format='Barracuda';
18 +SET GLOBAL innodb_file_per_table=ON;
21 +-- disable_result_log
23 +DROP TABLE IF EXISTS `test1`;
24 +CREATE TABLE IF NOT EXISTS `test1` (
25 + `a` int primary key auto_increment,
27 + `c` char(100) default 'testtest'
28 +) ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8;
31 +CREATE PROCEDURE insert_many(p1 int)
37 + insert into test1 set b=1;
45 +UNTIL @x >= p1 END REPEAT;
49 +call insert_many(100000);
50 +DROP PROCEDURE insert_many;
52 +# The bug is hangup at the following statement
53 +ALTER TABLE test1 ENGINE=MyISAM;
56 +SET GLOBAL innodb_file_format=@old_innodb_file_format;
57 +SET GLOBAL innodb_file_format_max=@old_innodb_file_format_max;
58 +SET GLOBAL innodb_file_per_table=@old_innodb_file_per_table;