Fri Nov 10 06:04:13 2023 UTC ()
mysql57: updated to 5.7.44

Changes in MySQL 5.7.44

SQL Function and Operator Notes

The STR_TO_DATE() function did not perform complete range checking on the string to be converted, so that it was possible to pass to it a string which would yield an invalid date, such as '2021-11-31'.

Packaging Notes

On Windows, the MSI package definition files were updated to work with the Windows Installer XML (WiX) toolset version 4. Note that they can no longer be used with previous versions of the toolset.

The bundled libedit library was upgraded to version 20221030-3.1.

Functionality Added or Changed

Important Change: The linked OpenSSL library for MySQL Server has been updated to version 3.0.10. Issues fixed in OpenSSL version 3.0.10 are described at https://www.openssl.org/news/cl30.txt.

Bugs Fixed

InnoDB: Fixed processing of single character tokens by a FTS parser plugin.

Our thanks to Shaohua Wang for the contribution.

InnoDB: The last detected deadlock section of the engine status log was only showing 1024 characters for the combined thread and query information. Fixing by removing the printed query string limit.

Some complex queries using multiple common table expressions were not always handled correctly.


(adam)
diff -r1.48 -r1.49 pkgsrc/databases/mysql57-client/Makefile
diff -r1.45 -r1.46 pkgsrc/databases/mysql57-client/Makefile.common
diff -r1.29 -r1.30 pkgsrc/databases/mysql57-client/PLIST
diff -r1.53 -r1.54 pkgsrc/databases/mysql57-client/distinfo
diff -r1.49 -r1.50 pkgsrc/databases/mysql57-server/Makefile
diff -r1.28 -r1.29 pkgsrc/databases/mysql57-server/PLIST
cvs diff -r1.48 -r1.49 pkgsrc/databases/mysql57-client/Makefile (expand / switch to unified diff)

--- pkgsrc/databases/mysql57-client/Makefile 2023/11/08 13:18:27 1.48
+++ pkgsrc/databases/mysql57-client/Makefile 2023/11/10 06:04:12 1.49
@@ -1,16 +1,15 @@ @@ -1,16 +1,15 @@
1# $NetBSD: Makefile,v 1.48 2023/11/08 13:18:27 wiz Exp $ 1# $NetBSD: Makefile,v 1.49 2023/11/10 06:04:12 adam Exp $
2 2
3PKGNAME= ${DISTNAME:S/-/-client-/} 3PKGNAME= ${DISTNAME:S/-/-client-/}
4PKGREVISION= 2 
5COMMENT= MySQL 5, a free SQL database (client) 4COMMENT= MySQL 5, a free SQL database (client)
6 5
7CONFLICTS= mysql3-client-[0-9]* 6CONFLICTS= mysql3-client-[0-9]*
8 7
9.include "Makefile.common" 8.include "Makefile.common"
10 9
11CMAKE_ARGS+= -DWITHOUT_SERVER=ON 10CMAKE_ARGS+= -DWITHOUT_SERVER=ON
12UNWRAP_FILES+= scripts/mysql_config 11UNWRAP_FILES+= scripts/mysql_config
13INFO_FILES= yes 12INFO_FILES= yes
14INSTALL_DIRS+= client include libmysql man scripts testclients 13INSTALL_DIRS+= client include libmysql man scripts testclients
15 14
16.include "../../mk/bsd.pkg.mk" 15.include "../../mk/bsd.pkg.mk"
cvs diff -r1.45 -r1.46 pkgsrc/databases/mysql57-client/Makefile.common (expand / switch to unified diff)

