Bug #33271 Self built Windows Binaries fail several Tests
Submitted: 16 Dec 2007 15:57 Modified: 19 Dec 2007 0:25
Reporter: Roland Volkmann Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: Compiling Severity:S2 (Serious)
Version:5.0.45 / 5.0.51 OS:Windows (XP Prof. SP2)
Assigned to: CPU Architecture:Any
Tags: binaries, build, compile, test, windows

[16 Dec 2007 15:57] Roland Volkmann
Description:
Self built Windows Binaries of MySQL 5.0.51 (source Distribution) fail several Tests, e.g. "merge", "mysqltest" and most of the "rpl...". The Build Process itself finishes without any errors, and all binaries are created. If I replace the binaries with the ones included in XAMPP "xampp-win32-1.6.5-beta1.exe" (http://www.apachefriends.org/de/xampp-beta.html), the same tests fail.

A cross check with MySQL 5.0.45 shows, that the self built binaries fail the tests as above, but after replacing the binaries with the official ones of MySQL AB, all tests pass.

So there seems to be something wrong with the make-files. My build environment is set up on Windows XP Prof. SP2 as described in the manual and "How to Build MySQL on Windows/Presentation" from MySQLForge Wiki: Microsoft VC8++ Express (SP1) + latest SDK + CMake 2.4.7 (Cross check with Visual Studio .NET 2003 instead results in the same behaviour, also using debug-binaries instead of release). Build Environment of XAMPP-Project I don't know. It doesn't matter to run the tests from Cygwin-Bash-Shell or with ActivePerl from Windows Command Line.

How to repeat:
Install Microsoft VC8++ Express and SP1. Install Microsoft Windows SDK 6.0.6000 (or latest Update from Internet, or Windows Server 2003 SP1 Platform SDK) and Integrate SDK with Visual Studio 2005. Install CMake 2.4.7.
Unpack MySQL Source Distribution mysql-5.0.51.zip to working directory. From VC-Command Line run on work directory "win\configure WITH_INNOBASE_STORAGE_ENGINE WITH_ARCHIVE_STORAGE_ENGINE WITH_BLACKHOLE_STORAGE_ENGINE WITH_FEDERATED_STORAGE_ENGINE" and then "win\build-vs8.bat". From within Visual Studio load "MySql.sln" and build the projects (F7). Run the tests from Cygwin-Shell, directory "mysql-test":
> export MTS_VS_CONFIG=release
> perl mysql-test-run.pl --force --timer

Suggested fix:
Compare Make Files in Source Distribution to the official ones of MySQL AB
[18 Dec 2007 22:36] MySQL Verification Team
Thank you for the bug report. I wasn't able to repeat compiling the current
source with VS 2003 Pro and VS 2005 Pro.

view                           [ pass ]          22369
view_grant                     [ pass ]           4695
wait_timeout                   [ pass ]           3300
warnings                       [ pass ]           1487
windows                        [ pass ]            232
xa                             [ pass ]            407
-------------------------------------------------------
Stopping All Servers
All 423 tests were successful.
The servers were restarted 102 times
Spent 1723.249 of 3046 seconds executing testcases

miguel@amanhecer /cygdrive/c/dbs/mysql-5.0
$ sql/release/mysqld --version
c:\dbs\mysql-5.0\sql\release\mysqld.exe  Ver 5.0.56-nt for Win32 on ia32 (Source
 distribution)

miguel@amanhecer /cygdrive/c/dbs/mysql-5.0
[19 Dec 2007 0:25] Roland Volkmann
Thank you for analyzing. I will set up a complete new machine which has never seen a development environment before, avoiding influence of other installations. The results will be presented here.