CVS commit: pkgsrc/databases

["Makoto Fujiwara" <mef%netbsd.org@localhost>]

Module Name:    pkgsrc
Committed By:   mef
Date:           Thu Apr 13 13:44:49 UTC 2017

Modified Files:
        pkgsrc/databases/mysql51-client: Makefile Makefile.common distinfo
        pkgsrc/databases/mysql51-server: Makefile PLIST distinfo

Log Message:
Updated databases/mysql51-{client,server} to 5.1.73
------------------------------------------------------------
The ChangeLog since 5.1.72 is too huge, so the beginning some
lines are listed here:
  ------------------------------------------------------------
  timestamp: Fri 2013-11-01 16:39:19 +0100
  message:
    Bug#17617945 BUFFER OVERFLOW IN GET_MERGE_MANY_BUFFS_COST WITH SMALL SORT_BUFFER_SIZE

    get_cost_calc_buff_size() could return wrong value for the size of imerge_cost_buff.
  ------------------------------------------------------------
  timestamp: Thu 2013-10-31 22:53:56 +0000
  message:
    BUG#17662398: REMOVE DUPLICATE TEST CASES

    Remove duplicate test cases.
  ------------------------------------------------------------
  timestamp: Thu 2013-10-31 23:02:44 +0530
  message:
    Bug #12917164 DROP USER CAN'T DROP USERS WITH LEGACY
        UPPER CASE HOST NAME ANYMORE

    Description:
    It is not possible to drop users with host names with upper case
    letters in them. i.e DROP USER 'root'@'Tmp_Host_Name'; is failing
    with error.

    Analysis: Since the fix 11748570 we came up with lower case hostnames
    as standard. But in the current bug the hostname is created by
    mysql_install_db script is still having upper case hostnames.
    So, if we have the hostname with upper case letters like(Tmp_Host_Name)
    then we will have as it is stored in the mysql.user table.
    In this case if use "'DROP USER 'root'@'Tmp_Host_Name';" it gives
    error because we do compare with the lower case of hostname since the
    11748570 fix.

    Fix: We need to convert the hostname to lower case before storing into
    the mysql.user table when we run the mysql_install_db script.
------------------------------------------------------------


To generate a diff of this commit:
cvs rdiff -u -r1.23 -r1.24 pkgsrc/databases/mysql51-client/Makefile
cvs rdiff -u -r1.33 -r1.34 pkgsrc/databases/mysql51-client/Makefile.common
cvs rdiff -u -r1.28 -r1.29 pkgsrc/databases/mysql51-client/distinfo
cvs rdiff -u -r1.28 -r1.29 pkgsrc/databases/mysql51-server/Makefile
cvs rdiff -u -r1.26 -r1.27 pkgsrc/databases/mysql51-server/PLIST
cvs rdiff -u -r1.32 -r1.33 pkgsrc/databases/mysql51-server/distinfo

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

Modified files:

Index: pkgsrc/databases/mysql51-client/Makefile
diff -u pkgsrc/databases/mysql51-client/Makefile:1.23 pkgsrc/databases/mysql51-client/Makefile:1.24
--- pkgsrc/databases/mysql51-client/Makefile:1.23       Sat Jul  9 06:38:00 2016
+++ pkgsrc/databases/mysql51-client/Makefile    Thu Apr 13 13:44:49 2017
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.23 2016/07/09 06:38:00 wiz Exp $
+# $NetBSD: Makefile,v 1.24 2017/04/13 13:44:49 mef Exp $
 
 PKGNAME=       ${DISTNAME:S/-/-client-/}
-PKGREVISION=   7
 COMMENT=       MySQL 5, a free SQL database (client)
 
 CONFLICTS=     mysql3-client-[0-9]*

Index: pkgsrc/databases/mysql51-client/Makefile.common
diff -u pkgsrc/databases/mysql51-client/Makefile.common:1.33 pkgsrc/databases/mysql51-client/Makefile.common:1.34
--- pkgsrc/databases/mysql51-client/Makefile.common:1.33        Thu Feb 25 11:46:21 2016
+++ pkgsrc/databases/mysql51-client/Makefile.common     Thu Apr 13 13:44:49 2017
@@ -1,9 +1,9 @@
-# $NetBSD: Makefile.common,v 1.33 2016/02/25 11:46:21 jperkin Exp $
+# $NetBSD: Makefile.common,v 1.34 2017/04/13 13:44:49 mef Exp $
 #
 # used by databases/mysql51-client/Makefile
 # used by databases/mysql51-server/Makefile
 
-DISTNAME=      mysql-5.1.72
+DISTNAME=      mysql-5.1.73
 CATEGORIES=    databases
 MASTER_SITES=  ${MASTER_SITE_MYSQL:=MySQL-5.1/}
 