--- pkgsrc/databases/mysql57-client/Makefile.common 2023/10/02 10:31:58 1.45
+++ pkgsrc/databases/mysql57-client/Makefile.common 2023/11/10 06:04:12 1.46
@@ -1,19 +1,19 @@ @@ -1,19 +1,19 @@
1# $NetBSD: Makefile.common,v 1.45 2023/10/02 10:31:58 adam Exp $ 1# $NetBSD: Makefile.common,v 1.46 2023/11/10 06:04:12 adam Exp $
2# 2#
3# used by databases/mysql57-client/Makefile 3# used by databases/mysql57-client/Makefile
4# used by databases/mysql57-server/Makefile 4# used by databases/mysql57-server/Makefile
5 5
6DISTNAME= mysql-5.7.43 6DISTNAME= mysql-5.7.44
7CATEGORIES= databases 7CATEGORIES= databases
8MASTER_SITES= https://dev.mysql.com/get/Downloads/MySQL-5.7/ 8MASTER_SITES= https://dev.mysql.com/get/Downloads/MySQL-5.7/
9DISTFILES= mysql-boost-${PKGVERSION_NOREV}${EXTRACT_SUFX} 9DISTFILES= mysql-boost-${PKGVERSION_NOREV}${EXTRACT_SUFX}
10 10
11MAINTAINER?= pkgsrc-users@NetBSD.org 11MAINTAINER?= pkgsrc-users@NetBSD.org
12HOMEPAGE= https://www.mysql.com/ 12HOMEPAGE= https://www.mysql.com/
13LICENSE= gnu-gpl-v2 13LICENSE= gnu-gpl-v2
14 14
15DISTINFO_FILE?= ${.CURDIR}/../../databases/mysql57-client/distinfo 15DISTINFO_FILE?= ${.CURDIR}/../../databases/mysql57-client/distinfo
16PATCHDIR?= ${.CURDIR}/../../databases/mysql57-client/patches 16PATCHDIR?= ${.CURDIR}/../../databases/mysql57-client/patches
17 17
18USE_CXX_FEATURES+= c++14 18USE_CXX_FEATURES+= c++14
19 19
cvs diff -r1.29 -r1.30 pkgsrc/databases/mysql57-client/PLIST (expand / switch to unified diff)

--- pkgsrc/databases/mysql57-client/PLIST 2023/10/02 10:31:58 1.29
+++ pkgsrc/databases/mysql57-client/PLIST 2023/11/10 06:04:12 1.30
@@ -1,14 +1,14 @@ @@ -1,14 +1,14 @@
1@comment $NetBSD: PLIST,v 1.29 2023/10/02 10:31:58 adam Exp $ 1@comment $NetBSD: PLIST,v 1.30 2023/11/10 06:04:12 adam Exp $
2bin/mysql 2bin/mysql
3bin/mysql_client_test 3bin/mysql_client_test
4bin/mysql_config 4bin/mysql_config
5bin/mysql_config_editor 5bin/mysql_config_editor
6bin/mysql_ssl_rsa_setup 6bin/mysql_ssl_rsa_setup
7bin/mysqladmin 7bin/mysqladmin
8bin/mysqlbinlog 8bin/mysqlbinlog
9bin/mysqlcheck 9bin/mysqlcheck
10bin/mysqldump 10bin/mysqldump
11bin/mysqlimport 11bin/mysqlimport
12bin/mysqlpump 12bin/mysqlpump
13bin/mysqlshow 13bin/mysqlshow
14bin/mysqlslap 14bin/mysqlslap
@@ -112,27 +112,27 @@ include/mysql/plugin_keyring.h @@ -112,27 +112,27 @@ include/mysql/plugin_keyring.h
112include/mysql/plugin_validate_password.h 112include/mysql/plugin_validate_password.h
113include/mysql/sql_common.h 113include/mysql/sql_common.h
114include/mysql/sql_state.h 114include/mysql/sql_state.h
115include/mysql/sslopt-case.h 115include/mysql/sslopt-case.h
116include/mysql/sslopt-longopts.h 116include/mysql/sslopt-longopts.h
117include/mysql/sslopt-vars.h 117include/mysql/sslopt-vars.h
118include/mysql/thr_cond.h 118include/mysql/thr_cond.h
119include/mysql/thr_mutex.h 119include/mysql/thr_mutex.h
120include/mysql/thr_rwlock.h 120include/mysql/thr_rwlock.h
121include/mysql/typelib.h 121include/mysql/typelib.h
122lib/libmysqlclient.a 122lib/libmysqlclient.a
123lib/libmysqlclient.so 123lib/libmysqlclient.so
124lib/libmysqlclient.so.20 124lib/libmysqlclient.so.20
125lib/libmysqlclient.so.20.3.30 125lib/libmysqlclient.so.20.3.31
126lib/pkgconfig/mysqlclient.pc 126lib/pkgconfig/mysqlclient.pc
127man/man1/comp_err.1 127man/man1/comp_err.1
128man/man1/innochecksum.1 128man/man1/innochecksum.1
129man/man1/lz4_decompress.1 129man/man1/lz4_decompress.1
130man/man1/my_print_defaults.1 130man/man1/my_print_defaults.1
131man/man1/myisam_ftdump.1 131man/man1/myisam_ftdump.1
132man/man1/myisamchk.1 132man/man1/myisamchk.1
133man/man1/myisamlog.1 133man/man1/myisamlog.1
134man/man1/myisampack.1 134man/man1/myisampack.1
135man/man1/mysql.1 135man/man1/mysql.1
136man/man1/mysql.server.1 136man/man1/mysql.server.1
137man/man1/mysql_config.1 137man/man1/mysql_config.1
138man/man1/mysql_config_editor.1 138man/man1/mysql_config_editor.1
cvs diff -r1.53 -r1.54 pkgsrc/databases/mysql57-client/distinfo (expand / switch to unified diff)

