Bug #30408 Suite "parts" needs bug numbers updated

Submitted: 14 Aug 2007 15:48 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 15:48] 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_NO_PARTITION_FOR_GIVEN_VALUE had code 1514 up to version 5.1.19
but has code 1523 since version 5.1.20.

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

-------------------------------------------------------
*** /PATH/mysql-test/suite/parts/r/partition_alter2_innodb.result
--- /PATH/mysql-test/suite/parts/r/partition_alter2_innodb.reject
***************
*** 1523,118634
  # check single-6 success:     1
  INSERT INTO t1 SET f_int1 = @max_int_4 , f_int2 = @max_int_4, f_charbig = '#2147483647##';
  ERROR HY000: Table has no partition for value 2147483647
! DELETE FROM t1 WHERE f_int1 IS NULL OR f_int1 = 0;
! INSERT t1 SET f_int1 = 0 , f_int2 = 0,
.....
! DROP TABLE IF EXISTS t0_definition;
! DROP TABLE IF EXISTS t0_template;
--- 1523,1530
  # check single-6 success:     1
  INSERT INTO t1 SET f_int1 = @max_int_4 , f_int2 = @max_int_4, f_charbig = '#2147483647##';
  ERROR HY000: Table has no partition for value 2147483647
! #      The last command got an unexepected error response.
! #      Expected/handled SQL codes are 0,1514

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

-------------------------------------------------------
*** /PATH/mysql-test/suite/parts/r/partition_alter2_myisam.result
--- /PATH/mysql-test/suite/parts/r/partition_alter2_myisam.reject
***************
*** 1587,73943
  # check single-6 success:     1
  INSERT INTO t1 SET f_int1 = @max_int_4 , f_int2 = @max_int_4, f_charbig = '#2147483647##';
  ERROR HY000: Table has no partition for value 2147483647
! DELETE FROM t1 WHERE f_int1 IS NULL OR f_int1 = 0;
! INSERT t1 SET f_int1 = 0 , f_int2 = 0,
.....
! DROP TABLE IF EXISTS t0_definition;
! DROP TABLE IF EXISTS t0_template;
--- 1587,1594
  # check single-6 success:     1
  INSERT INTO t1 SET f_int1 = @max_int_4 , f_int2 = @max_int_4, f_charbig = '#2147483647##';
  ERROR HY000: Table has no partition for value 2147483647
! #      The last command got an unexepected error response.
! #      Expected/handled SQL codes are 0,1514

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

Similar:
partition_alter4_innodb
partition_alter4_myisam
partition_basic_innodb
partition_basic_myisam
partition_engine_innodb
partition_engine_myisam

How to repeat:
Run the "parts" test suite.

Suggested fix:
Change the expected error number.
[23 Aug 2007 20:28] 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:38] 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.066 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.