Bug 32516 - sqlite3 is built without ICU support
Summary: sqlite3 is built without ICU support
Status: NEW
Alias: None
Product: Mageia
Classification: Unclassified
Component: RPM Packages (show other bugs)
Version: 9
Hardware: All Linux
Priority: Normal major
Target Milestone: ---
Assignee: Thierry Vignaud
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-11-13 20:56 CET by Oleg Bosis
Modified: 2024-03-16 02:21 CET (History)
3 users (show)

See Also:
Source RPM: sqlite3-3.40.1-1.mga9.src.rpm
CVE:
Status comment:


Attachments

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

Note You need to log in before you can comment on or make changes to this bug.