Bug 1887106

Summary:	RFE: enable FTS4
Product:	[Fedora] Fedora	Reporter:	Sheng Mao <shngmao>
Component:	sqlite	Assignee:	Ondrej Dubaj <odubaj>
Status:	CLOSED ERRATA	QA Contact:	Fedora Extras Quality Assurance <extras-qa>
Severity:	medium	Docs Contact:
Priority:	unspecified
Version:	rawhide	CC:	itamar, odubaj, pkubat, wilmer5
Target Milestone:	---
Target Release:	---
Hardware:	All
OS:	Linux
Whiteboard:
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:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2020-10-19 16:57:26 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

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.