Changes 5.0.37:

* Added the SHOW PROFILES and SHOW PROFILE statements to display statement
  profile data, and the accompanying INFORMATION_SCHEMA.PROFILING table.

* Added the Uptime_since_flush_status status variable, which indicates the
  number of seconds since the most recent FLUSH STATUS statement.

* Incompatible change in DATE_FORMAT().

* NDB Cluster: The LockPagesInMainMemory configuration parameter has changed
  its type and possible values.

* The bundled yaSSL library was upgraded to version 1.5.8.

* The --skip-thread-priority option now is enabled by default for binary Mac
  OS X distributions. Use of thread priorities degrades performance on Mac OS X.

* Added the --disable-grant-options option to configure.

* Bug fixes.

18 files changed, 191 insertions, 132 deletions

diff --git a/databases/mysql5-server/Makefile b/databases/mysql5-server/Makefile
index fbf9abb833b..079a6f2b9c7 100644
--- a/databases/mysql5-server/Makefile
+++ b/databases/mysql5-server/Makefile
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile,v 1.17 2007/01/07 09:13:50 rillig Exp $
+# $NetBSD: Makefile,v 1.18 2007/03/11 18:42:49 adam Exp $
 
 PKGNAME=		${DISTNAME:S/-/-server-/}
 SVR4_PKGNAME=		mysqs
@@ -32,7 +32,7 @@ FILES_SUBST+=		HOSTNAME_CMD=${HOSTNAME_CMD:Q} \
 MESSAGE_SUBST+=		MYSQL_DATADIR=${MYSQL_DATADIR} \
 			MYSQL_USER=${MYSQL_USER} MYSQL_GROUP=${MYSQL_GROUP}
 BUILD_DEFS+=		MYSQL_DATADIR
-BUILD_DIRS=		${WRKSRC} ${WRKSRC}/man
+BUILD_DIRS=		. man
 
 REPLACE_PERL+=		mysql-test/mysql-test-run.pl
 
@@ -49,17 +49,16 @@ BUILDLINK_DEPMETHOD.readline=build
 .include "../../security/tcp_wrappers/buildlink3.mk"
 
 post-configure:
-	cd ${WRKSRC} && ${CP} -f config.h include/my_config.h
+	cd ${WRKSRC} && cp -f config.h include/my_config.h
 
 post-build:
-	cd ${WRKSRC}/scripts && ${SETENV} ${MAKE_ENV} ${MAKE_PROGRAM}	\
+	cd ${WRKSRC}/scripts && env ${MAKE_ENV} ${MAKE_PROGRAM}	\
 		${MAKE_FLAGS} mysqld_safe mysql_install_db
 
 post-install:
 	${INSTALL_SCRIPT} ${WRKSRC}/scripts/mysqld_safe ${PREFIX}/bin
 	${INSTALL_SCRIPT} ${WRKSRC}/scripts/mysql_install_db ${PREFIX}/bin
 	${INSTALL_SCRIPT} ${WRKSRC}/support-files/mysql.server ${PREFIX}/bin
-	${INSTALL_MAN} ${WRKSRC}/man/mysqld.1 ${PREFIX}/${PKGMANDIR}/man1
 	${INSTALL_MAN} ${WRKSRC}/man/mysqld_multi.1 ${PREFIX}/${PKGMANDIR}/man1
 	#${INSTALL_MAN} ${WRKSRC}/man/mysqld_safe.1 ${PREFIX}/${PKGMANDIR}/man1
 	${INSTALL_SCRIPT} ${WRKSRC}/scripts/mysql_secure_installation.sh \
diff --git a/databases/mysql5-server/PLIST b/databases/mysql5-server/PLIST
index 534189b07db..8aba6382e6b 100644
--- a/databases/mysql5-server/PLIST
+++ b/databases/mysql5-server/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.8 2006/10/14 18:41:34 xtraeme Exp $
+@comment $NetBSD: PLIST,v 1.9 2007/03/11 18:42:49 adam Exp $
 bin/comp_err
 bin/innochecksum
 bin/my_print_defaults
@@ -25,7 +25,6 @@ lib/mysql/libmystrings.a
 lib/mysql/libmysys.a
 lib/mysql/libvio.a
 libexec/mysqld
-man/man1/mysqld.1
 man/man1/mysqld_multi.1
 man/man8/mysqld.8
 man/man8/mysqlmanager.8
@@ -34,7 +33,9 @@ share/mysql-test/README
 share/mysql-test/cacert.pem
 share/mysql-test/client-cert.pem
 share/mysql-test/client-key.pem
+share/mysql-test/include/analyze_failure_sync_with_master.test
 share/mysql-test/include/big_test.inc
+share/mysql-test/include/check-testcase.test
 share/mysql-test/include/check_var_limit.inc
 share/mysql-test/include/common-tests.inc
 share/mysql-test/include/ctype_common.inc
@@ -78,11 +79,11 @@ share/mysql-test/include/have_ucs2.inc
 share/mysql-test/include/have_udf.inc
 share/mysql-test/include/have_ujis.inc
 share/mysql-test/include/im_check_env.inc
+share/mysql-test/include/innodb_rollback_on_timeout.inc
 share/mysql-test/include/is_debug_build.inc
 share/mysql-test/include/loaddata_autocom.inc
 share/mysql-test/include/master-slave.inc
 share/mysql-test/include/mysqltest-x.inc
-share/mysql-test/include/mysqltest_while.inc
 share/mysql-test/include/ndb_default_cluster.inc
 share/mysql-test/include/not_as_root.inc
 share/mysql-test/include/not_embedded.inc
@@ -94,17 +95,18 @@ share/mysql-test/include/ps_modify.inc
 share/mysql-test/include/ps_modify1.inc
 share/mysql-test/include/ps_query.inc
 share/mysql-test/include/ps_renew.inc
+share/mysql-test/include/report-features.test
 share/mysql-test/include/rpl_stmt_seq.inc
 share/mysql-test/include/show_msg.inc
 share/mysql-test/include/show_msg80.inc
-share/mysql-test/include/sourced.inc
-share/mysql-test/include/sourced1.inc
 share/mysql-test/include/sp-vars.inc
 share/mysql-test/include/strict_autoinc.inc
 share/mysql-test/include/system_db_struct.inc
 share/mysql-test/include/test_outfile.inc
 share/mysql-test/include/testdb_only.inc
 share/mysql-test/include/varchar.inc
+share/mysql-test/include/wait_for_query_to_suceed.inc
+share/mysql-test/include/wait_show_pattern.inc
 share/mysql-test/include/wait_slave_status.inc
 share/mysql-test/include/windows.inc
 share/mysql-test/install_test_db
@@ -113,6 +115,7 @@ share/mysql-test/lib/mtr_cases.pl
 share/mysql-test/lib/mtr_diff.pl
 share/mysql-test/lib/mtr_gcov.pl
 share/mysql-test/lib/mtr_gprof.pl
+share/mysql-test/lib/mtr_im.pl
 share/mysql-test/lib/mtr_io.pl
 share/mysql-test/lib/mtr_match.pl
 share/mysql-test/lib/mtr_misc.pl
@@ -120,10 +123,13 @@ share/mysql-test/lib/mtr_process.pl
 share/mysql-test/lib/mtr_report.pl
 share/mysql-test/lib/mtr_stress.pl
 share/mysql-test/lib/mtr_timer.pl
+share/mysql-test/lib/mtr_unique.pl
 share/mysql-test/mtr
 share/mysql-test/mysql-test-run
+share/mysql-test/mysql-test-run-shell
 share/mysql-test/mysql-test-run.pl
 share/mysql-test/r/alias.result
