diff options
| author | Mikael Ronstrom <mikael@mysql.com> | 2009-10-06 17:01:59 +0200 |
|---|---|---|
| committer | Mikael Ronstrom <mikael@mysql.com> | 2009-10-06 17:01:59 +0200 |
| commit | 576dd76aa81787f71e038efd9e00713b7a44b3c5 (patch) | |
| tree | 8a64b121a12e42e2945fe186a5bef63e60082416 /mysql-test/r/partition_column.result | |
| parent | 2ef1c756db41b003f6e634104f9024cdb4f2b982 (diff) | |
| download | mariadb-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/r/partition_column.result')
| -rw-r--r-- | mysql-test/r/partition_column.result | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/r/partition_column.result b/mysql-test/r/partition_column.result index 621a127f310..fb7f815fd98 100644 --- a/mysql-test/r/partition_column.result +++ b/mysql-test/r/partition_column.result @@ -1,4 +1,11 @@ drop table if exists t1; +create table t1 (a int, b int) +partition by key (a,a); +ERROR HY000: Duplicate partition field name a +create table t1 (a int, b int) +partition by list column_list(a,a) +( partition p values in (column_list(1,1))); +ERROR HY000: Duplicate partition field name a create table t1 (a int signed) partition by list (a) ( partition p0 values in (1, 3, 5, 7, 9, NULL), |