Recommended update for perl-DBD-Pg, perl-DBD-SQLite, perl-DBI, perl-YAML-LibYAML

Announcement ID: SUSE-RU-2024:2971-1
Rating: moderate
References:
Affected Products:
  • Development Tools Module 15-SP5
  • Development Tools Module 15-SP6
  • openSUSE Leap 15.5
  • openSUSE Leap 15.6
  • SUSE Enterprise Storage 7.1
  • SUSE Linux Enterprise Desktop 15 SP4 LTSS 15-SP4
  • SUSE Linux Enterprise Desktop 15 SP5
  • SUSE Linux Enterprise Desktop 15 SP6
  • SUSE Linux Enterprise High Performance Computing 15 SP2
  • SUSE Linux Enterprise High Performance Computing 15 SP2 LTSS 15-SP2
  • SUSE Linux Enterprise High Performance Computing 15 SP3
  • SUSE Linux Enterprise High Performance Computing 15 SP4
  • SUSE Linux Enterprise High Performance Computing 15 SP5
  • SUSE Linux Enterprise High Performance Computing ESPOS 15 SP4
  • SUSE Linux Enterprise High Performance Computing LTSS 15 SP3
  • SUSE Linux Enterprise High Performance Computing LTSS 15 SP4
  • SUSE Linux Enterprise Real Time 15 SP5
  • SUSE Linux Enterprise Real Time 15 SP6
  • SUSE Linux Enterprise Server 15 SP2
  • SUSE Linux Enterprise Server 15 SP2 LTSS 15-SP2
  • SUSE Linux Enterprise Server 15 SP3
  • SUSE Linux Enterprise Server 15 SP3 LTSS 15-SP3
  • SUSE Linux Enterprise Server 15 SP4
  • SUSE Linux Enterprise Server 15 SP4 LTSS 15-SP4
  • SUSE Linux Enterprise Server 15 SP5
  • SUSE Linux Enterprise Server 15 SP6
  • SUSE Linux Enterprise Server for SAP Applications 15 SP2
  • SUSE Linux Enterprise Server for SAP Applications 15 SP3
  • SUSE Linux Enterprise Server for SAP Applications 15 SP4
  • SUSE Linux Enterprise Server for SAP Applications 15 SP5
  • SUSE Linux Enterprise Server for SAP Applications 15 SP6

An update that can now be installed.

Description:

This update for perl-DBD-Pg, perl-DBD-SQLite, perl-DBI, perl-YAML-LibYAML fixes the following issues:

perl-DBI was updated from version 1.642 to 1.643:

  • Updated Devel::PPPort and removed redundant compatibility macros
  • Correct minor typo in documentation
  • Correct documentation introducing $dbh->selectall_array()
  • Introduced select and do wrappers earlier in the documentation
  • Mark as deprecated old API functions which overflow or are affected by Unicode issues
  • Add new attribute RaiseWarn, similar to RaiseError

perl-DBD-SQLite was updated from version 1.66 to 1.74:

  • Fixed disabling of __perllib_provides
  • Upgraded SQLite to 3.42.0
  • Added missing possible table_type values to POD
  • Set UTF8CACHE to avoid slowdown with -DDEBUGGING
  • Lowercase datatype in table column metadata for back-compatibility
  • Fixed test failure on perl built with -DDEBUGGING
  • Improve sqlite_load_extension documentation
  • Add a feature to unregister a created function
  • Fixed accented characters in POD
  • Link embedded sqlite devel files to system files
  • Use the system sqlite rather than the built-in one
  • Fixed documentation to use the correct attribute with sqlite_
  • Modify the fix to silence the sqlite_unicode warning not to check the attribute twice
  • Fix an encoding issue of naive
  • Made DBD_SQLITE_STRING_MODE constants exportable
  • Stop setting THREADSAFE=0 if perl has pthread (ie. 5.20+)
  • Fixed a memory leak in ::VirtualTable
  • Introduced "string_mode" handle attribute to fix long-standing issues of sqlite_unicode
  • Added a dependency from dbdimp.o to the *.inc files included into dbdimp.c
  • Fixed an offset issue of VirtualTable
  • Fixed quadmath issues
  • Added sqlite_txn_state method to see internal state of the backend
  • Switched to XSLoader
  • Use quadmath_snprintf if USE_QUADMATH is defined
  • Use av_fetch instead of av_shift