--- pkgsrc/databases/mysql57-client/distinfo 2023/10/02 10:31:58 1.53
+++ pkgsrc/databases/mysql57-client/distinfo 2023/11/10 06:04:12 1.54
@@ -1,18 +1,18 @@ @@ -1,18 +1,18 @@
1$NetBSD: distinfo,v 1.53 2023/10/02 10:31:58 adam Exp $ 1$NetBSD: distinfo,v 1.54 2023/11/10 06:04:12 adam Exp $
2 2
3BLAKE2s (mysql-boost-5.7.43.tar.gz) = 97211c8094140ddcfbb539f56aa08c061f3bf9e59498f8ee52929369f2b458be 3BLAKE2s (mysql-boost-5.7.44.tar.gz) = acc0ededc1e2f93433dd3e188b36a58a389d511ab5bc6e5ac21857faa29bb3aa
4SHA512 (mysql-boost-5.7.43.tar.gz) = 296645c4beb1c55fc17eb0cea59968020a6396bca73fe1042e19b52d396834a4cf156abd4193babc6cf83418b2d8db0ee154b7779f830d21f1813e74365bfaa3 4SHA512 (mysql-boost-5.7.44.tar.gz) = 371b641e622321419ad875662f2b80a255d3059a6cbae40868447b0e4b70b2dccc9bdb227800d719d4f66857aed458e8a843c3095bf64cef5e5b92b7c0234b6b
5Size (mysql-boost-5.7.43.tar.gz) = 53291096 bytes 5Size (mysql-boost-5.7.44.tar.gz) = 53298645 bytes
6SHA1 (patch-CMakeLists.txt) = 03c15cfdc396448bb7db31434d2e7afaac708223 6SHA1 (patch-CMakeLists.txt) = 03c15cfdc396448bb7db31434d2e7afaac708223
7SHA1 (patch-client_CMakeLists.txt) = 4af2fb3f3d05a66a9ee89f3653e2fcccadfa5f79 7SHA1 (patch-client_CMakeLists.txt) = 4af2fb3f3d05a66a9ee89f3653e2fcccadfa5f79
8SHA1 (patch-client_completion_hash.cc) = b86ec80beac624b2aa21c7587e351ff126400ecb 8SHA1 (patch-client_completion_hash.cc) = b86ec80beac624b2aa21c7587e351ff126400ecb
9SHA1 (patch-client_mysqladmin.cc) = e1650ef3695675bcc01375bacdebcb7318218b93 9SHA1 (patch-client_mysqladmin.cc) = e1650ef3695675bcc01375bacdebcb7318218b93
10SHA1 (patch-cmake_build__configurations_compiler__options.cmake) = 999110815237c53a69c74c42e66c45df83cbf355 10SHA1 (patch-cmake_build__configurations_compiler__options.cmake) = 999110815237c53a69c74c42e66c45df83cbf355
11SHA1 (patch-cmake_build__configurations_mysql__release.cmake) = 7a1fb8c686f187db8fd9d8ad203c1f764d6e55a6 11SHA1 (patch-cmake_build__configurations_mysql__release.cmake) = 7a1fb8c686f187db8fd9d8ad203c1f764d6e55a6
12SHA1 (patch-cmake_ldap.cmake) = 9bdc3c311330852286838e6159295ecc5fbdc0ea 12SHA1 (patch-cmake_ldap.cmake) = 9bdc3c311330852286838e6159295ecc5fbdc0ea
13SHA1 (patch-cmake_os_SunOS.cmake) = b71c3e1fafb48ebbba77c19bb1c31556ebe1ad2a 13SHA1 (patch-cmake_os_SunOS.cmake) = b71c3e1fafb48ebbba77c19bb1c31556ebe1ad2a
14SHA1 (patch-cmake_plugin.cmake) = 4480438969e297f67890b1974a86fb88a23d28ed 14SHA1 (patch-cmake_plugin.cmake) = 4480438969e297f67890b1974a86fb88a23d28ed
15SHA1 (patch-cmake_readline.cmake) = 96ee989be126c939a4c9ef80f8cbb27e0c0719a5 15SHA1 (patch-cmake_readline.cmake) = 96ee989be126c939a4c9ef80f8cbb27e0c0719a5
16SHA1 (patch-cmake_ssl.cmake) = 5eb9736b1153191d9df94992d3dec556ce970432 16SHA1 (patch-cmake_ssl.cmake) = 5eb9736b1153191d9df94992d3dec556ce970432
17SHA1 (patch-include_CMakeLists.txt) = 944991702f046ea7a5e2b6ea4dc390f17426e55a 17SHA1 (patch-include_CMakeLists.txt) = 944991702f046ea7a5e2b6ea4dc390f17426e55a
18SHA1 (patch-include_my__compare.h) = f45bac4b488332a668b0005751856279b67401f5 18SHA1 (patch-include_my__compare.h) = f45bac4b488332a668b0005751856279b67401f5
cvs diff -r1.49 -r1.50 pkgsrc/databases/mysql57-server/Makefile (expand / switch to unified diff)

