Bug #8593 'sp' fails in 5.0.3-alpha when running PS protocol tests
Submitted: 17 Feb 2005 22:52 Modified: 18 Feb 2005 13:40
Reporter: Matt Wagner Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:5.0.3-alpha OS:many, use 'build' as example
Assigned to: Per-Erik Martin CPU Architecture:Any

[17 Feb 2005 22:52] Matt Wagner
Description:
on 'build' from a 5.0.3-alpha '-standard' compile:

sp                             [ fail ]
10545: 
10546: Errors are (from /build/mysqldev/build/test/mysql-standard-5.0.3-alpha-pc-linux-gnu-i686/mysql-test/var/log/mysqltest-time) :
10547: /build/mysqldev/build/test/mysql-standard-5.0.3-alpha-pc-linux-gnu-i686/bin/mysqltest: At line 2856: Result length mismatch
10548: (the last lines may be the most important ones)
10549: Below are the diffs between actual and expected results:
10550: -------------------------------------------------------
10551: *** r/sp.result  Tue Feb 15 23:38:03 2005
10552: --- r/sp.reject  Wed Feb 16 13:13:41 2005
10553: ***************
10554: *** 2366,2372 ****
10555:   insert into t1 values ("answer", 42)|
10556:   select id, bug5240() from t1|
10557:   id     bug5240()
10558: ! 42     42
10559:   drop function bug5240|
10560:   drop function if exists bug5278|
10561:   create function bug5278 () returns char
10562: --- 2366,2372 ----
10563:   insert into t1 values ("answer", 42)|
10564:   select id, bug5240() from t1|
10565:   id     bug5240()
10566: ! NULL   10802
10567:   drop function bug5240|
10568:   drop function if exists bug5278|
10569:   create function bug5278 () returns char
10570: -------------------------------------------------------

How to repeat:
compile 5.0.3-alpha '-standard' on 'build' and run --ps-protocol test suite.

See this url for affected platforms: https://intranet.mysql.com/~kboortz/status/mysql-5.0.3-alpha/builds.html
[18 Feb 2005 13:40] Per-Erik Martin
This was fixed in the source already.