Bug #30411 Suite "parts" needs bug numbers updated: ER_UNIQUE_KEY_NEED_ALL_FIELDS_IN_PF
Submitted: 14 Aug 2007 16:18 Modified: 29 Aug 2007 18:47
Reporter: Joerg Bruehe Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Tests Severity:S3 (Non-critical)
Version:5.1.21 OS:Any
Assigned to: Timothy Smith CPU Architecture:Any
Tags: sr5_1

[14 Aug 2007 16:18] Joerg Bruehe
Description:
This was detected during release builds of 5.1.21.

Most likely, this is a consequence of bug#29245
  ("Bad Merge Caused Error Codes Conflict between 5.0/5.1")
having been fixed in 5.1.20

Error ER_UNIQUE_KEY_NEED_ALL_FIELDS_IN_PF had code 1491 up to version 5.1.19
but has code 1500 since version 5.1.20.

The logs have been severely reduced, to keep just the essential parts:

-------------------------------------------------------
*** /PATH/mysql-test/suite/parts/r/partition_alter1_innodb.result
--- /PATH/mysql-test/suite/parts/r/partition_alter1_innodb.reject
***************
*** 68,80148
  WHERE f_int1 BETWEEN 1 AND @max_row_div2 - 1;
  ALTER TABLE t1 ADD PRIMARY KEY(f_int2);
  ERROR HY000: A PRIMARY KEY must include all columns in the table's partitioning function
! DROP TABLE t1;
! CREATE TABLE t1 (
! f_int1 INTEGER,
.....
! DROP TABLE IF EXISTS t0_aux;
! DROP TABLE IF EXISTS t0_definition;
! DROP TABLE IF EXISTS t0_template;
--- 68,75
  WHERE f_int1 BETWEEN 1 AND @max_row_div2 - 1;
  ALTER TABLE t1 ADD PRIMARY KEY(f_int2);
  ERROR HY000: A PRIMARY KEY must include all columns in the table's partitioning function
! #      The last command got an unexepected error response.
! #      Expected/handled SQL codes are 0,1030,1491,1495

! #      SQL code we got was:   1500
! #      Sorry, have to abort.
-------------------------------------------------------

-------------------------------------------------------
*** /PATH/mysql-test/suite/parts/r/partition_alter1_myisam.result
--- /PATH/mysql-test/suite/parts/r/partition_alter1_myisam.reject
***************
*** 68,32410
  WHERE f_int1 BETWEEN 1 AND @max_row_div2 - 1;
  ALTER TABLE t1 ADD UNIQUE INDEX uidx1 (f_int2);
  ERROR HY000: A UNIQUE INDEX must include all columns in the table's partitioning function
! DROP TABLE t1;
! CREATE TABLE t1 (
! f_int1 INTEGER,
.....
! DROP TABLE IF EXISTS t0_aux;
! DROP TABLE IF EXISTS t0_definition;
! DROP TABLE IF EXISTS t0_template;
--- 68,75
  WHERE f_int1 BETWEEN 1 AND @max_row_div2 - 1;
  ALTER TABLE t1 ADD UNIQUE INDEX uidx1 (f_int2);
  ERROR HY000: A UNIQUE INDEX must include all columns in the table's partitioning function
! #      The last command got an unexepected error response.
! #      Expected/handled SQL codes are 0,1030,1491,1495

! #      SQL code we got was:   1500
! #      Sorry, have to abort.
-------------------------------------------------------

How to repeat:
Run the "parts" suite.
[23 Aug 2007 20:27] Timothy Smith
ChangeSet isn't showing up in commits list for some reason.  Here it is:

https://intranet.mysql.com/~tsmith/tmp/suite-parts-1.diff
[27 Aug 2007 18:39] Trudy Pelzer
Horst has verified Tim's patch fixes this and the following 
bugs:
- Bug#30316 Some "parts" tests fail because the server uses "--secure-file-priv"
- Bug#30341: Test suite "parts" needs to be adapted to the new rules disallowing many functio
- Bug#30408: Suite "parts" needs bug numbers updated
- Bug#30411: Suite "parts" needs bug numbers updated: ER_UNIQUE_KEY_NEED_ALL_FIELDS_IN_PF
- Bug#30576: part_supported_sql_func_innodb.test tries to LOAD DATA outside of var dir
- Bug#30581 partition_value tests use disallowed CAST() function
[28 Aug 2007 18:39] Timothy Smith
Queued to target-5.1.22
[29 Aug 2007 18:47] Timothy Smith
Test case changes only, no need to document
[4 Sep 2007 17:12] Bugs System
Pushed into 5.1.23-beta