head 1.7; access; symbols pkgsrc-2024Q2:1.6.0.38 pkgsrc-2024Q2-base:1.6 pkgsrc-2024Q1:1.6.0.36 pkgsrc-2024Q1-base:1.6 pkgsrc-2023Q4:1.6.0.34 pkgsrc-2023Q4-base:1.6 pkgsrc-2023Q3:1.6.0.32 pkgsrc-2023Q3-base:1.6 pkgsrc-2023Q2:1.6.0.30 pkgsrc-2023Q2-base:1.6 pkgsrc-2023Q1:1.6.0.28 pkgsrc-2023Q1-base:1.6 pkgsrc-2022Q4:1.6.0.26 pkgsrc-2022Q4-base:1.6 pkgsrc-2022Q3:1.6.0.24 pkgsrc-2022Q3-base:1.6 pkgsrc-2022Q2:1.6.0.22 pkgsrc-2022Q2-base:1.6 pkgsrc-2022Q1:1.6.0.20 pkgsrc-2022Q1-base:1.6 pkgsrc-2021Q4:1.6.0.18 pkgsrc-2021Q4-base:1.6 pkgsrc-2021Q3:1.6.0.16 pkgsrc-2021Q3-base:1.6 pkgsrc-2021Q2:1.6.0.14 pkgsrc-2021Q2-base:1.6 pkgsrc-2021Q1:1.6.0.12 pkgsrc-2021Q1-base:1.6 pkgsrc-2020Q4:1.6.0.10 pkgsrc-2020Q4-base:1.6 pkgsrc-2020Q3:1.6.0.8 pkgsrc-2020Q3-base:1.6 pkgsrc-2020Q2:1.6.0.6 pkgsrc-2020Q2-base:1.6 pkgsrc-2020Q1:1.6.0.2 pkgsrc-2020Q1-base:1.6 pkgsrc-2019Q4:1.6.0.4 pkgsrc-2019Q4-base:1.6 pkgsrc-2019Q3:1.5.0.4 pkgsrc-2019Q3-base:1.5 pkgsrc-2019Q2:1.5.0.2 pkgsrc-2019Q2-base:1.5 pkgsrc-2019Q1:1.4.0.4 pkgsrc-2019Q1-base:1.4 pkgsrc-2018Q4:1.4.0.2 pkgsrc-2018Q4-base:1.4 pkgsrc-2018Q3:1.3.0.4 pkgsrc-2018Q3-base:1.3 pkgsrc-2018Q2:1.3.0.2 pkgsrc-2018Q2-base:1.3 pkgsrc-2018Q1:1.2.0.10 pkgsrc-2018Q1-base:1.2 pkgsrc-2017Q4:1.2.0.8 pkgsrc-2017Q4-base:1.2 pkgsrc-2017Q3:1.2.0.6 pkgsrc-2017Q3-base:1.2 pkgsrc-2017Q2:1.2.0.2 pkgsrc-2017Q2-base:1.2 pkgsrc-2017Q1:1.1.0.6 pkgsrc-2017Q1-base:1.1 pkgsrc-2016Q4:1.1.0.4 pkgsrc-2016Q4-base:1.1 pkgsrc-2016Q3:1.1.0.2 pkgsrc-2016Q3-base:1.1; locks; strict; comment @# @; 1.7 date 2024.08.05.06.30.32; author wiz; state dead; branches; next 1.6; commitid bBHFyVW9uHUXcBkF; 1.6 date 2019.10.14.20.19.29; author adam; state Exp; branches; next 1.5; commitid mlwwAvuckvsahSGB; 1.5 date 2019.04.25.10.13.04; author adam; state Exp; branches; next 1.4; commitid 5Q0DaUbcOdv3sIkB; 1.4 date 2018.11.22.16.14.53; author adam; state Exp; branches; next 1.3; commitid ZU7ZMrVZ8g6voX0B; 1.3 date 2018.04.29.21.44.12; author adam; state Exp; branches; next 1.2; commitid sHIO4GAaXEhgSnAA; 1.2 date 2017.04.11.20.49.15; author adam; state Exp; branches; next 1.1; commitid W4wFCzklPBr8T9Nz; 1.1 date 2016.09.16.06.49.11; author adam; state Exp; branches; next ; commitid bzWTDZHvVHlQStmz; desc @@ 1.7 log @mysql* 5.6, 5.7: remove As proposed on pkgsrc-users on July 26. These versions are unsupported by upstream since 2018 and 2020 respectively. @ text @$NetBSD: patch-rapid_plugin_x_CMakeLists.txt,v 1.6 2019/10/14 20:19:29 adam Exp $ Use system OpenSSL. Fix mysqlxtest binary linking. --- rapid/plugin/x/CMakeLists.txt.orig 2019-09-27 07:00:15.000000000 +0000 +++ rapid/plugin/x/CMakeLists.txt @@@@ -99,13 +99,13 @@@@ ELSE() ${CMAKE_SOURCE_DIR}/include #temporary ${CMAKE_CURRENT_SOURCE_DIR}/include/mysql ${CMAKE_CURRENT_BINARY_DIR}/generated - ${SSL_INCLUDE_DIRS} ) INCLUDE_DIRECTORIES(SYSTEM ${BOOST_INCLUDE_DIR} ${PROTOBUF_INCLUDE_DIRS} ${LIBEVENT_INCLUDE_DIRS} + ${SSL_INCLUDE_DIRS} ) IF(XPLUGIN_NO_LITE_PROTOBUF) @@@@ -221,7 +221,10 @@@@ ELSE() ENDIF() TARGET_LINK_LIBRARIES(mysqlxtest mysys strings ${FORCE_SSL_SOLARIS} mysqlclient) - TARGET_LINK_LIBRARIES(mysqlxtest ${PROTOBUF_LIBRARY}) + TARGET_LINK_LIBRARIES(mysqlxtest ${PROTOBUF_LIBRARY} ${CRYPTO_LIBRARY}) + IF(CMAKE_SYSTEM_NAME STREQUAL "SunOS") + TARGET_LINK_LIBRARIES(mysqlxtest "socket") + ENDIF() IF(INSTALL_MYSQLTESTDIR) INSTALL( @ 1.6 log @mysql57: updated to 5.7.28 Changes in MySQL 5.7.28 Configuration Notes It is now possible to compile MySQL 5.7 using OpenSSL 1.1.1, enabling compilation support for MySQL 5.7 against OpenSSL even when OpenSSL 1.0.2 reaches End of Life status at the end of 2019. All MySQL 5.7 builds now use OpenSSL. MySQL no longer supports using yaSSL as the SSL library, and source distributions no longer include yaSSL. The WITH_SSL CMake option no longer permits bundled (use yaSSL) as a valid value, and the default option value has changed from bundled to system (use the version of OpenSSL installed on the host system). sys Schema Notes The sys.schema_unused_indexes view now filters out unique indexes. The sys.ps_is_consumer_enabled() function now produces an error rather than returning NULL if the argument is an unknown non-NULL consumer name. Previously, sys schema sources were maintained in a separate Git repository. sys schema sources now are included with and maintained within MySQL source distributions (under scripts/sys_schema). The sys.version view is deprecated and will be removed in a future MySQL version. Affected applications should be adjusted to use an alternative instead. For example, use the VERSION() function to retrieve the MySQL server version. Bugs Fixed InnoDB: An ALTER TABLE ... ENCRYPTION = 'Y' operation on a MyISAM table failed to raise an error indicating that the storage engine does not support encryption. The INPLACE algorithm did not check encryption support before updating metadata in the .frm file. To address this issue, an encryption support flag was added. The ALTER TABLE ... ENCRYPTION = 'Y' operation now checks the flag and reports an error if the storage engine does not support encryption. InnoDB: Delete marked rows were able to acquire an external read lock before a partial rollback was completed. The external read lock prevented conversion of an implicit lock to an explicit lock during the partial rollback, causing an assertion failure. InnoDB: A long running ALTER TABLE ... ADD INDEX operation with concurrent inserts caused semaphore waits. Replication: A deadlock involving three threads could occur if a START SLAVE statement was issued to start the SQL thread on a slave while the SQL thread was still in the process of being stopped, and a request for the slave status was made at the same time. The issue has now been fixed by releasing a lock earlier while the SQL thread is being stopped. Replication: A locking issue in the WAIT_FOR_EXECUTED_GTID_SET() function could cause the server to hang in certain circumstances. The issue has now been corrected. Replication: On a multi-threaded slave with GTIDs in use and MASTER_AUTO_POSITION set to ON, following an unexpected halt the slave would attempt relay log recovery, which failed if relay logs had been lost, preventing replication from starting. However, this step was unnecessary as GTID auto-positioning can be used to restore any missing transactions. In a recovery situation, the slave now checks first whether MASTER_AUTO_POSITION is set to ON, and if it is, skips relay log recovery. When generating C source from SQL scripts, Some utf8-encoded characters were split across lines. Thanks to Przemysław Skibiński for the patch. For Solaris, mysqld.cc contained a prototype for memcntl() that is no longer needed. The prototype has been removed. For Solaris, -DWITH_SSL=system did not work when compiling with GCC. MySQL builds configured with -DWITHOUT_SERVER=1 failed. For the keyring_aws plugin, some valid region values for the keyring_aws_region system variable were rejected. For debug builds, an assertion could be raised during UNION queries when computing the combined data type of a GEOMETRY column and SELECT * FROM (SELECT NULL). For authentication using an LDAP authentication plugin, if the user DN portion was empty and group mapping was configured, authentication assigned an incorrect user DN and skipped the user search. mysqlpump produced an error when run against a server older than MySQL 5.7. A possible integer overflow due to unsigned integer type casting could lead to later buffer overflow due to arbitrary size memory allocation. Attempted use of a freed object during MeCab plugin initialization caused a segmentation fault. For MySQL installed using RPM packages, an initialization script that tested server connectivity misbehaved if the client account authenticated using an LDAP authentication plugin. Improper locking during storage engine initialization could cause a server exit. On a GTID-enabled server, concurrent execution of DROP USER and a prepared statement that accessed a view could deadlock. A query with a WHERE clause whose predicate contained a numeric value in scientific notation was not handled correctly. VS2019 produced compilation errors with debug compilation selected due to use of the /ZI flag. Now /Z7 is used instead. The client library could dereference a null pointer while fetching result set metadata from the server. In READ UNCOMMITTED isolation level, a segmentation fault occurred under heavy load from memcached clients. An externally stored BLOB column that was being updated by one transaction was read by another transaction as having a NULL value and a non-zero data length. Arguments for the TIMESTAMPADD() function could be reversed for prepared statements. With the thread_pool plugin enabled, the sys.processlist and sys.session views displayed a thread name rather than the actual user name. The delete_latency column in the sys.schema_index_statistics view incorrectly referred to the SUM_TIMER_INSERT column of the Performance Schema table_io_waits_summary_by_index_usage table rather than the SUM_TIMER_DELETE column. In output from the sys.diagnostics() procedure, the latency column for the user_summary_by_file_io_type view was incorrectly displayed in raw picoseconds rather than as a formatted value. MySQL Enterprise Encryption functions could apply Diffie-Hellman (DH) methods to non-DH keys, resulting in unpredictable results or server exit. Password masking was incomplete for SHOW PROCESSLIST and some INFORMATION_SCHEMA and Performance Schema tables. The -DWITH_EXAMPLE_STORAGE_ENGINE=1 CMake option was ignored but should not have been. If -DWITH_EXAMPLE_STORAGE_ENGINE=0 is given, the EXAMPLE storage engine is built as a plugin. @ text @d1 1 a1 1 $NetBSD: patch-rapid_plugin_x_CMakeLists.txt,v 1.5 2019/04/25 10:13:04 adam Exp $ @ 1.5 log @mysql57: updated to 5.7.26 mysql-5.7.26: Unknown changes @ text @d1 1 a1 1 $NetBSD: patch-rapid_plugin_x_CMakeLists.txt,v 1.4 2018/11/22 16:14:53 adam Exp $ d6 1 a6 1 --- rapid/plugin/x/CMakeLists.txt.orig 2019-04-13 13:32:15.000000000 +0000 d8 1 a8 1 @@@@ -92,13 +92,13 @@@@ ELSE() d23 1 a23 1 @@@@ -214,7 +214,10 @@@@ ELSE() d26 1 a26 1 TARGET_LINK_LIBRARIES(mysqlxtest mysys strings mysqlclient) @ 1.4 log @mysql57: updated to 5.7.24 Changes in MySQL 5.7.24 Deprecation and Removal Notes * InnoDB; Partitioning: Support for placing table partitions in shared tablespaces is deprecated and will be removed in a future version of MySQL. Shared tablespaces include the system tablespace and general tablespaces. For information about identifying partitions in shared tablespaces and moving them to file-per-table tablespaces, see Preparing Your Installation for Upgrade. * InnoDB: Support for TABLESPACE = innodb_file_per_table and TABLESPACE = innodb_temporary clauses with CREATE TEMPORARY TABLE is deprecated and will be removed in a future MySQL version. Functionality Added or Changed Replication: Use the group_replication_exit_state_action option to configure how Group Replication behaves when a member leaves the group involuntarily, for example when it is expelled from the group due to an unstable network connection. When group_replication_exit_state_action is set to ABORT_SERVER, upon exiting the group unintentionally, the instance shuts MySQL down, and when group_replication_exit_state_action is set to READ_ONLY the instance sets MySQL to super read only mode instead and its state is set to ERROR. Previously, file I/O performed in the I/O cache in the mysys library was not instrumented, affecting in particular file I/O statistics reported by the Performance Schema about the binary log index file. Now, this I/O is instrumented and Performance Schema statistics are accurate. Thanks to Yura Sorokin for the contribution. The zlib library version bundled with MySQL was raised from version 1.2.3 to version 1.2.11. MySQL implements compression with the help of the zlib library. The zlib compressBound() function in zlib 1.2.11 returns a slightly higher estimate of the buffer size required to compress a given length of bytes than it did in zlib version 1.2.3. The compressBound() function is called by InnoDB functions that determine the maximum row size permitted when creating compressed InnoDB tables or inserting rows into compressed InnoDB tables. As a result, CREATE TABLE ... ROW_FORMAT=COMPRESSED or INSERT operations with row sizes very close to the maximum row size that were successful in earlier releases could now fail. Bugs Fixed * InnoDB: An ALTER TABLE operation that added a primary key produced a segmentation fault. * InnoDB: A query that scanned the primary key of a table did not return the expected result. * InnoDB: A query interruption during a lock wait caused an error. * InnoDB: An index record was not found when updating a secondary index defined on a generated column. * InnoDB: The update log applied as part of an online ALTER TABLE operation did not take into account the computed value of the generated column in the old row while updating the secondary index. * InnoDB: An unsupported DDL operation involving a foreign key constraint raised an assertion. * InnoDB: An attempted foreign key check on a discarded table caused a segmentation fault. * InnoDB: An assertion was raised during an OPTIMIZE TABLE operation. * InnoDB: A foreign key constraint name was duplicated during a rename table operation, causing a failure during later query execution. * InnoDB: In a function called before the execution of a statement in a stored procedure, a read and write operation on trx->lock.start_stmt was not protected by a mutex. * InnoDB: An error occurred during a DDL operation due to a mismatch in a REDUNDANT row format calculation that determines the length of the online log. * InnoDB: The location of the Innodb Merge Temp File that reported by the wait/io/file/innodb/innodb_temp_file Performance Schema instrument was incorrect. * Partitioning: When a CREATE TABLE ... PARTITION BY ... statement failed due to an invalid partition definition, the server did not remove any partition files which might have been created prior to encountering the invalid PARTITION clause. * Partitioning: It was possible to perform FLUSH TABLES FOR EXPORT on a partitioned table created with innodb_file_per_table=1 after discarding its tablespace. Attempting to do so now raises ER_TABLESPACE_DISCARDED. * Replication: When the binlog_group_commit_sync_delay system variable is set to a wait time to delay synchronization of transactions to disk, and the binlog_group_commit_sync_no_delay_count system variable is also set to a number of transactions, the MySQL server exits the wait procedure if the specified number of transactions is reached before the specified wait time is reached. The server manages this process by checking on the transaction count after a delta of one tenth of the time specified by binlog_group_commit_sync_delay has elapsed, then subtracting that interval from the remaining wait time. more... @ text @d1 1 a1 1 $NetBSD: patch-rapid_plugin_x_CMakeLists.txt,v 1.3 2018/04/29 21:44:12 adam Exp $ d6 1 a6 1 --- rapid/plugin/x/CMakeLists.txt.orig 2018-10-04 05:48:22.000000000 +0000 d18 1 a18 1 ${LIBEVENT_INCLUDE_DIR} @ 1.3 log @mysql57: updated to 5.7.22 Changes in MySQL 5.7.22: Deprecation and Removal Notes These compatibility SQL modes are now deprecated and will be removed in MySQL 8.0: DB2, MAXDB, MSSQL, MYSQL323, MYSQL40, ORACLE, POSTGRESQL, NO_FIELD_OPTIONS, NO_KEY_OPTIONS, NO_TABLE_OPTIONS. These deprecations have two implications: Assigning a deprecated mode to the sql_mode system variable produces a warning. With the MAXDB SQL mode enabled, using CREATE TABLE or ALTER TABLE to add a TIMESTAMP column to a table produces a warning. Statements that use these deprecated SQL modes may fail when replicated from a MySQL 5.7 master to a MySQL 8.0 slave, or may have different effects on master and slave. To avoid such problems, applications that use the modes deprecated in MySQL 5.7 should be revised not to use them. Test Suite Notes Reduction of compiler and platform differences in GIS handling of floating-point results enables simplification of related test cases that no longer need rounding to avoid spurious test failures. X Plugin Notes X Plugin connection attempts using the X Protocol did not return an error when the default database specified in the connection options was invalid, and the connection was allowed with a null default database. Connection attempts using the classic MySQL protocol did return an error and disallowed the connection. X Protocol connection attempts now also disallow the connection if an invalid schema is specified. Functionality Added or Changed Replication: Changes introduced in version 8 which enable XCom to identify members using the concept of an incarnation have been merged in to version 5.7. These underlying changes add a UUID to members each time they join a group and this information can be used to distinguish among different member incarnations. Replication: It is now possible to specify whether information written into the binary log enables replication slaves to parallelize based on commit timestamps, or on transaction write sets. JSON: The JSON_MERGE() function is renamed to JSON_MERGE_PRESERVE(). JSON: Added the JSON utility function JSON_PRETTY(), which prints an existing JSON value, or any string that can successfully be parsed as a JSON document, in a format that can be easily read by humans. Each JSON object member or array value is displayed on a separate line of the output; each child object or array is intended 2 spaces with respect to its parent. Bugs Fixed @ text @d1 1 a1 1 $NetBSD: patch-rapid_plugin_x_CMakeLists.txt,v 1.2 2017/04/11 20:49:15 adam Exp $ d3 1 a3 1 Use system OpenSSL and zlib. d6 1 a6 1 --- rapid/plugin/x/CMakeLists.txt.orig 2018-03-04 13:40:40.000000000 +0000 d8 1 a8 1 @@@@ -92,14 +92,14 @@@@ ELSE() a12 1 - ${ZLIB_INCLUDE_DIR} a19 1 + ${ZLIB_INCLUDE_DIR} d23 1 a23 1 @@@@ -215,7 +215,10 @@@@ ELSE() @ 1.2 log @Changes 5.7.18: * Windows builds now use the default runtime libraries (builds use the /MD flag). * CMake support was added for compiling with Developer Studio 12.6. * MySQL failed to compile if -DENABLE_DEBUG_SYNC=OFF AND -DWITH_DEBUG=ON were both given. The ENABLE_DEBUG_SYNC option has been removed and enabling WITH_DEBUG enables Debug Sync. * The --temp-pool server option is deprecated and will be removed in MySQL 8.0. * Support for DTrace is deprecated and is removed in MySQL 8.0. * Changes in RPM package structure require a larger set of packages to be removed to install MySQL Server cleanly. * To avoid potential race conditions, Debian packages now use the GNU install utility rather than a combination of mkdir, touch, and chown. * The my-default.cnf.sh file (used to produce a default my-default.cnf or my-default.ini file) is no longer included in source distributions and my-default.cnf and my-default.ini are no longer included in or installed by distribution packages. * Reminder: MySQL 5.7 requires the Microsoft Visual C++ 2013 Redistributable Package to run on Windows platforms. Users should make sure the package has been installed on the system before starting the server. The package is available at the Microsoft Download Center. * PROCEDURE ANALYSE() syntax is now deprecated and is removed in MySQL 8.0. * The use of \N as a synonym for NULL in SQL statements is deprecated and is removed in MySQL 8.0. Use NULL instead. * The linked OpenSSL library for the MySQL Commercial Server has been updated to version 1.0.2k. @ text @d1 1 a1 1 $NetBSD: patch-rapid_plugin_x_CMakeLists.txt,v 1.1 2016/09/16 06:49:11 adam Exp $ d6 1 a6 1 --- rapid/plugin/x/CMakeLists.txt.orig 2017-03-18 07:45:14.000000000 +0000 d35 2 a36 2 IF( WIN32 ) ADD_DEFINITIONS(-DMYSQLXTEST_EXPORTS) @ 1.1 log @MySQL is a SQL (Structured Query Language) database server. SQL is the most popular database language in the world. MySQL is a client-server implementation that consists of a server daemon `mysqld' and many different client programs/libraries. The main goals of MySQL are speed and robustness. The base upon which MySQL is built is a set of routines that have been used in a highly demanding production environment for many years. While MySQL is still in development it already offers a rich and highly useful function set. @ text @d1 1 a1 1 $NetBSD$ d3 1 a3 1 Use bundled boost, but system OpenSSL and zlib. d6 1 a6 1 --- rapid/plugin/x/CMakeLists.txt.orig 2016-06-30 06:22:11.000000000 +0000 d8 1 a8 2 @@@@ -91,14 +91,14 @@@@ ELSE() ${CMAKE_CURRENT_SOURCE_DIR}/ngs/include d11 1 a13 1 + ${BOOST_INCLUDE_DIR} d17 1 a17 1 - ${BOOST_INCLUDE_DIR} d25 1 a25 1 @@@@ -200,7 +200,10 @@@@ ELSE() @