Log message:
p5-App-Sqitch: Update to 1.4.1. Changes:

- Removed the quoting of the role and warehouse identifiers that was
  added to the Snowflake engine in v1.4.0. Turns out Snowflake allows a
  warehouse to be specified in a different database, in which case dots
  are valid in the name and should not be quoted! So users must properly
  quote when necessary, but added notes to `sqitchtutorial-snowflake.pod`
  on the need to use URI escapes for special characters. Thanks to
  Patrick Sabo for the find, and to @marc-marketparts for validating
  that URI encoding works.
- Added notes on URL encoding database URLs to `sqitch-target.pod`, the
  main reference for database URLs in the Sqitch documentation.
- Fixed the output of the list of changes to be deployed or reverted to
  actually require `--verbose` twice, as described in the v1.4.0 changes,
  and not just once. Thanks to Erik Wienhold for the PR (#785)!
- Removed the duplicate change name from the output of the list of
  changes to be deployed or reverted with `-VV`. Thanks to Erik Wienhold
  for the PR (#787)!
- Fixed invalid template resolution when adding a singe change to
  multiple engines at once. Thanks to Christian Riedel for the detailed
  bug report (#795)!
- Fixed Oracle and Firebird test failures due to incorrect use of `chmod`.
  Thanks to Slaven Rezić for the report and the fix (#807)!
- Tests now require Test::Warn 0.31 or later, as newline handling issues
  cause test failures in earlier versions. Thanks to Slaven Rezić for the
  test reports and for identifying the issue.
- Updated the locale configuration to fix issues in more recent versions
  of Perl, and added tests to ensure that the sqitch CLI executes and
  properly emits localized messages (except on Windows, where the language
  codes are incompatible).
- Fixed an issue where the MySQL engine failed to recognize the MariaDB
  `mysql` client installed by Homebrew on macOS. Thanks to Carlos Ramos
  for the bug report and PR (#791)!

Log message:
Update to 1.4.0. From the changelog:

- Fixed Snowflake warehouse and role setup to properly quote identifiers
  unless they're valid unquoted identifiers or already quoted. Thanks to
  @marc-marketparts for the report (#685).
- Fixed a bug reworking a change when a rework directory is configured
  but not created. Thanks to @jfeaver for the report (#686).
- Output the list of changes to be deployed or reverted when `--verbose`
  is specified at least twice. Thanks to @vectro for the PR (#702).
- Fixed the formatting of the log and plan commands to allow empty or `0`
  separators in lists of things (such as `%{0}t` for a list of tags).
  Thanks to @web-vertalo for the pull request (#703).
- Updated the MySQL Tutorial to use 5.7 features. Thanks to Vlad
  Safronov for the PR (#705).
- Deprecated the `no_prompt` and `no_prompt` attributes of
  App::Sqitch::Engine in favor of passing booleans to the `revert` and
  `verify` methods. The attributes still exist for reverse compatibility,
  but now emit warnings and will be removed in the future. Thanks to
  Thanks to @vectro for the PR (#704).
- Added a warning for a double extension on the file names created
  by the `add` command. Thanks to @blairjordan for the PR (#724)!
- Added the `revert.strict` boolean configuration variable which, when
  set to true, requires the specification of a change to revert to. It
  also disables the `rebase` and `checkout` commands, though the
  `rebase.strict` and `checkout.strict` variables, respectively, may
  override it. Use `revert.strict` to prevent accidental reverts in
  sensitive environments. Thanks to @vectro for the PR (#719; revised in
  #735)!
- Fixed test failures due to a bug fix in the Perl URI module
  (libwww-perl/URI#13). Thanks to @bobfang for the report (#744)!
- Fixed test failures due to a change in the generation of DBI DSN by
  URI::Oracle introduced by libwww-perl/URI-db#23.
- Added a format option `%F` to `sqitch plan` that prints the path for
  the deploy file for each migration in the plan.
- Changed the default location for the Oracle `sqlplus` client when the
  `ORACLE_HOME` environment variable is set. It now returns either
  `$ORACLE_HOME/bin/sqlplus` or `$ORACLE_HOME/sqlplus` if it exists
  and is executable (and ends in `.exe` on Windows). Otherwise it simply
  returns `sqlplus` as before, assuming it will be found in the path.
  Thanks to @vectro for the suggestion (#747).
- Increased the required version of DBI to 1.631 or higher and removed
  a MySQL engine workaround for older versions.
- Added detection of a missing registry schema on connect and conditions
  to avoid querying it when it does not exist. Fixes an issue where
  Sqitch might find a project record in the current schema instead of the
  expected registry schema. Thanks to @vectro for the report and
  investigation (#668)!
- Fixed Snowflake and MySQL to properly raise errors on session query
  failures immediately after connection.
- Fixed the handling of unique violations for deploy script hash
  uniqueness so that it no longer returns a database error but properly
  reports the issue in a more human-friendly error message. Thanks to
  Stefan Badenhorst for the reminder (#630).
- Updated the registry SQL scripts for Vertica to always enable primary
  key and unique constraints. Unique constraints are now enabled for
  all database engines except Exasol and Snowflake.
- Dropped support for Vertica 7.1, as unique constraint enforcement was
  not added until Vertica 7.2.
- Increased minimum SQLite versions to 3.8.6, when unique constraint
  enforcement was added.
- Removed remaining uses of the smartmatch operator, thus eliminating
  the Perl 5.38 warnings about its deprecation. (#769)
- Added Cockroach to the list of valid engines recognized in command-line
  arguments (and a test to ensure new engines won't be omitted in the
  future). Thanks to @NOBLES5E for the spot (#772)!

Log message:
*: recursive bump for perl 5.38

Log message:
Mass-change BUILD_DEPENDS to TOOL_DEPENDS outside mk/.

Almost all uses, if not all of them, are wrong, according to the
semantics of BUILD_DEPENDS (packages built for target available for
use _by_ tools at build-time) and TOOL_DEPEPNDS (packages built for
host available for use _as_ tools at build-time).

No change to BUILD_DEPENDS as used correctly inside buildlink3.

As proposed on tech-pkg:
https://mail-index.netbsd.org/tech-pkg/2023/06/03/msg027632.html

Log message:
Update to 1.3.1. From the changelog:

- Fixed a bug introduced in v1.3.0 where the Postgres engine would
  always pass the port to `psql`, thus ignoring the `PGPORT` environment
  variable. Thanks to Cam Feenstra for the spot (#675)!
- Fixed test failures on OSes where the local time zone cannot be
  determined. Thanks to Slaven Rezić for the test reports, and to
  Dave Rolsky for the solution (#672).
- Updated the MySQL deploy/revert lock to be specific to the target
  database. This allows multiple instances of Sqitch to run at the
  same time on the same server as long as they're connecting to different
  databases. Thanks to Dmytro Kh for the report and discussion of the
  options (#670).
- Fixed test failures where DBD::Mem was not installed. Likely only
  occurred on some CPAN Testers nodes. Thanks to Slaven Rezić for those
  (#673).
- Banned the backslash character (`\`) in change and tag names. It would
  be ignored on Unix-style systems, but create unexpected subdirectories
  on Windows systems.
- Banned the slash character (`/`) in tag names. They're still allowed
  in change names to enable script organization, but can wreak havoc
  when used in tag names. Thanks to @ewie for the report (#680)!

Log message:
Update to 1.3.0. From the changelog:

- Fixed an issue when testing Firebird on a host with Firebird installed
  but no `isql`, and when using a local Firebird (e.g., the Engine12
  provider), which allows only one connection at a time. Thanks to Slaven
  Rezić for the the reproducible configuration (#597).
- Tweaked the Postgres engine to support Yugabyte. The only unsupported
  features are explicit locks, so users need to manually ensure that only
  one instance of Sqitch is updating the cluster at a time.
- Added support for CockroachDB. Almost exactly the same as for Postgres,
  so the new App::Sqitch::Engine::cockroach class extends
  App::Sqitch::Engine::pg to make a few changes. The SQL files with
  the registry DDL varies in a few ways, so they're separate.
- Now require URI::db v0.20 for Cockroach and Yugabyte URI support.
- Dropped support for MySQL 5.0.
- Added explicit sorting for aggregated lists (such as the tags associated
  with a commit) to the MySQL, Exasol, Snowflake, and Postgres (8.4 and
  higher) engines.
- Fixed slow deploys on MariaDB thanks to fractional timestamp support
  added in 5.03.05. Thanks to @rbrigot for the PR (#658)!
- Fixed a bug where destination locking failed on the first deploy to
  MySQL. Bug introduced along with destination locking in v1.2.0.
  Thanks Tom Bloor the report and to Alberto Simões for the help
  replicating the issue (#601).
- Removed the `sqitch engine update-config` action, originally added for
  compatibility reasons in 2014, and the prompt to use it was removed as
  of 0.9999 in 2019.
- Fixed a warning when searching for the Firebird client on Windows.

pkgsrc changes:

- Enable 'sqlite' by default to pass the self-tests.

Log message:
*: recursive bump for perl 5.36

Log message:
Update to 1.2.1. From the changelog:

- Updated all the live engine tests, aside from Oracle, to test with
  unique registry names, so as to avoid conflicts when multiple
  instances are being tested at once. Thanks to Slaven Rezić for the
  report (#597).
- Removed `local` directory from the distribution, accidentally included
  in v1.2.0. Thanks to gregor herrmann for the report (#600).

Log message:
Update to 1.2.0. From the changelog:

- Fixed partitioned search for deployed changes on Oracle and Exasol to
  correctly support plans with more than 250 changes. Thanks to @Nicqu
  for the report (#521).
- DBI connections to the registry will now be set to trace level one
  when a verbosity level of three or higher is passed to Sqitch
  (i.e., `sqitch -vvv`). Thanks to @wkoszek for the suggestion (#155).
- Renamed the "master" branch to "main" and updated all relevant
  references.
- Fixed the parsing of the Snowflake account name from the target URL
  to that it no longer strips out the region and cloud platform parts.
  Also deprecated the use of the region, host, and port config and
  environment variables. This is to comply with the new account name
  format. Thanks to @ldsingh00 for the report (#544).
- The checkout command will now show a usage statement when no branch
  name is passed to it, rather than a series of warnings and a Git error.
  Thanks to François Beausoleil for the report (#561).
- The checkout command now works when operating on a Sqitch project in
  a subdirectory of a Git project. Thanks to François Beausoleil for the
  report and suggested fix (#560).
- Fixed a failing bundle test when a top directory was configured in the
  user or system configuration. Thanks to @CodingMinds for the spot
  (#587).
- Added support to the Exasol engine for the `AUTHMETHOD` query parameter
  (to allow Open ID authentication) and the `SSLCERTIFICATE=SSL_VERIFY_NONE`
  query parameter to disable SSL verification. Thanks to Torsten Glunde
  for the report (#588).
- Fixed "Use of uninitialized value $engine in concatenation" error when
  Sqitch is unable to determine the engine when writing a plan file. Only
  happens in the rare case that the core.engine value is not set.
- Improved the error message when attempting to update a plan file and no
  project pragma is present. Thanks to Laurentiu Diaconu for the report
  (#577).
- Fixed the error message when attempting to deploy a change that has
  already been deployed to display the name of the change, rather than a
  memory address. Thanks to Neil Mayhew for the report (#579).
- Added destination locking, currently implemented for PostgresQL and
  MySQL. On starting a deploy or revert, Sqitch attempts to "lock the
  destination" using advisory locks, to ensure that only one instance of
  Sqitch makes changes to the database at any one time. This complements
  the existing locking, which applies as each change is deployed or
  reverted, as that pattern led to failures when multiple instances of
  Sqitch were working at once. Thanks to Neil Mayhew for the report
  (#579).
- Added the --lock-timeout option to the deploy, revert, rebase, and
  checkout commands, to allow for shorter or longer times to wait for an
  exclusive target database advisory lock for engines that support it.
  Defaults to 60 seconds.
- Fixed the behavior of the plan command's `--max-count` option when used
  with `--reverse` to show the proper items. Thanks to Adrian Klaver for
  the report (#517).
- Fixed an issue that could cause bugs with the `check` command on
  Firebird, Exasol, Oracle, and Vertica. Broken since the `check` command
  was added in v1.1.0.

Log message:
databases: Replace RMD160 checksums with BLAKE2s checksums

All checksums have been double-checked against existing RMD160 and
SHA512 hashes

The following distfiles could not be fetched (some may be only fetched
conditionally):

./databases/cstore/distinfo D6.data.ros.gz
./databases/cstore/distinfo cstore0.2.tar.gz
./databases/cstore/distinfo data4.tar.gz