| Bug #60407 | engines/funcs/sf_alter test fails to run correctly | ||
|---|---|---|---|
| Submitted: | 9 Mar 2011 18:04 | Modified: | 9 Mar 2011 21:39 |
| Reporter: | Thomas Jones-Low | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Tests | Severity: | S3 (Non-critical) |
| Version: | 5.5.8 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | mtr | ||
[9 Mar 2011 19:10]
Valeriy Kravchuk
Please, check with a newer version, 5.5.9. I do not see any problem with current code on Mac OS X for example: macbook-pro:mysql-test openxs$ ./mtr --suite=engines/funcs --nodefault-myisam --skip-rpl sf_alter Logging: ./mtr --suite=engines/funcs --nodefault-myisam --skip-rpl sf_alter 110309 21:08:26 [Warning] Setting lower_case_table_names=2 because file system for /var/folders/dX/dXCzvuSlHX4Op1g-o1jIWk+++TI/-Tmp-/DGGhZp2Jj0/ is case insensitive 110309 21:08:26 [Note] Plugin 'FEDERATED' is disabled. MySQL Version 5.5.11 Checking supported features... - skipping ndbcluster - SSL connections supported - binaries are debug compiled Collecting tests... vardir: /Users/openxs/dbs/5.5/mysql-test/var Checking leftover processes... Removing old var directory... Creating var directory '/Users/openxs/dbs/5.5/mysql-test/var'... Installing system database... Using server port 54534 ============================================================================== TEST RESULT TIME (ms) or COMMENT -------------------------------------------------------------------------- worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009 engines/funcs.sf_alter [ pass ] 27862 -------------------------------------------------------------------------- The servers were restarted 0 times Spent 27.862 of 49 seconds executing testcases
[9 Mar 2011 20:42]
Thomas Jones-Low
Verified this is fixed in the 5.5.9 release by adding the Warnings to the results file.
[9 Mar 2011 21:39]
MySQL Verification Team
Closing according prior comment.
Description: run the following: ./mtr --suite=engines/funcs --nodefault-myisam --skip-rpl sf_alter engines/funcs.sf_alter [ fail ] Test ended at 2011-03-09 12:06:25 CURRENT_TEST: engines/funcs.sf_alter --- /usr/share/mysql-test/suite/engines/funcs/r/sf_alter.result 2010-12-03 20:58:25.000000000 +0300 +++ /usr/share/mysql-test/suite/engines/funcs/r/sf_alter.reject 2011-03-09 20:06:25.000000000 +0300 @@ -35,6 +35,8 @@ SELECT sf1(); sf1() 0 +Warnings: +Error 1329 No data - zero rows fetched, selected, or processed Every instance of the call to sf1() produces the warning which is not in the results file. How to repeat: ./mtr --suite=engines/funcs --nodefault-myisam --skip-rpl sf_alter Affect the following tests: sf_alter sf_cursor sf_simple1 sp_alter sp_cursor Suggested fix: Either fix the sf1() function to correct handle the nested cursor with no data exceptions or re-record the test results file to expect the (harmless) warning.