Bug 1887106 - RFE: enable FTS4
Summary: RFE: enable FTS4
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Fedora
Classification: Fedora
Component: sqlite
Version: rawhide
Hardware: All
OS: Linux
unspecified
medium
Target Milestone: ---
Assignee: Ondrej Dubaj
QA Contact: Fedora Extras Quality Assurance
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2020-10-10 21:13 UTC by Sheng Mao
Modified: 2020-10-26 01:05 UTC (History)
4 users (show)

Fixed In Version: sqlite-3.33.0-2.fc32 sqlite-3.33.0-2.fc33
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2020-10-19 16:57:26 UTC
Type: Bug
Embargoed:


Attachments (Terms of Use)

Description Sheng Mao 2020-10-10 21:13:47 UTC
Description of problem:

SQLite currently supports FTS3~5 as full-text search engine. Since Aug 2017, FTS5 is enabled to support tracker (bugzilla #481417).

Fossil, the source code management tool for SQLite, requires FTS4 for full-text indexing. Fedora currently ships fossil 2.8 (Feb 2019), which is compiled with system's SQLite. Since Aug 2019, fossil adds a compatibility test to ./configure to ensure FTS4 support.

I confirm with Dr. Hipp, the author of SQLite and fossil, fossil requires FTS4 if user want to use "a server with search enabled" (it is a key feature). https://fossil-scm.org/forum/forumpost/72002a9978?t=h

Due to lack of FTS4 in SQLite in Fedora, fossil package 1) cannot update to version higher than 2.8; 2) is feature-incomplete.

Version-Release number of selected component (if applicable): all versions up to 3.33.0

How reproducible:

Use sqlcompattest.c file (https://fossil-scm.org/home/file?name=src/sqlcompattest.c&ci=tip) and compile with gcc sqlcompattest.c -lsqlite3. The result shows:

> system SQLite library omits required build option -DSQLITE_ENABLE_FTS4

Thank you!

Comment 1 Ondrej Dubaj 2020-10-11 08:21:31 UTC
Hi, agree with this change, thanks for the patch. Merging to f32, f33 and rawhide.

Comment 2 Fedora Update System 2020-10-11 11:23:19 UTC
FEDORA-2020-64a10b3ee6 has been submitted as an update to Fedora 33. https://bodhi.fedoraproject.org/updates/FEDORA-2020-64a10b3ee6

Comment 3 Fedora Update System 2020-10-11 22:31:58 UTC
FEDORA-2020-64a10b3ee6 has been pushed to the Fedora 33 testing repository.
In short time you'll be able to install the update with the following command:
`sudo dnf upgrade --enablerepo=updates-testing --advisory=FEDORA-2020-64a10b3ee6`
You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2020-64a10b3ee6

See also https://fedoraproject.org/wiki/QA:Updates_Testing for more information on how to test updates.

Comment 4 Fedora Update System 2020-10-12 00:02:05 UTC
FEDORA-2020-1206341a85 has been pushed to the Fedora 32 testing repository.
In short time you'll be able to install the update with the following command:
`sudo dnf upgrade --enablerepo=updates-testing --advisory=FEDORA-2020-1206341a85`
You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2020-1206341a85

See also https://fedoraproject.org/wiki/QA:Updates_Testing for more information on how to test updates.

Comment 5 Fedora Update System 2020-10-19 16:57:26 UTC
FEDORA-2020-1206341a85 has been pushed to the Fedora 32 stable repository.
If problem still persists, please make note of it in this bug report.

Comment 6 Fedora Update System 2020-10-26 01:05:56 UTC
FEDORA-2020-64a10b3ee6 has been pushed to the Fedora 33 stable repository.
If problem still persists, please make note of it in this bug report.


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