Combined fix for

   Bug#31481 test suite parts: Many tests fail because of changed server error codes
   Bug#31243 Test "partition_basic_myisam" truncates path names
+ minor cleanup


mysql-test/suite/parts/inc/partition.pre:
  - Blow column file_list up to VARBINARY(10000)
     = Fix for Bug#31243 Test "partition_basic_myisam" truncates path names
  - Minor cleanup
    = remove reference to fixed bugs #17455, #19305
mysql-test/suite/parts/inc/partition_alter_1.inc:
  Adjust expected server error codes
mysql-test/suite/parts/inc/partition_check.inc:
  Adjust expected server error codes
mysql-test/suite/parts/inc/partition_syntax.inc:
  Minor cleanup
  = replace error numbers with error names
mysql-test/suite/parts/inc/partition_syntax_1.inc:
  Adjust expected server error codes
mysql-test/suite/parts/r/partition_alter1_innodb.result:
  Updated results
mysql-test/suite/parts/r/partition_alter1_myisam.result:
  Updated results
mysql-test/suite/parts/r/partition_alter2_innodb.result:
  Updated results
mysql-test/suite/parts/r/partition_alter2_myisam.result:
  Updated results
mysql-test/suite/parts/r/partition_alter3_innodb.result:
  Updated results
mysql-test/suite/parts/r/partition_alter3_myisam.result:
  Updated results
mysql-test/suite/parts/r/partition_alter4_innodb.result:
  Updated results
mysql-test/suite/parts/r/partition_alter4_myisam.result:
  Updated results
mysql-test/suite/parts/r/partition_basic_innodb.result:
  Updated results
mysql-test/suite/parts/r/partition_basic_myisam.result:
  Updated results
mysql-test/suite/parts/r/partition_engine_innodb.result:
  Updated results
mysql-test/suite/parts/r/partition_engine_myisam.result:
  Updated results
mysql-test/suite/parts/r/partition_syntax_innodb.result:
  Updated results
mysql-test/suite/parts/r/partition_syntax_myisam.result:
  Updated results

19 files changed, 80 insertions, 114 deletions

diff --git a/mysql-test/suite/parts/inc/partition.pre b/mysql-test/suite/parts/inc/partition.pre
index c09cfed29e6..ade4a1592be 100644
--- a/mysql-test/suite/parts/inc/partition.pre
+++ b/mysql-test/suite/parts/inc/partition.pre
@@ -12,11 +12,14 @@
 # The README for the partitioning testcases is at the end of this file.        #
 #                                                                              #
 #------------------------------------------------------------------------------#
-# Original Author: ML                                                          #
-# Original Date: 2006-03-05                                                    #
-# Change Author:                                                               #
-# Change Date:                                                                 #
-# Change:                                                                      #
+# Original Author: mleich                                                      #
+# Original Date:   2006-03-05                                                  #
+# Change Author:   mleich                                                      #
+# Change Date:     2007-10-08                                                  #
+# Change:          Minor cleanup and fix for                                   #
+#                  Bug#31243 Test "partition_basic_myisam" truncates path names#
+#                  - Blow column file_list up to VARBINARY(10000)              #
+#                  - remove reference to fixed bugs #17455, #19305             #
 ################################################################################
 
 # Set the session storage engine
@@ -31,9 +34,6 @@ if (`SELECT @@session.storage_engine IN('ndbcluster')`)
 {
 --echo # #18730, Bug#18735
 }
---echo # The expected results suffer from the following bugs
---echo # harmless #17455, #19305
---echo # which cannot be suppressed because of technical reasons.
 --echo #------------------------------------------------------------------------
 # Attention: Only bugs appearing in all storage engines should be mentioned above.
 #            The top level test wrapper (example: t/partition_basic_ndb.test)
@@ -164,7 +164,7 @@ DROP TABLE IF EXISTS t0_definition;
 CREATE TABLE t0_definition (
 state CHAR(3),
 create_command VARBINARY(5000),
-file_list      VARBINARY(5000),
+file_list      VARBINARY(10000),
 PRIMARY KEY (state)
 ) ENGINE = MEMORY;
 