Index: pkgsrc/databases/mysql51-client/distinfo
diff -u pkgsrc/databases/mysql51-client/distinfo:1.28 pkgsrc/databases/mysql51-client/distinfo:1.29
--- pkgsrc/databases/mysql51-client/distinfo:1.28       Tue Nov  3 01:56:15 2015
+++ pkgsrc/databases/mysql51-client/distinfo    Thu Apr 13 13:44:49 2017
@@ -1,9 +1,9 @@
-$NetBSD: distinfo,v 1.28 2015/11/03 01:56:15 agc Exp $
+$NetBSD: distinfo,v 1.29 2017/04/13 13:44:49 mef Exp $
 
-SHA1 (mysql-5.1.72.tar.gz) = af1f46e56402b38a085ac592cd7df3aa25e9cea2
-RMD160 (mysql-5.1.72.tar.gz) = a5ba8bedf4027af90a4612a1a7f3a848999cfbf5
-SHA512 (mysql-5.1.72.tar.gz) = ea9cf82bfc85acdab4b0c6b670b3315fbeb4e17e07f98bef9a137ef4568ee996293d763875a26e61f4d5c15ae078e713b2b6511d19f1d22b0598713516a52d95
-Size (mysql-5.1.72.tar.gz) = 24044338 bytes
+SHA1 (mysql-5.1.73.tar.gz) = 6cb1c547dec873a0afda825c83fd8e5a32b9a619
+RMD160 (mysql-5.1.73.tar.gz) = ceee36663abbf135d3ddbebe52ebc537ecba25a6
+SHA512 (mysql-5.1.73.tar.gz) = 2e3651ebc1370dad7e01158cdd99133ed3f90c985114766b6282d58b743ae7bce16db797e82819fa5bbc2fa53d89811fd76b278c7459338288e7957634a8c3ff
+Size (mysql-5.1.73.tar.gz) = 24023347 bytes
 SHA1 (patch-aa) = 344bc9ab7013fbf64be6adbe8a9fc6279887beb1
 SHA1 (patch-ab) = a1c699ebd9dc7e2cec9354035cbd9fdc2a411175
 SHA1 (patch-ac) = a250b9797fbaad51d054cbb324feb0f7c29096d4

Index: pkgsrc/databases/mysql51-server/Makefile
diff -u pkgsrc/databases/mysql51-server/Makefile:1.28 pkgsrc/databases/mysql51-server/Makefile:1.29
--- pkgsrc/databases/mysql51-server/Makefile:1.28       Sat Mar  5 11:27:42 2016
+++ pkgsrc/databases/mysql51-server/Makefile    Thu Apr 13 13:44:49 2017
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.28 2016/03/05 11:27:42 jperkin Exp $
+# $NetBSD: Makefile,v 1.29 2017/04/13 13:44:49 mef Exp $
 
 PKGNAME=       ${DISTNAME:S/-/-server-/}
-PKGREVISION=   6
 COMMENT=       MySQL 5, a free SQL database (server)
 
 CONFLICTS=             mysql3-server-[0-9]*

Index: pkgsrc/databases/mysql51-server/PLIST
diff -u pkgsrc/databases/mysql51-server/PLIST:1.26 pkgsrc/databases/mysql51-server/PLIST:1.27
--- pkgsrc/databases/mysql51-server/PLIST:1.26  Thu Jun 18 04:29:51 2015
+++ pkgsrc/databases/mysql51-server/PLIST       Thu Apr 13 13:44:49 2017
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.26 2015/06/18 04:29:51 dholland Exp $
+@comment $NetBSD: PLIST,v 1.27 2017/04/13 13:44:49 mef Exp $
 bin/innochecksum
 bin/my_print_defaults
 bin/myisam_ftdump
@@ -308,6 +308,7 @@ share/mysql-test/include/have_gb2312.inc
 share/mysql-test/include/have_gbk.inc
 share/mysql-test/include/have_geometry.inc
 share/mysql-test/include/have_innodb.inc
+share/mysql-test/include/have_innodb_change_buffering.inc
 share/mysql-test/include/have_innodb_plugin.inc
 share/mysql-test/include/have_koi8r.inc
 share/mysql-test/include/have_latin2_ch.inc
@@ -430,6 +431,7 @@ share/mysql-test/include/rpl_udf.inc
 share/mysql-test/include/running_event_scheduler.inc
 share/mysql-test/include/safe_set_to_maybe_ro_var.inc
 share/mysql-test/include/save_master_pos.inc
+share/mysql-test/include/search_pattern_in_file.inc
 share/mysql-test/include/select_ndb_apply_status.inc
 share/mysql-test/include/set_binlog_format_mixed.sql
 share/mysql-test/include/set_binlog_format_row.sql
