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

[13 Apr 2004 10:40] Bryn Dyment
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
[15 Apr 2004 7:57] John Marquart
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
[15 Apr 2004 11:44] Bernard Johnson
This also occurs on Fedora Core 1, fully updated.
[27 Apr 2004 13:38] Sergei Golubchik
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