diff --git a/mysql-test/suite/parts/inc/partition_alter_1.inc b/mysql-test/suite/parts/inc/partition_alter_1.inc
index 1498970547a..206073d6775 100644
--- a/mysql-test/suite/parts/inc/partition_alter_1.inc
+++ b/mysql-test/suite/parts/inc/partition_alter_1.inc
@@ -26,19 +26,21 @@
 # are also to be set outside (source ./include/partition.pre).                 #
 #                                                                              #
 #------------------------------------------------------------------------------#
-# Original Author: ML                                                          #
-# Original Date: 2006-03-05                                                    #
-# Change Author:                                                               #
-# Change Date:                                                                 #
-# Change:                                                                      #
+# Original Author: mleich                                                      #
+# Original Date:   2006-03-05                                                  #
+# Change Author:   mleich                                                      #
+# Change Date:     2007-10-08                                                  #
+# Change:          Fix for                                                     #
+#                  Bug#31481 test suite parts: Many tests fail because of      #
+#                            changed server error codes                        #
 ################################################################################
 
 eval $insert_first_half;
 # Possible/Expected return codes for ALTER TABLE ...
 # 0
 # 1030: ER_GET_ERRNO
-# 1500: ER_UNIQUE_KEY_NEED_ALL_FIELDS_IN_PF
-# 1504: ER_DROP_PARTITION_NON_EXISTENT
+# 1502: ER_UNIQUE_KEY_NEED_ALL_FIELDS_IN_PF
+# 1506: ER_DROP_PARTITION_NON_EXISTENT
 --disable_abort_on_error
 eval $alter;
 --enable_abort_on_error
@@ -48,11 +50,11 @@ if ($no_debug)
 }
 eval SET @my_errno = $mysql_errno;
 let $run_test= `SELECT @my_errno = 0`;
-let $unexpected_error= `SELECT @my_errno NOT IN (0,1030,1500,1504)`;
+let $unexpected_error= `SELECT @my_errno NOT IN (0,1030,1502,1506)`;
 if ($unexpected_error)
 {
    --echo #      The last command got an unexepected error response.
-   --echo #      Expected/handled SQL codes are 0,1030,1500,1504
+   --echo #      Expected/handled SQL codes are 0,1030,1502,1506
    SELECT '#      SQL code we got was: ' AS "", @my_errno AS "";
    --echo #      Sorry, have to abort.
    exit;
diff --git a/mysql-test/suite/parts/inc/partition_check.inc b/mysql-test/suite/parts/inc/partition_check.inc
index 6f03ed58241..87d8c5a3c5a 100644
--- a/mysql-test/suite/parts/inc/partition_check.inc
+++ b/mysql-test/suite/parts/inc/partition_check.inc
@@ -35,11 +35,15 @@
 #                      This is useful for cleanups.                            #
 #                                                                              #
 #------------------------------------------------------------------------------#
-# Original Author: ML                                                          #
-# Original Date: 2006-03-05                                                    #
-# Change Author:                                                               #
-# Change Date:                                                                 #
-# Change:                                                                      #
+# Original Author: mleich                                                      #
+# Original Date:   2006-03-05                                                  #
+# Change Author:   mleich                                                      #
+# Change Date:     2007-10-08                                                  #
+# Change:          Around fix for                                              #
+#                  Bug#31243 Test "partition_basic_myisam" truncates path names#
+#                  Adjustments of expected error codes:                        #
+#                  ER_NO_PARTITION_FOR_GIVEN_VALUE is now 1525                 #
+#                  ER_SAME_NAME_PARTITION is now 1516                          #
 ################################################################################
 
 
@@ -495,7 +499,7 @@ WHERE f_charbig = '#SINGLE#' AND f_int1 IN (-1,@cur_value);
 # 4.7  Insert one record with such a big value for f_int1, so that in case
 #      - f_int1 is used within the partitioning algorithm
 #      - we use range partitioning
-#      we get error ER_NO_PARTITION_FOR_GIVEN_VALUE (1523)
+#      we get error ER_NO_PARTITION_FOR_GIVEN_VALUE (1525)
 #         "Table has no partition for value ...."
 #      or ER_SAME_NAME_PARTITION (1514)
 --disable_abort_on_error
@@ -506,11 +510,11 @@ if ($no_debug)
 --disable_query_log
 }
 eval SET @my_errno = $mysql_errno;
