Description:
OS: Solaris 9, sparc
Compiler: Sun C 5.5 2003/03/12
The 'grant_cache' test fails with the following errors:
-----------
grant_cache [ fail ]
Errors are (from /MySQL_DB/4.1.3/mysql-4.1.3-beta/mysql-test/var/log/mysqltest-time) :
/MySQL_DB/4.1.3/mysql-4.1.3-beta/client/mysqltest: At line 136: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/grant_cache.result Mon Jun 28 01:26:46 2004
--- r/grant_cache.reject Tue Aug 31 02:17:36 2004
***************
*** 112,119 ****
Variable_name Value
Qcache_not_cached 1
show grants for current_user();
! Grants for @localhost
! GRANT USAGE ON *.* TO ''@'localhost'
select "user2";
user2
user2
--- 112,119 ----
Variable_name Value
Qcache_not_cached 1
show grants for current_user();
! Grants for root@localhost
! GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION
select "user2";
user2
user2
-------------------------------------------------------
Please follow the instructions outlined at
http://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html
to find the reason to this problem and how to report this.
Aborting: grant_cache failed. To continue, re-run with '--force'.
----------------------------------
If run with mysql-test-run --debug options, get the error messages as bellow:
----------------------------------
TEST RESULT
------------------------------------------
grant_cache [ fail ]
Errors are (from /MySQL_DB/4.1.3/mysql-4.1.3-beta/mysql-test/var/log/mysqltest-time) :
/MySQL_DB/4.1.3/mysql-4.1.3-beta/client/mysqltest: Could not open connection 'root2': Can't connect to local MySQL server through socket '/MySQL_DB/4.1.3/mysql-4.1.3-beta/mysql-test/var/tmp/master.sock' (146)
(the last lines may be the most important ones)
Aborting: grant_cache failed. To continue, re-run with '--force'.
--------------------------------------------
How to repeat:
Compile with the following flags and configuration options:
CC=cc CFLAGS="-mt -fast -xstrconst -xarch=v9" CXX=CC CXXFLAGS="-noex -mt -fast -xarch=v9" ./configure --prefix=/usr/local/mysql --localstatedir=/usr/local/mysql/data --libexecdir=/usr/local/mysql/bin --with-extra-charsets=complex --enable-thread-safe-client --enable-local-infile --with-named-curses-libs=-lcurses --with-named-z-libs=bundled --disable-shared --with-debug --with-readline --with-server-suffix="-debug" --with-embedded-server --with-innodb
Run "make", then make install
Then run "make test"