CVS commit: pkgsrc/databases

["Jaromir Dolecek" <jdolecek%netbsd.org@localhost>]

Module Name:    pkgsrc
Committed By:   jdolecek
Date:           Thu May 13 15:25:21 UTC 2021

Modified Files:
        pkgsrc/databases: Makefile
Added Files:
        pkgsrc/databases/mysql80-client: DESCR MESSAGE Makefile Makefile.common
            PLIST TODO buildlink3.mk distinfo options.mk
        pkgsrc/databases/mysql80-client/patches: patch-CMakeLists.txt
            patch-client_CMakeLists.txt patch-client_mysqladmin.cc
            patch-cmake_boost.cmake patch-cmake_os_SunOS.cmake
            patch-cmake_readline.cmake patch-config.h.cmake
            patch-configure.cmake patch-include_CMakeLists.txt
            patch-include_my__compare.h patch-include_my__thread.h
            patch-include_my__thread__os__id.h
            patch-include_tables__contained__in.h patch-libmysql_CMakeLists.txt
            patch-mysys_kqueue__timers.cc patch-mysys_stacktrace.cc
            patch-router_CMakeLists.txt
            patch-router_src_harness_include_mysql_harness_net_ts_impl_netif.h
            patch-router_src_harness_include_mysql_harness_net_ts_internet.h
            patch-router_src_harness_include_mysql_harness_net_ts_local.h
            patch-router_src_harness_include_mysql_harness_tty.h
            patch-router_src_harness_src_stdx_io_file_handle.cc
            patch-scripts_CMakeLists.txt patch-scripts_mysqld_safe.sh
            patch-sql_CMakeLists.txt
            patch-sql_conn__handler_socket__connection.cc
            patch-sql_item_geofunc_relchecks_bgwrap.h
            patch-sql_resourcegroups_platform_thread__attrs__api__apple.cc
            patch-vio_viosocket.cc
        pkgsrc/databases/mysql80-server: DEINSTALL DESCR MESSAGE MESSAGE.sphinx
            Makefile PLIST PLIST.SunOS buildlink3.mk
        pkgsrc/databases/mysql80-server/files: ffsll.cc mysqld.sh
        pkgsrc/databases/mysql80-server/files/smf: manifest.xml mysqld.sh

Log Message:
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


To generate a diff of this commit:
cvs rdiff -u -r1.629 -r1.630 pkgsrc/databases/Makefile
cvs rdiff -u -r0 -r1.1 pkgsrc/databases/mysql80-client/DESCR \
    pkgsrc/databases/mysql80-client/MESSAGE \
    pkgsrc/databases/mysql80-client/Makefile \
    pkgsrc/databases/mysql80-client/Makefile.common \
    pkgsrc/databases/mysql80-client/PLIST \
    pkgsrc/databases/mysql80-client/TODO \
    pkgsrc/databases/mysql80-client/buildlink3.mk \
    pkgsrc/databases/mysql80-client/distinfo \
    pkgsrc/databases/mysql80-client/options.mk
cvs rdiff -u -r0 -r1.1 \
    pkgsrc/databases/mysql80-client/patches/patch-CMakeLists.txt \
    pkgsrc/databases/mysql80-client/patches/patch-client_CMakeLists.txt \
    pkgsrc/databases/mysql80-client/patches/patch-client_mysqladmin.cc \
    pkgsrc/databases/mysql80-client/patches/patch-cmake_boost.cmake \
    pkgsrc/databases/mysql80-client/patches/patch-cmake_os_SunOS.cmake \
    pkgsrc/databases/mysql80-client/patches/patch-cmake_readline.cmake \
    pkgsrc/databases/mysql80-client/patches/patch-config.h.cmake \
    pkgsrc/databases/mysql80-client/patches/patch-configure.cmake \
    pkgsrc/databases/mysql80-client/patches/patch-include_CMakeLists.txt \
    pkgsrc/databases/mysql80-client/patches/patch-include_my__compare.h \
    pkgsrc/databases/mysql80-client/patches/patch-include_my__thread.h \
    pkgsrc/databases/mysql80-client/patches/patch-include_my__thread__os__id.h \
    pkgsrc/databases/mysql80-client/patches/patch-include_tables__contained__in.h \
    pkgsrc/databases/mysql80-client/patches/patch-libmysql_CMakeLists.txt \
    pkgsrc/databases/mysql80-client/patches/patch-mysys_kqueue__timers.cc \
    pkgsrc/databases/mysql80-client/patches/patch-mysys_stacktrace.cc \
    pkgsrc/databases/mysql80-client/patches/patch-router_CMakeLists.txt \
    pkgsrc/databases/mysql80-client/patches/patch-router_src_harness_include_mysql_harness_net_ts_impl_netif.h \
    pkgsrc/databases/mysql80-client/patches/patch-router_src_harness_include_mysql_harness_net_ts_internet.h \
    pkgsrc/databases/mysql80-client/patches/patch-router_src_harness_include_mysql_harness_net_ts_local.h \
    pkgsrc/databases/mysql80-client/patches/patch-router_src_harness_include_mysql_harness_tty.h \
    pkgsrc/databases/mysql80-client/patches/patch-router_src_harness_src_stdx_io_file_handle.cc \
    pkgsrc/databases/mysql80-client/patches/patch-scripts_CMakeLists.txt \
    pkgsrc/databases/mysql80-client/patches/patch-scripts_mysqld_safe.sh \
    pkgsrc/databases/mysql80-client/patches/patch-sql_CMakeLists.txt \
    pkgsrc/databases/mysql80-client/patches/patch-sql_conn__handler_socket__connection.cc \
    pkgsrc/databases/mysql80-client/patches/patch-sql_item_geofunc_relchecks_bgwrap.h \
    pkgsrc/databases/mysql80-client/patches/patch-sql_resourcegroups_platform_thread__attrs__api__apple.cc \
    pkgsrc/databases/mysql80-client/patches/patch-vio_viosocket.cc
cvs rdiff -u -r0 -r1.1 pkgsrc/databases/mysql80-server/DEINSTALL \
    pkgsrc/databases/mysql80-server/DESCR \
    pkgsrc/databases/mysql80-server/MESSAGE \
    pkgsrc/databases/mysql80-server/MESSAGE.sphinx \
    pkgsrc/databases/mysql80-server/Makefile \
    pkgsrc/databases/mysql80-server/PLIST \
    pkgsrc/databases/mysql80-server/PLIST.SunOS \
    pkgsrc/databases/mysql80-server/buildlink3.mk
cvs rdiff -u -r0 -r1.1 pkgsrc/databases/mysql80-server/files/ffsll.cc \
    pkgsrc/databases/mysql80-server/files/mysqld.sh
cvs rdiff -u -r0 -r1.1 pkgsrc/databases/mysql80-server/files/smf/manifest.xml \
    pkgsrc/databases/mysql80-server/files/smf/mysqld.sh

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

diffs are larger than 1MB and have been omitted