[tracker/tracker-1.2] functions-tracker: Fix collate order
- From: Carlos Garnacho <carlosg src gnome org>
- To: commits-list gnome org
- Cc:
- Subject: [tracker/tracker-1.2] functions-tracker: Fix collate order
- Date: Tue, 19 Jan 2016 01:21:22 +0000 (UTC)
commit 38764ae59415868bbe0acad1c923cde20f2879fa
Author: Iain Lane <iain orangesquash org uk>
Date: Tue May 12 15:01:20 2015 +0100
functions-tracker: Fix collate order
Somewhere between sqlite 3.8.7 and 3.8.10.2, sqlite seemed to fix
a bug on ORDER BY SOMESTRINGFUNCTION() clauses, where it would
invariably apply the BINARY collator, despite tracker specifying
its own one.
This is something that 2 libtracker-data tests were indirectly
testing, where queries are sorted by tracker:coalesce(), these now
happen to fail because the stored results inadvertently had the wrong
order.
https://bugzilla.gnome.org/show_bug.cgi?id=749262
.../functions/functions-tracker-1.out | 2 +-
.../functions/functions-tracker-2.out | 2 +-
2 files changed, 2 insertions(+), 2 deletions(-)
---
diff --git a/tests/libtracker-data/functions/functions-tracker-1.out
b/tests/libtracker-data/functions/functions-tracker-1.out
index d8c2484..8fc886d 100644
--- a/tests/libtracker-data/functions/functions-tracker-1.out
+++ b/tests/libtracker-data/functions/functions-tracker-1.out
@@ -1,7 +1,7 @@
-"Text"
"default"
"optional"
"optional for third"
"other"
"purposes"
"testing"
+"Text"
diff --git a/tests/libtracker-data/functions/functions-tracker-2.out
b/tests/libtracker-data/functions/functions-tracker-2.out
index 9045c23..80bddb5 100644
--- a/tests/libtracker-data/functions/functions-tracker-2.out
+++ b/tests/libtracker-data/functions/functions-tracker-2.out
@@ -1,3 +1,3 @@
+"title of a film"
"Title X"
"UnitTesting"
-"title of a film"
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]