Module Name:	pkgsrc
Committed By:	jdolecek
Date:		Sun Sep 28 09:03:53 UTC 2003

Modified Files:
	pkgsrc/databases/mysql-client: Makefile Makefile.common PLIST
	    buildlink2.mk distinfo
	pkgsrc/databases/mysql-client/patches: patch-af
	pkgsrc/databases/mysql-server: Makefile distinfo
	pkgsrc/databases/mysql-server/patches: patch-aa patch-af
	pkgsrc/doc: CHANGES

Log Message:
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.


To generate a diff of this commit:
cvs rdiff -r1.25 -r1.26 pkgsrc/databases/mysql-client/Makefile
cvs rdiff -r1.17 -r1.18 pkgsrc/databases/mysql-client/Makefile.common
cvs rdiff -r1.6 -r1.7 pkgsrc/databases/mysql-client/PLIST
cvs rdiff -r1.5 -r1.6 pkgsrc/databases/mysql-client/buildlink2.mk
cvs rdiff -r1.9 -r1.10 pkgsrc/databases/mysql-client/distinfo
cvs rdiff -r1.6 -r1.7 pkgsrc/databases/mysql-client/patches/patch-af
cvs rdiff -r1.49 -r1.50 pkgsrc/databases/mysql-server/Makefile
cvs rdiff -r1.21 -r1.22 pkgsrc/databases/mysql-server/distinfo
cvs rdiff -r1.7 -r1.8 pkgsrc/databases/mysql-server/patches/patch-aa
cvs rdiff -r1.10 -r1.11 pkgsrc/databases/mysql-server/patches/patch-af
cvs rdiff -r1.3560 -r1.3561 pkgsrc/doc/CHANGES

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