Update mysql-client and mysql-server to 3.23.51nb1 - pkg revision kept

set, the packages contain extra security fixes, which are not part
of 3.23.51 distribution

NOTE: this is the last 3.23.x version with bundled mit-pthreads package;
any further upgrade would need some additional efford to keep the package
usable on NetBSD 1.6.x and older

Highlights of changes:
* Add missing <row> tags for mysqldump XML output.
* SHOW VARIABLES LIKE 'xxx' is now case-insensitive
* InnoDB now allows foreign key constraints to be added through the
  ALTER TABLE syntax.
* InnoDB tables can now be set to automatically grow in size (autoextend).
* Changed name of server variables Com_show_master_stat to
  Com_show_master_status and Com_show_slave_stat to Com_show_slave_status.
* Changed handling of gethostbyname() to make the client library thread-safe
  even if gethostbyname_r doesn't exist.
* If we get an overflow when inserting '+11111' for DECIMAL(5,0) UNSIGNED
  columns, we will just drop the sign.
* many bugfixes

Full list of changes:

3.23.50:
* Fixed buffer overflow problem if someone specified a too long datadir
  parameter to mysqld
* Add missing <row> tags for mysqldump XML output.
* Fixed problem with crash-me and gcc 3.0.4.
* Fixed that @@unknown_variable doesn't hang server.
* Added @@VERSION as a synonym for VERSION().
* SHOW VARIABLES LIKE 'xxx' is now case-insensitive.
* Fixed timeout for GET_LOCK() on HP-UX with DCE threads.
* Fixed memory allocation bug in the glibc library used to build Linux
  binaries, which caused mysqld to die in 'free()'.
* Fixed SIGINT and SIGQUIT problems in mysql.
* Fixed bug in character table converts when used with big ( > 64K) strings.
* InnoDB now retains foreign key constraints through ALTER TABLE and
  CREATE/DROP INDEX.
* InnoDB now allows foreign key constraints to be added through the
  ALTER TABLE syntax.
* InnoDB tables can now be set to automatically grow in size (autoextend).
* Our Linux RPMS and binaries are now compiled with gcc 3.0.4, which should
  make them a bit faster.
* Fixed some buffer overflow problems when reading startup parameters.
* Because of problems on shutdown we have now disabled named pipes on Windows
  by default. One can enable named pipes by starting mysqld
  with --enable-named-pipe.
* Fixed bug when using WHERE key_column = 'J' or key_column='j'.
* Fixed core-dump bug when using --log-bin with LOAD DATA INFILE without
  an active database.
* Fixed bug in RENAME TABLE when used with lower_case_table_names=1 (default
  on Windows).
* Fixed unlikely core-dump bug when using DROP TABLE on a table that was
  in use by a thread that also used queries on only temporary tables.
* Fixed problem with SHOW CREATE TABLE and PRIMARY KEY when using 32 indexes.
* Fixed that one can use SET PASSWORD for the anonymous user.
* Fixed core dump bug when reading client groups from option files using
  mysql_options().
* Memory leak (16 bytes per every corrupted table) closed.
* Fixed binary builds to use --enable-local-infile.
* Update source to work with new version of bison.
* Updated shell scripts to now agree with new POSIX standard.
* Fixed bug where DATE_FORMAT() returned empty string when used with GROUP BY.

3.23.51:
* Fix bug with closing tags missing slash for mysqldump XML output.
* Remove end space from ENUM values. (This fixed a problem with SHOW CREATE
  TABLE.)
* Fixed bug in CONCAT_WS() that cut the result.
* Changed name of server variables Com_show_master_stat to
  Com_show_master_status and Com_show_slave_stat to Com_show_slave_status.
* Changed handling of gethostbyname() to make the client library thread-safe
  even if gethostbyname_r doesn't exist.
* Fixed core-dump problem when giving a wrong password string to GRANT.
* Fixed bug in DROP DATABASE with symlinked directory.
* Fixed optimisation problem with DATETIME and value outside DATETIME range.
* Removed Sleepycat's BDB doc files from the source tree, as they're not needed
  (MySQL covers BDB in its own documentation).
