[rygel] core: Workaround bug in sqlite 3.6.12



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]