1# Tests for the partition storage engine in connection with the 2# storage engine BLACKHOLE. 3# 4# Creation: 5# 2007-10-18 mleich - Move BLACKHOLE related sub tests of partition.test to 6# this test. Reason: BLACKHOLE is not everytime available. 7# - Minor cleanup 8# 9 10--source include/have_partition.inc 11--source include/have_blackhole.inc 12 13# 14# Bug#14524 Partitions: crash if blackhole 15# 16--disable_warnings 17DROP TABLE IF EXISTS t1; 18--enable_warnings 19CREATE TABLE `t1` ( 20 `id` int(11) default NULL 21) ENGINE=BLACKHOLE DEFAULT CHARSET=latin1 PARTITION BY HASH (id) ; 22SELECT * FROM t1; 23 24DROP TABLE t1; 25