mysql-test/main/partition_blackhole.test


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

# Tests for the partition storage engine in connection with the
# storage engine BLACKHOLE.
#
# Creation:
# 2007-10-18 mleich  - Move BLACKHOLE related sub tests of partition.test to
#                      this test. Reason: BLACKHOLE is not everytime available.
#                    - Minor cleanup
#

--source include/have_partition.inc
--source include/have_blackhole.inc

#
# Bug#14524 Partitions: crash if blackhole
#
--disable_warnings
DROP TABLE IF EXISTS t1;
--enable_warnings
CREATE TABLE `t1` (
  `id` int(11) default NULL
) ENGINE=BLACKHOLE DEFAULT CHARSET=latin1 PARTITION BY HASH (id) ;
SELECT * FROM t1;

DROP TABLE t1;