--- pkgsrc/databases/mysql57-server/Makefile 2023/11/08 13:18:27 1.49
+++ pkgsrc/databases/mysql57-server/Makefile 2023/11/10 06:04:12 1.50
@@ -1,17 +1,16 @@ @@ -1,17 +1,16 @@
1# $NetBSD: Makefile,v 1.49 2023/11/08 13:18:27 wiz Exp $ 1# $NetBSD: Makefile,v 1.50 2023/11/10 06:04:12 adam Exp $
2 2
3PKGNAME= ${DISTNAME:S/-/-server-/} 3PKGNAME= ${DISTNAME:S/-/-server-/}
4PKGREVISION= 2 
5COMMENT= MySQL 5, a free SQL database (server) 4COMMENT= MySQL 5, a free SQL database (server)
6 5
7CONFLICTS= mysql3-server-[0-9]* 6CONFLICTS= mysql3-server-[0-9]*
8 7
9.include "../../databases/mysql57-client/Makefile.common" 8.include "../../databases/mysql57-client/Makefile.common"
10 9
11INFO_FILES= yes 10INFO_FILES= yes
12 11
13CMAKE_ARGS+= -DINSTALL_INFODIR=${PKGINFODIR} 12CMAKE_ARGS+= -DINSTALL_INFODIR=${PKGINFODIR}
14 13
15PLIST_VARS+= embedded auth_socket 14PLIST_VARS+= embedded auth_socket
16 15
17.if !empty(PKG_OPTIONS:Membedded-server) 16.if !empty(PKG_OPTIONS:Membedded-server)
cvs diff -r1.28 -r1.29 pkgsrc/databases/mysql57-server/PLIST (expand / switch to unified diff)