* Fixed MIT-pthreads to compile with glibc 2.2 (needed for make dist).
* Fixed the FLOAT(X+1,X) is not converted to FLOAT(X+2,X). (This also affected
  DECIMAL, DOUBLE and REAL types)
* Fixed the result from IF() is case in-sensitive if the second and third
  arguments are case sensitive.
* Fixed core dump problem on OSF/1 in gethostbyname_r.
* Fixed that underflowed decimal fields are not zero filled.
* If we get an overflow when inserting '+11111' for DECIMAL(5,0) UNSIGNED
  columns, we will just drop the sign.
* Fixed optimisation bug with ISNULL(expression_which_cannot_be_null) and
  ISNULL(constant_expression).
* Fixed host lookup bug in the glibc library that we used with the 3.23.50
  Linux-x86 binaries.

10 files changed, 34 insertions, 34 deletions

diff --git a/databases/mysql-client/Makefile b/databases/mysql-client/Makefile
index 90c31a8a4bd..64092cd6b5a 100644
--- a/databases/mysql-client/Makefile
+++ b/databases/mysql-client/Makefile
@@ -1,7 +1,7 @@
-# $NetBSD: Makefile,v 1.25 2003/08/24 02:00:58 taca Exp $
+# $NetBSD: Makefile,v 1.26 2003/09/28 09:03:52 jdolecek Exp $
 
 PKGNAME=		${DISTNAME:S/-/-client-/}
-PKGREVISION=		4
+PKGREVISION=		1
 SVR4_PKGNAME=		mysqc
 COMMENT=		MySQL, a free SQL database (client)
 
diff --git a/databases/mysql-client/Makefile.common b/databases/mysql-client/Makefile.common
index f38ae9b7ae6..79927729564 100644
--- a/databases/mysql-client/Makefile.common
+++ b/databases/mysql-client/Makefile.common
@@ -1,6 +1,6 @@
-# $NetBSD: Makefile.common,v 1.17 2003/08/24 01:57:50 taca Exp $
+# $NetBSD: Makefile.common,v 1.18 2003/09/28 09:03:52 jdolecek Exp $
 
-DISTNAME=		mysql-3.23.49
+DISTNAME=		mysql-3.23.51
 CATEGORIES=		databases
 MASTER_SITES=		http://mirrors.sunsite.dk/mysql/Downloads/MySQL-3.23/ \
 			ftp://sunsite.dk/mirrors/mysql/Downloads/MySQL-3.23/ \
diff --git a/databases/mysql-client/PLIST b/databases/mysql-client/PLIST
index 52d8350b3c3..cc3064f0628 100644
--- a/databases/mysql-client/PLIST
+++ b/databases/mysql-client/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.6 2003/06/29 22:28:17 seb Exp $
+@comment $NetBSD: PLIST,v 1.7 2003/09/28 09:03:52 jdolecek Exp $
 bin/msql2mysql
 bin/mysql
 bin/mysqlcheck
@@ -62,7 +62,7 @@ share/mysql/my-huge.cnf
 share/mysql/my-large.cnf
 share/mysql/my-medium.cnf
 share/mysql/my-small.cnf
-share/mysql/mysql-3.23.49.spec
+share/mysql/mysql-3.23.51.spec
 share/mysql/mysql-log-rotate
 @dirrm share/mysql
 @dirrm lib/mysql
diff --git a/databases/mysql-client/buildlink2.mk b/databases/mysql-client/buildlink2.mk
index 16ebecc9cf0..9188e9edfc4 100644
--- a/databases/mysql-client/buildlink2.mk
+++ b/databases/mysql-client/buildlink2.mk
@@ -1,10 +1,10 @@
-# $NetBSD: buildlink2.mk,v 1.5 2003/03/14 19:37:34 jlam Exp $
+# $NetBSD: buildlink2.mk,v 1.6 2003/09/28 09:03:52 jdolecek Exp $
 
 .if !defined(MYSQL_CLIENT_BUILDLINK2_MK)
 MYSQL_CLIENT_BUILDLINK2_MK=	# defined
 
 BUILDLINK_PACKAGES+=			mysql-client
