Re: How to test the MySQL Server (windows version) ?
Hi! lu ming wrote: Hi! I tried to run the perl scripts in the windows platform yesterday,but an error occured [[...]] I can just repeat: This script is still under construction, and adaptions are still needed to make tests work correctly on Windows platforms. If you run it, you are on your own, and we are not investing any effort in supporting it externally now; we fully concentrate on improving it for our own internal tests. When this is finished, we can still announce it and then work on the problems which you and other users may experience. Jörg -- Joerg Bruehe, Senior Production Engineer MySQL AB, www.mysql.com Office: (+49 30) 417 01 487 VoIP: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to test the MySQL Server (windows version) ?
Hi, joerg Thanks for your patient answer! I hope that we will have the ability to run the test suite on windows system early. Best regards luming _ 与联机的朋友进行交流,请使用 MSN Messenger: http://messenger.msn.com/cn -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to test the MySQL Server (windows version) ?
Hi! I tried to run the perl scripts in the windows platform yesterday,but an error occured as following output info: C:\MySQL\MySQLServer5\mysql-test\perl mysql-test-run.pl mysql-test-run: *** ERROR: Could not find C:/MySQL/MySQLServer5/scripts/mysql_fix_privilege_tables I find that the mysql_fix_privilege_tables file is already exist, why did it occured this error? Is my method wrong? Or the perl test script that is included in the source distribution has some bugs? ( the source distribution i used is mysql-5.0.12-beta-linux ) Best regards lu ming _ 享用世界上最大的电子邮件系统― MSN Hotmail。 http://www.hotmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to test the MySQL Server (windows version) ?
lu ming [EMAIL PROTECTED] wrote on 10/14/2005 12:20:19 AM: Hi, joerg Thank you very much! But i want to know more about this problem. I find a perl script about mysql server's test in the mysql-test subdirectory(/mysql-test/mysql-test-run.pl). Is this the test script written by perl what could replace the shell script(/mysql-test/mysql-test-run.sh) in Windows mentioned in your e-mail? Could it be rightly run in windows now? Or it cann't be run due to the unfinished work? Are the perl scripts that mentioned in your e-mail included in the MySQL Server's Unix source distributions(mysql-5.0.12-beta-linux) ? Are the perl test scripts only used in Mysql's internal works now? Best regards luming The problems are more with Windows than with the script. The testing script was written in BASH (I believe) which does not have an interpreter for Windows (outside of Cygwin. However if you are inside Cygwin, you really aren't working with Windows any more.) Several other scripting languages do have interpreters for Windows: VBScript (d), JScript (d), PHP, Python, PERL, and more. (d) = installed by default. I think that the mysql testing script is being ported from BASH into PERL and when that happens you will have the ability to run it on any Windows system configured to run PERL scripts. Until then, we Win32 people just trust the binaries and avoid compiling our own copies unless we absolutely need to. Shawn Green Database Administrator Unimin Corporation - Spruce Pine
Re: How to test the MySQL Server (windows version) ?
Hi! [EMAIL PROTECTED] wrote: lu ming [EMAIL PROTECTED] wrote on 10/14/2005 12:20:19 AM: Hi, joerg Thank you very much! But i want to know more about this problem. I find a perl script about mysql server's test in the mysql-test subdirectory(/mysql-test/mysql-test-run.pl). Is this the test script written by perl what could replace the shell script(/mysql-test/mysql-test-run.sh) in Windows mentioned in your e-mail? It will be the one. It is not yet finished. Could it be rightly run in windows now? Or it cann't be run due to the unfinished work? You can run it, but you may have problems interpreting the results. Several tests will seem to fail, just because some output differs from the expected one. Obviously, much output is platform dependent (starting with file names, then process or thread IDs, ...), and the tests do not yet allow for the output generated on Windows. Note that I say output, not database result! Are the perl scripts that mentioned in your e-mail included in the MySQL Server's Unix source distributions(mysql-5.0.12-beta-linux) ? Yes, they are included (AFAIK - not checked), but they are under construction even for Unix. Just today, I fixed another problem in them, that had shown up during our internal 5.0 builds. Are the perl test scripts only used in Mysql's internal works now? Obviously, I cannot guarantee that nobody else is using them. But we have not proposed to anybody outside MySQL to do so. The problems are more with Windows than with the script. The testing script was written in BASH (I believe) which does not have an interpreter for Windows (outside of Cygwin. However if you are inside Cygwin, you really aren't working with Windows any more.) Just for completeness: If anybody wants to use Unix style tools (shell, awk, ed, tr, sed, lex/bison/yacc, ...) in a Windows environment, I propose to look at MinGW because these are native Windows binaries. Several other scripting languages do have interpreters for Windows: VBScript (d), JScript (d), PHP, Python, PERL, and more. (d) = installed by default. Right. So for us, Perl is the language of choice, as we can make it available on all platforms. I think that the mysql testing script is being ported from BASH into PERL and when that happens you will have the ability to run it on any Windows system configured to run PERL scripts. Until then, we Win32 people just trust the binaries and avoid compiling our own copies unless we absolutely need to. We will see not to disappoint that trust, and appreciate it. Thanks! Joerg -- Joerg Bruehe, Senior Production Engineer MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How to test the MySQL Server (windows version) ?
The test system that is included in MySQL Server's Unix source distributions.(/mysql-test/mysql-test-run.sh) We can use the suite to run a test against to the MySQL Server. But these tests only can be run on Unix(linux). If you want to run the tests on Windows, you must use the Cygwin environment, and the server must be compiled under Cygwin environment. Actually, it doesn't test the MySQL Server's Windows version because the Cygwin had make the running environment be equal to the Unix's i think. Is my opinion right? I want to know how to test the MySQL Server's Windows version. Is MySQL AB doesn't provide the test method? Who can give me an answer? _ 与联机的朋友进行交流,请使用 MSN Messenger: http://messenger.msn.com/cn -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to test the MySQL Server (windows version) ?
Hi ! lu ming wrote: The test system that is included in MySQL Server's Unix source distributions.(/mysql-test/mysql-test-run.sh) We can use the suite to run a test against to the MySQL Server. But these tests only can be run on Unix(linux). If you want to run the tests on Windows, you must use the Cygwin environment, and the server must be compiled under Cygwin environment. Actually, it doesn't test the MySQL Server's Windows version because the Cygwin had make the running environment be equal to the Unix's i think. Is my opinion right? Well, this is a typical Windows problem (yes, I admit being a Unix guy): Native Windows does not come with a decent portable scripting language. You are right that the MySQL test suite is based on a shell script approach which does not work in (native) Windows. (You might get MinGW, MKS or similar suites to get a shell and try in that environment, but this would be your own personal experiment. If you have looked into that script, you get an idea of the complexity needed, plain batch files will not work for this.) I want to know how to test the MySQL Server's Windows version. Is MySQL AB doesn't provide the test method? Who can give me an answer? MySQL is internally working on replacing the shell script by a set of Perl scripts, which can also be used on Windows (provided you install Perl). However, this work is not yet finished, and several tests will produce different results on Windows from the Unix ones, which the tool considers to be failures - even if it is just the way the result is written,no real database difference. So currently there is no way for you to run the test suite on Windows and get usable results - sorry. We are working on this. Regards, Jörg -- Joerg Bruehe, Senior Production Engineer MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to test the MySQL Server (windows version) ?
Hi, joerg Thank you very much! But i want to know more about this problem. I find a perl script about mysql server's test in the mysql-test subdirectory(/mysql-test/mysql-test-run.pl). Is this the test script written by perl what could replace the shell script(/mysql-test/mysql-test-run.sh) in Windows mentioned in your e-mail? Could it be rightly run in windows now? Or it cann't be run due to the unfinished work? Are the perl scripts that mentioned in your e-mail included in the MySQL Server's Unix source distributions(mysql-5.0.12-beta-linux) ? Are the perl test scripts only used in Mysql's internal works now? Best regards luming _ 享用世界上最大的电子邮件系统― MSN Hotmail。 http://www.hotmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]