Bug #10844 Testcase 'information_schema' fails on Windows
Submitted: 24 May 2005 22:39 Modified: 5 Jul 2005 23:50
Reporter: Kent Boortz Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.6-pre OS:Windows (Windows)
Assigned to: Jim Winstead CPU Architecture:Any

[24 May 2005 22:39] Kent Boortz 
Description:
Testcase returns

information_schema              [ fail ]
Errors are (from C:/cygwin/home/mysqldev/kent/mysql-5.0.6-beta-win32/mysql-test/var/log/mysqltest-time) :
C:\cygwin\home\mysqldev\kent\mysql-5.0.6-beta-win32\bin\mysqltest.exe: At line 99: query 'create function sub1(i int) returns int^M
return i+1' failed: 1418: This routine is declared to be non-deterministic and to modify data and binary logging is enabled (you *might* want to use the less safe log_bin_trust_rout\
ine_creators variable)

How to repeat:
Run testcase on Windows
[2 Jun 2005 12:49] MySQL Verification Team 
Verified with 5.0.7:

=======================================================
Finding  Tests in the 'main' suite
Starting Tests in the 'main' suite

TEST                            RESULT
-------------------------------------------------------

information_schema              [ fail ]
Errors are (from d:/cygwin/home/miguel/mysql/mysql-test/var/log/mysqltest-time) :
[18 Jun 2005 1:02] 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/internals/26147
[29 Jun 2005 11:24] Magnus Blåudd 
Why is this added?

+  mtr_add_arg($args, "%s--log-bin-trust-routine-creators", $prefix);
[30 Jun 2005 18:27] Jim Winstead 
This adds an option to calling the server that is already used in the sh-based mysql-test-run. It prevents spurious errors in the test suite having to do with stored procedures.
[5 Jul 2005 23:50] Jim Winstead 
Fixed in 5.0.9.