+share/mysql-test/r/alter_table-big.result
 share/mysql-test/r/alter_table.result
 share/mysql-test/r/analyse.result
 share/mysql-test/r/analyze.result
@@ -139,6 +145,7 @@ share/mysql-test/r/bdb-deadlock.result
 share/mysql-test/r/bdb.result
 share/mysql-test/r/bdb_cache.result
 share/mysql-test/r/bdb_gis.result
+share/mysql-test/r/bdb_notembedded.result
 share/mysql-test/r/bench_count_distinct.result
 share/mysql-test/r/big_test.require
 share/mysql-test/r/bigint.result
@@ -178,6 +185,7 @@ share/mysql-test/r/ctype_eucjpms.result
 share/mysql-test/r/ctype_euckr.result
 share/mysql-test/r/ctype_gb2312.result
 share/mysql-test/r/ctype_gbk.result
+share/mysql-test/r/ctype_hebrew.result
 share/mysql-test/r/ctype_latin1.result
 share/mysql-test/r/ctype_latin1_de.result
 share/mysql-test/r/ctype_latin2.result
@@ -206,12 +214,17 @@ share/mysql-test/r/empty_table.result
 share/mysql-test/r/endspace.result
 share/mysql-test/r/errors.result
 share/mysql-test/r/exampledb.result
+share/mysql-test/r/execution_constants.result
 share/mysql-test/r/explain.result
 share/mysql-test/r/federated.result
 share/mysql-test/r/federated_archive.result
 share/mysql-test/r/federated_bug_13118.result
+share/mysql-test/r/fix_priv_tables.result
+share/mysql-test/r/fix_priv_tabs.result
 share/mysql-test/r/flush.result
+share/mysql-test/r/flush2.result
 share/mysql-test/r/flush_block_commit.result
+share/mysql-test/r/flush_block_commit_notembedded.result
 share/mysql-test/r/flush_read_lock_kill.result
 share/mysql-test/r/flush_table.result
 share/mysql-test/r/foreign_key.result
@@ -282,6 +295,7 @@ share/mysql-test/r/have_innodb.require
 share/mysql-test/r/have_latin2_ch.require
 share/mysql-test/r/have_met_timezone.require
 share/mysql-test/r/have_moscow_leap_timezone.require
+share/mysql-test/r/have_mysql_upgrade.result
 share/mysql-test/r/have_ndb.require
 share/mysql-test/r/have_ndb_status_ok.require
 share/mysql-test/r/have_openssl.require
@@ -329,8 +343,10 @@ share/mysql-test/r/innodb_gis.result
 share/mysql-test/r/innodb_handler.result
 share/mysql-test/r/innodb_mysql.result
 share/mysql-test/r/innodb_notembedded.result
+share/mysql-test/r/innodb_timeout_rollback.result
 share/mysql-test/r/innodb_unsafe_binlog.result
 share/mysql-test/r/insert.result
+share/mysql-test/r/insert_notembedded.result
 share/mysql-test/r/insert_select-binlog.result
 share/mysql-test/r/insert_select.result
 share/mysql-test/r/insert_update.result
@@ -372,6 +388,8 @@ share/mysql-test/r/myisam.result
 share/mysql-test/r/mysql.result
 share/mysql-test/r/mysql_client_test.result
 share/mysql-test/r/mysql_protocols.result
+share/mysql-test/r/mysql_upgrade.result
+share/mysql-test/r/mysqladmin.result
 share/mysql-test/r/mysqlbinlog.result
 share/mysql-test/r/mysqlbinlog2.result
 share/mysql-test/r/mysqlcheck.result
@@ -436,6 +454,7 @@ share/mysql-test/r/overflow.result
 share/mysql-test/r/packet.result
 share/mysql-test/r/perror.result
 share/mysql-test/r/preload.result
+share/mysql-test/r/profiling.result
 share/mysql-test/r/ps.result
 share/mysql-test/r/ps_10nestset.result
 share/mysql-test/r/ps_11bugs.result
@@ -457,6 +476,7 @@ share/mysql-test/r/rename.result
 share/mysql-test/r/repair.result
 share/mysql-test/r/replace.result
 share/mysql-test/r/rollback.result
+share/mysql-test/r/round.result
 share/mysql-test/r/row.result
 share/mysql-test/r/rowid_order_bdb.result
 share/mysql-test/r/rowid_order_innodb.result
@@ -473,14 +493,13 @@ share/mysql-test/r/rpl000012.result
 share/mysql-test/r/rpl000013.result
 share/mysql-test/r/rpl000015.result
 share/mysql-test/r/rpl000017.result
-share/mysql-test/r/rpl000018.result
 share/mysql-test/r/rpl_EE_error.result
 share/mysql-test/r/rpl_alter.result
 share/mysql-test/r/rpl_auto_increment.result
 share/mysql-test/r/rpl_auto_increment_11932.result
-share/mysql-test/r/rpl_chain_temp_table.result
 share/mysql-test/r/rpl_change_master.result
 share/mysql-test/r/rpl_charset.result
+share/mysql-test/r/rpl_charset_sjis.result
 share/mysql-test/r/rpl_commit_after_flush.result
 share/mysql-test/r/rpl_create_database.result
 share/mysql-test/r/rpl_ddl.result
@@ -494,12 +513,10 @@ share/mysql-test/r/rpl_dual_pos_advance.result
 share/mysql-test/r/rpl_empty_master_crash.result
 share/mysql-test/r/rpl_error_ignored_table.result
 share/mysql-test/r/rpl_failed_optimize.result
-share/mysql-test/r/rpl_failsafe.result
 share/mysql-test/r/rpl_flush_log_loop.result
 share/mysql-test/r/rpl_flush_tables.result
 share/mysql-test/r/rpl_free_items.result
 share/mysql-test/r/rpl_get_lock.result
-share/mysql-test/r/rpl_heap.result
 share/mysql-test/r/rpl_ignore_grant.result
 share/mysql-test/r/rpl_ignore_revoke.result
 share/mysql-test/r/rpl_ignore_table.result
@@ -512,6 +529,7 @@ share/mysql-test/r/rpl_loaddata.result
 share/mysql-test/r/rpl_loaddata_rule_m.result
 share/mysql-test/r/rpl_loaddata_rule_s.result
 share/mysql-test/r/rpl_loaddatalocal.result
+share/mysql-test/r/rpl_locale.result
 share/mysql-test/r/rpl_log.result
 share/mysql-test/r/rpl_log_pos.result
 share/mysql-test/r/rpl_many_optimize.result
@@ -529,6 +547,7 @@ share/mysql-test/r/rpl_mystery22.result
 share/mysql-test/r/rpl_ndb_innodb_trans.result
 share/mysql-test/r/rpl_openssl.result
 share/mysql-test/r/rpl_optimize.result
+share/mysql-test/r/rpl_packet.result
 share/mysql-test/r/rpl_ps.result
 share/mysql-test/r/rpl_redirect.result
 share/mysql-test/r/rpl_relayrotate.result
@@ -577,10 +596,13 @@ share/mysql-test/r/sp-threads.result
 share/mysql-test/r/sp-vars.result
 share/mysql-test/r/sp.result
 share/mysql-test/r/sp_notembedded.result
+share/mysql-test/r/sp_stress_case.result
 share/mysql-test/r/sp_trans.result
 share/mysql-test/r/sql_mode.result
 share/mysql-test/r/ssl.result
 share/mysql-test/r/ssl_compress.result
