[rygel] core: Workaround bug in sqlite 3.6.12
- From: Zeeshan Ali Khattak <zeeshanak src gnome org>
- To: svn-commits-list gnome org
- Cc:
- Subject: [rygel] core: Workaround bug in sqlite 3.6.12
- Date: Sat, 24 Oct 2009 15:20:47 +0000 (UTC)
commit 1dd004d776acab0c12b1fd2131575e2419a64543
Author: Jens Georg <mail jensge org>
Date: Wed Oct 21 17:23:55 2009 +0200
core: Workaround bug in sqlite 3.6.12
Apparently select count(*) on an empty sqlite_master table triggers bug #3774.
Used another query to check if there is data in that table which won't make
sqlite 3.6.12 crash.
src/rygel/rygel-media-db.vala | 3 ++-
1 files changed, 2 insertions(+), 1 deletions(-)
---
diff --git a/src/rygel/rygel-media-db.vala b/src/rygel/rygel-media-db.vala
index 3bcec15..632bebc 100644
--- a/src/rygel/rygel-media-db.vala
+++ b/src/rygel/rygel-media-db.vala
@@ -303,7 +303,8 @@ public class Rygel.MediaDB : Object {
debug ("Could not find schema version; checking for empty database...");
try {
int rows = -1;
- this.db.exec ("SELECT count(*) FROM sqlite_master",
+ this.db.exec ("SELECT count(type) FROM sqlite_master " +
+ "WHERE rowid=1",
null,
(stmt) => {
rows = stmt.column_int (0);
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]