-BUILDLINK_DEPENDS.mysql-client?=	mysql-client>=3.23.49nb2
+BUILDLINK_DEPENDS.mysql-client?=	mysql-client>=3.23.51nb1
 BUILDLINK_PKGSRCDIR.mysql-client?=	../../databases/mysql-client
 
 EVAL_PREFIX+=	BUILDLINK_PREFIX.mysql-client=mysql-client
diff --git a/databases/mysql-client/distinfo b/databases/mysql-client/distinfo
index 98185772304..e7823e5ca4a 100644
--- a/databases/mysql-client/distinfo
+++ b/databases/mysql-client/distinfo
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.9 2002/12/13 14:19:54 tron Exp $
+$NetBSD: distinfo,v 1.10 2003/09/28 09:03:52 jdolecek Exp $
 
-SHA1 (mysql-3.23.49.tar.gz) = 0256331c7aa9388955148f80cdca382f467ad1be
-Size (mysql-3.23.49.tar.gz) = 11844905 bytes
-SHA1 (patch-af) = 5c627852dd12807580825199cdbd9a1ebc320f33
+SHA1 (mysql-3.23.51.tar.gz) = 5833feb9ecacd9870586d20a94c4c4650f988770
+Size (mysql-3.23.51.tar.gz) = 11203102 bytes
+SHA1 (patch-af) = 89dc4d3761cb9f2be0afc2658b80595ceacd1643
 SHA1 (patch-al) = 8d8738a168233dcf968b02c7c48c0711342ea200
diff --git a/databases/mysql-client/patches/patch-af b/databases/mysql-client/patches/patch-af
index 0bc7ac18fca..209ffe84c4a 100644
--- a/databases/mysql-client/patches/patch-af
+++ b/databases/mysql-client/patches/patch-af
@@ -1,12 +1,12 @@
-$NetBSD: patch-af,v 1.6 2002/03/18 14:17:39 martti Exp $
+$NetBSD: patch-af,v 1.7 2003/09/28 09:03:53 jdolecek Exp $
 
---- configure.orig	Thu Feb 14 18:30:42 2002
-+++ configure	Mon Mar 18 14:34:47 2002
-@@ -9509,7 +9509,6 @@
+--- configure.orig	2002-06-03 12:39:20.000000000 +0200
++++ configure	2003-09-28 10:31:36.000000000 +0200
+@@ -13397,7 +13397,6 @@
  else
    bench_dirs=""
  fi
 -bench_dirs="$bench_dirs mysql-test"
  
- 
  # Don't build readline, i have it already
+ 
diff --git a/databases/mysql-server/Makefile b/databases/mysql-server/Makefile
index 0cb13de2b2c..74711a9a992 100644
--- a/databases/mysql-server/Makefile
+++ b/databases/mysql-server/Makefile
@@ -1,7 +1,7 @@
-# $NetBSD: Makefile,v 1.49 2003/09/19 14:36:51 wiz Exp $
+# $NetBSD: Makefile,v 1.50 2003/09/28 09:03:53 jdolecek Exp $
 
 PKGNAME=		${DISTNAME:S/-/-server-/}
-PKGREVISION=		6
+PKGREVISION=		1
 SVR4_PKGNAME=		mysqs
 COMMENT=		MySQL, a free SQL database (server)
 
diff --git a/databases/mysql-server/distinfo b/databases/mysql-server/distinfo
index 02779110107..a93b64a2153 100644
--- a/databases/mysql-server/distinfo
+++ b/databases/mysql-server/distinfo
@@ -1,13 +1,13 @@
-$NetBSD: distinfo,v 1.21 2003/09/17 21:03:08 wiz Exp $
+$NetBSD: distinfo,v 1.22 2003/09/28 09:03:53 jdolecek Exp $
 