-let $unexpected_error= `SELECT @my_errno NOT IN (0,1514,1523)`;
+let $unexpected_error= `SELECT @my_errno NOT IN (0,1514,1525)`;
 if ($unexpected_error)
 {
    --echo #      The last command got an unexepected error response.
-   --echo #      Expected/handled SQL codes are 0,1514,1523
+   --echo #      Expected/handled SQL codes are 0,1514,1525
    SELECT '#      SQL code we got was: ' AS "", @my_errno AS "";
    --echo #      Sorry, have to abort.
    exit;
diff --git a/mysql-test/suite/parts/inc/partition_syntax.inc b/mysql-test/suite/parts/inc/partition_syntax.inc
index a2a29d25e48..26bf57f3ef2 100644
--- a/mysql-test/suite/parts/inc/partition_syntax.inc
+++ b/mysql-test/suite/parts/inc/partition_syntax.inc
@@ -249,7 +249,7 @@ PARTITION BY RANGE(f_int1)
 --echo #      This is a limitation of MySQL 5.1, which could be removed in
 --echo #      later releases.
 --echo #------------------------------------------------------------------------
---error 1064
+--error ER_PARSE_ERROR
 eval CREATE TABLE t1 (
 $column_list,
 PRIMARY KEY (f_int1)
@@ -324,7 +324,7 @@ PARTITION BY RANGE(f_int1)
 --echo #------------------------------------------------------------------------
 --echo #  3.5.1 NULL in RANGE partitioning clause
 --echo #  3.5.1.1 VALUE LESS THAN (NULL) is not allowed
---error 1064
+--error ER_PARSE_ERROR
 eval CREATE TABLE t1 (
 $column_list
 )
@@ -332,7 +332,7 @@ PARTITION BY RANGE(f_int1)
 ( PARTITION part1 VALUES LESS THAN (NULL),
   PARTITION part2 VALUES LESS THAN (1000));
 --echo #  3.5.1.2 VALUE LESS THAN (NULL) is not allowed
---error 1064
+--error ER_PARSE_ERROR
 eval CREATE TABLE t1 (
 $column_list
 )
@@ -456,17 +456,17 @@ let $part3_Y= `SELECT @AUX`;
 eval $part01 $column_list $part02 $part1_N $part2_N $part3_N ;
 DROP TABLE t1;
 # Bug#15407 Partitions: crash if subpartition
---error 1064
+--error ER_PARSE_ERROR
 eval $part01 $column_list $part02 $part1_N $part2_N $part3_Y ;
---error 1064
+--error ER_PARSE_ERROR
 eval $part01 $column_list $part02 $part1_N $part2_Y $part3_N ;
---error 1064
+--error ER_PARSE_ERROR
 eval $part01 $column_list $part02 $part1_N $part2_Y $part3_Y ;
---error 1064
+--error ER_PARSE_ERROR
 eval $part01 $column_list $part02 $part1_Y $part2_N $part3_N ;
---error 1064
+--error ER_PARSE_ERROR
 eval $part01 $column_list $part02 $part1_Y $part2_N $part3_Y ;
---error 1064
+--error ER_PARSE_ERROR
 eval $part01 $column_list $part02 $part1_Y $part2_Y $part3_N ;
 eval $part01 $column_list $part02 $part1_Y $part2_Y $part3_Y ;
 --source suite/parts/inc/partition_layout_check1.inc
@@ -640,12 +640,12 @@ let $part_number= "GARBAGE";
 
 --echo # 4.2.6 (negative) partition/subpartition numbers per @variables
 SET @aux = 5;
---error 1064
+--error ER_PARSE_ERROR
 eval CREATE TABLE t1 (
 $column_list
 )
 PARTITION BY HASH(f_int1) PARTITIONS @aux;
---error 1064
+--error ER_PARSE_ERROR
 eval CREATE TABLE t1 (
 $column_list
 )
@@ -685,13 +685,13 @@ DROP TABLE t1;
 --echo #                  already checked above
 --echo # 4.3.3 (negative) number of partitions/subpartitions
 --echo #                         > number of named partitions/subpartitions
---error 1064
+--error ER_PARSE_ERROR
 eval CREATE TABLE t1 (
 $column_list
 )
 PARTITION BY HASH(f_int1) PARTITIONS 2 ( PARTITION part1 ) ;
 # Wrong number of named subpartitions in first partition
---error 1064
+--error ER_PARSE_ERROR
 eval CREATE TABLE t1 (
 $column_list
 )
@@ -703,7 +703,7 @@ SUBPARTITION BY HASH(f_int1) SUBPARTITIONS 2
     (SUBPARTITION subpart21, SUBPARTITION subpart22)
 );
 # Wrong number of named subpartitions in non first/non last partition
---error 1064
+--error ER_PARSE_ERROR
 eval CREATE TABLE t1 (
 $column_list
 )
@@ -717,7 +717,7 @@ SUBPARTITION BY HASH(f_int1) SUBPARTITIONS 2
     (SUBPARTITION subpart31, SUBPARTITION subpart32)
 );
 # Wrong number of named subpartitions in last partition