--- pkgsrc/databases/mysql57-server/PLIST 2023/10/02 10:31:59 1.28
+++ pkgsrc/databases/mysql57-server/PLIST 2023/11/10 06:04:12 1.29
@@ -1,14 +1,14 @@ @@ -1,14 +1,14 @@
1@comment $NetBSD: PLIST,v 1.28 2023/10/02 10:31:59 adam Exp $ 1@comment $NetBSD: PLIST,v 1.29 2023/11/10 06:04:12 adam Exp $
2bin/innochecksum 2bin/innochecksum
3bin/lz4_decompress 3bin/lz4_decompress
4bin/my_print_defaults 4bin/my_print_defaults
5bin/myisam_ftdump 5bin/myisam_ftdump
6bin/myisamchk 6bin/myisamchk
7bin/myisamlog 7bin/myisamlog
8bin/myisampack 8bin/myisampack
9${PLIST.embedded}bin/mysql_client_test_embedded 9${PLIST.embedded}bin/mysql_client_test_embedded
10${PLIST.embedded}bin/mysql_embedded 10${PLIST.embedded}bin/mysql_embedded
11bin/mysql_install_db 11bin/mysql_install_db
12bin/mysql_plugin 12bin/mysql_plugin
13bin/mysql_secure_installation 13bin/mysql_secure_installation
14bin/mysql_tzinfo_to_sql 14bin/mysql_tzinfo_to_sql
@@ -5145,26 +5145,27 @@ share/mysql/test/suite/innodb/include/in @@ -5145,26 +5145,27 @@ share/mysql/test/suite/innodb/include/in
5145share/mysql/test/suite/innodb/include/innodb_merge_threshold_secondary.inc 5145share/mysql/test/suite/innodb/include/innodb_merge_threshold_secondary.inc
5146share/mysql/test/suite/innodb/include/innodb_merge_threshold_update.inc 5146share/mysql/test/suite/innodb/include/innodb_merge_threshold_update.inc
5147share/mysql/test/suite/innodb/include/innodb_stats.inc 5147share/mysql/test/suite/innodb/include/innodb_stats.inc
5148share/mysql/test/suite/innodb/include/innodb_stats_table_flag.inc 5148share/mysql/test/suite/innodb/include/innodb_stats_table_flag.inc
5149share/mysql/test/suite/innodb/include/innodb_stats_table_flag_analyze.inc 5149share/mysql/test/suite/innodb/include/innodb_stats_table_flag_analyze.inc
5150share/mysql/test/suite/innodb/include/innodb_undo_logs_action.inc 5150share/mysql/test/suite/innodb/include/innodb_undo_logs_action.inc
5151share/mysql/test/suite/innodb/include/innodb_v_large_col.inc 5151share/mysql/test/suite/innodb/include/innodb_v_large_col.inc
5152share/mysql/test/suite/innodb/include/innodb_wl6501_crash.inc 5152share/mysql/test/suite/innodb/include/innodb_wl6501_crash.inc
5153share/mysql/test/suite/innodb/include/innodb_wl6501_crash_temp.inc 5153share/mysql/test/suite/innodb/include/innodb_wl6501_crash_temp.inc
5154share/mysql/test/suite/innodb/include/log_file_cleanup.inc 5154share/mysql/test/suite/innodb/include/log_file_cleanup.inc
5155share/mysql/test/suite/innodb/include/query_workload_itt.inc 5155share/mysql/test/suite/innodb/include/query_workload_itt.inc
5156share/mysql/test/suite/innodb/include/show_i_s_tables.inc 5156share/mysql/test/suite/innodb/include/show_i_s_tables.inc
5157share/mysql/test/suite/innodb/include/show_i_s_tablespaces.inc 5157share/mysql/test/suite/innodb/include/show_i_s_tablespaces.inc
 5158share/mysql/test/suite/innodb/include/show_last_deadlock.inc
5158share/mysql/test/suite/innodb/include/tablespace_filenames.inc 5159share/mysql/test/suite/innodb/include/tablespace_filenames.inc
5159share/mysql/test/suite/innodb/include/tablespace_portability.inc 5160share/mysql/test/suite/innodb/include/tablespace_portability.inc
5160share/mysql/test/suite/innodb/include/wl5522_oom.inc 5161share/mysql/test/suite/innodb/include/wl5522_oom.inc
5161share/mysql/test/suite/innodb/r/add_foreign_key.result 5162share/mysql/test/suite/innodb/r/add_foreign_key.result
5162share/mysql/test/suite/innodb/r/alter_crash.result 5163share/mysql/test/suite/innodb/r/alter_crash.result
5163share/mysql/test/suite/innodb/r/alter_foreign_crash.result 5164share/mysql/test/suite/innodb/r/alter_foreign_crash.result
5164share/mysql/test/suite/innodb/r/alter_kill.result 5165share/mysql/test/suite/innodb/r/alter_kill.result
5165share/mysql/test/suite/innodb/r/alter_missing_tablespace.result 5166share/mysql/test/suite/innodb/r/alter_missing_tablespace.result
5166share/mysql/test/suite/innodb/r/alter_page_size.result 5167share/mysql/test/suite/innodb/r/alter_page_size.result
5167share/mysql/test/suite/innodb/r/alter_rename_existing.result 5168share/mysql/test/suite/innodb/r/alter_rename_existing.result
5168share/mysql/test/suite/innodb/r/alter_rename_files.result 5169share/mysql/test/suite/innodb/r/alter_rename_files.result
5169share/mysql/test/suite/innodb/r/alter_row_format.result 5170share/mysql/test/suite/innodb/r/alter_row_format.result
5170share/mysql/test/suite/innodb/r/alter_table_redundant.result 5171share/mysql/test/suite/innodb/r/alter_table_redundant.result