MySQL Bugs: #30316: Some "parts" tests fail because the server uses "--secure-file-priv"

Bug #30316	Some "parts" tests fail because the server uses "--secure-file-priv"
Submitted:	8 Aug 2007 17:02	Modified:	29 Aug 2007 18:46
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

Description:
Build of 5.1.21-beta

parts.part_supported_sql_func_innodb [ fail ]

Errors are (from /PATH/mysqltest-time) :
mysqltest: In included file "./suite/parts/inc/partition_supported_sql_funcs.inc": At line 87: query 'load data infile '$MY
SQL_TEST_DIR/suite/parts/inc/$infile' into table t4' failed: 1290: The MySQL server is running with the --secure-file-priv
option so it cannot execute this statement
(the last lines may be the most important ones)

parts.part_supported_sql_func_myisam [ fail ]

Errors are (from /PATH/mysqltest-time) :
mysqltest: In included file "./suite/parts/inc/partition_supported_sql_funcs.inc": At line 87: query 'load data infile '$MY
SQL_TEST_DIR/suite/parts/inc/$infile' into table t4' failed: 1290: The MySQL server is running with the --secure-file-priv
option so it cannot execute this statement
(the last lines may be the most important ones)

The failing command comes from an include file.

How to repeat:
Run the "parts" test suite,
using the standard settings as provided in "make test-bt".

Suggested fix:
a) Copy the data files to a directory from which "load data infile" is allowed.

or

b) Change the "test-bt" target in the top-level "Makefile.am" so that the "parts" suite (and only this one !) is run without using "--secure-file-priv".

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/32963

ChangeSet@1.2567, 2007-08-23 16:18:16+02:00, hhunger@hh-nb.hhunger +9 -0
  Changes due to bug#30316 and the changed lists of supported and 
  not permitted SQL functions in partitioning.

Igore Horst's patch above; Timothy has a different patch.
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

Per Timothy:
ChangeSet isn't showing up in commits list for some reason.  Here it is:

https://intranet.mysql.com/~tsmith/tmp/suite-parts-1.diff

Queued to target-5.1.22

Test case changes only, no need to document.

Pushed into 5.1.23-beta