Debian Codegraph @

mysql-test/suite/parts/t/partition_special_myisam.test

raw
1 ################################################################################
2 # t/partition_special_myisam.test #
3 # #
4 # Purpose: #
5 # different Tests #
6 # MYISAM branch #
7 # #
8 #------------------------------------------------------------------------------#
9 # Original Author: HH #
10 # Original Date: 2006-08-01 #
11 # Change Author: #
12 # Change Date: #
13 # Change: #
14 ################################################################################
15
16 #
17 # NOTE: PLEASE DO NOT ADD NOT MYISAM SPECIFIC TESTCASES HERE !
18 # TESTCASES WHICH MUST BE APPLIED TO ALL STORAGE ENGINES MUST BE ADDED IN
19 # THE SOURCED FILES ONLY.
20 #
21 # Please read the README at the end of inc/partition.pre before changing
22 # any of the variables.
23 #
24
25 #------------------------------------------------------------------------------#
26 # General not engine specific settings and requirements
27
28 ##### Options, for debugging support #####
29 let $debug= 0;
30
31 # The server must support partitioning.
32 --source include/have_partition.inc
33 --source include/test_db_charset_latin1.inc
34
35 #------------------------------------------------------------------------------#
36 # Engine specific settings and requirements
37
38 ##### Storage engine to be tested
39 let $engine= 'MyISAM';
40
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
47
48 --echo #
49 --echo # Bug#53770: Server crash at handler.cc:2076 on LOAD DATA
50 --echo # after timed out COALESCE PARTITION
51 CREATE TABLE t1 ( i INT NOT NULL AUTO_INCREMENT PRIMARY KEY, f INT )
52 ENGINE = MyISAM PARTITION BY HASH(i) PARTITIONS 3;
53
54 START TRANSACTION;
55 SELECT * FROM t1;
56
57 --connect (con2,localhost,root,,)
58 SET lock_wait_timeout = 2;
59 --error ER_LOCK_WAIT_TIMEOUT
60 ALTER TABLE t1 COALESCE PARTITION 2;
61
62 --connect (con3,localhost,root,,)
63
64 --let $MYSQLD_DATADIR= `SELECT @@datadir`
65 --write_file $MYSQLD_DATADIR/test/load.in
66 1
67 2
68 3
69 EOF
70 send LOAD DATA INFILE 'load.in' INTO TABLE t1 (f);
71
72 --connection default
73 --real_sleep 1
74 COMMIT;
75
76 --connection con3
77 --reap
78 --remove_file $MYSQLD_DATADIR/test/load.in
79 DROP TABLE t1;
80
81 --disconnect con3
82 --disconnect con2
83 --connection default
84 --source include/test_db_charset_restore.inc