From 3e27508554d6d6786ce395aa236c6f6bd3a7caf0 Mon Sep 17 00:00:00 2001 From: unknown Date: Tue, 19 Dec 2006 16:37:50 +0400 Subject: bug #22451 (Partitions: duplicating results with ENGINE=FEDERATED) As presently PARTITIONS + FEDERATED just doesn't work i added error message to inform user about that. Should be enabled again after releted WL's completion. storage/federated/ha_federated.cc: partitioning disabled in FEDERATED engine mysql-test/r/partition_federated.result: result added mysql-test/t/partition_federated.test: test added --- mysql-test/t/partition_federated.test | 21 +++++++++++++++++++++ 1 file changed, 21 insertions(+) create mode 100644 mysql-test/t/partition_federated.test (limited to 'mysql-test/t/partition_federated.test') diff --git a/mysql-test/t/partition_federated.test b/mysql-test/t/partition_federated.test new file mode 100644 index 00000000000..c8483291228 --- /dev/null +++ b/mysql-test/t/partition_federated.test @@ -0,0 +1,21 @@ +# +# Tests for partitioned FEDERATED +# +-- source include/have_partition.inc +-- source include/not_embedded.inc +-- source include/have_federated_db.inc + +--disable_warnings +drop table if exists t1; +--enable_warnings + +# +# Bug #22451 Partitions: duplicate results with engine=federated +# + +--error ER_PARTITION_MERGE_ERROR +create table t1 (s1 int) engine=federated +connection='mysql://root@localhost/federated/t1' partition by list (s1) +(partition p1 values in (1), partition p2 values in (2)); + +--echo End of 5.1 tests -- cgit v1.2.1