| OLD | NEW |
| 1 # 2006 January 31 | 1 # 2006 January 31 |
| 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 325 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
| 336 AND LENGTH(bbb.title) > 0 | 336 AND LENGTH(bbb.title) > 0 |
| 337 AND bbb.parent = 4 | 337 AND bbb.parent = 4 |
| 338 ORDER BY bbb.title COLLATE NOCASE ASC; | 338 ORDER BY bbb.title COLLATE NOCASE ASC; |
| 339 } { | 339 } { |
| 340 0 0 1 {SEARCH TABLE aaa USING INDEX aaa_333 (fk=?) (~10 rows)} | 340 0 0 1 {SEARCH TABLE aaa USING INDEX aaa_333 (fk=?) (~10 rows)} |
| 341 0 1 0 {SEARCH TABLE aaa AS bbb USING INTEGER PRIMARY KEY (rowid=?) (~1 rows)} | 341 0 1 0 {SEARCH TABLE aaa AS bbb USING INTEGER PRIMARY KEY (rowid=?) (~1 rows)} |
| 342 0 0 0 {USE TEMP B-TREE FOR ORDER BY} | 342 0 0 0 {USE TEMP B-TREE FOR ORDER BY} |
| 343 } | 343 } |
| 344 | 344 |
| 345 finish_test | 345 finish_test |
| OLD | NEW |