From 13eaba787efd7f37bf189134a0d12e4f6d5deb25 Mon Sep 17 00:00:00 2001 From: unknown Date: Mon, 22 Oct 2007 20:10:51 +0200 Subject: This changeset contains the following stuff: - Fix for Bug#28827 Partition test needs archive engine Bug#26669 Two tests on partition fail while blackhole engine is missing Solution: Move ARCHIVE and BLACKHOLE sub test cases to their own main test. - The two bugs above + the fact that CSV could be also sometimes not available --> Move also CSV sub tests out. - Minor cleanups - Replace error numbers with error names - fix typos, wrong comments - remove redundant sub test cases - add missing drop database - SET GLOBAL general_log = default is wrong, = 1 is correct mysql-test/r/partition.result: Updated results mysql-test/t/partition.test: Remove ARCHIVE, BLACKHOLE and CSV related sub test cases. mysql-test/r/partition_archive.result: Expected results mysql-test/r/partition_blackhole.result: Expected results mysql-test/r/partition_csv.result: Expected results mysql-test/t/partition_archive.test: Tests for the partition storage engine in connection with the storage engine ARCHIVE. mysql-test/t/partition_blackhole.test: Tests for the partition storage engine in connection with the storage engine BLACKHOLE. mysql-test/t/partition_csv.test: Tests for the partition storage engine in connection with the storage engine CSV. --- mysql-test/t/partition_blackhole.test | 24 ++++++++++++++++++++++++ 1 file changed, 24 insertions(+) create mode 100644 mysql-test/t/partition_blackhole.test (limited to 'mysql-test/t/partition_blackhole.test') diff --git a/mysql-test/t/partition_blackhole.test b/mysql-test/t/partition_blackhole.test new file mode 100644 index 00000000000..9344ecb3b62 --- /dev/null +++ b/mysql-test/t/partition_blackhole.test @@ -0,0 +1,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; -- cgit v1.2.1