MySQL Bugs: #7204: "func_str" fails on AIX 4.3 when using --ps-protocol

Bug #7204	"func_str" fails on AIX 4.3 when using --ps-protocol
Submitted:	12 Dec 2004 17:20	Modified:	13 Dec 2004 7:50
Reporter:	Lenz Grimmer	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	4.1.8-pre	OS:	IBM AIX (AIX 4.3.3)
Assigned to:	Sergei Golubchik	CPU Architecture:	Any

Description:
The "func_str" test fails on IBM AIX 4.3.3 when using the prepared statement protocol with the following diff:

TEST                            RESULT
-------------------------------------------------------
func_str                       [ fail ]

Errors are (from /home/mysqldev/aix43/test/mysql-debug-4.1.8-ibm-aix4.3.3.0-powerpc/mysql-test/var/log/mysqltest-time) :
/home/mysqldev/aix43/test/mysql-debug-4.1.8-ibm-aix4.3.3.0-powerpc/bin/mysqltest: At line 432: Result content mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/func_str.result   Fri Dec 10 22:09:45 2004
--- r/func_str.reject   Sun Dec 12 20:17:17 2004
***************
*** 689,693 ****
  insert into t1 (a,b,c) values (1,'Tom',now()),(2,'ball games',now()), (3,'Basil',now()), (4,'Dean',now()),(5,'Ellis',now()), (6,'Serg',now()), (7,'Sergei',now()),(8,'Georg',now()),(9,'Salle',now()),(10,'Sinisa',now());
  select count(*) as total, left(c,10) as reg from t1 group by reg order by reg desc limit 0,12;
  total reg
! 10    2004-12-10
  drop table t1;
--- 689,693 ----
  insert into t1 (a,b,c) values (1,'Tom',now()),(2,'ball games',now()), (3,'Basil',now()), (4,'Dean',now()),(5,'Ellis',now()), (6,'Serg',now()), (7,'Sergei',now()),(8,'Georg',now()),(9,'Salle',now()),(10,'Sinisa',now());
  select count(*) as total, left(c,10) as reg from t1 group by reg order by reg desc limit 0,12;
  total reg
! 10    2004-12-12
  drop table t1;
-------------------------------------------------------

How to repeat:
Run the "func_str" test on aix 4.3 and observe the diff.

Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

Additional info:

Fixed a couple of days ago.

Nothing to investigate here - test uses now() so it's by definition not repeatable.

You are right - we used an older source tarball on aix43 by accident. Now retesting with the correct one.