Changes between Initial Version and Version 1 of Ticket #12915, comment 6


Ignore:
Timestamp:
Oct 27, 2016, 4:20:13 AM (7 years ago)
Author:
Jun Omae
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #12915, comment 6

    initial v1  
    5757                 'summary': row[1],
    5858}}}
     59
     60Typing `77`, the following query is generated.
     61{{{
     62sqlite> EXPLAIN QUERY PLAN
     63   ...> SELECT id, summary FROM ticket
     64   ...> WHERE id>=77 AND id<78 OR id>=770 AND id<780 OR id>=7700 AND id<7800 OR id>=77000 AND id<78000 OR id>=770000 AND id<780000 OR id>=7700000 AND id<7800000 OR id>=77000000 AND id<78000000 OR id>=770000000 AND id<780000000
     65   ...> ORDER BY changetime DESC
     66   ...> LIMIT 10;
     670|0|0|SEARCH TABLE ticket USING INTEGER PRIMARY KEY (rowid>? AND rowid<?)
     680|0|0|SEARCH TABLE ticket USING INTEGER PRIMARY KEY (rowid>? AND rowid<?)
     690|0|0|SEARCH TABLE ticket USING INTEGER PRIMARY KEY (rowid>? AND rowid<?)
     700|0|0|SEARCH TABLE ticket USING INTEGER PRIMARY KEY (rowid>? AND rowid<?)
     710|0|0|SEARCH TABLE ticket USING INTEGER PRIMARY KEY (rowid>? AND rowid<?)
     720|0|0|SEARCH TABLE ticket USING INTEGER PRIMARY KEY (rowid>? AND rowid<?)
     730|0|0|SEARCH TABLE ticket USING INTEGER PRIMARY KEY (rowid>? AND rowid<?)
     740|0|0|SEARCH TABLE ticket USING INTEGER PRIMARY KEY (rowid>? AND rowid<?)
     750|0|0|USE TEMP B-TREE FOR ORDER BY
     76}}}