| OLD | NEW |
| 1 # 2010 April 07 | 1 # 2010 April 07 |
| 2 # | 2 # |
| 3 # The author disclaims copyright to this source code. In place of | 3 # The author disclaims copyright to this source code. In place of |
| 4 # a legal notice, here is a blessing: | 4 # a legal notice, here is a blessing: |
| 5 # | 5 # |
| 6 # May you do good and not evil. | 6 # May you do good and not evil. |
| 7 # May you find forgiveness for yourself and forgive others. | 7 # May you find forgiveness for yourself and forgive others. |
| 8 # May you share freely, never taking more than you give. | 8 # May you share freely, never taking more than you give. |
| 9 # | 9 # |
| 10 #************************************************************************* | 10 #************************************************************************* |
| (...skipping 231 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
| 242 } { | 242 } { |
| 243 1 0 0 {SCAN TABLE sheep AS s (~1000000 rows)} | 243 1 0 0 {SCAN TABLE sheep AS s (~1000000 rows)} |
| 244 1 1 1 {SEARCH TABLE flock_owner AS prev USING INDEX sqlite_autoindex_flock_own
er_1 (flock_no=? AND owner_change_date<?) (~2 rows)} | 244 1 1 1 {SEARCH TABLE flock_owner AS prev USING INDEX sqlite_autoindex_flock_own
er_1 (flock_no=? AND owner_change_date<?) (~2 rows)} |
| 245 1 0 0 {EXECUTE CORRELATED SCALAR SUBQUERY 2} | 245 1 0 0 {EXECUTE CORRELATED SCALAR SUBQUERY 2} |
| 246 2 0 0 {SEARCH TABLE flock_owner AS later USING COVERING INDEX sqlite_autoindex
_flock_owner_1 (flock_no=? AND owner_change_date>? AND owner_change_date<?) (~1
rows)} | 246 2 0 0 {SEARCH TABLE flock_owner AS later USING COVERING INDEX sqlite_autoindex
_flock_owner_1 (flock_no=? AND owner_change_date>? AND owner_change_date<?) (~1
rows)} |
| 247 0 0 0 {SCAN TABLE sheep AS x USING INDEX sheep_reg_flock_index (~1000000 rows)
} | 247 0 0 0 {SCAN TABLE sheep AS x USING INDEX sheep_reg_flock_index (~1000000 rows)
} |
| 248 0 1 1 {SEARCH SUBQUERY 1 AS y USING AUTOMATIC COVERING INDEX (sheep_no=?) (~8
rows)} | 248 0 1 1 {SEARCH SUBQUERY 1 AS y USING AUTOMATIC COVERING INDEX (sheep_no=?) (~8
rows)} |
| 249 } | 249 } |
| 250 | 250 |
| 251 finish_test | 251 finish_test |
| OLD | NEW |