summaryrefslogtreecommitdiff
path: root/mysql-test/suite/federated
diff options
context:
space:
mode:
authorSergei Golubchik <sergii@pisem.net>2011-07-16 09:59:04 +0200
committerSergei Golubchik <sergii@pisem.net>2011-07-16 09:59:04 +0200
commit73a46b3eb954d92b1032d1c458ee349247800def (patch)
tree56a8513b1120f56f620898dc676d2f8920955af7 /mysql-test/suite/federated
parent2853f6bfbb2f392fa5623b480a2ce112991d2486 (diff)
downloadmariadb-git-73a46b3eb954d92b1032d1c458ee349247800def.tar.gz
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
Diffstat (limited to 'mysql-test/suite/federated')
-rw-r--r--mysql-test/suite/federated/partition_federated.result6
-rw-r--r--mysql-test/suite/federated/partition_federated.test21
2 files changed, 27 insertions, 0 deletions
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