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.

4 files changed, 18 insertions, 18 deletions

diff --git a/databases/mysql-server/distinfo b/databases/mysql-server/distinfo
index bda784177ce..e9ec70a33fa 100644
--- a/databases/mysql-server/distinfo
+++ b/databases/mysql-server/distinfo
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.10 2002/01/08 14:09:38 martti Exp $
+$NetBSD: distinfo,v 1.11 2002/03/18 14:17:43 martti Exp $
 
-SHA1 (mysql-3.23.47.tar.gz) = 3e33fc126f1c9b48df6934e39a22feaa53f4d2c0
-Size (mysql-3.23.47.tar.gz) = 11939073 bytes
-SHA1 (patch-aa) = 9b131a94a758085dd312a4320ea7d179a32a7c5f
-SHA1 (patch-ae) = ae92a86f356228d737fb40ef7bbd6ffa6d3164ba
-SHA1 (patch-af) = dfb22d74216e753cde8626942201a08cc78372a3
+SHA1 (mysql-3.23.49.tar.gz) = 0256331c7aa9388955148f80cdca382f467ad1be
+Size (mysql-3.23.49.tar.gz) = 11844905 bytes
+SHA1 (patch-aa) = d40a52dd115b3fd4236d66c2c5946fddc04f13cb
+SHA1 (patch-ae) = 81fa0273261ea44c599cf44f5a3a56935c3a62bd
+SHA1 (patch-af) = 78acdcd5a0f65ecaf545561eb3d450fa43746d1a
 SHA1 (patch-ah) = 7cd4278c9bdc5220de04f7e6b62bb8d11c892ffb
diff --git a/databases/mysql-server/patches/patch-aa b/databases/mysql-server/patches/patch-aa
index 91c078d767a..0591060e6cb 100644
--- a/databases/mysql-server/patches/patch-aa
+++ b/databases/mysql-server/patches/patch-aa
@@ -1,8 +1,8 @@
-$NetBSD: patch-aa,v 1.5 2002/01/08 14:09:39 martti Exp $
+$NetBSD: patch-aa,v 1.6 2002/03/18 14:17:44 martti Exp $
 
---- Makefile.in.orig	Thu Dec 27 13:37:01 2001
-+++ Makefile.in	Tue Jan  8 13:55:38 2002
-@@ -182,7 +182,7 @@
+--- Makefile.in.orig	Thu Feb 14 18:50:36 2002
++++ Makefile.in	Mon Mar 18 14:48:56 2002
+@@ -184,7 +184,7 @@
  # These are built from source in the Docs directory
  EXTRA_DIST = INSTALL-SOURCE README 			COPYING COPYING.LIB MIRRORS
  
diff --git a/databases/mysql-server/patches/patch-ae b/databases/mysql-server/patches/patch-ae
index 3e5eaf03fa2..855dfce9945 100644
--- a/databases/mysql-server/patches/patch-ae
+++ b/databases/mysql-server/patches/patch-ae
@@ -1,8 +1,8 @@
-$NetBSD: patch-ae,v 1.9 2002/01/08 14:09:39 martti Exp $
+$NetBSD: patch-ae,v 1.10 2002/03/18 14:17:44 martti Exp $
 
---- configure.in.orig	Thu Dec 27 13:23:29 2001
-+++ configure.in	Tue Jan  8 13:56:02 2002
-@@ -1716,7 +1716,6 @@
+--- configure.in.orig	Thu Feb 14 18:30:15 2002
++++ configure.in	Mon Mar 18 14:49:20 2002
+@@ -1743,7 +1743,6 @@
  else
    bench_dirs=""
  fi
diff --git a/databases/mysql-server/patches/patch-af b/databases/mysql-server/patches/patch-af
index 8d8bd51cb43..bda888f030f 100644
--- a/databases/mysql-server/patches/patch-af
+++ b/databases/mysql-server/patches/patch-af
@@ -1,8 +1,8 @@
-$NetBSD: patch-af,v 1.9 2002/01/08 14:09:39 martti Exp $
+$NetBSD: patch-af,v 1.10 2002/03/18 14:17:45 martti Exp $
 
---- configure.orig	Thu Dec 27 13:23:51 2001
-+++ configure	Tue Jan  8 13:56:24 2002
-@@ -9629,7 +9629,6 @@
+--- configure.orig	Thu Feb 14 18:30:42 2002
++++ configure	Mon Mar 18 14:49:41 2002
+@@ -9509,7 +9509,6 @@
  else
    bench_dirs=""
  fi