summaryrefslogtreecommitdiff
path: root/mysql-test/r/partition_error.result
diff options
context:
space:
mode:
authorMattias Jonsson <mattias.jonsson@oracle.com>2011-01-26 19:33:53 +0100
committerMattias Jonsson <mattias.jonsson@oracle.com>2011-01-26 19:33:53 +0100
commit6ae9810f388034ac9509d8709e97c0575d316c95 (patch)
treeb8710a28697907b5b3c47d1637b8f14d8b7b9e2e /mysql-test/r/partition_error.result
parente99f2b1c4efa0d9c1f6eef549562f8d7f165b404 (diff)
parentec5e43da337688d4b6f169143bb9e12409402f3b (diff)
downloadmariadb-git-6ae9810f388034ac9509d8709e97c0575d316c95.tar.gz
merge of bug 47902 and (null-merge) of bug 57924.
bug#57924 does not occur in 5.5, so I reverted the 5.1 specific code and used the errors from 5.5 instead in the tests
Diffstat (limited to 'mysql-test/r/partition_error.result')
-rw-r--r--mysql-test/r/partition_error.result13
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/r/partition_error.result b/mysql-test/r/partition_error.result
index 1dcb2fdebb8..87eafb234a8 100644
--- a/mysql-test/r/partition_error.result
+++ b/mysql-test/r/partition_error.result
@@ -1,5 +1,18 @@
drop table if exists t1, t2;
#
+# Bug#57924: crash when creating partitioned table with
+# multiple columns in the partition key
+#
+CREATE TABLE t1 (a INT, b INT, PRIMARY KEY (a,b))
+PARTITION BY KEY(a, b, a);
+ERROR HY000: Duplicate partition field name 'a'
+CREATE TABLE t1 (a INT, b INT, PRIMARY KEY (a,b))
+PARTITION BY KEY(A, b);
+DROP TABLE t1;
+CREATE TABLE t1 (a INT, b INT, PRIMARY KEY (a,b))
+PARTITION BY KEY(a, b, A);
+ERROR HY000: Duplicate partition field name 'a'
+#
# Bug#54483: valgrind errors when making warnings for multiline inserts
# into partition
#