Bug 1034714
| Summary: | Regression in 3.8.1 causes breakage in Tracker's SPARQL queries | ||
|---|---|---|---|
| Product: | [Fedora] Fedora | Reporter: | Debarshi Ray <debarshir> |
| Component: | sqlite | Assignee: | Jan Staněk <jstanek> |
| Status: | CLOSED ERRATA | QA Contact: | Fedora Extras Quality Assurance <extras-qa> |
| Severity: | unspecified | Docs Contact: | |
| Priority: | unspecified | ||
| Version: | 20 | CC: | awilliam, debarshir, johannbg, jstanek, kevin, mruckman, robatino, wilmer5 |
| Target Milestone: | --- | ||
| Target Release: | --- | ||
| Hardware: | Unspecified | ||
| OS: | Unspecified | ||
| Whiteboard: | AcceptedBlocker | ||
| Fixed In Version: | sqlite-3.8.1-2.fc20 | Doc Type: | Bug Fix |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2013-11-29 13:54:34 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: | 980656 | ||
|
Description
Debarshi Ray
2013-11-26 11:47:44 UTC
After some back and forth on the sqlite Git mirror [1] I found that it has been fixed in master. Particularly this commit appears to fix it:
commit c098d918e1e19088be9659c409f1a6fa32b0efe6
Author: D. Richard Hipp <drh>
Date: Mon Oct 28 20:15:56 2013 +0000
Do not use transitive WHERE-clause constraints on LEFT JOINs.
Fix for ticket [c620261b5b5dc].
I am going to build a Fedora package with this commit cherry-picked and if it does not break anything we can hopefully push it to stable.
[1] http://repo.or.cz/w/sqlite.git
sqlite-3.8.1-2.fc20 has been submitted as an update for Fedora 20. https://admin.fedoraproject.org/updates/sqlite-3.8.1-2.fc20 Proposing as a final FE as this breaks behaviour in apps people may want to run from the live images. Proposed as a Blocker for 20-final by Fedora user rishi using the blocker tracking app because: Proposing as a blocker because it adversely affects the functionality (ie. collections) of a default application (ie. gnome-documents). Package sqlite-3.8.1-2.fc20: * should fix your issue, * was pushed to the Fedora 20 testing repository, * should be available at your local mirror within two days. Update it with: # su -c 'yum update --enablerepo=updates-testing sqlite-3.8.1-2.fc20' as soon as you are able to. Please go to the following url: https://admin.fedoraproject.org/updates/FEDORA-2013-22183/sqlite-3.8.1-2.fc20 then log in and leave karma (feedback). +1 FE - this would be good to get into TC3. +1 FE +1 FE Setting AcceptedFreezeException with four votes, thanks. Discussed at 2013-11-27 blocker review meeting: http://meetbot.fedoraproject.org/fedora-blocker-review/2013-11-27/f20-blocker-review-3.2013-11-27-17.01.log.txt . Accepted as a blocker per criterion "All applications that can be launched using the standard graphical mechanism of a release-blocking desktop after a default installation of that desktop must start successfully and withstand a basic functionality test." - https://fedoraproject.org/wiki/Fedora_20_Final_Release_Criteria#Default_application_functionality ; the functions of Documents and Photos in question are pretty basic. Tested, with the updated sqlite and a restart of goa-daemon (it doesn't seem to autorespawn; after killing it, I had to manually launch it again...), Photos works great. sqlite-3.8.1-2.fc20 has been pushed to the Fedora 20 stable repository. If problems still persist, please make note of it in this bug report. |