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

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.063 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.