From: Date: January 6 2006 7:49pm Subject: bk commit into 5.1 tree (reggie:1.2016) BUG#15408 List-Archive: http://lists.mysql.com/commits/716 X-Bug: 15408 Message-Id: <20060106184910.0563B5CEC0@linux.site> Below is the list of changes that have just been committed into a local 5.1 repository of reggie. When reggie does a push these changes will be propagated to the main repository and, within 24 hours after the push, to the public repository. For information on how to access the public repository see http://dev.mysql.com/doc/mysql/en/installing-source-tree.html ChangeSet 1.2016 06/01/06 12:49:00 reggie@stripped +7 -0 BUG# 15408 - Partitions: subpartition names are not unique Fixed. sql/sql_partition.cc 1.19 06/01/06 12:40:23 reggie@stripped +11 -13 * increased the size of MAX_PART_NAME_SIZE since we are no including partition name * now pass in partitoin_name into create_default_partition_names so that it can prefix it when building up subpart names * moved call of create_default_partition_names inside outer partition loop so that we will build up names for every partition * instead of calling is_partitions_in_table, we are now calling the new partition_info::has_duplicate_names to make sure all the part and subpart names are unique * removed the code that prefixed the part name and _ for use in explain sql/handler.h 1.175 06/01/06 12:40:22 reggie@stripped +4 -0 added some useful methods to partition_info sql/ha_partition.cc 1.19 06/01/06 12:40:21 reggie@stripped +6 -7 removed now unused name_add function not calling name_add anymore to "build up" the partition name sql/Makefile.am 1.130 06/01/06 12:40:20 reggie@stripped +1 -1 added partition_info.cc to the sources for the server mysql-test/t/partition_mgm_err.test 1.3 06/01/06 12:40:19 reggie@stripped +9 -0 added new test for duplicate subpartition names mysql-test/r/partition_mgm_err.result 1.3 06/01/06 12:40:17 reggie@stripped +8 -0 add results of new test for duplicate subpartition names libmysqld/Makefile.am 1.77 06/01/06 12:40:04 reggie@stripped +2 -1 add partition_info.cc to the list of sources for the embedded server # This is a BitKeeper patch. What follows are the unified diffs for the # set of deltas contained in the patch. The rest of the patch, the part # that BitKeeper cares about, is below these diffs. # User: reggie # Host: linux.site # Root: /home/reggie/work/mysql-5.1-bug15408-2 --- 1.129/sql/Makefile.am 2005-12-31 03:13:33 -06:00 +++ 1.130/sql/Makefile.am 2006-01-06 12:40:20 -06:00 @@ -98,7 +98,7 @@ sp_head.cc sp_pcontext.cc sp_rcontext.cc sp.cc \ sp_cache.cc parse_file.cc sql_trigger.cc \ sql_plugin.cc sql_binlog.cc \ - handlerton.cc + handlerton.cc partition_info.cc EXTRA_mysqld_SOURCES = ha_innodb.cc ha_berkeley.cc ha_archive.cc \ ha_innodb.h ha_berkeley.h ha_archive.h \ ha_blackhole.cc ha_federated.cc ha_ndbcluster.cc \ --- 1.174/sql/handler.h 2005-12-26 05:54:47 -06:00 +++ 1.175/sql/handler.h 2006-01-06 12:40:22 -06:00 @@ -677,6 +677,10 @@ subpart_field_list.empty(); } ~partition_info() {} + + bool has_duplicate_names(); +private: + bool has_unique_name(partition_element *el_to_check); }; --- 1.76/libmysqld/Makefile.am 2005-12-22 22:04:23 -06:00 +++ 1.77/libmysqld/Makefile.am 2006-01-06 12:40:04 -06:00 @@ -65,7 +65,8 @@ sp_head.cc sp_pcontext.cc sp.cc sp_cache.cc sp_rcontext.cc \ parse_file.cc sql_view.cc sql_trigger.cc my_decimal.cc \ item_xmlfunc.cc \ - rpl_filter.cc sql_partition.cc handlerton.cc sql_plugin.cc + rpl_filter.cc sql_partition.cc handlerton.cc sql_plugin.cc \ + ../sql/partition_info.cc libmysqld_int_a_SOURCES= $(libmysqld_sources) $(libmysqlsources) $(sqlsources) EXTRA_libmysqld_a_SOURCES = ha_innodb.cc ha_berkeley.cc ha_archive.cc \ --- 1.18/sql/ha_partition.cc 2005-12-30 22:53:54 -06:00 +++ 1.19/sql/ha_partition.cc 2006-01-06 12:40:21 -06:00 @@ -576,10 +576,10 @@ between the partition names. */ -static uint name_add(char *dest, const char *first_name, const char *sec_name) -{ - return (uint) (strxmov(dest, first_name, "_", sec_name, NullS) -dest) + 1; -} +//static uint name_add(char *dest, const char *first_name, const char *sec_name) +//{ +// return (uint) (strxmov(dest, first_name, "_", sec_name, NullS) -dest) + 1; +//} /* @@ -658,9 +658,8 @@ for (j= 0; j < m_part_info->no_subparts; j++) { subpart_elem= sub_it++; - name_buffer_ptr+= name_add(name_buffer_ptr, - part_elem->partition_name, - subpart_elem->partition_name); + name_buffer_ptr= strmov(name_buffer_ptr, + subpart_elem->partition_name)+1; *engine_array= (uchar) ha_legacy_type(part_elem->engine_type); engine_array++; } --- 1.18/sql/sql_partition.cc 2005-12-26 05:53:40 -06:00 +++ 1.19/sql/sql_partition.cc 2006-01-06 12:40:23 -06:00 @@ -567,9 +567,10 @@ The external routine needing this code is check_partition_info */ -#define MAX_PART_NAME_SIZE 8 +#define MAX_PART_NAME_SIZE 16 -static char *create_default_partition_names(uint no_parts, uint start_no, +static char *create_default_partition_names(const char *partition_name, + uint no_parts, uint start_no, bool subpart) { char *ptr= sql_calloc(no_parts*MAX_PART_NAME_SIZE); @@ -581,7 +582,8 @@ do { if (subpart) - my_sprintf(move_ptr, (move_ptr,"sp%u", (start_no + i))); + my_sprintf(move_ptr, (move_ptr,"%s_sp%u", partition_name, + (start_no + i))); else my_sprintf(move_ptr, (move_ptr,"p%u", (start_no + i))); move_ptr+=MAX_PART_NAME_SIZE; @@ -644,7 +646,7 @@ my_error(ER_TOO_MANY_PARTITIONS_ERROR, MYF(0)); goto end; } - if (unlikely((!(default_name= create_default_partition_names(no_parts, + if (unlikely((!(default_name= create_default_partition_names(NULL, no_parts, start_no, FALSE))))) goto end; @@ -712,15 +714,15 @@ my_error(ER_TOO_MANY_PARTITIONS_ERROR, MYF(0)); goto end; } - if (unlikely((!(default_name= - create_default_partition_names(no_subparts, (uint)0, TRUE))))) - goto end; i= 0; do { part_elem= part_it++; j= 0; - name_ptr= default_name; + name_ptr= create_default_partition_names(part_elem->partition_name, + no_subparts, (uint)0, TRUE); + if (!name_ptr) + goto end; do { partition_element *subpart_elem= new partition_element(); @@ -853,7 +855,7 @@ my_error(ER_TOO_MANY_PARTITIONS_ERROR, MYF(0)); goto end; } - if (unlikely(is_partitions_in_table(part_info, part_info))) + if (unlikely(part_info->has_duplicate_names())) { my_error(ER_SAME_NAME_PARTITION, MYF(0)); goto end; @@ -3493,10 +3495,6 @@ { if (parts_str->length()) parts_str->append(','); - parts_str->append(head_pe->partition_name, - strlen(head_pe->partition_name), - system_charset_info); - parts_str->append('_'); parts_str->append(pe->partition_name, strlen(pe->partition_name), system_charset_info); --- 1.2/mysql-test/r/partition_mgm_err.result 2005-12-15 05:22:59 -06:00 +++ 1.3/mysql-test/r/partition_mgm_err.result 2006-01-06 12:40:17 -06:00 @@ -52,6 +52,14 @@ PARTITION BY KEY (a) (PARTITION x0, PARTITION x1, PARTITION x2, PARTITION x3, PARTITION x3); ERROR HY000: All partitions must have unique names in the table +CREATE TABLE t1 (a int, b int) +PARTITION BY RANGE(a) +SUBPARTITION BY HASH(b) +(PARTITION x0 VALUES LESS THAN (20) +(SUBPARTITION s0, SUBPARTITION s1), +PARTITION x1 VALUES LESS THAN MAXVALUE +(SUBPARTITION s0, SUBPARTITION s1)); +ERROR HY000: All partitions must have unique names in the table CREATE TABLE t1 (a int) PARTITION BY RANGE (a) SUBPARTITION BY KEY (a) --- 1.2/mysql-test/t/partition_mgm_err.test 2005-12-15 05:22:59 -06:00 +++ 1.3/mysql-test/t/partition_mgm_err.test 2006-01-06 12:40:19 -06:00 @@ -78,6 +78,15 @@ PARTITION BY KEY (a) (PARTITION x0, PARTITION x1, PARTITION x2, PARTITION x3, PARTITION x3); +--error ER_SAME_NAME_PARTITION +CREATE TABLE t1 (a int, b int) +PARTITION BY RANGE(a) +SUBPARTITION BY HASH(b) +(PARTITION x0 VALUES LESS THAN (20) + (SUBPARTITION s0, SUBPARTITION s1), +PARTITION x1 VALUES LESS THAN MAXVALUE + (SUBPARTITION s0, SUBPARTITION s1)); + CREATE TABLE t1 (a int) PARTITION BY RANGE (a) SUBPARTITION BY KEY (a)