head 1.2; access; symbols pkgsrc-2026Q1:1.2.0.28 pkgsrc-2026Q1-base:1.2 pkgsrc-2025Q4:1.2.0.26 pkgsrc-2025Q4-base:1.2 pkgsrc-2025Q3:1.2.0.24 pkgsrc-2025Q3-base:1.2 pkgsrc-2025Q2:1.2.0.22 pkgsrc-2025Q2-base:1.2 pkgsrc-2025Q1:1.2.0.20 pkgsrc-2025Q1-base:1.2 pkgsrc-2024Q4:1.2.0.18 pkgsrc-2024Q4-base:1.2 pkgsrc-2024Q3:1.2.0.16 pkgsrc-2024Q3-base:1.2 pkgsrc-2024Q2:1.2.0.14 pkgsrc-2024Q2-base:1.2 pkgsrc-2024Q1:1.2.0.12 pkgsrc-2024Q1-base:1.2 pkgsrc-2023Q4:1.2.0.10 pkgsrc-2023Q4-base:1.2 pkgsrc-2023Q3:1.2.0.8 pkgsrc-2023Q3-base:1.2 pkgsrc-2023Q2:1.2.0.6 pkgsrc-2023Q2-base:1.2 pkgsrc-2023Q1:1.2.0.4 pkgsrc-2023Q1-base:1.2 pkgsrc-2022Q4:1.2.0.2 pkgsrc-2022Q4-base:1.2 pkgsrc-2022Q3:1.1.0.12 pkgsrc-2022Q3-base:1.1 pkgsrc-2022Q2:1.1.0.10 pkgsrc-2022Q2-base:1.1 pkgsrc-2022Q1:1.1.0.8 pkgsrc-2022Q1-base:1.1 pkgsrc-2021Q4:1.1.0.6 pkgsrc-2021Q4-base:1.1 pkgsrc-2021Q3:1.1.0.4 pkgsrc-2021Q3-base:1.1 pkgsrc-2021Q2:1.1.0.2 pkgsrc-2021Q2-base:1.1; locks; strict; comment @# @; 1.2 date 2022.11.02.17.02.10; author jperkin; state Exp; branches; next 1.1; commitid DOgyfL7l8eHVj90E; 1.1 date 2021.05.13.15.25.20; author jdolecek; state Exp; branches; next ; commitid VM2QlICeU94R20TC; desc @@ 1.2 log @mysql80: Update to 8.0.31. Includes a number of pkgsrc cleanups, removing nonsense that has been cargo-culted since the MySQL 3.23.x days(!). Stop shipping mysql-test, it's absolutely huge and unnecessary. Add XXX to undocumented patches that we should probably just drop, and make others easier to maintain. Upstream changes are far too numerous to include here, so here are the links to the corresponding release notes for each since 8.0.24: https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-31.html https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-30.html https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-29.html https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-28.html https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-27.html https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-26.html https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-25.html Tested on SmartOS, I'll monitor bulk build reports for any fallout on other platforms (it takes ages to build). @ text @$NetBSD: patch-sql_CMakeLists.txt,v 1.1 2021/05/13 15:25:20 jdolecek Exp $ * use a provided ffsll implementation if the system does not have one * use noop implementation (apple) for binding threads to a cpu TODO: netbsd and irix has apis for this, perhaps implement this. --- sql/CMakeLists.txt.orig 2022-09-13 16:15:16.000000000 +0000 +++ sql/CMakeLists.txt @@@@ -648,6 +648,10 @@@@ IF(BUILD_IS_SINGLE_CONFIG) ENDIF() ENDIF() +IF(NOT HAVE_FFSLL) +LIST(APPEND SQL_SHARED_SOURCES ffsll.cc) +ENDIF() + # BISON_TARGET( # [COMPILE_FLAGS ] # [DEFINES_FILE ] @@@@ -748,6 +752,9 @@@@ ELSEIF(SOLARIS) ELSEIF(WIN32) LIST(APPEND SQL_SHARED_SOURCES resourcegroups/platform/thread_attrs_api_win.cc) +ELSE() + LIST(APPEND SQL_SHARED_SOURCES + resourcegroups/platform/thread_attrs_api_apple.cc) ENDIF() SET(SQL_SOURCE @ 1.1 log @import mysql80-client and mysql80-server packages from pkgsrc wip package is experimental right now - it was confirmed working on NetBSD and compile on macOS only for now 8.0 brings many improvements over 5.7, following is shortened list, more details are available on https://dev.mysql.com/doc/refman/8.0/en/mysql-nutshell.html - transactional data dictionary - atomic DDL - integrated upgrade procedure - security and account management improvements - resource groups and threads (thread affinity needs some work for NetBSD) - table encryption management - loads of innodb enhancements - default character set utf8mb4 - JSON enhancements - CTE, Window functions - lateral derived tables - reworked regular experssion support - internal temporary tables - HASH JOIN optimization - EXPLAIN ANALYZE - time zone support for TIMESTAMP and DATETIME - optimizer hints for FORCE INDEX, IGNORE INDEX - XML enhancements - single preparation of statements - single RIGHT JOIN as LEFT JOIN handling - derived condition pushdown optimization Number of features were also deprecated, check the release notes for that @ text @d1 1 a1 1 $NetBSD$ d7 1 a7 1 --- sql/CMakeLists.txt.orig 2021-03-22 08:44:50.000000000 +0000 d9 3 a11 3 @@@@ -589,6 +589,10 @@@@ SET(SQL_SHARED_SOURCES daemon_proxy_keyring/daemon_proxy_keyring.cc ) d20 1 a20 1 @@@@ -689,6 +693,9 @@@@ ELSEIF(SOLARIS) @