+share/mysql-test/r/ssl_connect.result
+share/mysql-test/r/ssl_des.result
 share/mysql-test/r/status.result
 share/mysql-test/r/strict.result
 share/mysql-test/r/strict_autoinc_1myisam.result
@@ -590,6 +612,7 @@ share/mysql-test/r/strict_autoinc_4bdb.result
 share/mysql-test/r/strict_autoinc_5ndb.result
 share/mysql-test/r/subselect.result
 share/mysql-test/r/subselect2.result
+share/mysql-test/r/subselect3.result
 share/mysql-test/r/subselect_gis.result
 share/mysql-test/r/subselect_innodb.result
 share/mysql-test/r/subselect_notembedded.result
@@ -606,6 +629,7 @@ share/mysql-test/r/testdb_only.require
 share/mysql-test/r/timezone.result
 share/mysql-test/r/timezone2.result
 share/mysql-test/r/timezone3.result
+share/mysql-test/r/timezone4.result
 share/mysql-test/r/timezone_grant.result
 share/mysql-test/r/trigger-compat.result
 share/mysql-test/r/trigger-grant.result
@@ -651,8 +675,12 @@ share/mysql-test/server-cert.pem
 share/mysql-test/server-key.pem
 share/mysql-test/std_data/14897.frm
 share/mysql-test/std_data/Moscow_leap
+share/mysql-test/std_data/bad_gis_data.dat
 share/mysql-test/std_data/bug15328.cnf
 share/mysql-test/std_data/bug16266.000001
+share/mysql-test/std_data/bug19371.MYD
+share/mysql-test/std_data/bug19371.MYI
+share/mysql-test/std_data/bug19371.frm
 share/mysql-test/std_data/cacert.pem
 share/mysql-test/std_data/client-cert.pem
 share/mysql-test/std_data/client-key.pem
@@ -671,7 +699,9 @@ share/mysql-test/std_data/ndb_config_mycnf2.cnf
 share/mysql-test/std_data/rpl_loaddata.dat
 share/mysql-test/std_data/rpl_loaddata2.dat
 share/mysql-test/std_data/rpl_timezone.dat
+share/mysql-test/std_data/server-cert-des.pem
 share/mysql-test/std_data/server-cert.pem
+share/mysql-test/std_data/server-key-des.pem
 share/mysql-test/std_data/server-key.pem
 share/mysql-test/std_data/trunc_binlog.000001
 share/mysql-test/std_data/untrusted-cacert.pem
@@ -679,6 +709,7 @@ share/mysql-test/std_data/vchar.frm
 share/mysql-test/std_data/warnings_loaddata.dat
 share/mysql-test/std_data/words.dat
 share/mysql-test/t/alias.test
+share/mysql-test/t/alter_table-big.test
 share/mysql-test/t/alter_table.test
 share/mysql-test/t/analyse.test
 share/mysql-test/t/analyze.test
@@ -697,6 +728,7 @@ share/mysql-test/t/bdb.test
 share/mysql-test/t/bdb_cache-master.opt
 share/mysql-test/t/bdb_cache.test
 share/mysql-test/t/bdb_gis.test
+share/mysql-test/t/bdb_notembedded.test
 share/mysql-test/t/bench_count_distinct.test
 share/mysql-test/t/bigint.test
 share/mysql-test/t/binary.test
@@ -735,6 +767,7 @@ share/mysql-test/t/ctype_eucjpms.test
 share/mysql-test/t/ctype_euckr.test
 share/mysql-test/t/ctype_gb2312.test
 share/mysql-test/t/ctype_gbk.test
+share/mysql-test/t/ctype_hebrew.test
 share/mysql-test/t/ctype_latin1.test
 share/mysql-test/t/ctype_latin1_de-master.opt
 share/mysql-test/t/ctype_latin1_de.test
@@ -767,12 +800,17 @@ share/mysql-test/t/empty_table.test
 share/mysql-test/t/endspace.test
 share/mysql-test/t/errors.test
 share/mysql-test/t/exampledb.test
+share/mysql-test/t/execution_constants.test
 share/mysql-test/t/explain.test
 share/mysql-test/t/federated.test
 share/mysql-test/t/federated_archive.test
 share/mysql-test/t/federated_bug_13118.test
+share/mysql-test/t/fix_priv_tables.test
 share/mysql-test/t/flush.test
+share/mysql-test/t/flush2-master.opt
+share/mysql-test/t/flush2.test
 share/mysql-test/t/flush_block_commit.test
+share/mysql-test/t/flush_block_commit_notembedded.test
 share/mysql-test/t/flush_read_lock_kill-master.opt
 share/mysql-test/t/flush_read_lock_kill.test
 share/mysql-test/t/flush_table.test
@@ -863,11 +901,15 @@ share/mysql-test/t/innodb_cache-master.opt
 share/mysql-test/t/innodb_cache.test
 share/mysql-test/t/innodb_gis.test
 share/mysql-test/t/innodb_handler.test
+share/mysql-test/t/innodb_mysql-master.opt
 share/mysql-test/t/innodb_mysql.test
 share/mysql-test/t/innodb_notembedded.test
+share/mysql-test/t/innodb_timeout_rollback-master.opt
+share/mysql-test/t/innodb_timeout_rollback.test
 share/mysql-test/t/innodb_unsafe_binlog-master.opt
 share/mysql-test/t/innodb_unsafe_binlog.test
 share/mysql-test/t/insert.test
+share/mysql-test/t/insert_notembedded.test
 share/mysql-test/t/insert_select-binlog.test
 share/mysql-test/t/insert_select.test
 share/mysql-test/t/insert_update.test
@@ -891,6 +933,7 @@ share/mysql-test/t/lock.test
 share/mysql-test/t/lock_multi.test
 share/mysql-test/t/lock_tables_lost_commit-master.opt
 share/mysql-test/t/lock_tables_lost_commit.test
+share/mysql-test/t/log.sh
 share/mysql-test/t/lowercase_fs_off.test
 share/mysql-test/t/lowercase_table-master.opt
 share/mysql-test/t/lowercase_table.test
@@ -918,8 +961,11 @@ share/mysql-test/t/mysql.test
 share/mysql-test/t/mysql_client_test.opt
 share/mysql-test/t/mysql_client_test.test
 share/mysql-test/t/mysql_delimiter.sql
+share/mysql-test/t/mysql_delimiter_19799.sql
 share/mysql-test/t/mysql_delimiter_source.sql
 share/mysql-test/t/mysql_protocols.test
+share/mysql-test/t/mysql_upgrade.test
+share/mysql-test/t/mysqladmin.test
 share/mysql-test/t/mysqlbinlog-master.opt
 share/mysql-test/t/mysqlbinlog.test
 share/mysql-test/t/mysqlbinlog2.test
@@ -982,6 +1028,8 @@ share/mysql-test/t/overflow.test
 share/mysql-test/t/packet.test
 share/mysql-test/t/perror.test
 share/mysql-test/t/preload.test
+share/mysql-test/t/profiling.test
+share/mysql-test/t/ps-master.opt
 share/mysql-test/t/ps.test
 share/mysql-test/t/ps_10nestset.test
 share/mysql-test/t/ps_11bugs.test
@@ -1003,6 +1051,7 @@ share/mysql-test/t/rename.test
 share/mysql-test/t/repair.test
 share/mysql-test/t/replace.test
 share/mysql-test/t/rollback.test
+share/mysql-test/t/round.test
 share/mysql-test/t/row.test
 share/mysql-test/t/rowid_order_bdb.test
 share/mysql-test/t/rowid_order_innodb.test
@@ -1030,15 +1079,14 @@ share/mysql-test/t/rpl000017-slave.sh
 share/mysql-test/t/rpl000017.test
 share/mysql-test/t/rpl000018-master.opt
 share/mysql-test/t/rpl000018-slave.opt
