Bugzilla – Bug 1218946
DBD::SQLite is compiled with older version of SQLite than standalone SQLite
Last modified: 2024-06-03 16:30:12 UTC
As of today I have installed perl-DBD-SQLite-1.66-150300.3.6.1.x86_64 that was compiled using SQLite 3.32.3, but when installing sqlite3 or sqlite3-doc I would get 3.44.0-150000.3.23.1. There are several problems with this approach: 1) When reading the documentation of SQLite, some features described may not be available via the DBD::SQLite interface. 2) A database created using the sqlite3 standalone-command might be incompatible with a program using DBD::SQLite to access the database. Actually I had discovered the issue for an older version of Leap where I got a syntax error for a command that worked flawlessly when being entered interactively in sqlite3. As a developer may try commands interactively before adding them to a program, it is important that both interactive tools and DB interfaces are compatible. Command to get the version of SQLite used to compile DBD::SQLite: perl -MDBD::SQLite -le'print $DBD::SQLite::sqlite_version'
(In reply to Ulrich Windl from comment #0) > As of today I have installed perl-DBD-SQLite-1.66-150300.3.6.1.x86_64 that > was compiled using SQLite 3.32.3, but when installing sqlite3 or sqlite3-doc > I would get 3.44.0-150000.3.23.1. > > There are several problems with this approach: > 1) When reading the documentation of SQLite, some features described may not > be available via the DBD::SQLite interface. > 2) A database created using the sqlite3 standalone-command might be > incompatible with a program using DBD::SQLite to access the database. > > Actually I had discovered the issue for an older version of Leap where I got > a syntax error for a command that worked flawlessly when being entered > interactively in sqlite3. As a developer may try commands interactively > before adding them to a program, it is important that both interactive tools > and DB interfaces are compatible. > > Command to get the version of SQLite used to compile DBD::SQLite: > perl -MDBD::SQLite -le'print $DBD::SQLite::sqlite_version' Thanks for the bug report. That is something that should already be fixed following this older bug reports: https://bugzilla.suse.com/show_bug.cgi?id=1195771#c5 I suspect bundled sqlite.c file interfere during the compilation even if we choose to compile with the system libraries from leap 15.3. In that way, also in Tumbleweed, we don't get the same sqlite version from sqlite3 package to the perl module package.
SUSE-SU-2024:1086-1: An update that has one security fix can now be installed. Category: security (moderate) Bug References: 1218946 Maintenance Incident: [SUSE:Maintenance:32928](https://smelt.suse.de/incident/32928/) Sources used: openSUSE Leap 15.3 (src): perl-DBD-SQLite-1.66-150300.3.9.1 openSUSE Leap 15.5 (src): perl-DBD-SQLite-1.66-150300.3.9.1 Basesystem Module 15-SP5 (src): perl-DBD-SQLite-1.66-150300.3.9.1 NOTE: This line indicates an update has been released for the listed product(s). At times this might be only a partial fix. If you have questions please reach out to maintenance coordination.
Update of this bug report: A maintenance has been started that will bring a fix to this wrong SQLite version given by the perl module, internally. Leap would be patched afterwards. More information about the fix on Factory side: https://build.opensuse.org/package/rdiff/openSUSE:Factory/perl-DBD-SQLite?linkrev=base&rev=53
SUSE-RU-2024:1914-1: An update that has one fix can now be installed. Category: recommended (moderate) Bug References: 1218946 Maintenance Incident: [SUSE:Maintenance:34055](https://smelt.suse.de/incident/34055/) Sources used: openSUSE Leap 15.3 (src): perl-DBD-SQLite-1.66-150300.3.12.1 openSUSE Leap 15.5 (src): perl-DBD-SQLite-1.66-150300.3.12.1 openSUSE Leap 15.6 (src): perl-DBD-SQLite-1.66-150300.3.12.1 Basesystem Module 15-SP5 (src): perl-DBD-SQLite-1.66-150300.3.12.1 Basesystem Module 15-SP6 (src): perl-DBD-SQLite-1.66-150300.3.12.1 SUSE Linux Enterprise High Performance Computing LTSS 15 SP3 (src): perl-DBD-SQLite-1.66-150300.3.12.1 SUSE Linux Enterprise High Performance Computing ESPOS 15 SP4 (src): perl-DBD-SQLite-1.66-150300.3.12.1 SUSE Linux Enterprise High Performance Computing LTSS 15 SP4 (src): perl-DBD-SQLite-1.66-150300.3.12.1 SUSE Linux Enterprise Desktop 15 SP4 LTSS 15-SP4 (src): perl-DBD-SQLite-1.66-150300.3.12.1 SUSE Linux Enterprise Server 15 SP3 LTSS 15-SP3 (src): perl-DBD-SQLite-1.66-150300.3.12.1 SUSE Linux Enterprise Server 15 SP4 LTSS 15-SP4 (src): perl-DBD-SQLite-1.66-150300.3.12.1 SUSE Linux Enterprise Server for SAP Applications 15 SP3 (src): perl-DBD-SQLite-1.66-150300.3.12.1 SUSE Linux Enterprise Server for SAP Applications 15 SP4 (src): perl-DBD-SQLite-1.66-150300.3.12.1 SUSE Manager Proxy 4.3 (src): perl-DBD-SQLite-1.66-150300.3.12.1 SUSE Manager Retail Branch Server 4.3 (src): perl-DBD-SQLite-1.66-150300.3.12.1 SUSE Manager Server 4.3 (src): perl-DBD-SQLite-1.66-150300.3.12.1 SUSE Enterprise Storage 7.1 (src): perl-DBD-SQLite-1.66-150300.3.12.1 NOTE: This line indicates an update has been released for the listed product(s). At times this might be only a partial fix. If you have questions please reach out to maintenance coordination.