@@ -3776,6 +3778,7 @@ share/mysql-test/suite/rpl/r/rpl_drop_db
 share/mysql-test/suite/rpl/r/rpl_drop_temp.result
 share/mysql-test/suite/rpl/r/rpl_drop_view.result
 share/mysql-test/suite/rpl/r/rpl_dual_pos_advance.result
+share/mysql-test/suite/rpl/r/rpl_dump_events_twice_bug.result
 share/mysql-test/suite/rpl/r/rpl_empty_master_crash.result
 share/mysql-test/suite/rpl/r/rpl_err_ignoredtable.result
 share/mysql-test/suite/rpl/r/rpl_events.result
@@ -3830,6 +3833,7 @@ share/mysql-test/suite/rpl/r/rpl_loaddat
 share/mysql-test/suite/rpl/r/rpl_loadfile.result
 share/mysql-test/suite/rpl/r/rpl_locale.result
 share/mysql-test/suite/rpl/r/rpl_log_pos.result
+share/mysql-test/suite/rpl/r/rpl_lost_events_on_rotate.result
 share/mysql-test/suite/rpl/r/rpl_manual_change_index_file.result
 share/mysql-test/suite/rpl/r/rpl_many_optimize.result
 share/mysql-test/suite/rpl/r/rpl_master_pos_wait.result
@@ -4053,6 +4057,7 @@ share/mysql-test/suite/rpl/t/rpl_drop_te
 share/mysql-test/suite/rpl/t/rpl_drop_view.test
 share/mysql-test/suite/rpl/t/rpl_dual_pos_advance-master.opt
 share/mysql-test/suite/rpl/t/rpl_dual_pos_advance.test
+share/mysql-test/suite/rpl/t/rpl_dump_events_twice_bug.test
 share/mysql-test/suite/rpl/t/rpl_empty_master_crash-master.opt
 share/mysql-test/suite/rpl/t/rpl_empty_master_crash.test
 share/mysql-test/suite/rpl/t/rpl_err_ignoredtable-slave.opt
@@ -4137,6 +4142,7 @@ share/mysql-test/suite/rpl/t/rpl_loaddat
 share/mysql-test/suite/rpl/t/rpl_loadfile.test
 share/mysql-test/suite/rpl/t/rpl_locale.test
 share/mysql-test/suite/rpl/t/rpl_log_pos.test
+share/mysql-test/suite/rpl/t/rpl_lost_events_on_rotate.test
 share/mysql-test/suite/rpl/t/rpl_manual_change_index_file.test
 share/mysql-test/suite/rpl/t/rpl_many_optimize.test
 share/mysql-test/suite/rpl/t/rpl_master_pos_wait.test

Index: pkgsrc/databases/mysql51-server/distinfo
diff -u pkgsrc/databases/mysql51-server/distinfo:1.32 pkgsrc/databases/mysql51-server/distinfo:1.33
--- pkgsrc/databases/mysql51-server/distinfo:1.32       Tue Nov  3 01:56:15 2015
+++ pkgsrc/databases/mysql51-server/distinfo    Thu Apr 13 13:44:49 2017
@@ -1,9 +1,9 @@
-$NetBSD: distinfo,v 1.32 2015/11/03 01:56:15 agc Exp $
+$NetBSD: distinfo,v 1.33 2017/04/13 13:44:49 mef Exp $
 
-SHA1 (mysql-5.1.72.tar.gz) = af1f46e56402b38a085ac592cd7df3aa25e9cea2
-RMD160 (mysql-5.1.72.tar.gz) = a5ba8bedf4027af90a4612a1a7f3a848999cfbf5
-SHA512 (mysql-5.1.72.tar.gz) = ea9cf82bfc85acdab4b0c6b670b3315fbeb4e17e07f98bef9a137ef4568ee996293d763875a26e61f4d5c15ae078e713b2b6511d19f1d22b0598713516a52d95
-Size (mysql-5.1.72.tar.gz) = 24044338 bytes
+SHA1 (mysql-5.1.73.tar.gz) = 6cb1c547dec873a0afda825c83fd8e5a32b9a619
+RMD160 (mysql-5.1.73.tar.gz) = ceee36663abbf135d3ddbebe52ebc537ecba25a6
+SHA512 (mysql-5.1.73.tar.gz) = 2e3651ebc1370dad7e01158cdd99133ed3f90c985114766b6282d58b743ae7bce16db797e82819fa5bbc2fa53d89811fd76b278c7459338288e7957634a8c3ff
+Size (mysql-5.1.73.tar.gz) = 24023347 bytes
 SHA1 (patch-aa) = 2a5321738e637a56e57cd6b1b40908d2bf275506
 SHA1 (patch-ab) = 4c485a74d55553d63fc3dbc0350d0aa0068e1fcf
 SHA1 (patch-ac) = bfb6eec77d7c5aa8d2b849632769005dcf2e272c