-share/mysql-test/t/rpl000018.test
 share/mysql-test/t/rpl_EE_error.test
 share/mysql-test/t/rpl_alter.test
 share/mysql-test/t/rpl_auto_increment-master.opt
 share/mysql-test/t/rpl_auto_increment.test
 share/mysql-test/t/rpl_auto_increment_11932.test
-share/mysql-test/t/rpl_chain_temp_table.test
 share/mysql-test/t/rpl_change_master.test
 share/mysql-test/t/rpl_charset.test
+share/mysql-test/t/rpl_charset_sjis.test
 share/mysql-test/t/rpl_commit_after_flush.test
 share/mysql-test/t/rpl_create_database-master.opt
 share/mysql-test/t/rpl_create_database-slave.opt
@@ -1054,12 +1102,12 @@ share/mysql-test/t/rpl_drop_temp-slave.opt
 share/mysql-test/t/rpl_drop_temp.test
 share/mysql-test/t/rpl_dual_pos_advance-master.opt
 share/mysql-test/t/rpl_dual_pos_advance.test
+share/mysql-test/t/rpl_empty_master_crash-master.opt
 share/mysql-test/t/rpl_empty_master_crash.test
 share/mysql-test/t/rpl_error_ignored_table-slave.opt
 share/mysql-test/t/rpl_error_ignored_table.test
 share/mysql-test/t/rpl_failed_optimize-master.opt
 share/mysql-test/t/rpl_failed_optimize.test
-share/mysql-test/t/rpl_failsafe.test
 share/mysql-test/t/rpl_flush_log_loop-master.opt
 share/mysql-test/t/rpl_flush_log_loop-master.sh
 share/mysql-test/t/rpl_flush_log_loop-slave.opt
@@ -1069,7 +1117,6 @@ share/mysql-test/t/rpl_flush_tables.test
 share/mysql-test/t/rpl_free_items-slave.opt
 share/mysql-test/t/rpl_free_items.test
 share/mysql-test/t/rpl_get_lock.test
-share/mysql-test/t/rpl_heap.test
 share/mysql-test/t/rpl_ignore_grant-slave.opt
 share/mysql-test/t/rpl_ignore_grant.test
 share/mysql-test/t/rpl_ignore_revoke-slave.opt
@@ -1090,6 +1137,7 @@ share/mysql-test/t/rpl_loaddata_rule_m.test
 share/mysql-test/t/rpl_loaddata_rule_s-slave.opt
 share/mysql-test/t/rpl_loaddata_rule_s.test
 share/mysql-test/t/rpl_loaddatalocal.test
+share/mysql-test/t/rpl_locale.test
 share/mysql-test/t/rpl_log-master.opt
 share/mysql-test/t/rpl_log-slave.opt
 share/mysql-test/t/rpl_log.test
@@ -1115,6 +1163,9 @@ share/mysql-test/t/rpl_ndb_innodb_trans-slave.opt
 share/mysql-test/t/rpl_ndb_innodb_trans.test
 share/mysql-test/t/rpl_openssl.test
 share/mysql-test/t/rpl_optimize.test
+share/mysql-test/t/rpl_packet-master.opt
+share/mysql-test/t/rpl_packet-slave.opt
+share/mysql-test/t/rpl_packet.test
 share/mysql-test/t/rpl_ps.test
 share/mysql-test/t/rpl_redirect.test
 share/mysql-test/t/rpl_relayrotate-slave.opt
@@ -1163,6 +1214,7 @@ share/mysql-test/t/schema.test
 share/mysql-test/t/select.test
 share/mysql-test/t/select_found.test
 share/mysql-test/t/select_safe.test
+share/mysql-test/t/show_check-master.opt
 share/mysql-test/t/show_check.test
 share/mysql-test/t/skip_grants-master.opt
 share/mysql-test/t/skip_grants.test
@@ -1179,10 +1231,14 @@ share/mysql-test/t/sp-threads.test
 share/mysql-test/t/sp-vars.test
 share/mysql-test/t/sp.test
 share/mysql-test/t/sp_notembedded.test
+share/mysql-test/t/sp_stress_case.test
 share/mysql-test/t/sp_trans.test
 share/mysql-test/t/sql_mode.test
 share/mysql-test/t/ssl.test
 share/mysql-test/t/ssl_compress.test
+share/mysql-test/t/ssl_connect.test
+share/mysql-test/t/ssl_des-master.opt
+share/mysql-test/t/ssl_des.test
 share/mysql-test/t/status.test
 share/mysql-test/t/strict.test
 share/mysql-test/t/strict_autoinc_1myisam.test
@@ -1192,6 +1248,7 @@ share/mysql-test/t/strict_autoinc_4bdb.test
 share/mysql-test/t/strict_autoinc_5ndb.test
 share/mysql-test/t/subselect.test
 share/mysql-test/t/subselect2.test
+share/mysql-test/t/subselect3.test
 share/mysql-test/t/subselect_gis.test
 share/mysql-test/t/subselect_innodb.test
 share/mysql-test/t/subselect_notembedded.test
@@ -1202,8 +1259,10 @@ share/mysql-test/t/synchronization.test
 share/mysql-test/t/sysdate_is_now-master.opt
 share/mysql-test/t/sysdate_is_now.test
 share/mysql-test/t/system_mysql_db.test
-share/mysql-test/t/system_mysql_db_fix-master.opt
-share/mysql-test/t/system_mysql_db_fix.test
+share/mysql-test/t/system_mysql_db_fix30020-master.opt
+share/mysql-test/t/system_mysql_db_fix30020.test
+share/mysql-test/t/system_mysql_db_fix40123-master.opt
+share/mysql-test/t/system_mysql_db_fix40123.test
 share/mysql-test/t/system_mysql_db_refs.test
 share/mysql-test/t/tablelock.test
 share/mysql-test/t/temp_table-master.opt
@@ -1213,6 +1272,8 @@ share/mysql-test/t/timezone.test
 share/mysql-test/t/timezone2.test
 share/mysql-test/t/timezone3-master.opt
 share/mysql-test/t/timezone3.test
+share/mysql-test/t/timezone4-master.opt
+share/mysql-test/t/timezone4.test
 share/mysql-test/t/timezone_grant.test
 share/mysql-test/t/trigger-compat.test
 share/mysql-test/t/trigger-grant.test
@@ -1245,12 +1306,14 @@ share/mysql-test/t/update.test
 share/mysql-test/t/user_limits.test
 share/mysql-test/t/user_var-binlog.test
 share/mysql-test/t/user_var.test
+share/mysql-test/t/utils.sh
 share/mysql-test/t/varbinary.test
 share/mysql-test/t/variables.test
 share/mysql-test/t/view.test
 share/mysql-test/t/view_grant.test
 share/mysql-test/t/view_query_cache.test
 share/mysql-test/t/wait_for_process.sh
+share/mysql-test/t/wait_for_socket.sh
 share/mysql-test/t/wait_timeout-master.opt
 share/mysql-test/t/wait_timeout.test
 share/mysql-test/t/warnings-master.opt
diff --git a/databases/mysql5-server/distinfo b/databases/mysql5-server/distinfo
index 954c8e1ea80..0865c72a7f0 100644
--- a/databases/mysql5-server/distinfo
+++ b/databases/mysql5-server/distinfo
@@ -1,21 +1,21 @@
-$NetBSD: distinfo,v 1.13 2006/12/10 04:12:17 xtraeme Exp $
+$NetBSD: distinfo,v 1.14 2007/03/11 18:42:49 adam Exp $
 