perl-DBD-Pg was update from version 3.10.4 to 3.18.0:

  • Support new PQclosePrepared function, added in Postgres 17
  • Improved documentation about ping always returning a value
  • New database handle attribute pg_skip_deallocate Prevents any deallocation of automatically prepared statements to support new pgBouncer feature
  • Fix to handle escaped quotes in connection string
  • Return number of affected rows from a MERGE command
  • Added support for Github CI actions
  • Removed undocumented internal-only pg_pid_number attribute
  • Small warning in docs about PG_CHAR
  • Added new attribute "pg_int8_as_string", for backwards compatibility.
  • Added a META.json file; rename META.yml to META.yaml
  • Fix 03smethod.t $sth->last_insert_id skip count for DBI < 1.642
  • Documentation improvements for service files
  • Automatically use 64-bit versions of large object functions when available
  • Set UTF8 flag as needed for error messages
  • In tests, do not assume what the default transaction isolation level will be
  • Make tests smarter about detecting pg_ctl results in different locales
  • Adjust tests for the fact that reltuples can be -1 in Postgres version 13 and later. This is mostly reflected in the CARDINALITY column for $dbh->statistics_info.
  • Correctly pull back pg_async status from statement handle. Previously, $dbh->{pg_async} would return undef.
  • Remove the experimental 'fulltest' Makefile target.
  • The $dbh->primary_key_info and $dbh->foreign_key_info methods will now always return a statement handle, even with no matches. Previously, they returned undef directly. Callers can check if the returned handle contains any rows.
  • The $dbh->tables method will always return a list, even if it is empty.
  • Add pg_lo_tell64, pg_lo_seek64, and pg_lo_truncate64, for anyone dealing with really, really, really large 'large objects'. Requires Postgres 9.3 or better.
  • Allow test to run again when using a non-superuser to connect
  • Adjust tests to force loading proper version of DBD::Pg every time.
  • Removed the long-deprecated _pg_use_catalog method.
  • Many improvements and changes to the test suite.
  • Redo the "last_result" internals in dbdimp.c, which fixes a memory leak.
  • Fixed regression in Perl length() for returned query results
  • Make $sth->finish() do a little less. Notably, even after calling finish(), pg_error_field will still work on the last action performed.
  • Tweak tests so Windows boxes pass
  • Run tests in verbose mode
  • Prevent DBI from flipping AutoCommit to 'on' after a failed commit
  • Revert overly aggressive testing shortcut as it can cause installs to fail
  • Return the table info row last in statistics_info. This fixes statistics_info on pre-8.3 servers.
  • Fixed ASC_OR_DESC field in statistics_info
  • Indicate NULL ordering in statistics_info
  • Adjust Makefile to fix failing 'fulltest' target on BSD systems
  • Indicate non-key index columns (INCLUDE) in statistics_info
  • Return an empty result set instead of undef from statistics_info when the requested table doesn't exist and $unique_only is false.
  • Fixed segfault during st destroy
  • Improved testing for table_info()
  • Improved UTF-8 wording in documentaion

