Subject: CVS commit: pkgsrc/databases
From: Adam Ciarcinski
Date: 2023-10-02 12:31:59
Message id: 20231002103159.8924FFBDB@cvs.NetBSD.org

Log Message:
mysql57: updated to 5.7.43

Changes in MySQL 5.7.43

Compilation Notes

Improved Clang 15 usage, although it's not officially supported in v5.7.

Functionality Added or Changed

Important Change: The linked OpenSSL library for MySQL Server has been upgraded \ 
from OpenSSL 1.1.1 to OpenSSL 3.0. The exact version is now 3.0.9. More \ 
information on changes from 1.1.1 to 3.0 can be found at \ 
https://www.openssl.org/docs/man3.0/man7/migration_guide.html.

The linked curl library for MySQL Server (Enterprise Edition) has been updated \ 
to version 8.1.1.

Bugs Fixed

Group Replication: After one machine halted and restarted in a three-node MySQL \ 
InnoDB Cluster, one node failed to start; after restarting all nodes, the \ 
cluster shut down unexpectedly.

Our thanks to Zetang Zeng for the contribution.

Fortified parsing of the network packet data sent by the server to the client.

Some floating-point literals were not always handled correctly.

Executing a query with an implicit aggregation should return exactly one row, \ 
unless the query has a HAVING clause that filters out the row, but a query with \ 
a HAVING clause which evaluated to FALSE sometimes ignored this, and returned a \ 
row regardless.

During optimization, range-select tree creation uses logic which differs based \ 
on the left-hand side of the IN() predicate. For a field item, each value on the \ 
right-hand side is added to an OR tree to create the necessary expression. In \ 
the case of a row item comparison (example: WHERE (a,b) IN ((n1,m1), (n2, m2), \ 
...)), an expression in disjunctive normal form (DNF) is needed. A DNF \ 
expression is created by adding an AND tree with column values to an OR tree for \ 
each set of RHS values, but instead the OR tree was added to the AND tree \ 
causing the tree merge to require exponential time due to O(n2) runtime \ 
complexity.

Files:
RevisionActionfile
1.45modifypkgsrc/databases/mysql57-client/Makefile.common
1.29modifypkgsrc/databases/mysql57-client/PLIST
1.53modifypkgsrc/databases/mysql57-client/distinfo
1.6modifypkgsrc/databases/mysql57-client/patches/patch-cmake_ssl.cmake
1.28modifypkgsrc/databases/mysql57-server/PLIST