-SHA1 (mysql-5.0.27.tar.gz) = 656de9c03f07c2371f40277076ec2fc6eac51ec8
-RMD160 (mysql-5.0.27.tar.gz) = 3de75b959d04e002b2e4cfe322abdb48bf2f80fd
-Size (mysql-5.0.27.tar.gz) = 25867740 bytes
-SHA1 (patch-aa) = 82be9c02ebb483ac0fd2eac1e6e086d17b156794
-SHA1 (patch-ab) = 147f8afd19634e62d6a794b0b96f29ebfd920895
-SHA1 (patch-ac) = e75a01f7efe477060cb6e1639c9a7b68a832761d
-SHA1 (patch-ad) = 36fb22fa10f2d379decf8e6fc86fc966472930e2
-SHA1 (patch-ae) = adc6956d4be304db61aa0323061143fffc1b9751
+SHA1 (mysql-5.0.37.tar.gz) = 7c957d4337156c7f98b0617fd5a63f3a838a9bc4
+RMD160 (mysql-5.0.37.tar.gz) = 132d3886a81fcec9be50cdc8d97c868928f5424f
+Size (mysql-5.0.37.tar.gz) = 23239518 bytes
+SHA1 (patch-aa) = 9dcc34093f425024755d32346524117d72f00943
+SHA1 (patch-ab) = d79d5eb4c9e8c939da4bf34e8d7f3f5a52e41a10
+SHA1 (patch-ac) = 22e2fe1a978eeeb03aa98afd24207c7719a6112c
+SHA1 (patch-ad) = 2956a12d9a5a053fd5dd380f856475242e8c1199
+SHA1 (patch-ae) = dc67ad03f9ea370b17a45f73e974013e0ac48d71
 SHA1 (patch-af) = 256de04aefd067ac7bdf8a6d1d817723efa6c6ec
-SHA1 (patch-ag) = ec9e2465b14d16b0479427548a9a0150cbea78ac
-SHA1 (patch-ah) = 81a8cdd4f3ebea640ee5fa75ab8884c452ed3cd7
-SHA1 (patch-ai) = 725a3a6e06d39b26efb706bebbe3ff95da82be96
-SHA1 (patch-aj) = c4e27a4332df3079891935fe963a86c2cbdced20
-SHA1 (patch-ak) = 516460b0aa9f641d74f83c5514f258a980033e41
-SHA1 (patch-al) = 6deee284643a474d5bc0674d149b49e36913fe12
-SHA1 (patch-am) = 999bb2dbca518a7e19a96b53678de35c0b227434
-SHA1 (patch-an) = a186d330698f1d6e178aacc8b91f942b41cdb878
-SHA1 (patch-ao) = c6c56cbff6fbb7ff809b9b544c28ea28fcd18517
-SHA1 (patch-bf) = c63133d40c2008ba57a968af693173a1fd97a927
+SHA1 (patch-ag) = 7c12975196f504c76954bfe92ffff0a98ba63019
+SHA1 (patch-ah) = b7002140ed0ebc24e5df5f92b1c0ceaf8e2a6211
+SHA1 (patch-ai) = c8ba7dfe00f37682e3f521314fe4225aa0b8e4a3
+SHA1 (patch-aj) = c3a0d3df30775e19017ca0835fbc15ea879b0c55
+SHA1 (patch-ak) = 2930b7fae228e02de593dd8deb083d373ca75e5a
+SHA1 (patch-al) = 3b58ef9a835dc9cf39ff720516e5319d332f08f1
+SHA1 (patch-am) = 977d37ec5eba241bbad61481143de59e49b7892e
+SHA1 (patch-an) = ec63621ba908b9da9e1d6dacba9a7894c21e9f5b
+SHA1 (patch-ao) = 235f7d6bfdf609abf14441b1432b00dc5744fed8
+SHA1 (patch-bf) = 87be24d45f0d3f48ea2b911025eb41696d088299
diff --git a/databases/mysql5-server/patches/patch-aa b/databases/mysql5-server/patches/patch-aa
index 0d3c787ef1b..05504a2dc51 100644
--- a/databases/mysql5-server/patches/patch-aa
+++ b/databases/mysql5-server/patches/patch-aa
@@ -1,8 +1,8 @@
-$NetBSD: patch-aa,v 1.3 2006/10/14 18:41:34 xtraeme Exp $
+$NetBSD: patch-aa,v 1.4 2007/03/11 18:42:49 adam Exp $
 
---- Makefile.in.orig	2006-10-14 19:47:57.000000000 +0200
-+++ Makefile.in	2006-10-14 19:48:09.000000000 +0200
-@@ -370,12 +370,8 @@
+--- Makefile.in.orig	2007-03-05 20:23:25.000000000 +0100
++++ Makefile.in
+@@ -372,12 +372,8 @@ AUTOMAKE_OPTIONS = foreign
  EXTRA_DIST = INSTALL-SOURCE INSTALL-WIN-SOURCE \
  			README COPYING EXCEPTIONS-CLIENT CMakeLists.txt
  
diff --git a/databases/mysql5-server/patches/patch-ab b/databases/mysql5-server/patches/patch-ab
index bdf83f77a54..fce429272ff 100644
--- a/databases/mysql5-server/patches/patch-ab
+++ b/databases/mysql5-server/patches/patch-ab
@@ -1,17 +1,17 @@
-$NetBSD: patch-ab,v 1.3 2006/10/14 18:41:34 xtraeme Exp $
+$NetBSD: patch-ab,v 1.4 2007/03/11 18:42:49 adam Exp $
 
---- tests/Makefile.in.orig	2006-10-14 19:48:42.000000000 +0200
-+++ tests/Makefile.in	2006-10-14 19:49:16.000000000 +0200
-@@ -99,7 +99,7 @@
+--- tests/Makefile.in.orig	2007-03-05 20:23:23.000000000 +0100
++++ tests/Makefile.in
+@@ -93,7 +93,7 @@ insert_test_LDADD = $(LDADD)
  am_mysql_client_test_OBJECTS = mysql_client_test.$(OBJEXT) \
- 	$(am__objects_1) my_memmem.$(OBJEXT)
+ 	my_memmem.$(OBJEXT)
  mysql_client_test_OBJECTS = $(am_mysql_client_test_OBJECTS)
 -am__DEPENDENCIES_1 = $(top_builddir)/libmysql/libmysqlclient.la
 +am__DEPENDENCIES_1 =
  am__DEPENDENCIES_2 =
  mysql_client_test_DEPENDENCIES = $(am__DEPENDENCIES_1) \
  	$(am__DEPENDENCIES_2)
-@@ -111,7 +111,7 @@
+@@ -103,7 +103,7 @@ select_test_LDADD = $(LDADD)
  thread_test_SOURCES = thread_test.c
  thread_test_OBJECTS = thread_test.$(OBJEXT)
  thread_test_LDADD = $(LDADD)
@@ -20,7 +20,7 @@ $NetBSD: patch-ab,v 1.3 2006/10/14 18:41:34 xtraeme Exp $
  DEFAULT_INCLUDES = -I. -I$(srcdir) -I$(top_builddir)
  depcomp = $(SHELL) $(top_srcdir)/depcomp
  am__depfiles_maybe = depfiles
-@@ -416,8 +416,7 @@
+@@ -397,8 +397,7 @@ EXTRA_DIST = auto_increment.res auto_inc
  INCLUDES = -I$(top_builddir)/include -I$(top_srcdir)/include \
  			$(openssl_includes)
  
