MySQL Bugs: #3459: timezone test fails in 4.0.18

Bug #3459	timezone test fails in 4.0.18
Submitted:	13 Apr 2004 10:40	Modified:	27 Apr 2004 13:38
Reporter:	Bryn Dyment	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Installing	Severity:	S3 (Non-critical)
Version:	4.0.18	OS:	FreeBSD (FreeBSD)
Assigned to:	Sergei Golubchik	CPU Architecture:	Any

Description:
timezone                       [ fail ]

Errors are (from /usr/local/src/mysql-4.0.18/mysql-test/var/log/mysqltest-time) :
/usr/local/src/mysql-4.0.18/client/mysqltest: At line 48: Result length mismatch
(the last line(s) may be the ones that caused the die() in mysqltest)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/timezone.result   Tue Feb 10 21:39:43 2004
--- r/timezone.reject   Tue Apr 13 20:29:36 2004
***************
*** 1,7 ****
  DROP TABLE IF EXISTS t1;
  show variables like "timezone";
  Variable_name Value
! timezone      MET
  select @a:=FROM_UNIXTIME(1);
  @a:=FROM_UNIXTIME(1)
  1970-01-01 01:00:01
--- 1,7 ----
  DROP TABLE IF EXISTS t1;
  show variables like "timezone";
  Variable_name Value
! timezone      MEST
  select @a:=FROM_UNIXTIME(1);
  @a:=FROM_UNIXTIME(1)
  1970-01-01 01:00:01
-------------------------------------------------------

How to repeat:
Built from source on a clean FreeBSD 4.9 machine:

cd /usr/local/src
fetch -o mysql-4.0.18.tar.gz http://dev.mysql.com/get/Downloads/MySQL-4.0/mysql-4.0.18.tar.gz/from/http://mysql.he.net/
pw groupadd mysql
pw useradd mysql -g mysql
tar -xzf mysql-4.0.18.tar.gz
cd mysql-4.0.18
./configure --prefix=/usr/local/mysql --with-extra-charsets=complex --enable-thread-safe-client --enable-local-infile --enable-assembler --with-named-z-libs=not-used --disable-shared (from INSTALL-SOURCE)
make
make test

Same problem:  Linux Mandrake 10, using gcc 3.3.3. (gcc compiled w/ no options) and the mandrake stock gcc (3.3.2)

mysql 4.0.18 configured w/: --prefix /my/path --with-extra-charsets=all

Confirmed on numerous builds

This also occurs on Fedora Core 1, fully updated.

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