perl-YAML-LibYAML was updated to version 0.89:

  • Breaking Change: Set $YAML::XS::LoadBlessed default to false to make it more secure
  • Fixed disabling of __perllib_provides
  • Recognise core booleans on Perl 5.36+ at dump time
  • Fixed YAML::XS pod in cpanminus
  • Convert doc from Swim to Markdown
  • Added option ForbidDuplicateKeys
  • Recognize tied variables
  • Updated libyaml sources to 0.2.4. Changes affecting YAML::XS are
  • Output '...' at the stream end after a block scalar with trailing empty lines
  • Accept '%YAML 1.2' directives (they are ignored and do not change behaviour though)
  • Fix memory leak when loading invalid YAML
  • Support aliasing scalars resolved as null or booleans
  • Add YAML::XS::LibYAML::libyaml_version()
  • Support standard !!int/!!float tags instead of dying
  • Fixed double free/core dump when Dump()ing binary data
  • Update config.h from libyaml
  • Update libyaml to version 0.2.2. Most important change for users is that plain urls in flow style can be parsed now. Example: [ http://yaml.org].
  • Added $Indent - number of spaces when dumping
  • Implemented $LoadCode
  • Update to libyaml 0.2.1. It's forbidden now to escape single quotes inside double quotes
  • When disabling $LoadBlessed, return scalars not refs
  • Save anchors also for blessed scalars
  • Fixed format specifier/argument mismatch
  • Fixed a C90-compatibility issue
  • Prevent warning about unused variables

Patch Instructions:

To install this SUSE update use the SUSE recommended installation methods like YaST online_update or "zypper patch".
Alternatively you can run the command listed for your product:

  • openSUSE Leap 15.6
    zypper in -t patch SUSE-2024-2971=1 openSUSE-SLE-15.6-2024-2971=1
  • openSUSE Leap 15.5
    zypper in -t patch openSUSE-SLE-15.5-2024-2971=1
  • Development Tools Module 15-SP5
    zypper in -t patch SUSE-SLE-Module-Development-Tools-15-SP5-2024-2971=1
  • Development Tools Module 15-SP6
    zypper in -t patch SUSE-SLE-Module-Development-Tools-15-SP6-2024-2971=1
  • SUSE Linux Enterprise High Performance Computing 15 SP2 LTSS 15-SP2
    zypper in -t patch SUSE-SLE-Product-HPC-15-SP2-LTSS-2024-2971=1
  • SUSE Linux Enterprise High Performance Computing LTSS 15 SP3
    zypper in -t patch SUSE-SLE-Product-HPC-15-SP3-LTSS-2024-2971=1
  • SUSE Linux Enterprise High Performance Computing ESPOS 15 SP4
    zypper in -t patch SUSE-SLE-Product-HPC-15-SP4-ESPOS-2024-2971=1
  • SUSE Linux Enterprise High Performance Computing LTSS 15 SP4
    zypper in -t patch SUSE-SLE-Product-HPC-15-SP4-LTSS-2024-2971=1
  • SUSE Linux Enterprise Desktop 15 SP4 LTSS 15-SP4
    zypper in -t patch SUSE-SLE-Product-SLED-15-SP4-LTSS-2024-2971=1
  • SUSE Linux Enterprise Server 15 SP2 LTSS 15-SP2
    zypper in -t patch SUSE-SLE-Product-SLES-15-SP2-LTSS-2024-2971=1
  • SUSE Linux Enterprise Server 15 SP3 LTSS 15-SP3
    zypper in -t patch SUSE-SLE-Product-SLES-15-SP3-LTSS-2024-2971=1
  • SUSE Linux Enterprise Server 15 SP4 LTSS 15-SP4
    zypper in -t patch SUSE-SLE-Product-SLES-15-SP4-LTSS-2024-2971=1
  • SUSE Linux Enterprise Server for SAP Applications 15 SP2
    zypper in -t patch SUSE-SLE-Product-SLES_SAP-15-SP2-2024-2971=1
  • SUSE Linux Enterprise Server for SAP Applications 15 SP3
    zypper in -t patch SUSE-SLE-Product-SLES_SAP-15-SP3-2024-2971=1
  • SUSE Linux Enterprise Server for SAP Applications 15 SP4
    zypper in -t patch SUSE-SLE-Product-SLES_SAP-15-SP4-2024-2971=1
  • SUSE Enterprise Storage 7.1
    zypper in -t patch SUSE-Storage-7.1-2024-2971=1

Package List:

  • openSUSE Leap 15.6 (aarch64 ppc64le s390x x86_64 i586)
    • perl-DBI-debuginfo-1.643-150600.12.3.2
    • perl-DBD-SQLite-1.740.0-150600.10.3.2
    • perl-DBD-SQLite-debuginfo-1.740.0-150600.10.3.2
    • perl-DBI-debugsource-1.643-150600.12.3.2
    • perl-DBD-Pg-3.18.0-150600.14.3.2
    • perl-DBD-Pg-debuginfo-3.18.0-150600.14.3.2
    • perl-DBI-1.643-150600.12.3.2
    • perl-DBD-SQLite-debugsource-1.740.0-150600.10.3.2
    • perl-DBD-Pg-debugsource-3.18.0-150600.14.3.2
  • openSUSE Leap 15.6 (aarch64 ppc64le s390x x86_64)
    • perl-YAML-LibYAML-0.890.0-150000.3.8.2
    • perl-YAML-LibYAML-debuginfo-0.890.0-150000.3.8.2
    • perl-YAML-LibYAML-debugsource-0.890.0-150000.3.8.2
  • openSUSE Leap 15.5 (aarch64 ppc64le s390x x86_64)
    • perl-YAML-LibYAML-0.890.0-150000.3.8.2
    • perl-YAML-LibYAML-debuginfo-0.890.0-150000.3.8.2
    • perl-YAML-LibYAML-debugsource-0.890.0-150000.3.8.2
  • Development Tools Module 15-SP5 (aarch64 ppc64le s390x x86_64)
    • perl-YAML-LibYAML-0.890.0-150000.3.8.2
    • perl-YAML-LibYAML-debuginfo-0.890.0-150000.3.8.2
    • perl-YAML-LibYAML-debugsource-0.890.0-150000.3.8.2
  • Development Tools Module 15-SP6 (aarch64 ppc64le s390x x86_64)
    • perl-YAML-LibYAML-debugsource-0.890.0-150000.3.8.2
    • perl-YAML-LibYAML-debuginfo-0.890.0-150000.3.8.2
    • perl-DBD-Pg-3.18.0-150600.14.3.2
    • perl-DBD-Pg-debuginfo-3.18.0-150600.14.3.2
    • perl-YAML-LibYAML-0.890.0-150000.3.8.2
    • perl-DBD-Pg-debugsource-3.18.0-150600.14.3.2
  • SUSE Linux Enterprise High Performance Computing 15 SP2 LTSS 15-SP2 (aarch64 x86_64)
    • perl-YAML-LibYAML-0.890.0-150000.3.8.2
    • perl-YAML-LibYAML-debuginfo-0.890.0-150000.3.8.2
    • perl-YAML-LibYAML-debugsource-0.890.0-150000.3.8.2
  • SUSE Linux Enterprise High Performance Computing LTSS 15 SP3 (aarch64 x86_64)
    • perl-YAML-LibYAML-0.890.0-150000.3.8.2
    • perl-YAML-LibYAML-debuginfo-0.890.0-150000.3.8.2
    • perl-YAML-LibYAML-debugsource-0.890.0-150000.3.8.2
  • SUSE Linux Enterprise High Performance Computing ESPOS 15 SP4 (aarch64 x86_64)
    • perl-YAML-LibYAML-0.890.0-150000.3.8.2
    • perl-YAML-LibYAML-debuginfo-0.890.0-150000.3.8.2
    • perl-YAML-LibYAML-debugsource-0.890.0-150000.3.8.2
  • SUSE Linux Enterprise High Performance Computing LTSS 15 SP4 (aarch64 x86_64)
    • perl-YAML-LibYAML-0.890.0-150000.3.8.2
    • perl-YAML-LibYAML-debuginfo-0.890.0-150000.3.8.2
    • perl-YAML-LibYAML-debugsource-0.890.0-150000.3.8.2
  • SUSE Linux Enterprise Desktop 15 SP4 LTSS 15-SP4 (x86_64)
    • perl-YAML-LibYAML-0.890.0-150000.3.8.2
    • perl-YAML-LibYAML-debuginfo-0.890.0-150000.3.8.2
    • perl-YAML-LibYAML-debugsource-0.890.0-150000.3.8.2
  • SUSE Linux Enterprise Server 15 SP2 LTSS 15-SP2 (aarch64 ppc64le s390x x86_64)
    • perl-YAML-LibYAML-0.890.0-150000.3.8.2
    • perl-YAML-LibYAML-debuginfo-0.890.0-150000.3.8.2
    • perl-YAML-LibYAML-debugsource-0.890.0-150000.3.8.2
  • SUSE Linux Enterprise Server 15 SP3 LTSS 15-SP3 (aarch64 ppc64le s390x x86_64)
    • perl-YAML-LibYAML-0.890.0-150000.3.8.2
    • perl-YAML-LibYAML-debuginfo-0.890.0-150000.3.8.2
    • perl-YAML-LibYAML-debugsource-0.890.0-150000.3.8.2
  • SUSE Linux Enterprise Server 15 SP4 LTSS 15-SP4 (aarch64 ppc64le s390x x86_64)
    • perl-YAML-LibYAML-0.890.0-150000.3.8.2
    • perl-YAML-LibYAML-debuginfo-0.890.0-150000.3.8.2
    • perl-YAML-LibYAML-debugsource-0.890.0-150000.3.8.2
  • SUSE Linux Enterprise Server for SAP Applications 15 SP2 (ppc64le x86_64)
    • perl-YAML-LibYAML-0.890.0-150000.3.8.2
    • perl-YAML-LibYAML-debuginfo-0.890.0-150000.3.8.2
    • perl-YAML-LibYAML-debugsource-0.890.0-150000.3.8.2
  • SUSE Linux Enterprise Server for SAP Applications 15 SP3 (ppc64le x86_64)
    • perl-YAML-LibYAML-0.890.0-150000.3.8.2
    • perl-YAML-LibYAML-debuginfo-0.890.0-150000.3.8.2
    • perl-YAML-LibYAML-debugsource-0.890.0-150000.3.8.2
  • SUSE Linux Enterprise Server for SAP Applications 15 SP4 (ppc64le x86_64)
    • perl-YAML-LibYAML-0.890.0-150000.3.8.2
    • perl-YAML-LibYAML-debuginfo-0.890.0-150000.3.8.2
    • perl-YAML-LibYAML-debugsource-0.890.0-150000.3.8.2
  • SUSE Enterprise Storage 7.1 (aarch64 x86_64)
    • perl-YAML-LibYAML-0.890.0-150000.3.8.2
    • perl-YAML-LibYAML-debuginfo-0.890.0-150000.3.8.2
    • perl-YAML-LibYAML-debugsource-0.890.0-150000.3.8.2