@@ -29,4 +29,4 @@ $NetBSD: patch-ab,v 1.3 2006/10/14 18:41:34 xtraeme Exp $
 +LDADD = @CLIENT_EXTRA_LDFLAGS@ -lmysqlclient
  
  mysql_client_test_LDADD = $(LDADD) $(CXXLDFLAGS)
- mysql_client_test_SOURCES = mysql_client_test.c $(yassl_dummy_link_fix) \
+ mysql_client_test_SOURCES = mysql_client_test.c\
diff --git a/databases/mysql5-server/patches/patch-ac b/databases/mysql5-server/patches/patch-ac
index 17d4508e0dd..c8da422b493 100644
--- a/databases/mysql5-server/patches/patch-ac
+++ b/databases/mysql5-server/patches/patch-ac
@@ -1,17 +1,17 @@
-$NetBSD: patch-ac,v 1.4 2006/10/14 18:41:34 xtraeme Exp $
+$NetBSD: patch-ac,v 1.5 2007/03/11 18:42:49 adam Exp $
 
---- mysql-test/Makefile.in.orig	2006-10-14 19:50:21.000000000 +0200
-+++ mysql-test/Makefile.in	2006-10-14 19:51:30.000000000 +0200
-@@ -389,7 +389,7 @@
+--- mysql-test/Makefile.in.orig	2007-03-05 20:22:56.000000000 +0100
++++ mysql-test/Makefile.in
+@@ -374,7 +374,7 @@ zlib_dir = @zlib_dir@
  @HAVE_NDBCLUSTER_DB_FALSE@USE_NDBCLUSTER = \"\"
  @HAVE_NDBCLUSTER_DB_TRUE@USE_NDBCLUSTER = \"--ndbcluster\"
  benchdir_root = $(prefix)
 -testdir = $(benchdir_root)/mysql-test
 +testdir = $(benchdir_root)/share/mysql-test
- EXTRA_SCRIPTS = mysql-test-run.sh install_test_db.sh valgrind.supp $(PRESCRIPTS)
- EXTRA_DIST = $(EXTRA_SCRIPTS) 
- GENSCRIPTS = mysql-test-run install_test_db mtr
-@@ -820,12 +820,11 @@
+ EXTRA_SCRIPTS = mysql-test-run-shell.sh install_test_db.sh valgrind.supp $(PRESCRIPTS)
+ EXTRA_DIST = $(EXTRA_SCRIPTS)
+ GENSCRIPTS = mysql-test-run-shell mysql-test-run install_test_db mtr
+@@ -770,12 +770,11 @@ dist-hook:
  	$(INSTALL_DATA) $(srcdir)/lib/*.pl $(distdir)/lib
  
  install-data-local:
diff --git a/databases/mysql5-server/patches/patch-ad b/databases/mysql5-server/patches/patch-ad
index 0f1603af9b9..59a5744ad6d 100644
--- a/databases/mysql5-server/patches/patch-ad
+++ b/databases/mysql5-server/patches/patch-ad
@@ -1,8 +1,8 @@
-$NetBSD: patch-ad,v 1.1.1.1 2005/10/31 09:22:26 xtraeme Exp $
+$NetBSD: patch-ad,v 1.2 2007/03/11 18:42:49 adam Exp $
 
---- sql/mysqld.cc.orig	2005-10-17 03:27:30.000000000 +0200
-+++ sql/mysqld.cc	2005-10-31 09:57:13.000000000 +0100
-@@ -171,7 +171,7 @@
+--- sql/mysqld.cc.orig	2007-03-05 20:21:11.000000000 +0100
++++ sql/mysqld.cc
+@@ -171,7 +171,7 @@ static void getvolumeID(BYTE *volumeName
  int initgroups(const char *,unsigned int);
  #endif
  
@@ -11,7 +11,7 @@ $NetBSD: patch-ad,v 1.1.1.1 2005/10/31 09:22:26 xtraeme Exp $
  #include <ieeefp.h>
  #ifdef HAVE_FP_EXCEPT				// Fix type conflict
  typedef fp_except fp_except_t;
-@@ -3276,7 +3276,7 @@
+@@ -3431,7 +3431,7 @@ int main(int argc, char **argv)
    init_ssl();
  
  #ifdef HAVE_LIBWRAP
diff --git a/databases/mysql5-server/patches/patch-ae b/databases/mysql5-server/patches/patch-ae
index 7545d80c591..85d8a80ff69 100644
--- a/databases/mysql5-server/patches/patch-ae
+++ b/databases/mysql5-server/patches/patch-ae
@@ -1,8 +1,8 @@
-$NetBSD: patch-ae,v 1.1.1.1 2005/10/31 09:22:26 xtraeme Exp $
+$NetBSD: patch-ae,v 1.2 2007/03/11 18:42:49 adam Exp $
 
---- mysys/my_gethwaddr.c.orig	2005-10-14 10:21:10.000000000 +0000
+--- mysys/my_gethwaddr.c.orig	2007-03-05 20:21:11.000000000 +0100
 +++ mysys/my_gethwaddr.c
-@@ -31,7 +31,7 @@ static my_bool memcpy_and_test(uchar *to
+@@ -30,7 +30,7 @@ static my_bool memcpy_and_test(uchar *to
    return res;
  }
  
diff --git a/databases/mysql5-server/patches/patch-ag b/databases/mysql5-server/patches/patch-ag
index ca41472f5ea..30404561ceb 100644
--- a/databases/mysql5-server/patches/patch-ag
+++ b/databases/mysql5-server/patches/patch-ag
@@ -1,13 +1,13 @@
-$NetBSD: patch-ag,v 1.5 2006/10/14 18:41:34 xtraeme Exp $
+$NetBSD: patch-ag,v 1.6 2007/03/11 18:42:49 adam Exp $
 
---- man/Makefile.in.orig	2006-10-04 13:25:43.000000000 +0200
-+++ man/Makefile.in	2006-10-14 20:17:36.000000000 +0200
-@@ -344,7 +344,7 @@
+--- man/Makefile.in.orig	2007-03-05 20:22:54.000000000 +0100
++++ man/Makefile.in
+@@ -348,7 +348,7 @@ yassl_h_ln_cmd = @yassl_h_ln_cmd@
  yassl_libs = @yassl_libs@
  yassl_taocrypt_extra_cxxflags = @yassl_taocrypt_extra_cxxflags@
  zlib_dir = @zlib_dir@
 -man1_MANS = @man1_files@
-+man1_MANS = mysqld.1 mysqld_multi.1
++man1_MANS = mysqld_multi.1
  man8_MANS = @man8_files@
  EXTRA_DIST = $(man1_MANS) $(man8_MANS)
  all: all-am
diff --git a/databases/mysql5-server/patches/patch-ah b/databases/mysql5-server/patches/patch-ah
index c1a061c57cf..8a05691d7a6 100644
--- a/databases/mysql5-server/patches/patch-ah
+++ b/databases/mysql5-server/patches/patch-ah
@@ -1,20 +1,19 @@
-$NetBSD: patch-ah,v 1.3 2006/01/09 16:25:01 xtraeme Exp $
+$NetBSD: patch-ah,v 1.4 2007/03/11 18:42:49 adam Exp $
 
---- include/Makefile.in.orig	2006-01-09 16:47:58.000000000 +0100
-+++ include/Makefile.in	2006-01-09 16:48:13.000000000 +0100
-@@ -343,14 +343,7 @@
- yassl_taocrypt_extra_cxxflags = @yassl_taocrypt_extra_cxxflags@
- zlib_dir = @zlib_dir@
- BUILT_SOURCES = mysql_version.h m_ctype.h my_config.h
--pkginclude_HEADERS = my_dbug.h m_string.h my_sys.h my_list.h my_xml.h \
--			mysql.h mysql_com.h mysql_embed.h \
--		  	my_semaphore.h my_pthread.h my_no_pthread.h raid.h \
--			errmsg.h my_global.h my_net.h my_alloc.h \
--			my_getopt.h sslopt-longopts.h my_dir.h typelib.h \
+--- include/Makefile.in.orig	2007-03-05 20:22:51.000000000 +0100
++++ include/Makefile.in
+@@ -362,13 +362,7 @@ HEADERS_GEN = mysql_version.h my_config.
+ HEADERS_ABI = mysql.h mysql_com.h mysql_time.h \
+ 			my_list.h my_alloc.h typelib.h
+ 
+-pkginclude_HEADERS = $(HEADERS_ABI) my_dbug.h m_string.h my_sys.h \
+-			my_xml.h mysql_embed.h \
+-			my_semaphore.h my_pthread.h my_no_pthread.h raid.h \
+-			errmsg.h my_global.h my_net.h \
+-			my_getopt.h sslopt-longopts.h my_dir.h \
 -			sslopt-vars.h sslopt-case.h sql_common.h keycache.h \
--			mysql_time.h $(BUILT_SOURCES)
--
+-			m_ctype.h $(HEADERS_GEN)
 +pkginclude_HEADERS =
+ 
  noinst_HEADERS = config-win.h config-os2.h config-netware.h \
  			heap.h my_bitmap.h\
- 			myisam.h myisampack.h myisammrg.h ft_global.h\
diff --git a/databases/mysql5-server/patches/patch-ai b/databases/mysql5-server/patches/patch-ai
index 82c7c4cdc5d..1ee4fd0978e 100644
--- a/databases/mysql5-server/patches/patch-ai
+++ b/databases/mysql5-server/patches/patch-ai
@@ -1,8 +1,8 @@
-$NetBSD: patch-ai,v 1.1.1.1 2005/10/31 09:22:26 xtraeme Exp $
+$NetBSD: patch-ai,v 1.2 2007/03/11 18:42:49 adam Exp $
 
---- include/my_pthread.h.orig	2003-12-14 21:23:47.000000000 +0000
-+++ include/my_pthread.h	2003-12-20 12:09:31.000000000 +0000
-@@ -19,7 +19,13 @@
+--- include/my_pthread.h.orig	2007-03-05 20:21:12.000000000 +0100
++++ include/my_pthread.h
+@@ -18,7 +18,13 @@
  #ifndef _my_pthread_h
  #define _my_pthread_h
  
@@ -16,7 +16,7 @@ $NetBSD: patch-ai,v 1.1.1.1 2005/10/31 09:22:26 xtraeme Exp $
  #ifndef ETIME
  #define ETIME ETIMEDOUT				/* For FreeBSD */
  #endif
