Bug 32516

Summary:	sqlite3 is built without ICU support
Product:	Mageia	Reporter:	Oleg Bosis <olelukoie>
Component:	RPM Packages	Assignee:	Thierry Vignaud <thierry.vignaud>
Status:	NEW ---	QA Contact:
Severity:	major
Priority:	Normal	CC:	bugsquad, nicolas.salguero, smelror
Version:	9
Target Milestone:	---
Hardware:	All
OS:	Linux
Whiteboard:
Source RPM:	sqlite3-3.40.1-1.mga9.src.rpm	CVE:
Status comment:

Description Oleg Bosis 2023-11-13 20:56:24 CET

Description of problem:
The same bug as in bug 16814 again. ICU support in sqlite3 is a critical feature for me so please reenable it and DO NOT DISABLE IT ANY MORE, please!

Version-Release number of selected component (if applicable):
sqlite3-3.40.1-1.mga9.src.rpm

How reproducible:
Always

Steps to Reproduce:
1. See bug 16814. There is encoding breakage in that report so use the following command to test:

sqlite> select 'ы' like 'Ы';

2.
3.

Comment 1 Lewis Smith 2023-11-13 21:36:46 CET

Thank you for the report.

That old bug *is* old: 2015, Mageia 5.
Oleg, can you say whether the support that you ask for has existed since then (Mageia 6, 7, 8), but has disappeared in Mageia 9? Looks likely:

Since 2016, sqlite3 was rebuilt many times 'for ICU' (sometimes new versions of that). Then:

Jun 9 2022:
Build w/o icu. Since rpm uses sqlite, this bloats minimal install
Ah!
That was done by tv, so assigning this bug to him; CC'ing Stig who mostly updates the package.

CC: (none) => smelror
Assignee: bugsquad => thierry.vignaud

Comment 2 Oleg Bosis 2023-11-19 09:59:50 CET

Any chance getting this problem fixed?

Comment 3 Oleg Bosis 2023-11-23 21:30:10 CET

According to change log kekepower and wally are real mainteiners of sqlite3, so add them to CC or Assignee, please...

CC: (none) => bugsquad

Comment 4 Oleg Bosis 2023-11-25 14:42:15 CET

BTW, I've made a simple test in minimal chroot:

$ rpm -qa | grep icu
icu72-data-72.1-1.mga9
lib64icu72-72.1-1.mga9
$ LC_ALL=C sudo urpme lib64icu72
Removing the following package will break your system:
  basesystem-9-0.1.mga9.x86_64
   (due to missing bootloader)

So the reason to not support ICU in sqlite3 because "this bloats minimal install" is absolutely irrelevant. ICU *is* a part of any install as an indirect dependency of grub2-common:

$ LC_ALL=C sudo rpm -e lib64icu72-72.1-1.mga9
error: Failed dependencies:
        libicuuc.so.72()(64bit) is needed by (installed) lib64harfbuzz0-7.0.1-1.mga9.x86_64
$ LC_ALL=C sudo rpm -e lib64harfbuzz0-7.0.1-1.mga9.x86_64
error: Failed dependencies:
        libharfbuzz.so.0()(64bit) is needed by (installed) lib64freetype6-2.13.0-1.mga9.x86_64
$ LC_ALL=C sudo rpm -e lib64freetype6-2.13.0-1.mga9.x86_64
error: Failed dependencies:
        libfreetype.so.6()(64bit) is needed by (installed) lib64cairo2-1.17.6-2.mga9.x86_64
        libfreetype.so.6()(64bit) is needed by (installed) lib64harfbuzz0-7.0.1-1.mga9.x86_64
        libfreetype.so.6()(64bit) is needed by (installed) lib64fontconfig1-2.14.2-1.mga9.x86_64
        libfreetype.so.6()(64bit) is needed by (installed) fontconfig-2.14.2-1.mga9.x86_64
        libfreetype.so.6()(64bit) is needed by (installed) grub2-common-2.06-28.1.mga9.x86_64

Comment 5 Oleg Bosis 2024-03-15 20:03:35 CET

I see there are many mainteiners fix and update this package both in cauldron and in mga9 The last update was made yesterday by ns80 (https://svnweb.mageia.org/packages?view=revision&revision=2049866).

But all of them ignore this bug report. What's going on? Are there any chances of getting this bug fixed?

katnatek 2024-03-16 02:20:05 CET

CC: (none) => nicolas.salguero

Comment 6 katnatek 2024-03-16 02:21:51 CET

Add to Nicolas Salguero because he send us the last security fix bug#31868