---error 1064
+--error ER_PARSE_ERROR
 eval CREATE TABLE t1 (
 $column_list
 )
@@ -729,13 +729,13 @@ SUBPARTITION BY HASH(f_int1) SUBPARTITIONS 2
     (SUBPARTITION subpart21                        )
 );
 --echo # 4.3.4 (negative) number of partitions < number of named partitions
---error 1064
+--error ER_PARSE_ERROR
 eval CREATE TABLE t1 (
 $column_list
 )
 PARTITION BY HASH(f_int1) PARTITIONS 1 ( PARTITION part1, PARTITION part2 ) ;
 # Wrong number of named subpartitions in first partition
---error 1064
+--error ER_PARSE_ERROR
 eval CREATE TABLE t1 (
 $column_list
 )
@@ -747,7 +747,7 @@ SUBPARTITION BY HASH(f_int1) SUBPARTITIONS 1
     (SUBPARTITION subpart21, SUBPARTITION subpart22)
 );
 # Wrong number of named subpartitions in non first/non last partition
---error 1064
+--error ER_PARSE_ERROR
 eval CREATE TABLE t1 (
 $column_list
 )
@@ -761,7 +761,7 @@ SUBPARTITION BY HASH(f_int1) SUBPARTITIONS 1
     (SUBPARTITION subpart31, SUBPARTITION subpart32)
 );
 # Wrong number of named subpartitions in last partition
---error 1064
+--error ER_PARSE_ERROR
 eval CREATE TABLE t1 (
 $column_list
 )
diff --git a/mysql-test/suite/parts/inc/partition_syntax_1.inc b/mysql-test/suite/parts/inc/partition_syntax_1.inc
index e3e1b3ccbb7..79fdcdf1b91 100644
--- a/mysql-test/suite/parts/inc/partition_syntax_1.inc
+++ b/mysql-test/suite/parts/inc/partition_syntax_1.inc
@@ -10,11 +10,13 @@
 #    The parameter $part_number must be set before sourcing this script.       #
 #                                                                              #
 #------------------------------------------------------------------------------#
-# Original Author: ML                                                          #
-# Original Date: 2006-03-05                                                    #
-# Change Author:                                                               #
-# Change Date:                                                                 #
-# Change:                                                                      #
+# Original Author: mleich                                                      #
+# Original Date:   2006-03-05                                                  #
+# Change Author:   mleich                                                      #
+# Change Date:     2007-10-08                                                  #
+# Change:          Fix for                                                     #
+#                  Bug#31481 test suite parts: Many tests fail because of      #
+#                            changed server error codes                        #
 ################################################################################
 
 --disable_abort_on_error
@@ -30,13 +32,13 @@ let $run= `SELECT @my_errno = 0`;
 # 0
 # 1064 ER_PARSE_ERROR
 #      Reason: assign -1 partitions
