Bug #61086 Self tests that include not_as_root.inc are still getting run as root.
Submitted: 6 May 2011 20:59 Modified: 18 Jun 2011 11:01
Reporter: Miguel Suarez Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: Tests Severity:S3 (Non-critical)
Version:5.1.48 OS:Linux
Assigned to: CPU Architecture:Any

[6 May 2011 20:59] Miguel Suarez
Description:
The information_schema_chmod.test and trigger.test are failing when user 
is root because the tests are not getting skipped over. 

from "mysqltest.trace"

1275 | <read_line
1276 | info: query: skip Not as root
1277 | >my_malloc
1278 | | my: size: 17  my_flags: 16
1279 | | exit: ptr: 0x838df48
1280 | <my_malloc
1281 | info: first_word: skip
1282 <read_command
1283 >get_command_type
1284 | >find_type
1285 | | enter: x: 'skip'  lib: 0x8073b80
1286 | <find_type
1287 | info: type is 71
1288 | info: There are 0 expected errors
1289 <get_command_type
1290 >LogFile::write
1291 <LogFile::write
..
keeps going

==============================================================================

TEST                                      RESULT   TIME (ms)
------------------------------------------------------------

worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
worker[1] mysql-test-run: WARNING: running this script as _root_ will cause some tests to be skipped
main.information_schema_chmod            [ fail ]
        Test ended at 2011-05-06 16:55:37

CURRENT_TEST: main.information_schema_chmod
--- /extravol2/test_mysql/mysql_build_src_dir/mysql-5.1.48/mysql-test/r/information_schema_chmod.result     2010-06-03 19:18:10.000000000 +0300
+++ /extravol2/test_mysql/mysql_build_src_dir/mysql-5.1.48/mysql-test/r/information_schema_chmod.reject     2011-05-06 23:55:37.000000000 +0300
@@ -2,4 +2,5 @@
 create table mysqltest.t1(a int);
 select table_schema from information_schema.tables where table_schema='mysqltest';
 table_schema
+mysqltest
 drop database mysqltest;

mysqltest: Result length mismatch

How to repeat:
Run self-tests as root.
[18 May 2011 11:01] Valeriy Kravchuk
Please, check if the same problem happens with a recent version, 5.1.57. I do not see it there. Tests are skipped as expected.
[18 Jun 2011 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".