Bug #30581 partition_value tests use disallowed CAST() function

Submitted:	23 Aug 2007 0:49	Modified:	29 Aug 2007 18:49
Reporter:	Timothy Smith	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Tests	Severity:	S3 (Non-critical)
Version:	5.1	OS:	Any
Assigned to:	Timothy Smith	CPU Architecture:	Any

Description:
The partition_value_innodb, partition_value_myisam, and partition_value_ndb tests make use of the CAST() function when defining partitions.  This is not allowed: http://dev.mysql.com/doc/refman/5.1/en/partitioning-limitations-functions-supported.html

The tests should either be removed, or rewritten if there is still something useful they can perform.

How to repeat:
Run one of the problem tests.

Suggested fix:
Remove the tests and associated *.inc files, or rewrite the tests to do something useful without calling disallowed functions.

Fixed along with several other "parts" suite bugs.  Patch too large for mailing list, see https://intranet.mysql.com/~tsmith/tmp/suite-parts-1.diff

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

Queued to target-5.1.22

Test case changes only, no need to document

Pushed into 5.1.23-beta

Page generated in 0.060 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.