-@@ -301,7 +307,11 @@
+@@ -338,7 +344,11 @@ int sigwait(sigset_t *set, int *sig);
  #endif
  
  #ifndef HAVE_NONPOSIX_SIGWAIT
diff --git a/databases/mysql5-server/patches/patch-aj b/databases/mysql5-server/patches/patch-aj
index 4b21020e764..37613199cef 100644
--- a/databases/mysql5-server/patches/patch-aj
+++ b/databases/mysql5-server/patches/patch-aj
@@ -1,8 +1,8 @@
-$NetBSD: patch-aj,v 1.2 2006/10/14 18:41:34 xtraeme Exp $
+$NetBSD: patch-aj,v 1.3 2007/03/11 18:42:50 adam Exp $
 
---- scripts/mysqld_safe.sh.orig	2006-10-14 19:56:04.000000000 +0200
-+++ scripts/mysqld_safe.sh	2006-10-14 19:59:48.000000000 +0200
-@@ -330,6 +330,14 @@
+--- scripts/mysqld_safe.sh.orig	2007-03-05 20:21:13.000000000 +0100
++++ scripts/mysqld_safe.sh
+@@ -331,6 +331,14 @@ then
    ulimit -c $core_file_size
  fi
  
@@ -17,7 +17,7 @@ $NetBSD: patch-aj,v 1.2 2006/10/14 18:41:34 xtraeme Exp $
  #
  # If there exists an old pid file, check if the daemon is already running
  # Note: The switches to 'ps' may depend on your operating system
-@@ -340,18 +348,16 @@
+@@ -341,18 +349,16 @@ then
    then
      if @FIND_PROC@
      then    # The pid contains a mysqld process
@@ -40,7 +40,7 @@ $NetBSD: patch-aj,v 1.2 2006/10/14 18:41:34 xtraeme Exp $
      exit 1
    fi
  fi
-@@ -364,11 +370,11 @@
+@@ -365,11 +371,11 @@ fi
  # Alternatively, you can start mysqld with the "myisam-recover" option. See
  # the manual for details.
  #
@@ -54,7 +54,7 @@ $NetBSD: patch-aj,v 1.2 2006/10/14 18:41:34 xtraeme Exp $
  
  # Does this work on all systems?
  #if type ulimit | grep "shell builtin" > /dev/null
-@@ -376,7 +382,7 @@
+@@ -377,7 +383,7 @@ echo "Starting $MYSQLD daemon with datab
  #  ulimit -n 256 > /dev/null 2>&1		# Fix for BSD and FreeBSD systems
  #fi
  
@@ -63,7 +63,7 @@ $NetBSD: patch-aj,v 1.2 2006/10/14 18:41:34 xtraeme Exp $
  while true
  do
    rm -f $safe_mysql_unix_port $pid_file	# Some extra safety
-@@ -388,7 +394,7 @@
+@@ -389,7 +395,7 @@ do
    fi
    if test ! -f $pid_file		# This is removed if normal shutdown
    then
@@ -72,7 +72,7 @@ $NetBSD: patch-aj,v 1.2 2006/10/14 18:41:34 xtraeme Exp $
      break
    fi
  
-@@ -401,7 +407,7 @@
+@@ -402,7 +408,7 @@ do
      # kill -9 is used or the process won't react on the kill.
      numofproces=`ps xaww | grep -v "grep" | grep "$ledir/$MYSQLD\>" | grep -c "pid-file=$pid_file"`
  
@@ -81,7 +81,7 @@ $NetBSD: patch-aj,v 1.2 2006/10/14 18:41:34 xtraeme Exp $
      I=1
      while test "$I" -le "$numofproces"
      do 
-@@ -414,16 +420,14 @@
+@@ -415,16 +421,14 @@ do
        #    echo "TEST $I - $T **"
        if kill -9 $T
        then
diff --git a/databases/mysql5-server/patches/patch-ak b/databases/mysql5-server/patches/patch-ak
index 61a880cbaca..4a21ef03772 100644
--- a/databases/mysql5-server/patches/patch-ak
+++ b/databases/mysql5-server/patches/patch-ak
@@ -1,16 +1,16 @@
-$NetBSD: patch-ak,v 1.1.1.1 2005/10/31 09:22:26 xtraeme Exp $
+$NetBSD: patch-ak,v 1.2 2007/03/11 18:42:50 adam Exp $
 
---- support-files/Makefile.in.orig	2005-09-27 00:00:34.000000000 +0200
-+++ support-files/Makefile.in	2005-09-27 00:00:57.000000000 +0200
-@@ -345,14 +345,7 @@
+--- support-files/Makefile.in.orig	2007-03-05 20:23:22.000000000 +0100
++++ support-files/Makefile.in
+@@ -379,14 +379,7 @@ EXTRA_DIST = mysql.spec.sh \
  			ndb-config-2-node.ini.sh
  
