BIND 10 trac1756, updated. 3e152d6e6e5f12b178b16046813e938b5d7ad505 [1756] Add an index on (rname, rdtype) to records SQLite3 table

[BIND 10 source code commits]

The branch, trac1756 has been updated
       via  3e152d6e6e5f12b178b16046813e938b5d7ad505 (commit)
      from  a75d0d269a305aa449328439c0cf8e2deb89527e (commit)

Those revisions listed above that are new to this repository have
not appeared on any other notification email; so we list those
revisions in full, below.

- Log -----------------------------------------------------------------
commit 3e152d6e6e5f12b178b16046813e938b5d7ad505
Author: Mukund Sivaraman <muks at isc.org>
Date:   Thu Sep 20 12:23:28 2012 +0530

    [1756] Add an index on (rname, rdtype) to records SQLite3 table
    
    The dbutil upgrade tool still has to be checked if it needs an update.

-----------------------------------------------------------------------

Summary of changes:
 src/lib/datasrc/sqlite3_accessor.cc      |    1 +
 src/lib/datasrc/sqlite3_datasrc.cc       |    1 +
 src/lib/python/isc/datasrc/sqlite3_ds.py |    2 ++
 3 files changed, 4 insertions(+)

-----------------------------------------------------------------------
diff --git a/src/lib/datasrc/sqlite3_accessor.cc b/src/lib/datasrc/sqlite3_accessor.cc
index 13c9d5b..3a9aa71 100644
--- a/src/lib/datasrc/sqlite3_accessor.cc
+++ b/src/lib/datasrc/sqlite3_accessor.cc
@@ -347,6 +347,7 @@ const char* const SCHEMA_LIST[] = {
     // defining a separate index for rdtype only doesn't work either; SQLite3
     // would then create a temporary B-tree for "ORDER BY").
     "CREATE INDEX records_bytype_and_rname ON records (rdtype, rname)",
+    "CREATE INDEX records_byrname_and_rdtype ON records (rname, rdtype)",
     "CREATE TABLE nsec3 (id INTEGER PRIMARY KEY, zone_id INTEGER NOT NULL, "
         "hash TEXT NOT NULL COLLATE NOCASE, "
         "owner TEXT NOT NULL COLLATE NOCASE, "
diff --git a/src/lib/datasrc/sqlite3_datasrc.cc b/src/lib/datasrc/sqlite3_datasrc.cc
index bced1ae..0aef0a8 100644
--- a/src/lib/datasrc/sqlite3_datasrc.cc
+++ b/src/lib/datasrc/sqlite3_datasrc.cc
@@ -87,6 +87,7 @@ const char* const SCHEMA_LIST[] = {
     "CREATE INDEX records_byname ON records (name)",
     "CREATE INDEX records_byrname ON records (rname)",
     "CREATE INDEX records_bytype_and_rname ON records (rdtype, rname)",
+    "CREATE INDEX records_byrname_and_rdtype ON records (rname, rdtype)",
     "CREATE TABLE nsec3 (id INTEGER PRIMARY KEY, zone_id INTEGER NOT NULL, "
     "hash TEXT NOT NULL COLLATE NOCASE, "
     "owner TEXT NOT NULL COLLATE NOCASE, "
diff --git a/src/lib/python/isc/datasrc/sqlite3_ds.py b/src/lib/python/isc/datasrc/sqlite3_ds.py
index f9b47c0..df0c614 100644
--- a/src/lib/python/isc/datasrc/sqlite3_ds.py
+++ b/src/lib/python/isc/datasrc/sqlite3_ds.py
@@ -73,6 +73,8 @@ def create(cur):
         cur.execute("CREATE INDEX records_byrname ON records (rname)")
         cur.execute("""CREATE INDEX records_bytype_and_rname ON records
                        (rdtype, rname)""")
+        cur.execute("""CREATE INDEX records_byrname_and_rdtype ON records
+                       (rname, rdtype)""")
         cur.execute("""CREATE TABLE nsec3 (id INTEGER PRIMARY KEY,
                     zone_id INTEGER NOT NULL,
                     hash TEXT NOT NULL COLLATE NOCASE,