summaryrefslogtreecommitdiff
path: root/mysql-test/t/partition_column.test
diff options
context:
space:
mode:
authorMikael Ronstrom <mikael@mysql.com>2009-10-06 17:01:59 +0200
committerMikael Ronstrom <mikael@mysql.com>2009-10-06 17:01:59 +0200
commit576dd76aa81787f71e038efd9e00713b7a44b3c5 (patch)
tree8a64b121a12e42e2945fe186a5bef63e60082416 /mysql-test/t/partition_column.test
parent2ef1c756db41b003f6e634104f9024cdb4f2b982 (diff)
downloadmariadb-git-576dd76aa81787f71e038efd9e00713b7a44b3c5.tar.gz
BUG#47837, Duplicate field names were allowed in both column list partitioning and key partitioning, added check to give error in this case
Diffstat (limited to 'mysql-test/t/partition_column.test')
-rw-r--r--mysql-test/t/partition_column.test11
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/t/partition_column.test b/mysql-test/t/partition_column.test
index 5eef85b4fa2..1c7e8d59895 100644
--- a/mysql-test/t/partition_column.test
+++ b/mysql-test/t/partition_column.test
@@ -9,6 +9,17 @@ drop table if exists t1;
--enable_warnings
#
+# BUG#47837, Crash when two same fields in column list processing
+#
+--error ER_SAME_NAME_PARTITION_FIELD
+create table t1 (a int, b int)
+partition by key (a,a);
+--error ER_SAME_NAME_PARTITION_FIELD
+create table t1 (a int, b int)
+partition by list column_list(a,a)
+( partition p values in (column_list(1,1)));
+
+#
# BUG#47838, List partitioning have problems with <= and >=
#
create table t1 (a int signed)