- SUBDIRS = MacOSX
+ SUBDIRS = MacOSX RHEL4-SElinux
 -pkgdata_DATA = my-small.cnf \
 -			my-medium.cnf \
 -			my-large.cnf \
 -			my-huge.cnf \
--      my-innodb-heavy-4G.cnf \
+-			my-innodb-heavy-4G.cnf \
 -			mysql-log-rotate \
 -			binary-configure \
 -			ndb-config-2-node.ini
diff --git a/databases/mysql5-server/patches/patch-al b/databases/mysql5-server/patches/patch-al
index 0985afee7f1..7b96ff49296 100644
--- a/databases/mysql5-server/patches/patch-al
+++ b/databases/mysql5-server/patches/patch-al
@@ -1,8 +1,8 @@
-$NetBSD: patch-al,v 1.2 2006/05/18 16:11:15 cube Exp $
+$NetBSD: patch-al,v 1.3 2007/03/11 18:42:50 adam Exp $
 
---- myisam/Makefile.in.orig	2006-04-26 20:31:56.000000000 +0200
+--- myisam/Makefile.in.orig	2007-03-05 20:22:55.000000000 +0100
 +++ myisam/Makefile.in
-@@ -157,7 +157,7 @@ COMPILE = $(CC) $(DEFS) $(DEFAULT_INCLUD
+@@ -156,7 +156,7 @@ COMPILE = $(CC) $(DEFS) $(DEFAULT_INCLUD
  LTCOMPILE = $(LIBTOOL) --tag=CC --mode=compile $(CC) $(DEFS) \
  	$(DEFAULT_INCLUDES) $(INCLUDES) $(AM_CPPFLAGS) $(CPPFLAGS) \
  	$(AM_CFLAGS) $(CFLAGS)
diff --git a/databases/mysql5-server/patches/patch-am b/databases/mysql5-server/patches/patch-am
index bd99b0b84d9..9c4b08489cd 100644
--- a/databases/mysql5-server/patches/patch-am
+++ b/databases/mysql5-server/patches/patch-am
@@ -1,8 +1,8 @@
-$NetBSD: patch-am,v 1.1 2006/01/08 17:43:58 xtraeme Exp $
+$NetBSD: patch-am,v 1.2 2007/03/11 18:42:50 adam Exp $
 
---- extra/Makefile.in.orig	2006-01-08 18:36:49.000000000 +0100
-+++ extra/Makefile.in	2006-01-08 18:37:00.000000000 +0100
-@@ -431,9 +431,7 @@
+--- extra/Makefile.in.orig	2007-03-05 20:22:41.000000000 +0100
++++ extra/Makefile.in
+@@ -434,9 +434,7 @@ INCLUDES = -I$(top_builddir)/include -I$
  LDADD = @CLIENT_EXTRA_LDFLAGS@ ../mysys/libmysys.a \
  			../dbug/libdbug.a ../strings/libmystrings.a
  
@@ -12,4 +12,4 @@ $NetBSD: patch-am,v 1.1 2006/01/08 17:43:58 xtraeme Exp $
 +BUILT_SOURCES =
  
  pkginclude_HEADERS = $(BUILT_SOURCES)
- CLEANFILES = $(BUILT_SOURCES)
+ DISTCLEANFILES = $(BUILT_SOURCES)
diff --git a/databases/mysql5-server/patches/patch-an b/databases/mysql5-server/patches/patch-an
index a41c60a0607..9c7a7dd1772 100644
--- a/databases/mysql5-server/patches/patch-an
+++ b/databases/mysql5-server/patches/patch-an
@@ -1,10 +1,8 @@
-$NetBSD: patch-an,v 1.1 2006/10/14 18:41:34 xtraeme Exp $
+$NetBSD: patch-an,v 1.2 2007/03/11 18:42:50 adam Exp $
 
-Patch reported: http://bugs.mysql.com/bug.php?id=23294&thanks=4
-
---- configure.in.orig	2006-10-14 18:56:35.000000000 +0200
-+++ configure.in	2006-10-14 18:58:41.000000000 +0200
-@@ -475,7 +475,7 @@
+--- configure.in.orig	2007-03-05 20:21:13.000000000 +0100
++++ configure.in
+@@ -487,7 +487,7 @@ then
    FIND_PROC="$PS \$\$PID | grep -v grep | grep \$\$MYSQLD > /dev/null"
  else
    case $SYSTEM_TYPE in
@@ -13,7 +11,7 @@ Patch reported: http://bugs.mysql.com/bug.php?id=23294&thanks=4
        FIND_PROC="$PS p \$\$PID | grep -v grep | grep \$\$MYSQLD > /dev/null"
        ;;
      *darwin*)
-@@ -752,6 +752,8 @@
+@@ -794,6 +794,8 @@ AC_SEARCH_LIBS(crypt, crypt, AC_DEFINE(H
  
  # For sem_xxx functions on Solaris 2.6
  AC_CHECK_FUNC(sem_init, , AC_CHECK_LIB(posix4, sem_init))
@@ -22,7 +20,7 @@ Patch reported: http://bugs.mysql.com/bug.php?id=23294&thanks=4
  MYSQL_CHECK_ZLIB_WITH_COMPRESS
  
  # For large pages support
-@@ -1077,7 +1079,7 @@
+@@ -1119,7 +1121,7 @@ case $SYSTEM_TYPE in
        MAX_C_OPTIMIZE="-O"
      fi
      ;;
diff --git a/databases/mysql5-server/patches/patch-ao b/databases/mysql5-server/patches/patch-ao
index ce93f87d60d..0779dcec2e2 100644
--- a/databases/mysql5-server/patches/patch-ao
+++ b/databases/mysql5-server/patches/patch-ao
@@ -1,8 +1,8 @@
-$NetBSD: patch-ao,v 1.1 2006/04/17 11:21:41 tron Exp $
+$NetBSD: patch-ao,v 1.2 2007/03/11 18:42:50 adam Exp $
 
---- sql/sql_lex.cc.orig	2006-03-31 18:10:45.000000000 +0100
-+++ sql/sql_lex.cc	2006-04-17 12:09:26.000000000 +0100
-@@ -960,6 +960,9 @@
+--- sql/sql_lex.cc.orig	2007-03-05 20:21:11.000000000 +0100
++++ sql/sql_lex.cc
+@@ -931,6 +931,9 @@ int MYSQLlex(void *arg, void *yythd)
        while (lex->ptr != lex->end_of_query &&
  	     ((c=yyGet()) != '*' || yyPeek() != '/'))
        {
diff --git a/databases/mysql5-server/patches/patch-bf b/databases/mysql5-server/patches/patch-bf
index 78b8659f30a..213259fc610 100644
--- a/databases/mysql5-server/patches/patch-bf
+++ b/databases/mysql5-server/patches/patch-bf
@@ -1,8 +1,8 @@
-$NetBSD: patch-bf,v 1.1 2006/10/14 18:41:34 xtraeme Exp $
+$NetBSD: patch-bf,v 1.2 2007/03/11 18:42:50 adam Exp $
 
---- bdb/dist/configure.orig	2006-10-08 15:25:31.000000000 +0200
-+++ bdb/dist/configure	2006-10-08 15:26:39.000000000 +0200
-@@ -5038,7 +5038,7 @@ fi
+--- bdb/dist/configure.orig	2007-03-05 20:23:33.000000000 +0100
++++ bdb/dist/configure
+@@ -5039,7 +5039,7 @@ fi
  # we're using.
  case "$host_os" in
  sysv5UnixWare*|sysv5OpenUNIX8*)