doc: Updated textproc/highlight to 4.6

(schmonz)

Indent a couple lines.

(schmonz)

Reset PKGREVISION on libhighlight update.

(schmonz)

doc: Updated textproc/libhighlight to 4.6

(schmonz)

Update to 4.6. From the changelog:

- added `--service-mode` option to run highlight as long running
  process (#140)
- added extras/highlight-service.py as an example for the service mode
- updated astyle lib to version 3.3

(schmonz)

creduce: mention llvm 16 patch as comment

(nikita)

Set SSP_SUPPORTED=no for sparc64

(abs)

doc: Updated devel/libxtend to 0.1.7.12

(bacon)

devel/libxtend: Update to 0.1.7.12

Fix strptrcasecmp() to use strcasecmp()
Add romantoi(), convert Roman numeral text to integer
Add XT_SIGNUM() macro
A few minor fixes

(bacon)

jose: distinfo: regen

(nikita)

jose: add upstream patch to fix name collision:

The hsh local variable name conflicts with the function prototype of
hsh() in hsh.h, causing the following build issues with old compilers
(gcc 4.7):

(nikita)

libnitrokey: unbreak build on !Linux

(nikita)

doc: Updated lang/rakudo to 2023.04

(mef)

(lang/rakudo) Updated 2022.12 to 2023.04

(see doc/ChangeLog for full list)

New in 2023.04:

+ Improvements:
    + Make `Mu.WHY` a bit smarter, also handling CORE subroutines [faff9091]
    + Give `IO::Path.chown` more `unlink` like semantics [dde366ee]
    + `snip` now can also handle infinite lists [ec8cdd54]
    + Some exception message tweaking [331fd237]

+ Additions:
    + use v6.e.PREVIEW or v6.* implies `use experimental :rakuast` [fcdb78ce]
    + Add rotor capabilities to sub `comb` in 6.e [28a32766]

+ Fixes:
    + Fix `Range.Bool` for empty and infinite ranges in 6.e [83caae8e][188beb55]
      [53135c8d][f31a6d56]
    + Make sure `snitch` caches Seqs [61b8bee3]
    + Make prefix `//` working again [efb59f78]
    + Make `Cool.uninames` actually work [500ad5f6]
    + Make `Cool.uniname` actually match the documentation [af0c88cc]
    + Make `List.Set` work again without hanging [5a0e7a76]
    + Make `Distr.desc` correct for MacOS 11 and higher [eae02e8e]
    + Fix the git clone cmd in install docs [f79ae571]
    + Fix `IO::Path::Parts.raku` to handle type objects correctly [16924b41]
    + Fix "Unexpected named argument 'no_fallback' passed" on some meta types
      [b01d996d]
    + Warn about missing perl5 mods (Configure.pl) instead of crashing
      [6f86699f]
    + Make Supply.zip handle some potential deadlock situations better
      [6e2a46f6][2225e207]

+ Removals:
    + Remove support for PERL6_EXCEPTIONS_HANDLER [5d7e3857]

+ Internal:
    + Use HLL comparison for floating point noise check [3bd73896]
    + Remove some unnecessary BUILD methods [1a86348a]
    + Add Str.leading/trailing-whitespace implemementation-detail [5feb7f7f]

+ RakuAST Development:
    + A lot of work was done on RakuAST development (over 300 commits), raising
      the number of passing spectest files from 694 to 787 (out of 1355).

      [1f45b310][098a26e3][8809e87a][1338f4ae][e73f3bbd][48c19e15][f6fe1168]
... (omit) ..
      [1fd667cf][31fb2b9e][027e37cc][5d1d02d9][7b4b680e][3b838eaf][62d263fc]

New in 2023.02:

+ Improvements:
    + Make use of line directive information for compile time errors [6bc209fc]
      [89c23ddf]
    + Improve error message on "foo".Order [665375ba]
    + Try to be more explicit when exception reporting dies [45b19784]
    + Make X::Method::NotFound more resilient [eff02440]

+ Additions:
    + Allow for .rakutest as extension of Rakudo test files [4a42b211]
      [0d49c2e7]
    + Implement numeric coercers for Date/DateTime [72856df9]
    + Allow * to be used as identity on classify|categorize [4b264b80]
    + Introduce `$*EXIT` / `$*EXCEPTION` dynamic vars [50050866]
    + Add In Memoriam for Ben Davies [ccbf9a09][3d2f8bd9]
    + Add Complex.sign to v6.e [34cf82aa]
    + Add Unicode class to v6.c [db7ca2dd]
    + Make log and sqrt handle negative values mathematically correct
      in v6.e [760e21c1]
    + Make RakuAST:: classes available with `use experimental :rakuast`
      [c9cb334e]

+ Efficiency:
    + Make List.head() about 2.4x as fast [7e69a6de][615b9bf9]
    + Don't pollute PROCESS:: with failed $*FOO lookups [6ef8993f]

+ Fixes:
    + Fix EVAL regression on symbol leakage [1ea6be79]
    + Resolve the case of CUPR auto-vivifying some dynamics [7194b1e6]
    + Fix the list of expected symbols [c6afe382]
    + Fix swapped iterators in Seq.ACCEPTS [f078896c]
    + Don't error without git, but all needed files are present [e3e962c2]
    + Fix `race` to actually race and not secretly hypering [ffc9fc74]
    + Fix defaults for typed optional @/% params [JVM] [49facdc0]
    + Fix storing of typed Hashes from a list [c9e391f0][5ed14bc4]
    + Fix type constraints on QuantHashes [03b3b13d]
    + Fix breakage with "use v6.e.PREVIEW" [JVM] [c88f50d5]
    + Hopefully fix all inheritance issues with set operators [586466e9]
    + Set Xmx4G for building Rakudo [JVM] [67ba2dfc]
    + Fix error reporting for feeds [e09f20ca]
    + Fix serialization issues with Version [9e4fa286]
    + Make Junction:D.(Int|Numeric|Real) work [1841d6d9]
    + Don't special case [+] to List.sum [5c66515d][6b6c0ec8]
    + Correct description of BUILD/TWEAK in BUILDPLAN [fbb669ae]

+ Removals:
    + Eradicate knowledge of unimplemented COMPOSE phaser [0040f813]

+ Internal:
    + Make Azure pipelines know about the `main` branch [c3e0eb7c]
    + Fix a syntax error in Perl code [ad9302d7]
    + Fix NQP version check [7cd8adfa]
    + Some minor harness6 fixes [d50a8667]
    + Upgrade Rakudo tests to Unicode 15.0 [37826798][47ec76bd]
    + (test fixes) .classify|categorize(*) no longer throw [0baf2c0e]
    + Micro-optimize ADD-PAIRS-TO-BAG|MIX [7a6c3095]
    + Fix "ctxlexpad needs an MVMContext" regression in SETTING:: [b21cd61c]
    + Fix test description for unknown modifier (#5179) [69f1aa1f]
    + Warn about Unicode versioning issue wrt tests [268da12b]
    + Many, many commits related to RakuAST development:
      [e05474b6][956bd776][de998b6f][df72d0b1][fd3ed60e][93a39a6a][356e31cc]
... (omit) ...
      [2d559ef4][01a8faa7][4f1bbdbf][656b58bc][424de2f0][b6df0034][f8e22b6f]
      [1acb74d8]

(mef)

doc: Updated lang/nqp to 2023.04

(mef)

(lang/nqp) Updated 2022.12 to 2023.04, explicit ChangeLog unknown

(mef)

(devel/MoarVM) Also update buidlink3.mk

(mef)

doc: Updated devel/MoarVM to 2023.04

(mef)

(devel/MoarVM) Updated 2022.12 to 2023.04

New in 2023.04

Core:
+ Fix nqp::objprimunsigned handling of unsigned or sized integers [6adfc376]
+ Warn about missing perl5 mods in Configure instead of exploding make install
  [6589a170]

Documentation:

GC:

JIT:

Spesh:

Strings:

New in 2023.02

Core:
+ Avoid implicit function declarations in pthread_setname_np probe [9e6d9a8f]
+ Speedup creating sha1 digest string [8f90dc7c]
+ Bump mimalloc to v2.0.9 [d5430563]
+ Speedup VMArray's deserialize()... [a508c06b]
+ Update repo checking out script to also use 'main' [c9055873]
+ Add `--has-mimalloc` option to use system mimalloc [99479afe]
+ Update GitHub CI pipelines to track branch renames and OS deprecations
  [d7721042][e4336c71][d1bc8ff8][87183069][165e8297][8a80d3c6][8ddf6702]
+ Work around "const_iX NYI" after getlexstatic_o with fallback resolver
  [34bae78d]

Documentation:

GC:

JIT:
+ Jit nqp::rand_(i|n) [6866ff81]

Spesh:
+ Use right size for a lit_str_idx in JIT and spesh [6b456a6c]

Strings:
+ Simplify MVM_string_utf8_c8_encode_C_string [a64765e7]
+ Simplify MVM_string_index [ada3b80b]
+ Update to Unicode 15.0 [ebefe261]

(mef)

libproxy: fix build on SmartOS

(wiz)

net/termscp: reset maintainer

(pin)

doc: Updated textproc/typst to 0.4.0

(pin)

textproc/typst: update to 0.4.0

Footnotes
- Implemented support for footnotes
- The footnote function inserts a footnote
- The footnote.entry function can be used to customize the footnote listing
- The "chicago-notes" citation style is now available

Documentation
- Added a Guide for LaTeX users
- Now shows default values for optional arguments
- Added richer outlines in "On this Page"
- Added initial support for search keywords: "Table of Contents" will now find
  the outline function. Suggestions for more keywords are welcome!
- Fixed issue with search result ranking
- Fixed many more small issues

Math
- Breaking change: Alignment points (&) in equations now alternate between
  left and right alignment
- Added support for writing roots with Unicode: For example, $root(x+y)$ can
  now also be written as $√(x+y)$
- Fixed uneven vertical attachment alignment
- Fixed spacing on decorated elements (e.g., spacing around a canceled
  operator)
- Fixed styling for stretchable symbols
- Added tack.r.double, tack.l.double, dotless.i and dotless.j symbols
- Fixed show rules on symbols (e.g. {show sym.tack: set text(blue)})
- Fixed missing rename from ast.op to ast that should have been in the previous
  release

Scripting
- Added function scopes: A function can now hold related definitions in its own
  scope, similar to a module. The new assert.eq function, for instance, is part
  of the assert function's scope. Note that function scopes are currently only
  available for built-in functions.
- Added assert.eq and assert.ne functions for simpler equality and inequality
  assertions with more helpful error messages
- Exposed list, enum, and term list items in their respective functions' scope
- The at methods on strings, arrays, dictionaries, and content now support
  specifying a default value
- Added support for passing a function to replace that is called with each
  match.
- Fixed replacement strings: They are now inserted completely verbatim instead
  of supporting the previous (unintended) magic dollar syntax for capture
  groups
- Fixed bug with trailing placeholders in destructuring patterns
- Fixed bug with underscore in parameter destructuring
- Fixed crash with nested patterns and when hovering over an invalid pattern
- Better error messages when casting to an integer or float fails

Text and Layout
- Implemented sophisticated CJK punctuation adjustment
- Disabled overhang for CJK punctuation
- Added basic translations for Traditional Chinese
- Fixed alignment of text inside raw blocks (centering a raw block, e.g.
  through a figure, will now keep the text itself left-aligned)
- Added support for passing a array instead of a function to configure table
  cell alignment and fill per column
- Fixed automatic figure kind detection
- Made alignment of enum numbers configurable, defaulting to end
- Figures can now be made breakable with a show-set rule for blocks in figure
- Initial fix for smart quotes in RTL languages

Export
- Fixed ligatures in PDF export: They are now copyable and searchable
- Exported PDFs now embed ICC profiles for images that have them
- Fixed export of strokes with zero thickness

Web app
- Projects can now contain folders
- Added upload by drag-and-drop into the file panel
- Files from the file panel can now be dragged into the editor to insert them
  into a Typst file
- You can now copy-paste images and other files from your computer directly
  into the editor
- Added a button to resend confirmation email
- Added an option to invert preview colors in dark mode
- Added tips to the loading screen and the Help menu. Feel free to propose
  more!
- Added syntax highlighting for YAML files
- Allowed middle mouse button click on many buttons to navigate into a new tab
- Allowed more project names
- Fixed overridden Vim mode keybindings
- Fixed many bugs regarding file upload and more

Miscellaneous Improvements
- Improved performance of counters, state, and queries
- Improved incremental parsing for more efficient recompilations
- Added support for .yaml extension in addition to .yml for bibliographies
- The CLI now emits escape codes only if the output is a TTY
- For users of the typst crate: The Document is now Sync again and the World
  doesn't have to be 'static anymore

(pin)

doc: Updated sysutils/broot to 1.22.1

(pin)

sysutils/broot: update to 1.22.1

- allow dir computations in /run/media - Fix #704 - Thanks @jinliu
- fix included solarized-dark.hjson skin file

(pin)

luatex update

(markd)

luatex: update to 1.17.0 (via patches)

fixes  CVE-2023-32700

(markd)

Updated devel/py-maturin, www/py-httpcore

(adam)

py-httpcore: updated to 0.17.2

0.17.2 (May 23th, 2023)

- Add `socket_options` argument to `ConnectionPool` and `HTTProxy` classes.
- Improve logging with per-module logger names.
- Add `sni_hostname` request extension.
- Resolve race condition during import of `anyio` package.
- Enable TCP_NODELAY for all synchronous sockets.

(adam)

The 21.5 requirement of makeinfo 4.12 seems arbitrary - the
NetBSD-enclosed makeinfo 4.8 appears to work just fine.

Plus, simply not setting MAKEINFO will leave us without .info files.

(hauke)

py-maturin: updated to 1.0.0

v1.0.0
Add support for multiple --config-settings in PEP517 backend
Remove deprecated --universal2 cli option

(adam)

Updated sysutils/ansible, textproc/py-xlsxwriter

(adam)

py-xlsxwriter: updated to 3.1.1

Release 3.1.1
* Add support for new Excel dynamic functions added in 2023.
* Added support for adding a color to the `invert_if_negative` chart option.

(adam)

ansible: updated to 7.6.0

7.6.0

Major Changes

community.postgresql
- postgresql_privs - the ``password`` argument is deprecated and will be removed in community.postgresql 4.0.0, use the ``login_password`` argument instead (https://github.com/ansible-collections/community.postgresql/issues/406).

infoblox.nios_modules
- Added Grid Master Candidate feature
- Added Member Assignment to network and ranges
- Added NIOS Range module with Create, Update and Delete features
- Fixes issue unable to update/delete EAs using Ansible plugin
- Fixes static and dynamic allocation of IPV4 address of A Record
- Fixes to Update host name of  NIOS member
- Updates default WAPI version to 2.9

(adam)

doc: Updated sysutils/zabbix60-java to 6.0.17

(otis)

doc: Updated sysutils/zabbix60-frontend to 6.0.17

(otis)

doc: Updated sysutils/zabbix60-proxy to 6.0.17

(otis)

doc: Updated sysutils/zabbix60-agent to 6.0.17

(otis)

doc: Updated sysutils/zabbix60-server to 6.0.17

(otis)

zabbix60: Update to 6.0.17

* New Features and Improvements
  - Added Event-Driven Ansible media

* Bug Fixes
  - Fixed memory leak in json objects and identical keys
  - Fixed replace() function in expressions
  - Dropped support for custom geomap HTML attribution text
  - Added new limits for JS objects
  - Added debug logging for process selection in proc.mem[] on AIX
  - Updated go.mod/sum to allow mixing session and key parameter for Zabbix
    agent 2 items
  - Fixed minimum severity filter usage for map element link triggers
  - Fixed inability to import a template with trigger dependency on a host
    trigger
  - Fixed popup menus disappearing on right-clicking links in them
  - Optimised preprocessing steps and added two graphs and dashboard in the
    Hadoop by HTTP template
  - Prevented the ability to set a duplicate value for the uuid parameter when
    updating any of template entities; added possibility to update the uuid
    parameter for the Service API; fixed duplicate UUIDs in Proxmox VE by HTTP
    template
  - Optimised preprocessing steps in the Zookeeper by HTTP template
  - Optimised SQL queries and preprocessing steps
  - Removed limitation for size of logged messages in JS
  - Updated deprecated ports in Kubernetes templates, updated target tags,
    added notes about binding address options for Scheduler and Cluster
    Manager components

Full changelog: https://www.zabbix.com/rn/rn6.0.17

(otis)

Updated audio/opencore-amr, audio/fdk-aac

(adam)

fdk-aac: updated to 2.0.2

2.0.2
- Minor upstream updates
- Lots of upstream and local fuzzing fixes
- Added CMake project files
- Removed the MSVC specific makefile

2.0.1
- Minor release with a number of crash/fuzz fixes, primarily for the decoder

2.0.0
- Major update in the upstream source base, with support for new
  profiles and features, and numerous crash/fuzz fixes. The new
  upstream version is referred to as FDKv2, thus skipping the
  major version 1 and syncing the fdk-aac major version number to 2.

(adam)

opencore-amr: updated to 0.1.6

0.1.6
- Fixed an infinite loop when decoding some AMR-NB samples
- Fixed noise spikes when decoding non-voice frames for both AMR-NB and AMR-WB

(adam)

libtheora-docs: fix PLIST for latest doxygen and depend on it.

Bump PKGREVISION.

(wiz)

openobex: fix build with latest doxygen and depend on it

Bump PKGREVISION.

(wiz)

aubio: fix PLIST for latest doxygen and depend on it

Mark as not-for-python-3.11 while here.

(wiz)

irssi-xmpp: remove

No upstream commits in 4 years, does not support irssi 1.3+ and we
have irssi 1.4.

(wiz)

doc/TODO: + libproxy-0.5.1.

(wiz)

Updated devel/py-coverage, devel/py-test-xdist

(adam)

py-test-xdist: updated to 3.3.1

pytest-xdist 3.3.1 (2023-05-19)

Bug Fixes
- Avoid remote calls during startup as ``execnet`` by default does not ensure remote affinity with the
  main thread and might accidentally schedule the pytest worker into a non-main thread, which breaks numerous frameworks,
  for example ``asyncio``, ``anyio``, ``PyQt/PySide``, etc.

  A more safe correction will require thread affinity in ``execnet``

pytest-xdist 3.3.0 (2023-05-12)

Features
- Improved progress output when collecting nodes to be less verbose.

(adam)

py-coverage: updated to 7.2.6

Version 7.2.6 — 2023-05-23
--------------------------

- Fix: the ``lcov`` command could raise an IndexError exception if a file is
  translated to Python but then executed under its own name.  Jinja2 does this
  when rendering templates.  Fixes `issue 1553`_.

- Python 3.12 beta 1 now inlines comprehensions.  Previously they were compiled
  as invisible functions and coverage.py would warn you if they weren't
  completely executed.  This no longer happens under Python 3.12.

- Fix: the ``coverage debug sys`` command includes some environment variables
  in its output.  This could have included sensitive data.  Those values are
  now hidden with asterisks, closing `issue 1628`_.

(adam)

biology/Makefile: Add seqtk

(bacon)

doc: Added biology/seqtk version 1.4

(bacon)

biology/seqtk: Process FASTA/FASTQ sequences

Seqtk is a fast and lightweight tool for processing sequences in the
FASTA or FASTQ format. It seamlessly parses both FASTA and FASTQ files
which can also be optionally compressed by gzip.  It performs basic
file conversions and edits much like standard Unix tools do with text
files.

(bacon)

doc: Added x11/i3lock-color version 2.13.c.4

(nikita)

i3lock-color: import as x11/i3lock-color version 2.13.c.4

packaged in wip by kamil

i3lock improves slock by making it fork() and therefore combinable with
commands to suspend your computer. Additionally, instead of turning off
your screen via DPMS and/or displaying a black screen, i3lock displays
a white screen so you can see if your computer failed to resume from
suspend or if your screen is just locked. Also, when entering a wrong
password, i3lock does not call XBell(). This is important because
i3lock/slock think you've entered a password when resuming from suspend,
at least sometimes.

(nikita)

pngquant: add missing file

(wiz)

doc: Updated lang/erlang-doc to 26.0

(wiz)

doc: Updated lang/erlang-man to 26.0

(wiz)

doc: Updated lang/erlang to 26.0

(wiz)

erlang*: update to 26.0

Highlights:
    The shell
    Improvements of maps
    Improvements of the lists module
    No need to enable feature maybe in the runtime system
    Improvements in the Erlang compiler and JIT
    Incremental mode for Dialyzer
    argparse: A command line parser for Erlang
    SSL: Safer defaults
    SSL: Improved checking of options

See https://www.erlang.org/blog/otp-26-highlights/
and https://www.erlang.org/news/164

(wiz)

Updated databases/mysql80-client, databases/mysql80-server

(adam)

mysql80: updated to 8.0.33

8.0.33

Functionality Added or Changed

Important Change: For platforms on which OpenSSL libraries are bundled, the linked OpenSSL library for MySQL Server has been updated to version 1.1.1t. Issues fixed in OpenSSL version 1.1.1t are described at https://www.openssl.org/news/cl111.txt.

Replication: As part of ongoing work to change old terminology used in MySQL products, the terms ���master���, ���slave���, and ���MTS��� have been replaced in error messages relating to MySQL Replication by ���source���, ���replica���, and ���MTA���, respectively. This includes all error messages listed in messages_to_clients.txt and messages_to_error_log.txt relating to replication; the present task does not perform this replacement for messages used in other contexts.

See the MySQL 8.0 Error Message Reference, for more information.

Replication: mysqlbinlog --start-position now accepts values up to 18446744073709551615, unless the --read-from-remote-server or --read-from-remote-source option is also used, in which case the maximum is 4294967295.

Binary packages that include curl rather than linking to the system curl library have been upgraded to use curl 7.88.1.

The use of a generated column with DEFAULT(col_name) to specify the default value for a named column is not permitted and now emits an error message.

Bugs Fixed

NDB Cluster: Occasional temporary errors which could occur when opening a table from the NDB dictionary while repeatedly performing concurrent schema operations were not retried.

NDB Cluster: During iteration, ordered index scans retain a cursor position within each concurrently scanned ordered index fragment. Ordered index fragments are modified and balanced as a result of committing DML transactions, which can require scan cursors to be moved within the tree. When running with query threads configured (AutomaticThreadConfig set to 1), multiple threads can access the same index fragment tree structure, and the scans of multiple threads can have their cursors present in the same structure.

The current issue arose due to an assumption in the logic for moving scan cursors when committing DML operations that all scan cursors belonged to the LDM thread owning the index fragment, which did not allow for the possibility that such fragments might belong to query threads.

InnoDB: Dead code removal.

InnoDB: Error messages related to innodb_doublewrite moved to the error log.

InnoDB: Prevent online DDL operations from accessing out-of-bounds memory.

InnoDB: ALTER TABLE ... AUTO_INCREMENT could be set to less than MAX + 1 and not forced to MAX + 1.

InnoDB: Innodb_data_pending_fsyncs could show extremely high inaccurate values because of a variable overflow.

Partitioning: Some IN() queries on partitioned tables were not always handled correctly.

Partitioning: Queries using the INDEX_MERGE optimizer hint was not handled correctly in all cases.

Replication: XA transactions whose XIDs contained null bytes could not be recovered.

Replication: When binlog_order_commits was set equal to 1, for any two transactions and for any sub-step of the commit phase, the transaction that was written to the binary log first did not always execute the sub-step first, as expected.

Replication: The binary log recovery process did not report all possible error states.

Replication: Following CHANGE REPLICATION SOURCE TO SOURCE_CONNECTION_AUTO_FAILOVER=1, failover generated a number of misleading warnings in the log that implied there were problems when in fact conditions were those expected for such a failover. These log messages have been updated accordingly.

Replication: When a transaction failed, as a side effect, extraneous error messages relating the replication data repositories were written to the log. Now in such cases, we suppress such error messages, which are not directly related to the issue of the failed transaction or its cause.

Replication: Setting binlog_order_commits to OFF could lead to a missed GTID in the next binary log file's Previous_gtids event.

Our thanks to Yewei Xu and the Tencent team for the contribution.

Replication: Corrected the SQL statements suggested in the error message text for ER_RPL_REPLICA_ERROR_RUNNING_QUERY.

Our thanks to Dan McCombs for the contribution.

Replication: A hash scan builds a hash of changes, scans the target table or index, and applies any matching change for the current entry. In the build phase, it uses only the before image, and skips any after image. Problems arose in some cases because generated columns were computed for the (skipped) after image, leading to replication errors. This is fixed by not computing generated columns any longer for seek-only calls such as hash scans.

Our thanks to dc huang for the contribution.

Replication: In certain rare cases, it was possible to set gtid_mode=OFF for one session while another session, after WAIT_FOR_EXECUTED_GTID_SET() was issued by a user in this second session, was still waiting for the next GTID set from the first session. This could result in the second session waiting indefinitely for the function to return.

Group Replication: Accessing the Performance Schema replication_group_communication_information and replication_group_member_stats tables in parallel sometimes caused subsequent group replication operations to hang.

Group Replication: In certain cases, the group replication secondary node unexpectedly shut down while purging the relay log.

Group Replication: When shutting down the Group Replication plugin, the order in which the associated events were reported the error log sometimes led to confusion. To remove any doubts, we now make sure that Plugin group_replication reported: 'Plugin 'group_replication' has been stopped. is in fact the last log message relating to the shutdown, written only when all other events associated with shutting down the plugin have been logged.

Microsoft Windows: The authentication_fido_client plugin stopped responding during the authentication process if it was unable to find a FIDO device on the Windows client host.

In certain cases, CONVERT(utf8mb3_column USING UTF16) was rejected with the error Cannot convert string '\x--...' from binary to utf16.

When joining two tables on a string column, and the column from one of the tables has an additional predicate comparing it with a temporal literal, constant propagation in some cases incorrectly caused the join condition to be modified such that it used temporal rather than string semantics when comparing the strings. This caused incorrect results to be returned from the join.

Error messages returned after calling the mysql_reset_connection() C API function in a prepared statement did not identify the function name properly.

Fixed a regression in a previous fix for an issue with windowing functions.

Our thanks to Dmitry Lenev for the contribution.

When replacing subqueries in transforms, the internal flag showing whether a given query block contains any subqueries (PROP_SUBQUERY) was not updated afterwards.

A client setting the character set to an impermissible client character set (ucs2, utf16, utf16le, or utf32) could cause unexpected behavior when the client used an authentication plugin.

EXPLAIN ANALYZE displayed 0 when the average number of rows was less than 1. To fix this, we now format numbers in the output of EXPLAIN ANALYZE and EXPLAIN FORMAT=TREE such that numbers in the range 0.001-999999.5 are printed as decimal numbers, and numbers outside this range are printed using engineering notation (for example: 1.23e+9, 934e-6). In addition, trailing zeroes are no longer printed, and numbers less than 1e-12 are printed as 0.

This helps ensure consistent precision regardless of the number's value and improve readability, while producing minimal rounding errors.

The NTILE() function did not work correctly in all cases.

Some joins on views did not perform correctly.

Transforming a correlated scalar subquery to a derived table led to a wrong result for InnoDB tables when the subquery included duplicate predicates. An example of a query which could be affected by this issue is shown here:

SELECT * FROM t1
WHERE (
  SELECT t2.a FROM t2
  WHERE t2.a = t1.a AND t2.a = t1.a
    ) > 0;

Fixed an assert in sql/item_strfunc.cc that could potentially lead to issues with the SPACE() function.

Using ROW_COUNT() as the length argument to LPAD() or RPAD() did not perform as expected.

A query with a window function having an expression with a CASE function in its ORDER BY clause could lead to a server exit.

The fix for a previous issue introduced an assertion in debug builds when optimizing a HAVING clause.

When using mysqld_multi, the system that obscures "--password" usage as "--password=*****" would also match "--password-history" and "--password-require-current" definitions as "--password", but now explicitly checks for "--password=" instead.

In some cases, calling the mysql_bind_param() C API function could cause the server to become unresponsive.

The authentication_oci_client plugin was unable to open a valid configuration file if any of its entries contained an equals sign character separated by spaces (for example, key_file = /home/user/.oci/oci_api_key.pem). Now, both 'key=value' and 'key = value' entry formats are supported.

Incorrect results were returned when the result of an INTERSECT or EXCEPT operation was joined with another table. This issue affected these operations in such cases when used with either DISTINCT or ALL.

When preparing a view query, the operation used the system character set (instead of the character set stored in data dictionary) and then reported an invalid character-string error.

Prepared statements that operate on derived tables, including views, could stop unexpectedly due to problems with the code for reopening tables after an error.

Removed an assertion raised in certain cases by the RANDOM_BYTES() function in debug builds.

There was an issue in how persisted variables were set on startup, causing certain variables not to get properly set to their persisted value.

The MAKETIME() function did not perform correctly in all cases.

Some functions with multiple arguments did not produce the expected results.

A table reference in an ORDER BY outside the parenthesized query block in which the table was used, and which query block had no LIMIT or ORDER BY of its own, raised an error.

A left join with an impossible condition as part of an ON clause was not optimized as in MySQL 5.7, so that in MySQL 8.0, the query executed more quickly without the impossible condition than with it. An example of such a query, impossible condition included, is SELECT * FROM t1 JOIN t2 ON t1.c1=t2.c1 AND 1=2.

When a user defined function was part of a derived table that was merged into the outer query block, or was part of a subquery converted to a semi-join, knowledge of whether this UDF was deterministic (or not) was lost during processing.

With JSON logging enabled and an event subclass specified in the audit log filter definition, an empty item ("" : { }) was appended to the end of the logged event.

Some subqueries did not execute properly.

After the asymmetric_encrypt() component function in a SELECT query encountered a NULL field to decrypt, it could return NULL values for other non-NULL encrypted fields.

The server did not always shut down cleanly after uninstalling the audit log plugin.

Certain antijoins were not handled correctly by the server.

When the MySQL 5.7 Optimizer has 2 choices for an index to filter rows, one primary and one secondary, it picks a range scan on the secondary index because the range scan uses more key parts. MySQL 8.0 did not use this logic, instead choosing the primary index to filter rows with WHERE clause filtering. Primary key use is not suitable in such cases due to the presence of LIMIT, and due to the nature of data distribution. The secondary index was not considered while resolving order by due to constant elimination. This resulted in much different query plans in MySQL 5.7 and MySQL 8.0 for the same query.

We solve this issue in MySQL 8.0 by skipping the constant key parts of the index during order-by evaluation only if the query is constant-optimized, which can be done at this time, but not during LIMIT analysis.

The MySQL data dictionary caches failed lookups of se_private_id values (IDs which are not found), which speeds up execution of code specific to InnoDB, relying on the fact that InnoDB does not reuse these IDs. This assumption does not necessarily hold for other storage engines, most notably NDB, where this problem was resolved previously by not using this cache.

We extend the previous fix made for NDB so that the cache lookup is now employed only when the table uses the InnoDB storage engine.

Unexpected results were seen in some queries using DENSE_RANK(), possibly with the addition of WITH ROLLUP.

Fixed an assert raised in sql/sql_tmp_table.cc following work done previously to reimplement ROLLUP processing.

Some CTEs that did not use any tables were not always handled correctly.

Accessing rows from a window frame of a window function call present only in the query's ORDER BY list raised an error.

PERCENT_RANK() used with ORDER BY column did not return the correct result.

The --exclude-tables and --include-tables mysqlpump options did not handle views.

Changed the MySQL systemd service unit configuration from After=network-online.target to Wants=network-online.target to ensure that all configured network devices are available and have an IP address assigned before the service is started.

AVG(...) OVER (ROWS BETWEEN 1 FOLLOWING AND UNBOUNDED FOLLOWING) did not return the correct result.

A query of the form SELECT 1 FROM t1 WHERE NOT EXISTS (VALUES ROW(1), ROW(2)) caused an assert in debug builds when the subquery_to_derived optimizer switch was enabled.

mysqlimport did not escape reserved word table names when used with the --delete option.

When cloning a condition to push down to a derived table, characters in strings representing conditions were converted to utfmb4 correctly only for values less than 128 (the ASCII subset), and code points outside the ASCII subset were converted to invalid characters, causing the resulting character strings to become invalid. For derived tables without UNION, this led to problems when a column name from the derived table used characters outside the ASCII subset, and was used in the WHERE condition. For derived tables with UNION, it created problems when a character outside the ASCII subset was present in a WHERE condition.

We fix these issues by initializing the string used for representing the condition in such cases to the connection character set.

Using --single-transaction with mysqldump version 8.0.32 required either the RELOAD or FLUSH_TABLES privilege. This requirement now applies only when both gtid_mode=ON (default OFF) and with --set-gtid-purged = ON|AUTO (default AUTO).

Fixed a number of issues present in the internal documentation for the scramble generator algorithm in sha256_scramble_generator.cc and sha2_password_common.cc.

Our thanks to Niklas Keller for the contribution.

CREATE USER IF NOT EXISTS added a password history entry even when the user already existed and the password was not updated. This caused a subsequent ALTER USER statement to be rejected.

Many joins using eq_ref access did not perform as well as in previous versions. This issue was first reported in MySQL 8.0.29.

A hash outer join sometimes incorrectly matched NULL with a decimal zero or an empty string that used a non-padding collation, leading to erroneous results.

An object used internally by ALTER INSTANCE RELOAD TLS was not freed until the number of readers reached 0, under the assumption is that the number of readers should reach 0 fairly frequently. The read lock held during an SSL handshake is generally an expensive operation, with network calls, so when roundtrips between the client and the server took excessively long, the lock was held for a relatively long amount of time. This meant that, when changing the value of this object and there were a sufficient number of incoming SSL connections being made, the number of readers might not reach 0 in a reasonable length of time, leaving the thread holding the lock using 100% of the CPU until the lock was released.

We fix this by adding a wait after setting the pointer to this object to a new value, but before releasing the old object.

Our thanks to Sinisa Milivojevic for the contribution.

If mysqldump or mysqlpump could not convert a field's default value to UTF-8 (for instance, if the field was of type BINARY and the default value did not coincide with valid UTF-8), the operation produced results that were not valid to import. Further, using the --hex-blob option did not resolve the issue. We now convert the default value to the system character set. If this fails, the server sends the value as hexadecimal instead to make it more human-readable.

A connection using the C API (libmysqlclient) client library could fail with the FUTURE crypto policy.

While cloning a temporary table for a common table expression which used shared materialization, the cloned temp table was not marked as using hash deduplication, leading to wrong results. We now set the hash field for the cloned temporary table correctly, and update the hidden field count to take this into account.

CREATE EVENT and ALTER EVENT assumed that all values passed to them (other than in a DO clause) resolved as scalars without actually checking the values. This led to assertions when any such values actually rows.

We now perform an explicit check for the number of columns when resolving such items, and report an error when one produces a row and not a scalar value.

A view reference whose underlying field is a constant is not marked as constant when the reference is part of an inner table of an outer join. It was found that, when pushing a condition down to a derived table, the reference was stripped off and only the underlying field was cloned, which made it a constant, and led to wrong results.

To fix this problem, we ensure that we do not push such a condition down to the derived table by adding a check to see first whether the table used by the condition matches the derived table or is a constant expression; only when it is one or the other of these do we actually push the condition down.

(adam)

Updated www/nginx-devel to 1.25.0

(osa)

www/nginx-devel: update 1.24.0 -> 1.25.0

Enable HTTPv3 protocol by default.

The OpenSSL compatibility layer, which emulates BoringSSL
QUIC API for OpenSSL, is enabled by default, and 0-RTT is
not supported in this mode.

<ChangeLog>

*) Feature: experimental HTTP/3 support.

</ChangeLog>

(osa)

boost: macOS build fix

(tnn)

doc: Updated comms/libhidapi to 0.14.0

(nikita)

libhidapi: update to version 0.14.0

Changelog (taken from https://github.com/libusb/hidapi/releases/tag/hidapi-0.14.0):

hidapi-0.14.0
d3013f0

general: add hid_get_report_descriptor API function (#451)
macOS: fix retrieving USB Interface number on macOS 13.3 (#534)
macOS: Properly handle the close of run loop on macOS (#522)
libusb: fix crash in hid_enumerate() caused by a stale device handle (#526)

windows: alternative way to get USB Serial Number if not provided by HidD_GetSerialNumberString (#464)
windows: don't mark with dllexport in static build (#507/#515)
windows: Get Bluetooth device Model Number String instead of Device Name into product string (#500)

general: fixes (mostly error handling) of issues found by Coverity Scan (#552/#554/#555/#559/#560/#561)
general: variouse fixes and improvements

Released hidapi-win.zip includes pre-compiled:

    hidapi.dll
    hidapi.lib

For x86 and x64 Windows platforms.
And header file(s) for it.

(nikita)

doc: Updated security/nettle to 3.9

(wiz)

nettle: update to 3.9.

NEWS for the Nettle 3.9 release

This release includes bug fixes, several new features, a few
performance improvements, and one performance regression
affecting GCM on certain platforms.

The new version is intended to be fully source and binary
compatible with Nettle-3.6. The shared library names are
libnettle.so.8.7 and libhogweed.so.6.7, with sonames
libnettle.so.8 and libhogweed.so.6.

This release includes a rewrite of the C implementation of
GHASH (dating from 2011), as well as the plain x86_64 assembly
version, to use precomputed tables in a different way, with
tables always accessed in the same sequential manner.

This should make Nettle's GHASH implementation side-channel
silent on all platforms, but considerably slower on platforms
without carry-less mul instructions. E.g., benchmarks of the C
implementation on x86_64 showed a slowdown of 3 times.

Bug fixes:

* Fix bug in ecdsa and gostdsa signature verify operation, for
  the unlikely corner case that point addition really is point
  duplication.

* Fix for chacha on Power7, nettle's assembly used an
  instruction only available on later processors. Fixed by
  Mamone Tarsha.

* GHASH implementation should now be side-channel silent on
  all architectures.

* A few portability fixes for *BSD.

New features:

* Support for the SM4 block cipher, contributed by Tianjia
          Zhang.

* Support for the Balloon password hash, contributed by Zoltan
          Fridrich.

* Support for SIV-GCM authenticated encryption mode,
          contributed by Daiki Ueno.

* Support for OCB authenticated encryption mode.

* New exported functions md5_compress, sha1_compress,
  sha256_compress, sha512_compress, based on patches from
  Corentin Labbe.

Optimizations:

* Improved sha256 performance, in particular for x86_64 and
  s390x.

* Use GMP's mpn_sec_tabselect, which is implemented in
  assembly on many platforms, and delete the similar nettle
  function. Gives a modest speedup to all ecc operations.

* Faster poly1305 for x86_64 and ppc64. New ppc code
  contributed by Mamone Tarsha.

Miscellaneous:

* New ASM_FLAGS variable recognized by configure.

* Delete all arcfour assembly code. Affects 32-bit x86, 32-bit
  and 64-bit sparc.

Known issues:

* Version 6.2.1 of GNU GMP (the most recent GMP release as of
  this writing) has a known issue for MacOS on 64-bit ARM: GMP
  assembly files use the reserved x18 register. On this
  platform it is recommended to use a GMP snapshot where this
  bug is fixed, and upgrade to a later GMP release when one
  becomes available.

* Also on MacOS, Nettle's testsuite may still break due to
  DYLD_LIBRARY_PATH being discarded under some circumstances.
  As a workaround, use

  make check EMULATOR='env DYLD_LIBRARY_PATH=$(TEST_SHLIB_DIR)'

(wiz)

gexiv2: lower C++ standard from C++17 to C++11

gexiv2 requests C++17 by default in it's meson.build, but it depends on
graphics/exiv2 whose public headers are not C++17 compliant since they make
use of std::auto_ptr:

graphics/gexiv2/work/.buildlink/include/exiv2/tags.hpp:143:17: error: no template named 'auto_ptr' in namespace 'std'; did you mean simply 'auto_ptr'?

(tnn)

doc: Updated graphics/jpegoptim to 1.5.4

(fcambus)

jpegoptim: update to 1.5.4.

v1.5.4 - make sure JPEG mode (progressive vs non-progressive) is
        preserved by default,
        fix parallel processing when reading file list
(thanks to Cubittus)

(fcambus)

doc: Updated graphics/ansilove to 4.2.0

(fcambus)

ansilove: update to 4.2.0.

AnsiLove/C 4.2.0 (2023-05-23)

- Add initial RPM spec file
- Add support for the Spleen 8x16 font (requires libansilove >= 1.4.0)

(fcambus)

doc: Updated graphics/libansilove to 1.4.0

(fcambus)

libansilove: update to 1.4.0.

libansilove 1.4.0 (2023-05-23)

- Add initial RPM spec file
- Add font data for Spleen 8x16, it now has full CP437 support

(fcambus)

Updated devel/py-types-setuptools, devel/py-types-ujson, textproc/py-types-yaml, textproc/py-yamllint

(adam)

py-yamllint: updated to 1.32.0

1.32.0 (2023-05-22)
- Look for configuration file in parent directories
- Rule ``anchors``: add new option ``forbid-unused-anchors``

(adam)

py-types-yaml: updated to 6.0.12.10

6.0.12.10
Improve dump/serialize types

* Add overloads to return `str` or `bytes`, instead of `Any`.
* Mark some arguments as keyword-only.
* Add missing default values.

(adam)

py-types-ujson: updated to 5.7.0.5

5.7.0.5
Convert the remaining ujson uses of AnyStr

(adam)

py-types-setuptools: updated to 67.8.0.0

67.8.0.0
Bump setuptools to 67.8.*

(adam)

libgit2: manually drop -Werror with BUILDLINK_TRANSFORM

There is an ENABLE_WERROR cmake arg which is default OFF so I guess
the package logic for this is broken.

(tnn)

doc: Updated graphics/pngquant to 3.0.1

(wiz)

pngquant: update to 3.0.1.

Rewritten in rust.

version 3.0
-----------
- replaced C libimagequant library with a Rust imagequant crate
- switched build system from make to Cargo

(wiz)

*: bump for libproxy 0.5

(wiz)

doc: Updated www/libproxy to 0.5.0

(wiz)

libproxy: update to 0.5.0.

What's Changed

    Fix building without duktape by @mattst88 in #180
    Fix WITH_GNOME2 documentation by @mattst88 in #181
    bindings: perl: Use ccflags from %Config for libproxy module compilation by @Vogtinator in #183
    Use XDG_CURRENT_DESKTOP to detect GNOME desktop like systems by @janbrummer in #192
    Enable the use of ducktape in Windows systems by @illera88 in #194
    Enable static builds for libproxy by @illera88 in #195
    Fix build on macOS by @wegank in #189
    Complete rewrite by @janbrummer in #201
    kde: Remove line breaks in values by @janbrummer in #203
    Add man page for proxy tool by @janbrummer in #204
    Add PX_FORCE_CONFIG env by @janbrummer in #205
    add alert function to pacrunners by @multiSnow in #196
    Update architecture documentation by @janbrummer in #206
    Check for valid uri_host in ignore_ip() by @janbrummer in #210
    Remove line break in debug output by @janbrummer in #211
    Improve GNOME/KDE get_config() execution by @janbrummer in #212

(wiz)

x11/alacritty: unintended maintainer change

Didn't mean to take over maintainership.
I do maintain alacritty-dev in wip, currently 0.13.0 and managed to copy
the Makefile header. Sorry.

(pin)

doc: Updated x11/alacritty to 0.12.1

(pin)

x11/alacritty: update to 0.12.1

Fixed
- Very long startup times on Wayland systems with broken xdg-portal setup
- Error on startup with GLX when using old mesa platforms
- Character ; inside the URI in OSC 8 sequence breaking the URI
- Selection on last line not updating correctly on resize
- Keyboard input not working on macOS with some IMEs like Fig.io

(pin)

sysutils/xplr: clean-up after update

(pin)

libnitrokey: maybe needs udev on Linux

(nikita)

Find Tcl in any PREFIX.

(schmonz)

libudev: also build the rest of the program.

should be renamed to eudev eventually.

(nikita)