Bug #36789 Test funcs_1.falcon_storedproc_06 failing
Submitted: 18 May 2008 21:49 Modified: 24 Nov 2008 15:29
Reporter: Patrick Crews Email Updates:
Status: Closed Impact on me:
None 
Category:Tests: Server Severity:S3 (Non-critical)
Version:6.0 OS:Any
Assigned to: Patrick Crews CPU Architecture:Any
Tags: falcon, funcs_1, stored procedures, Tests

[18 May 2008 21:49] Patrick Crews
Description:
Test funcs_1.falcon_storedproc_06 is failing.

The test is still expecting the old funcs_1 data location  
-load data infile 'MYSQL_TEST_DIR/suite/funcs_1/data/t4.txt' into table t1;

It needs to be updated to the new funcs_1 data location
+load data infile '<MYSQLTEST_VARDIR>/std_data_ln/funcs_1/t4.txt' into table t1;

All of the include files, etc are correct, just the .result file needs updating for this engine

How to repeat:
Run the test in a 6.0 version of the server:

./mysql-test-run --suite=funcs_1  falcon_storedproc_06

Observe the failures are all tied to the location of the external data that is being loaded for the test

Suggested fix:
Update the .result file and verify that the only changes are the location of the external data files.
[30 May 2008 19:07] Bugs System
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/47274

2663 Patrick Crews	2008-05-30
      Bug#36789 - Test funcs_1.falcon_storedproc_06 failing
      
      Needed to re-record the result file for this test to account for changes in where data is stored
      As well as privilege grant / revokes on SP drops.
[2 Jun 2008 17:28] Bugs System
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/47333
[2 Jun 2008 17:57] Bugs System
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/47338