Bug 1232301

Summary:	[RFE] enable SQLITE_ENABLE_FTS3_PARENTHESIS extension
Product:	[Fedora] Fedora	Reporter:	Jitka Plesnikova <jplesnik>
Component:	sqlite	Assignee:	Jan Staněk <jstanek>
Status:	CLOSED CURRENTRELEASE	QA Contact:	Fedora Extras Quality Assurance <extras-qa>
Severity:	unspecified	Docs Contact:
Priority:	unspecified
Version:	rawhide	CC:	jstanek, puntogil, wilmer5
Target Milestone:	---
Target Release:	---
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2016-01-22 12:36:22 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:
Bug Depends On:
Bug Blocks:	1230982, 1234356

Description Jitka Plesnikova 2015-06-16 12:58:39 UTC

sqlite is currently compiled with SQLITE_ENABLE_FTS3_PARENTHESIS disabled. 

SQLITE_ENABLE_FTS3_PARENTHESIS macro is used to enable the enhanced query syntax
More details: https://sqlite.org/fts3.html#section_3_1

sqlite built with SQLITE_ENABLE_FTS3_PARENTHESIS is required for the latest version of perl-DBD-SQLite 0.48

It can be fixed be using by its own private copy of sqlite, but it would be much better if it would be able to use the system sqlite, so please consider building the system sqlite withS QLITE_ENABLE_FTS3_PARENTHESI enabled.

To enable it, add -DSQLITE_ENABLE_FTS3_PARENTHESIS=1 to CFLAGS.

Thanks

Comment 1 Jan Staněk 2015-06-19 10:52:38 UTC

Hi,
the sqlite package in rawhide should now be built with the extension enabled.
Packages for the branched Fedoras are currently being built.

Comment 2 gil cattaneo 2015-10-18 20:22:13 UTC

Hi
Could be possible enable other extensions as defined here 
https://github.com/xerial/sqlite-jdbc/blob/28882dd0ecbdf4af20c146a2f9c3a96096b99e6f/Makefile#L57 ?

regards

Comment 3 Jan Staněk 2016-01-22 12:36:22 UTC

Hi Gil,
if these extensions are still relevant for you, please file a separate bug listing those you need.

As the FTS3_PARENTHESIS extension is now enabled even in branched Fedoras, I'm closing this bug as CURRENTRELEASE.