-# 1496 ER_TOO_MANY_PARTITIONS_ERROR
-# 1501 ER_NO_PARTS_ERROR
-let $unexpected_error= `SELECT @my_errno NOT IN (0,1064,1496,1501)`;
+# 1498 ER_TOO_MANY_PARTITIONS_ERROR
+# 1503 ER_NO_PARTS_ERROR
+let $unexpected_error= `SELECT @my_errno NOT IN (0,1064,1498,1503)`;
 if ($unexpected_error)
 {
    --echo #      The last command got an unexepected error response.
-   --echo #      Expected/handled SQL codes are 0,1064,1496,1501
+   --echo #      Expected/handled SQL codes are 0,1064,1498,1503
    SELECT '#      SQL code we got was: ' AS "", @my_errno AS "";
    --echo #      Sorry, have to abort.
    exit;
@@ -68,13 +70,13 @@ let $run= `SELECT @my_errno = 0`;
 # 0
 # 1064 ER_PARSE_ERROR
 #      Reason: assign -1 partitions
-# 1496 ER_TOO_MANY_PARTITIONS_ERROR
-# 1501 ER_NO_PARTS_ERROR
-let $unexpected_error= `SELECT @my_errno NOT IN (0,1064,1496,1501)`;
+# 1498 ER_TOO_MANY_PARTITIONS_ERROR
+# 1503 ER_NO_PARTS_ERROR
+let $unexpected_error= `SELECT @my_errno NOT IN (0,1064,1498,1503)`;
 if ($unexpected_error)
 {
    --echo #      The last command got an unexepected error response.
-   --echo #      Expected/handled SQL codes are 0,1064,1496,1501
+   --echo #      Expected/handled SQL codes are 0,1064,1498,1503
    SELECT '#      SQL code we got was: ' AS "", @my_errno AS "";
    --echo #      Sorry, have to abort.
    exit;
diff --git a/mysql-test/suite/parts/r/partition_alter1_innodb.result b/mysql-test/suite/parts/r/partition_alter1_innodb.result
index 22f02356b77..84765c14e16 100644
--- a/mysql-test/suite/parts/r/partition_alter1_innodb.result
+++ b/mysql-test/suite/parts/r/partition_alter1_innodb.result
@@ -4,9 +4,6 @@ SET @@session.storage_engine = 'InnoDB';
 #------------------------------------------------------------------------
 # There are several testcases disabled because of the open bugs
 # #15890
-# The expected results suffer from the following bugs
-# harmless #17455, #19305
-# which cannot be suppressed because of technical reasons.
 #------------------------------------------------------------------------
 
 #------------------------------------------------------------------------
@@ -31,7 +28,7 @@ DROP TABLE IF EXISTS t0_definition;
 CREATE TABLE t0_definition (
 state CHAR(3),
 create_command VARBINARY(5000),
-file_list      VARBINARY(5000),
+file_list      VARBINARY(10000),
 PRIMARY KEY (state)
 ) ENGINE = MEMORY;
 DROP TABLE IF EXISTS t0_aux;
diff --git a/mysql-test/suite/parts/r/partition_alter1_myisam.result b/mysql-test/suite/parts/r/partition_alter1_myisam.result
index b2f1d657151..29c5f09eb3b 100644
--- a/mysql-test/suite/parts/r/partition_alter1_myisam.result
+++ b/mysql-test/suite/parts/r/partition_alter1_myisam.result
@@ -4,9 +4,6 @@ SET @@session.storage_engine = 'MyISAM';
 #------------------------------------------------------------------------
 # There are several testcases disabled because of the open bugs
 # #15890
-# The expected results suffer from the following bugs
-# harmless #17455, #19305
-# which cannot be suppressed because of technical reasons.
 #------------------------------------------------------------------------
 
 #------------------------------------------------------------------------
@@ -31,7 +28,7 @@ DROP TABLE IF EXISTS t0_definition;
 CREATE TABLE t0_definition (
 state CHAR(3),
 create_command VARBINARY(5000),
-file_list      VARBINARY(5000),
+file_list      VARBINARY(10000),
 PRIMARY KEY (state)
 ) ENGINE = MEMORY;
 DROP TABLE IF EXISTS t0_aux;
diff --git a/mysql-test/suite/parts/r/partition_alter2_innodb.result b/mysql-test/suite/parts/r/partition_alter2_innodb.result
index cdddae40467..833e82c6a89 100644
--- a/mysql-test/suite/parts/r/partition_alter2_innodb.result
+++ b/mysql-test/suite/parts/r/partition_alter2_innodb.result
@@ -4,9 +4,6 @@ SET @@session.storage_engine = 'InnoDB';
 #------------------------------------------------------------------------
 # There are several testcases disabled because of the open bugs
 # #15890
-# The expected results suffer from the following bugs
-# harmless #17455, #19305
-# which cannot be suppressed because of technical reasons.
 #------------------------------------------------------------------------
 
 #------------------------------------------------------------------------
@@ -31,7 +28,7 @@ DROP TABLE IF EXISTS t0_definition;
 CREATE TABLE t0_definition (
 state CHAR(3),
 create_command VARBINARY(5000),
-file_list      VARBINARY(5000),
+file_list      VARBINARY(10000),
 PRIMARY KEY (state)
 ) ENGINE = MEMORY;
 DROP TABLE IF EXISTS t0_aux;
diff --git a/mysql-test/suite/parts/r/partition_alter2_myisam.result b/mysql-test/suite/parts/r/partition_alter2_myisam.result
index 741ce2d8963..65bf85e61e5 100644
--- a/mysql-test/suite/parts/r/partition_alter2_myisam.result
+++ b/mysql-test/suite/parts/r/partition_alter2_myisam.result
@@ -4,9 +4,6 @@ SET @@session.storage_engine = 'MyISAM';
 #------------------------------------------------------------------------
 # There are several testcases disabled because of the open bugs
 # #15890
-# The expected results suffer from the following bugs
-# harmless #17455, #19305
-# which cannot be suppressed because of technical reasons.
 #------------------------------------------------------------------------
 
 #------------------------------------------------------------------------
@@ -31,7 +28,7 @@ DROP TABLE IF EXISTS t0_definition;
 CREATE TABLE t0_definition (
 state CHAR(3),
 create_command VARBINARY(5000),
-file_list      VARBINARY(5000),
+file_list      VARBINARY(10000),
 PRIMARY KEY (state)
 ) ENGINE = MEMORY;
 DROP TABLE IF EXISTS t0_aux;
diff --git a/mysql-test/suite/parts/r/partition_alter3_innodb.result b/mysql-test/suite/parts/r/partition_alter3_innodb.result
index 7228462c61d..3cff9aa3b0a 100644
--- a/mysql-test/suite/parts/r/partition_alter3_innodb.result
+++ b/mysql-test/suite/parts/r/partition_alter3_innodb.result
@@ -4,9 +4,6 @@ SET @@session.storage_engine = 'InnoDB';
 #------------------------------------------------------------------------
 # There are several testcases disabled because of the open bugs
 # #15890
-# The expected results suffer from the following bugs
-# harmless #17455, #19305
-# which cannot be suppressed because of technical reasons.
 #------------------------------------------------------------------------
 
 #------------------------------------------------------------------------
@@ -31,7 +28,7 @@ DROP TABLE IF EXISTS t0_definition;
 CREATE TABLE t0_definition (
 state CHAR(3),
 create_command VARBINARY(5000),
-file_list      VARBINARY(5000),
+file_list      VARBINARY(10000),
 PRIMARY KEY (state)
 ) ENGINE = MEMORY;
 DROP TABLE IF EXISTS t0_aux;
diff --git a/mysql-test/suite/parts/r/partition_alter3_myisam.result b/mysql-test/suite/parts/r/partition_alter3_myisam.result
index c24858aa2ca..8e93af1f3d0 100644
--- a/mysql-test/suite/parts/r/partition_alter3_myisam.result
+++ b/mysql-test/suite/parts/r/partition_alter3_myisam.result
@@ -4,9 +4,6 @@ SET @@session.storage_engine = 'MyISAM';
 #------------------------------------------------------------------------
 # There are several testcases disabled because of the open bugs
 # #15890
-# The expected results suffer from the following bugs
-# harmless #17455, #19305
-# which cannot be suppressed because of technical reasons.
 #------------------------------------------------------------------------
 
 #------------------------------------------------------------------------
@@ -31,7 +28,7 @@ DROP TABLE IF EXISTS t0_definition;
 CREATE TABLE t0_definition (
 state CHAR(3),
 create_command VARBINARY(5000),
-file_list      VARBINARY(5000),
+file_list      VARBINARY(10000),
 PRIMARY KEY (state)
 ) ENGINE = MEMORY;
 DROP TABLE IF EXISTS t0_aux;
diff --git a/mysql-test/suite/parts/r/partition_alter4_innodb.result b/mysql-test/suite/parts/r/partition_alter4_innodb.result
index 2c5f57d8a46..aa8ba992808 100644
--- a/mysql-test/suite/parts/r/partition_alter4_innodb.result
+++ b/mysql-test/suite/parts/r/partition_alter4_innodb.result
@@ -4,9 +4,6 @@ SET @@session.storage_engine = 'InnoDB';
 #------------------------------------------------------------------------
 # There are several testcases disabled because of the open bugs
 # #15890
-# The expected results suffer from the following bugs
-# harmless #17455, #19305
-# which cannot be suppressed because of technical reasons.
 #------------------------------------------------------------------------
 
 #------------------------------------------------------------------------
@@ -31,7 +28,7 @@ DROP TABLE IF EXISTS t0_definition;
 CREATE TABLE t0_definition (
 state CHAR(3),
 create_command VARBINARY(5000),
-file_list      VARBINARY(5000),
+file_list      VARBINARY(10000),
 PRIMARY KEY (state)
 ) ENGINE = MEMORY;
 DROP TABLE IF EXISTS t0_aux;
diff --git a/mysql-test/suite/parts/r/partition_alter4_myisam.result b/mysql-test/suite/parts/r/partition_alter4_myisam.result
index 32da415443d..6697bb9805c 100644
--- a/mysql-test/suite/parts/r/partition_alter4_myisam.result
+++ b/mysql-test/suite/parts/r/partition_alter4_myisam.result
@@ -4,9 +4,6 @@ SET @@session.storage_engine = 'MyISAM';
 #------------------------------------------------------------------------
 # There are several testcases disabled because of the open bugs
 # #15890
-# The expected results suffer from the following bugs
-# harmless #17455, #19305
-# which cannot be suppressed because of technical reasons.
 #------------------------------------------------------------------------
 
 #------------------------------------------------------------------------
@@ -31,7 +28,7 @@ DROP TABLE IF EXISTS t0_definition;
 CREATE TABLE t0_definition (
 state CHAR(3),
 create_command VARBINARY(5000),
-file_list      VARBINARY(5000),
+file_list      VARBINARY(10000),
 PRIMARY KEY (state)
 ) ENGINE = MEMORY;
 DROP TABLE IF EXISTS t0_aux;
diff --git a/mysql-test/suite/parts/r/partition_basic_innodb.result b/mysql-test/suite/parts/r/partition_basic_innodb.result
index dc875980678..adcac5cccad 100644
--- a/mysql-test/suite/parts/r/partition_basic_innodb.result
+++ b/mysql-test/suite/parts/r/partition_basic_innodb.result
@@ -4,9 +4,6 @@ SET @@session.storage_engine = 'InnoDB';
 #------------------------------------------------------------------------
 # There are several testcases disabled because of the open bugs
 # #15890
-# The expected results suffer from the following bugs
-# harmless #17455, #19305
-# which cannot be suppressed because of technical reasons.
 #------------------------------------------------------------------------
 
 #------------------------------------------------------------------------
@@ -31,7 +28,7 @@ DROP TABLE IF EXISTS t0_definition;
 CREATE TABLE t0_definition (
 state CHAR(3),
 create_command VARBINARY(5000),
-file_list      VARBINARY(5000),
+file_list      VARBINARY(10000),
 PRIMARY KEY (state)
 ) ENGINE = MEMORY;
 DROP TABLE IF EXISTS t0_aux;
diff --git a/mysql-test/suite/parts/r/partition_basic_myisam.result b/mysql-test/suite/parts/r/partition_basic_myisam.result
index 471eb4973f6..db8918029f1 100644
--- a/mysql-test/suite/parts/r/partition_basic_myisam.result
+++ b/mysql-test/suite/parts/r/partition_basic_myisam.result
@@ -4,9 +4,6 @@ SET @@session.storage_engine = 'MyISAM';
 #------------------------------------------------------------------------
 # There are several testcases disabled because of the open bugs
 # #15890
-# The expected results suffer from the following bugs
-# harmless #17455, #19305
-# which cannot be suppressed because of technical reasons.
 #------------------------------------------------------------------------
 
 #------------------------------------------------------------------------
@@ -31,7 +28,7 @@ DROP TABLE IF EXISTS t0_definition;
 CREATE TABLE t0_definition (
 state CHAR(3),
 create_command VARBINARY(5000),
-file_list      VARBINARY(5000),
+file_list      VARBINARY(10000),
 PRIMARY KEY (state)
 ) ENGINE = MEMORY;
 DROP TABLE IF EXISTS t0_aux;
diff --git a/mysql-test/suite/parts/r/partition_engine_innodb.result b/mysql-test/suite/parts/r/partition_engine_innodb.result
index bea9a59da9b..be95f5baae5 100644
--- a/mysql-test/suite/parts/r/partition_engine_innodb.result
+++ b/mysql-test/suite/parts/r/partition_engine_innodb.result
@@ -4,9 +4,6 @@ SET @@session.storage_engine = 'InnoDB';
 #------------------------------------------------------------------------
 # There are several testcases disabled because of the open bugs
 # #15890
-# The expected results suffer from the following bugs
-# harmless #17455, #19305
-# which cannot be suppressed because of technical reasons.
 #------------------------------------------------------------------------
 
 #------------------------------------------------------------------------
@@ -31,7 +28,7 @@ DROP TABLE IF EXISTS t0_definition;
 CREATE TABLE t0_definition (
 state CHAR(3),
 create_command VARBINARY(5000),
-file_list      VARBINARY(5000),
+file_list      VARBINARY(10000),
 PRIMARY KEY (state)
 ) ENGINE = MEMORY;
 DROP TABLE IF EXISTS t0_aux;
diff --git a/mysql-test/suite/parts/r/partition_engine_myisam.result b/mysql-test/suite/parts/r/partition_engine_myisam.result
index 343077c5e4d..a61ec2e5cef 100644
--- a/mysql-test/suite/parts/r/partition_engine_myisam.result
+++ b/mysql-test/suite/parts/r/partition_engine_myisam.result
@@ -4,9 +4,6 @@ SET @@session.storage_engine = 'MyISAM';
 #------------------------------------------------------------------------
 # There are several testcases disabled because of the open bugs
 # #15890
-# The expected results suffer from the following bugs
-# harmless #17455, #19305
-# which cannot be suppressed because of technical reasons.
 #------------------------------------------------------------------------
 
 #------------------------------------------------------------------------
@@ -31,7 +28,7 @@ DROP TABLE IF EXISTS t0_definition;
 CREATE TABLE t0_definition (
 state CHAR(3),
 create_command VARBINARY(5000),
-file_list      VARBINARY(5000),
+file_list      VARBINARY(10000),
 PRIMARY KEY (state)
 ) ENGINE = MEMORY;
 DROP TABLE IF EXISTS t0_aux;
diff --git a/mysql-test/suite/parts/r/partition_syntax_innodb.result b/mysql-test/suite/parts/r/partition_syntax_innodb.result
index c6fb2d38e4c..402ab2f524f 100644
--- a/mysql-test/suite/parts/r/partition_syntax_innodb.result
+++ b/mysql-test/suite/parts/r/partition_syntax_innodb.result
@@ -4,9 +4,6 @@ SET @@session.storage_engine = 'InnoDB';
 #------------------------------------------------------------------------
 # There are several testcases disabled because of the open bugs
 # #15890
-# The expected results suffer from the following bugs
-# harmless #17455, #19305
-# which cannot be suppressed because of technical reasons.
 #------------------------------------------------------------------------
 
 #------------------------------------------------------------------------
@@ -31,7 +28,7 @@ DROP TABLE IF EXISTS t0_definition;
 CREATE TABLE t0_definition (
 state CHAR(3),
 create_command VARBINARY(5000),
-file_list      VARBINARY(5000),
+file_list      VARBINARY(10000),
 PRIMARY KEY (state)
 ) ENGINE = MEMORY;
 DROP TABLE IF EXISTS t0_aux;
diff --git a/mysql-test/suite/parts/r/partition_syntax_myisam.result b/mysql-test/suite/parts/r/partition_syntax_myisam.result
index 49a7b155a58..ceac1b4f1b9 100644
--- a/mysql-test/suite/parts/r/partition_syntax_myisam.result
+++ b/mysql-test/suite/parts/r/partition_syntax_myisam.result
@@ -4,9 +4,6 @@ SET @@session.storage_engine = 'MyISAM';
 #------------------------------------------------------------------------
 # There are several testcases disabled because of the open bugs
 # #15890
-# The expected results suffer from the following bugs
-# harmless #17455, #19305
-# which cannot be suppressed because of technical reasons.
 #------------------------------------------------------------------------
 
 #------------------------------------------------------------------------
@@ -31,7 +28,7 @@ DROP TABLE IF EXISTS t0_definition;
 CREATE TABLE t0_definition (
 state CHAR(3),
 create_command VARBINARY(5000),
-file_list      VARBINARY(5000),
+file_list      VARBINARY(10000),
 PRIMARY KEY (state)
 ) ENGINE = MEMORY;
 DROP TABLE IF EXISTS t0_aux;