Bug #30576 part_supported_sql_func_innodb.test tries to LOAD DATA outside of var dir

Submitted: 22 Aug 2007 19:06 Modified: 29 Aug 2007 18:48
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

[22 Aug 2007 19:06] Timothy Smith
Description:
mysqltest: In included file "./suite/parts/inc/partition_supported_sql_funcs.inc": At line 87: query 'load data infile '$MYSQL_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 test suite runs the server with --secure-file-priv, which doesn't allow LOAD DATA for files outside the mysql-test/var directory.

How to repeat:
Run the parts.part_supported_sql_func_innodb test.

Suggested fix:
Either start the server without --secure-file-priv for this test, or copy the needed data file into the var dir.
[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:40] 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:48] 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.042 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.