<div class="container">
<h1>Recommended update for perl-DBD-Pg, perl-DBD-SQLite, perl-DBI, perl-YAML-LibYAML</h1>
<table class="table table-striped table-bordered">
<tbody>
<tr>
<th>Announcement ID:</th>
<td>SUSE-RU-2024:2971-1</td>
</tr>
<tr>
<th>Rating:</th>
<td>moderate</td>
</tr>
<tr>
<th>References:</th>
<td>
<ul>
</ul>
</td>
</tr>
<tr>
<th>Affected Products:</th>
<td>
<ul class="list-group">
<li class="list-group-item">Development Tools Module 15-SP5</li>
<li class="list-group-item">Development Tools Module 15-SP6</li>
<li class="list-group-item">openSUSE Leap 15.5</li>
<li class="list-group-item">openSUSE Leap 15.6</li>
<li class="list-group-item">SUSE Enterprise Storage 7.1</li>
<li class="list-group-item">SUSE Linux Enterprise Desktop 15 SP4 LTSS 15-SP4</li>
<li class="list-group-item">SUSE Linux Enterprise Desktop 15 SP5</li>
<li class="list-group-item">SUSE Linux Enterprise Desktop 15 SP6</li>
<li class="list-group-item">SUSE Linux Enterprise High Performance Computing 15 SP2</li>
<li class="list-group-item">SUSE Linux Enterprise High Performance Computing 15 SP2 LTSS 15-SP2</li>
<li class="list-group-item">SUSE Linux Enterprise High Performance Computing 15 SP3</li>
<li class="list-group-item">SUSE Linux Enterprise High Performance Computing 15 SP4</li>
<li class="list-group-item">SUSE Linux Enterprise High Performance Computing 15 SP5</li>
<li class="list-group-item">SUSE Linux Enterprise High Performance Computing ESPOS 15 SP4</li>
<li class="list-group-item">SUSE Linux Enterprise High Performance Computing LTSS 15 SP3</li>
<li class="list-group-item">SUSE Linux Enterprise High Performance Computing LTSS 15 SP4</li>
<li class="list-group-item">SUSE Linux Enterprise Real Time 15 SP5</li>
<li class="list-group-item">SUSE Linux Enterprise Real Time 15 SP6</li>
<li class="list-group-item">SUSE Linux Enterprise Server 15 SP2</li>
<li class="list-group-item">SUSE Linux Enterprise Server 15 SP2 LTSS 15-SP2</li>
<li class="list-group-item">SUSE Linux Enterprise Server 15 SP3</li>
<li class="list-group-item">SUSE Linux Enterprise Server 15 SP3 LTSS 15-SP3</li>
<li class="list-group-item">SUSE Linux Enterprise Server 15 SP4</li>
<li class="list-group-item">SUSE Linux Enterprise Server 15 SP4 LTSS 15-SP4</li>
<li class="list-group-item">SUSE Linux Enterprise Server 15 SP5</li>
<li class="list-group-item">SUSE Linux Enterprise Server 15 SP6</li>
<li class="list-group-item">SUSE Linux Enterprise Server for SAP Applications 15 SP2</li>
<li class="list-group-item">SUSE Linux Enterprise Server for SAP Applications 15 SP3</li>
<li class="list-group-item">SUSE Linux Enterprise Server for SAP Applications 15 SP4</li>
<li class="list-group-item">SUSE Linux Enterprise Server for SAP Applications 15 SP5</li>
<li class="list-group-item">SUSE Linux Enterprise Server for SAP Applications 15 SP6</li>
</ul>
</td>
</tr>
</tbody>
</table>
<p>An update that can now be installed.</p>
<h2>Description:</h2>
<p>This update for perl-DBD-Pg, perl-DBD-SQLite, perl-DBI, perl-YAML-LibYAML fixes the following issues:</p>
<p>perl-DBI was updated from version 1.642 to 1.643:</p>
<ul>
<li>Updated Devel::PPPort and removed redundant compatibility macros </li>
<li>Correct minor typo in documentation</li>
<li>Correct documentation introducing $dbh->selectall_array()</li>
<li>Introduced select and do wrappers earlier in the documentation</li>
<li>Mark as deprecated old API functions which overflow or are affected by Unicode issues</li>
<li>Add new attribute RaiseWarn, similar to RaiseError</li>
</ul>
<p>perl-DBD-SQLite was updated from version 1.66 to 1.74:</p>
<ul>
<li>Fixed disabling of __perllib_provides</li>
<li>Upgraded SQLite to 3.42.0</li>
<li>Added missing possible table_type values to POD</li>
<li>Set UTF8CACHE to avoid slowdown with -DDEBUGGING</li>
<li>Lowercase datatype in table column metadata for back-compatibility</li>
<li>Fixed test failure on perl built with -DDEBUGGING</li>
<li>Improve sqlite_load_extension documentation</li>
<li>Add a feature to unregister a created function</li>
<li>Fixed accented characters in POD</li>
<li>Link embedded sqlite devel files to system files</li>
<li>Use the system sqlite rather than the built-in one</li>
<li>Fixed documentation to use the correct attribute with sqlite_</li>
<li>Modify the fix to silence the sqlite_unicode warning not to check the attribute twice</li>
<li>Fix an encoding issue of naive</li>
<li>Made DBD_SQLITE_STRING_MODE constants exportable</li>
<li>Stop setting THREADSAFE=0 if perl has pthread (ie. 5.20+)</li>
<li>Fixed a memory leak in ::VirtualTable</li>
<li>Introduced "string_mode" handle attribute to fix long-standing issues of sqlite_unicode</li>
<li>Added a dependency from dbdimp.o to the *.inc files included into dbdimp.c</li>
<li>Fixed an offset issue of VirtualTable</li>
<li>Fixed quadmath issues</li>
<li>Added sqlite_txn_state method to see internal state of the backend</li>
<li>Switched to XSLoader</li>
<li>Use quadmath_snprintf if USE_QUADMATH is defined</li>
<li>Use av_fetch instead of av_shift</li>
</ul>
<p>perl-DBD-Pg was update from version 3.10.4 to 3.18.0:</p>
<ul>
<li>Support new PQclosePrepared function, added in Postgres 17</li>
<li>Improved documentation about ping always returning a value</li>
<li>New database handle attribute pg_skip_deallocate
Prevents any deallocation of automatically prepared
statements to support new pgBouncer feature</li>
<li>Fix to handle escaped quotes in connection string</li>
<li>Return number of affected rows from a MERGE command</li>
<li>Added support for Github CI actions</li>
<li>Removed undocumented internal-only pg_pid_number attribute</li>
<li>Small warning in docs about PG_CHAR</li>
<li>Added new attribute "pg_int8_as_string", for backwards compatibility.</li>
<li>Added a META.json file; rename META.yml to META.yaml</li>
<li>Fix 03smethod.t $sth->last_insert_id skip count for DBI < 1.642</li>
<li>Documentation improvements for service files</li>
<li>Automatically use 64-bit versions of large object functions when available</li>
<li>Set UTF8 flag as needed for error messages</li>
<li>In tests, do not assume what the default transaction isolation level will be</li>
<li>Make tests smarter about detecting pg_ctl results in different locales</li>
<li>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.</li>
<li>Correctly pull back pg_async status from statement handle.
Previously, $dbh->{pg_async} would return undef.</li>
<li>Remove the experimental 'fulltest' Makefile target.</li>
<li>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.</li>
<li>The $dbh->tables method will always return a list, even if it is empty.</li>
<li>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.</li>
<li>Allow test to run again when using a non-superuser to connect</li>
<li>Adjust tests to force loading proper version of DBD::Pg every time.</li>
<li>Removed the long-deprecated _pg_use_catalog method.</li>
<li>Many improvements and changes to the test suite.</li>
<li>Redo the "last_result" internals in dbdimp.c, which fixes a memory leak.</li>
<li>Fixed regression in Perl length() for returned query results</li>
<li>Make $sth->finish() do a little less. Notably, even
after calling finish(), pg_error_field will still work
on the last action performed.</li>
<li>Tweak tests so Windows boxes pass</li>
<li>Run tests in verbose mode</li>
<li>Prevent DBI from flipping AutoCommit to 'on' after a failed commit</li>
<li>Revert overly aggressive testing shortcut as it can cause installs to fail</li>
<li>Return the table info row last in statistics_info.
This fixes statistics_info on pre-8.3 servers.</li>
<li>Fixed ASC_OR_DESC field in statistics_info</li>
<li>Indicate NULL ordering in statistics_info</li>
<li>Adjust Makefile to fix failing 'fulltest' target on BSD systems</li>
<li>Indicate non-key index columns (INCLUDE) in statistics_info</li>
<li>Return an empty result set instead of undef from statistics_info
when the requested table doesn't exist and $unique_only is false.</li>
<li>Fixed segfault during st destroy</li>
<li>Improved testing for table_info()</li>
<li>Improved UTF-8 wording in documentaion</li>
</ul>
<p>perl-YAML-LibYAML was updated to version 0.89:</p>
<ul>
<li>Breaking Change: Set $YAML::XS::LoadBlessed default to false to make it more secure</li>
<li>Fixed disabling of __perllib_provides</li>
<li>Recognise core booleans on Perl 5.36+ at dump time</li>
<li>Fixed YAML::XS pod in cpanminus</li>
<li>Convert doc from Swim to Markdown</li>
<li>Added option ForbidDuplicateKeys</li>
<li>Recognize tied variables</li>
<li>Updated libyaml sources to 0.2.4. Changes affecting YAML::XS are</li>
<li>Output '...' at the stream end after a block scalar with trailing empty lines</li>
<li>Accept '%YAML 1.2' directives (they are ignored and do not change behaviour though)</li>
<li>Fix memory leak when loading invalid YAML</li>
<li>Support aliasing scalars resolved as null or booleans</li>
<li>Add YAML::XS::LibYAML::libyaml_version()</li>
<li>Support standard !!int/!!float tags instead of dying</li>
<li>Fixed double free/core dump when Dump()ing binary data</li>
<li>Update config.h from libyaml</li>
<li>Update libyaml to version 0.2.2. Most important change for users is that plain
urls in flow style can be parsed now. Example: <code>[ http://yaml.org]</code>.</li>
<li>Added $Indent - number of spaces when dumping</li>
<li>Implemented $LoadCode</li>
<li>Update to libyaml 0.2.1. It's forbidden now to escape single quotes inside double quotes</li>
<li>When disabling $LoadBlessed, return scalars not refs</li>
<li>Save anchors also for blessed scalars</li>
<li>Fixed format specifier/argument mismatch</li>
<li>Fixed a C90-compatibility issue</li>
<li>Prevent warning about unused variables</li>
</ul>
<h2>Patch Instructions:</h2>
<p>
To install this SUSE update use the SUSE recommended
installation methods like YaST online_update or "zypper patch".<br/>
Alternatively you can run the command listed for your product:
</p>
<ul class="list-group">
<li class="list-group-item">
openSUSE Leap 15.6
<br/>
<code>zypper in -t patch SUSE-2024-2971=1 openSUSE-SLE-15.6-2024-2971=1</code>
</li>
<li class="list-group-item">
openSUSE Leap 15.5
<br/>
<code>zypper in -t patch openSUSE-SLE-15.5-2024-2971=1</code>
</li>
<li class="list-group-item">
Development Tools Module 15-SP5
<br/>
<code>zypper in -t patch SUSE-SLE-Module-Development-Tools-15-SP5-2024-2971=1</code>
</li>
<li class="list-group-item">
Development Tools Module 15-SP6
<br/>
<code>zypper in -t patch SUSE-SLE-Module-Development-Tools-15-SP6-2024-2971=1</code>
</li>
<li class="list-group-item">
SUSE Linux Enterprise High Performance Computing 15 SP2 LTSS 15-SP2
<br/>
<code>zypper in -t patch SUSE-SLE-Product-HPC-15-SP2-LTSS-2024-2971=1</code>
</li>
<li class="list-group-item">
SUSE Linux Enterprise High Performance Computing LTSS 15 SP3
<br/>
<code>zypper in -t patch SUSE-SLE-Product-HPC-15-SP3-LTSS-2024-2971=1</code>
</li>
<li class="list-group-item">
SUSE Linux Enterprise High Performance Computing ESPOS 15 SP4
<br/>
<code>zypper in -t patch SUSE-SLE-Product-HPC-15-SP4-ESPOS-2024-2971=1</code>
</li>
<li class="list-group-item">
SUSE Linux Enterprise High Performance Computing LTSS 15 SP4
<br/>
<code>zypper in -t patch SUSE-SLE-Product-HPC-15-SP4-LTSS-2024-2971=1</code>
</li>
<li class="list-group-item">
SUSE Linux Enterprise Desktop 15 SP4 LTSS 15-SP4
<br/>
<code>zypper in -t patch SUSE-SLE-Product-SLED-15-SP4-LTSS-2024-2971=1</code>
</li>
<li class="list-group-item">
SUSE Linux Enterprise Server 15 SP2 LTSS 15-SP2
<br/>
<code>zypper in -t patch SUSE-SLE-Product-SLES-15-SP2-LTSS-2024-2971=1</code>
</li>
<li class="list-group-item">
SUSE Linux Enterprise Server 15 SP3 LTSS 15-SP3
<br/>
<code>zypper in -t patch SUSE-SLE-Product-SLES-15-SP3-LTSS-2024-2971=1</code>
</li>
<li class="list-group-item">
SUSE Linux Enterprise Server 15 SP4 LTSS 15-SP4
<br/>
<code>zypper in -t patch SUSE-SLE-Product-SLES-15-SP4-LTSS-2024-2971=1</code>
</li>
<li class="list-group-item">
SUSE Linux Enterprise Server for SAP Applications 15 SP2
<br/>
<code>zypper in -t patch SUSE-SLE-Product-SLES_SAP-15-SP2-2024-2971=1</code>
</li>
<li class="list-group-item">
SUSE Linux Enterprise Server for SAP Applications 15 SP3
<br/>
<code>zypper in -t patch SUSE-SLE-Product-SLES_SAP-15-SP3-2024-2971=1</code>
</li>
<li class="list-group-item">
SUSE Linux Enterprise Server for SAP Applications 15 SP4
<br/>
<code>zypper in -t patch SUSE-SLE-Product-SLES_SAP-15-SP4-2024-2971=1</code>
</li>
<li class="list-group-item">
SUSE Enterprise Storage 7.1
<br/>
<code>zypper in -t patch SUSE-Storage-7.1-2024-2971=1</code>
</li>
</ul>
<h2>Package List:</h2>
<ul>
<li>
openSUSE Leap 15.6 (aarch64 ppc64le s390x x86_64 i586)
<ul>
<li>perl-DBI-debuginfo-1.643-150600.12.3.2</li>
<li>perl-DBD-SQLite-1.740.0-150600.10.3.2</li>
<li>perl-DBD-SQLite-debuginfo-1.740.0-150600.10.3.2</li>
<li>perl-DBI-debugsource-1.643-150600.12.3.2</li>
<li>perl-DBD-Pg-3.18.0-150600.14.3.2</li>
<li>perl-DBD-Pg-debuginfo-3.18.0-150600.14.3.2</li>
<li>perl-DBI-1.643-150600.12.3.2</li>
<li>perl-DBD-SQLite-debugsource-1.740.0-150600.10.3.2</li>
<li>perl-DBD-Pg-debugsource-3.18.0-150600.14.3.2</li>
</ul>
</li>
<li>
openSUSE Leap 15.6 (aarch64 ppc64le s390x x86_64)
<ul>
<li>perl-YAML-LibYAML-0.890.0-150000.3.8.2</li>
<li>perl-YAML-LibYAML-debuginfo-0.890.0-150000.3.8.2</li>
<li>perl-YAML-LibYAML-debugsource-0.890.0-150000.3.8.2</li>
</ul>
</li>
<li>
openSUSE Leap 15.5 (aarch64 ppc64le s390x x86_64)
<ul>
<li>perl-YAML-LibYAML-0.890.0-150000.3.8.2</li>
<li>perl-YAML-LibYAML-debuginfo-0.890.0-150000.3.8.2</li>
<li>perl-YAML-LibYAML-debugsource-0.890.0-150000.3.8.2</li>
</ul>
</li>
<li>
Development Tools Module 15-SP5 (aarch64 ppc64le s390x x86_64)
<ul>
<li>perl-YAML-LibYAML-0.890.0-150000.3.8.2</li>
<li>perl-YAML-LibYAML-debuginfo-0.890.0-150000.3.8.2</li>
<li>perl-YAML-LibYAML-debugsource-0.890.0-150000.3.8.2</li>
</ul>
</li>
<li>
Development Tools Module 15-SP6 (aarch64 ppc64le s390x x86_64)
<ul>
<li>perl-YAML-LibYAML-debugsource-0.890.0-150000.3.8.2</li>
<li>perl-YAML-LibYAML-debuginfo-0.890.0-150000.3.8.2</li>
<li>perl-DBD-Pg-3.18.0-150600.14.3.2</li>
<li>perl-DBD-Pg-debuginfo-3.18.0-150600.14.3.2</li>
<li>perl-YAML-LibYAML-0.890.0-150000.3.8.2</li>
<li>perl-DBD-Pg-debugsource-3.18.0-150600.14.3.2</li>
</ul>
</li>
<li>
SUSE Linux Enterprise High Performance Computing 15 SP2 LTSS 15-SP2 (aarch64 x86_64)
<ul>
<li>perl-YAML-LibYAML-0.890.0-150000.3.8.2</li>
<li>perl-YAML-LibYAML-debuginfo-0.890.0-150000.3.8.2</li>
<li>perl-YAML-LibYAML-debugsource-0.890.0-150000.3.8.2</li>
</ul>
</li>
<li>
SUSE Linux Enterprise High Performance Computing LTSS 15 SP3 (aarch64 x86_64)
<ul>
<li>perl-YAML-LibYAML-0.890.0-150000.3.8.2</li>
<li>perl-YAML-LibYAML-debuginfo-0.890.0-150000.3.8.2</li>
<li>perl-YAML-LibYAML-debugsource-0.890.0-150000.3.8.2</li>
</ul>
</li>
<li>
SUSE Linux Enterprise High Performance Computing ESPOS 15 SP4 (aarch64 x86_64)
<ul>
<li>perl-YAML-LibYAML-0.890.0-150000.3.8.2</li>
<li>perl-YAML-LibYAML-debuginfo-0.890.0-150000.3.8.2</li>
<li>perl-YAML-LibYAML-debugsource-0.890.0-150000.3.8.2</li>
</ul>
</li>
<li>
SUSE Linux Enterprise High Performance Computing LTSS 15 SP4 (aarch64 x86_64)
<ul>
<li>perl-YAML-LibYAML-0.890.0-150000.3.8.2</li>
<li>perl-YAML-LibYAML-debuginfo-0.890.0-150000.3.8.2</li>
<li>perl-YAML-LibYAML-debugsource-0.890.0-150000.3.8.2</li>
</ul>
</li>
<li>
SUSE Linux Enterprise Desktop 15 SP4 LTSS 15-SP4 (x86_64)
<ul>
<li>perl-YAML-LibYAML-0.890.0-150000.3.8.2</li>
<li>perl-YAML-LibYAML-debuginfo-0.890.0-150000.3.8.2</li>
<li>perl-YAML-LibYAML-debugsource-0.890.0-150000.3.8.2</li>
</ul>
</li>
<li>
SUSE Linux Enterprise Server 15 SP2 LTSS 15-SP2 (aarch64 ppc64le s390x x86_64)
<ul>
<li>perl-YAML-LibYAML-0.890.0-150000.3.8.2</li>
<li>perl-YAML-LibYAML-debuginfo-0.890.0-150000.3.8.2</li>
<li>perl-YAML-LibYAML-debugsource-0.890.0-150000.3.8.2</li>
</ul>
</li>
<li>
SUSE Linux Enterprise Server 15 SP3 LTSS 15-SP3 (aarch64 ppc64le s390x x86_64)
<ul>
<li>perl-YAML-LibYAML-0.890.0-150000.3.8.2</li>
<li>perl-YAML-LibYAML-debuginfo-0.890.0-150000.3.8.2</li>
<li>perl-YAML-LibYAML-debugsource-0.890.0-150000.3.8.2</li>
</ul>
</li>
<li>
SUSE Linux Enterprise Server 15 SP4 LTSS 15-SP4 (aarch64 ppc64le s390x x86_64)
<ul>
<li>perl-YAML-LibYAML-0.890.0-150000.3.8.2</li>
<li>perl-YAML-LibYAML-debuginfo-0.890.0-150000.3.8.2</li>
<li>perl-YAML-LibYAML-debugsource-0.890.0-150000.3.8.2</li>
</ul>
</li>
<li>
SUSE Linux Enterprise Server for SAP Applications 15 SP2 (ppc64le x86_64)
<ul>
<li>perl-YAML-LibYAML-0.890.0-150000.3.8.2</li>
<li>perl-YAML-LibYAML-debuginfo-0.890.0-150000.3.8.2</li>
<li>perl-YAML-LibYAML-debugsource-0.890.0-150000.3.8.2</li>
</ul>
</li>
<li>
SUSE Linux Enterprise Server for SAP Applications 15 SP3 (ppc64le x86_64)
<ul>
<li>perl-YAML-LibYAML-0.890.0-150000.3.8.2</li>
<li>perl-YAML-LibYAML-debuginfo-0.890.0-150000.3.8.2</li>
<li>perl-YAML-LibYAML-debugsource-0.890.0-150000.3.8.2</li>
</ul>
</li>
<li>
SUSE Linux Enterprise Server for SAP Applications 15 SP4 (ppc64le x86_64)
<ul>
<li>perl-YAML-LibYAML-0.890.0-150000.3.8.2</li>
<li>perl-YAML-LibYAML-debuginfo-0.890.0-150000.3.8.2</li>
<li>perl-YAML-LibYAML-debugsource-0.890.0-150000.3.8.2</li>
</ul>
</li>
<li>
SUSE Enterprise Storage 7.1 (aarch64 x86_64)
<ul>
<li>perl-YAML-LibYAML-0.890.0-150000.3.8.2</li>
<li>perl-YAML-LibYAML-debuginfo-0.890.0-150000.3.8.2</li>
<li>perl-YAML-LibYAML-debugsource-0.890.0-150000.3.8.2</li>
</ul>
</li>
</ul>
</div>