BIND 10 #1756: revise "ITERATE" query in sqlite3_accessor

[BIND 10 Development]

#1756: revise "ITERATE" query in sqlite3_accessor
-------------------------------------+-------------------------------------
                   Reporter:         |                 Owner:  muks
  jinmei                             |                Status:  assigned
                       Type:         |             Milestone:
  defect                             |  Sprint-20120925
                   Priority:         |            Resolution:
  medium                             |             Sensitive:  0
                  Component:  data   |           Sub-Project:  DNS
  source                             |  Estimated Difficulty:  6
                   Keywords:         |           Total Hours:  0
            Defect Severity:  N/A    |
Feature Depending on Ticket:         |
        Add Hours to Ticket:  0      |
                  Internal?:  0      |
-------------------------------------+-------------------------------------

Comment (by muks):

 I've updated the `ANY_SUB` query too as it's mentioned in the mailing
 list. Here is what happens with the new syntax:

 {{{
 sqlite> --- old:
 sqlite> explain query plan SELECT rdtype, ttl, sigtype, rdata FROM records
 WHERE zone_id=5 AND name LIKE ('%.' || 'example.org.');
 0|0|0|SCAN TABLE records (~50000 rows)
 sqlite> --- new:
 sqlite> explain query plan SELECT rdtype, ttl, sigtype, rdata FROM records
 WHERE zone_id=5 AND rname LIKE 'org.example.%';
 0|0|0|SEARCH TABLE records USING INDEX records_byrname (rname>? AND
 rname<?) (~3125 rows)
 sqlite>
 }}}

-- 
Ticket URL: <http://bind10.isc.org/ticket/1756#comment:4>
BIND 10 Development <http://bind10.isc.org>
BIND 10 Development