1
################################################################################
2
# t/partition_special_innodb.test #
8
#------------------------------------------------------------------------------#
9
# Original Author: HH #
10
# Original Date: 2006-08-01 #
11
# Change Author: MattiasJ #
12
# Change Date: 2008-08-20 #
13
# Change: added test for bug#34604 #
14
################################################################################
17
# NOTE: PLEASE DO NOT ADD NOT INNODB SPECIFIC TESTCASES HERE !
18
# TESTCASES WHICH MUST BE APPLIED TO ALL STORAGE ENGINES MUST BE ADDED IN
19
# THE SOURCED FILES ONLY.
21
# Please read the README at the end of inc/partition.pre before changing
22
# any of the variables.
25
#------------------------------------------------------------------------------#
26
# General not engine specific settings and requirements
28
##### Options, for debugging support #####
31
# The server must support partitioning.
32
--source include/have_partition.inc
34
#------------------------------------------------------------------------------#
35
# Engine specific settings and requirements
37
##### Storage engine to be tested
38
--source include/have_innodb.inc
39
let $engine= 'InnoDB';
41
#------------------------------------------------------------------------------#
42
# Execute the tests to be applied to all storage engines
43
--source suite/parts/inc/partition_key_4col.inc
44
--source suite/parts/inc/partition_key_8col.inc
45
--source suite/parts/inc/partition_key_16col.inc
46
--source suite/parts/inc/partition_key_32col.inc
48
#------------------------------------------------------------------------------#
49
# Execute storage engine specific tests
51
--echo # Bug#34604 - Assertion 'inited==RND' failed in handler::ha_rnd_end
61
connect (con1,127.0.0.1,root,,test,$MASTER_MYPORT,);
62
connect (con2,127.0.0.1,root,,test,$MASTER_MYPORT,);
67
INSERT INTO t1 VALUES (NULL, 'first row t2');
71
--error ER_LOCK_WAIT_TIMEOUT
72
ALTER TABLE t1 AUTO_INCREMENT = 10;
75
INSERT INTO t1 VALUES (NULL, 'second row t2');
76
SELECT a,b FROM t1 ORDER BY a;