Subject: CVS commit: pkgsrc/databases/mysql-server
To: None <pkgsrc-changes@netbsd.org>
From: Martti Kuparinen <martti@netbsd.org>
List: pkgsrc-changes
Date: 03/18/2002 16:17:45
Module Name:	pkgsrc
Committed By:	martti
Date:		Mon Mar 18 14:17:45 UTC 2002

Modified Files:
	pkgsrc/databases/mysql-server: distinfo
	pkgsrc/databases/mysql-server/patches: patch-aa patch-ae patch-af

Log Message:
Updated mysql-server to 3.23.49

* Don't give warning for statement that is only a comment; This is
  needed for mysqldump --disable-keys to work.
* Fixed unlikely caching bug when doing a join without keys. In this case
  the last used field for a table always returned NULL.
* Added options to make LOAD DATA LOCAL INFILE more secure.
* Added --xml option to mysqldump for producing XML output.
* Changed to use autoconf 2.52 (from autoconf 2.13)
* Fixed bug in complicated join with const tables.
* Added internal safety checks for InnoDB.
* Some InnoDB variables was always shown in SHOW VARIABLES as OFF on
  high-byte-first systems (like sparc).
* Fixed problem with one thread using an InnoDB table and another thread
  doing an ALTER TABLE on the same table. Before that, mysqld could crash
  with an assertion failure in row0row.c, line 474.
* Tuned the InnoDB SQL optimizer to favor more often index searches over
  table scans. SELECT queries will now also generally run faster on all
  platforms.
* If MySQL binlogging is used, InnoDB now prints after crash recovery the
  latest MySQL binlog name and the offset InnoDB was able to recover to.
  This is useful, for example, when resynchronizing a master and a slave
  database in replication.
* Added better error messages to help in installation problems of
  InnoDB tables.
* One can now recover also MySQL temporary tables which have become
  orphaned inside the InnoDB tablespace.
* InnoDB now prevents a FOREIGN KEY declaration where the signedness is
  not the same in the referencing and referenced integer columns.
* Calling SHOW CREATE TABLE or SHOW TABLE STATUS could cause memory
  corruption and make mysqld to crash. Especially at risk was mysqldump,
  because it calls frequently SHOW CREATE TABLE.
* If inserts to several tables containing an auto-inc column were wrapped
  inside one LOCK TABLES, InnoDB asserted in lock0lock.c.
* In 3.23.47 we allowed several NULLS in a UNIQUE secondary index for an
  InnoDB table. But CHECK TABLE was not relaxed: it reports the table as
  corrupt. CHECK TABLE no longer complains in this situation.
* SHOW GRANTS now shows REFERENCES instead of REFERENCE.


To generate a diff of this commit:
cvs rdiff -r1.10 -r1.11 pkgsrc/databases/mysql-server/distinfo
cvs rdiff -r1.5 -r1.6 pkgsrc/databases/mysql-server/patches/patch-aa
cvs rdiff -r1.9 -r1.10 pkgsrc/databases/mysql-server/patches/patch-ae \
    pkgsrc/databases/mysql-server/patches/patch-af

Please note that diffs are not public domain; they are subject to the
copyright notices on the relevant files.