-SHA1 (mysql-3.23.49.tar.gz) = 0256331c7aa9388955148f80cdca382f467ad1be
-Size (mysql-3.23.49.tar.gz) = 11844905 bytes
-SHA1 (patch-aa) = 62ea698d88c7f402a94f584fcb27e564c5c31276
+SHA1 (mysql-3.23.51.tar.gz) = 5833feb9ecacd9870586d20a94c4c4650f988770
+Size (mysql-3.23.51.tar.gz) = 11203102 bytes
+SHA1 (patch-aa) = 78b86f81294ae1a483dcb64554d0c5d199201296
 SHA1 (patch-ab) = 8e80dc2b0def56f3453395f8310e71f8113c7ccd
 SHA1 (patch-ac) = 29fbb5bac3a81c3f9197c2d9ff84b795cdfbcaed
 SHA1 (patch-ad) = 7127dd00a6067aa06a563c13dde1ea25e70fa7bf
 SHA1 (patch-ae) = 81fa0273261ea44c599cf44f5a3a56935c3a62bd
-SHA1 (patch-af) = 78acdcd5a0f65ecaf545561eb3d450fa43746d1a
+SHA1 (patch-af) = 23afbae1f93c149612619f9b3c74dff1e871a019
 SHA1 (patch-ag) = 75634ff5c9ee61ff3ef61b1d9a4be4afc65e8754
 SHA1 (patch-ah) = 7cd4278c9bdc5220de04f7e6b62bb8d11c892ffb
 SHA1 (patch-ai) = 071e34cc9236b08cdc438afbb46801e66efc7e92
diff --git a/databases/mysql-server/patches/patch-aa b/databases/mysql-server/patches/patch-aa
index 8fc10f44527..5aa0661c27f 100644
--- a/databases/mysql-server/patches/patch-aa
+++ b/databases/mysql-server/patches/patch-aa
@@ -1,12 +1,12 @@
-$NetBSD: patch-aa,v 1.7 2003/01/21 08:13:19 lukem Exp $
+$NetBSD: patch-aa,v 1.8 2003/09/28 09:03:53 jdolecek Exp $
 
---- Makefile.in.orig	Thu Feb 14 18:50:36 2002
-+++ Makefile.in	Mon Mar 18 14:48:56 2002
-@@ -184,7 +184,7 @@
+--- Makefile.in.orig	2002-06-03 12:45:17.000000000 +0200
++++ Makefile.in	2003-09-28 09:59:18.000000000 +0200
+@@ -185,7 +185,7 @@
  # These are built from source in the Docs directory
  EXTRA_DIST = INSTALL-SOURCE README 			COPYING COPYING.LIB MIRRORS
  
--SUBDIRS = include @docs_dirs@ @readline_dir@ 			@thread_dirs@ @sql_client_dirs@ 			@sql_server_dirs@ scripts tests man 			@bench_dirs@ support-files
+-SUBDIRS = include @docs_dirs@ @readline_dir@ 			@thread_dirs@ @sql_client_dirs@ 			@sql_server_dirs@ scripts tests man 			@bench_dirs@ support-files os2
 +SUBDIRS = @thread_dirs@ @sql_server_dirs@ tests @bench_dirs@ support-files
  
  
diff --git a/databases/mysql-server/patches/patch-af b/databases/mysql-server/patches/patch-af
index bda888f030f..5cf0392dc1e 100644
--- a/databases/mysql-server/patches/patch-af
+++ b/databases/mysql-server/patches/patch-af
@@ -1,12 +1,12 @@
-$NetBSD: patch-af,v 1.10 2002/03/18 14:17:45 martti Exp $
+$NetBSD: patch-af,v 1.11 2003/09/28 09:03:53 jdolecek Exp $
 
---- configure.orig	Thu Feb 14 18:30:42 2002
-+++ configure	Mon Mar 18 14:49:41 2002
-@@ -9509,7 +9509,6 @@
+--- configure.orig	2002-06-03 12:39:20.000000000 +0200
++++ configure	2003-09-28 10:01:27.000000000 +0200
+@@ -13397,7 +13397,6 @@
  else
    bench_dirs=""
  fi
 -bench_dirs="$bench_dirs mysql-test"
  
- 
  # Don't build readline, i have it already
+