| Bug #31857 | funcs_1: a_processlist_priv_no_prot and b_processlist_priv_ps fail | ||
|---|---|---|---|
| Submitted: | 25 Oct 2007 16:51 | Modified: | 1 Nov 2007 12:56 |
| Reporter: | Matthias Leich | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Tests | Severity: | S3 (Non-critical) |
| Version: | 5.1 | OS: | Any |
| Assigned to: | Matthias Leich | CPU Architecture: | Any |
[25 Oct 2007 17:22]
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/36357 ChangeSet@1.2590, 2007-10-25 19:21:28+02:00, mleich@four.local.lan +3 -0 Fix for Bug#31857 funcs_1: a_processlist_priv_no_prot and b_processlist_priv_ps fail Reason for the changes is: WL4007 Deprecate RENAME DATABASE: replace with ALTER DATABASE <name> UPGRADE
[29 Oct 2007 9:31]
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/36530 ChangeSet@1.2591, 2007-10-29 09:31:13+01:00, mleich@four.local.lan +3 -0 Fix for Bug#31857 funcs_1: a_processlist_priv_no_prot and b_processlist_priv_ps fail Reason for the changes is: WL4007 Deprecate RENAME DATABASE: replace with ALTER DATABASE <name> UPGRADE
[29 Oct 2007 15:41]
Matthias Leich
Adjustment of tests, no documentation needed.
[1 Nov 2007 10:14]
Bugs System
Pushed into 6.0.4-alpha
[1 Nov 2007 10:16]
Bugs System
Pushed into 5.1.23-rc
Description: The tests a_processlist_priv_no_prot and b_processlist_priv_ps (both belong to the funcs_1 testsuite) fail now with error code 1064 ... wrong syntax ... instead of 1044 ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema' when running RENAME DATABASE information_schema TO info_schema. The reason is WL#4007 Deprecate RENAME DATABASE: replace with ALTER DATABASE <name> UPGRADE mysql-5.1-build last ChangeSet@1.2588, 2007-10-22 How to repeat: ./mysql-test-run.pl --suite=funcs_1 \ --do-test=a_processlist_priv_no_prot ./mysql-test-run.pl --suite=funcs_1 --ps-protocol \ --do-test=b_processlist_priv_no_prot Attention: The connection ID's differ too because we are not running this test in non standard way. Suggested fix: 1. Change the expected error to ER_PARSE_ERROR for RENAME DATABASE ... This is the bug fix. 2. Add a subtest with --error ER_DBACCESS_DENIED_ERROR ALTER DATABASE information_schema UPGRADE DATA DIRECTORY NAME after the RENAME DATABASE subtest. This is a now urgent needed additional subtest.