From 73a46b3eb954d92b1032d1c458ee349247800def Mon Sep 17 00:00:00 2001
From: Sergei Golubchik <sergii@pisem.net>
Date: Sat, 16 Jul 2011 09:59:04 +0200
Subject: skipped tests: improve skip messages, move to a proper suite, disable
 as needed

mysql-test/include/have_binlog_format_mixed_or_row.inc:
  better skip message
mysql-test/include/have_binlog_format_mixed_or_statement.inc:
  better skip message
mysql-test/include/have_binlog_format_row_or_statement.inc:
  better skip message
mysql-test/t/warnings_engine_disabled.test:
  better skip message
---
 .../suite/federated/partition_federated.result      |  6 ++++++
 mysql-test/suite/federated/partition_federated.test | 21 +++++++++++++++++++++
 2 files changed, 27 insertions(+)
 create mode 100644 mysql-test/suite/federated/partition_federated.result
 create mode 100644 mysql-test/suite/federated/partition_federated.test

(limited to 'mysql-test/suite/federated')

diff --git a/mysql-test/suite/federated/partition_federated.result b/mysql-test/suite/federated/partition_federated.result
new file mode 100644
index 00000000000..2d98e366c95
--- /dev/null
+++ b/mysql-test/suite/federated/partition_federated.result
@@ -0,0 +1,6 @@
+drop table if exists t1;
+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));
+ERROR HY000: Engine cannot be used in partitioned tables
+End of 5.1 tests
diff --git a/mysql-test/suite/federated/partition_federated.test b/mysql-test/suite/federated/partition_federated.test
new file mode 100644
index 00000000000..0fe692ecd01
--- /dev/null
+++ b/mysql-test/suite/federated/partition_federated.test
@@ -0,0 +1,21 @@
+#
+# Tests for partitioned FEDERATED
+#
+-- source include/have_partition.inc
+-- source include/not_embedded.inc
+-- source suite/federated/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