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

[23 Aug 2007 0:49] Timothy Smith
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.
[27 Aug 2007 18:00] Timothy Smith
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
[27 Aug 2007 18:41] 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:40] Timothy Smith
Queued to target-5.1.22
[29 Aug 2007 18:49] Timothy Smith
Test case changes only, no need to document
[4 Sep 2007 17:12] Bugs System
Pushed into 5.1.23-beta