| OLD | NEW |
| 1 # 2014-06-17 | 1 # 2014-06-17 |
| 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 200 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
| 211 t1, | 211 t1, |
| 212 t2, | 212 t2, |
| 213 t3 | 213 t3 |
| 214 WHERE | 214 WHERE |
| 215 t1.ptime > 1393520400 | 215 t1.ptime > 1393520400 |
| 216 AND param3<>9001 | 216 AND param3<>9001 |
| 217 AND t3.flg7 = 1 | 217 AND t3.flg7 = 1 |
| 218 AND t1.did = t2.did | 218 AND t1.did = t2.did |
| 219 AND t2.uid = t3.uid | 219 AND t2.uid = t3.uid |
| 220 ORDER BY t1.ptime desc LIMIT 500; | 220 ORDER BY t1.ptime desc LIMIT 500; |
| 221 } {0 0 0 {SEARCH TABLE t1 USING INDEX t1x1 (ptime>?)} 0 1 1 {SEARCH TABLE t2 USI
NG INDEX t2x0 (did=?)} 0 2 2 {SEARCH TABLE t3 USING INDEX t3x0 (uid=?)}} | 221 } {~/AUTO/} |
| 222 # | 222 # |
| 223 # ^^^--- Before being fixed, the above was using an automatic covering | 223 # ^^^--- Before being fixed, the above was using an automatic covering |
| 224 # on t3 and reordering the tables so that t3 was in the outer loop and | 224 # on t3 and reordering the tables so that t3 was in the outer loop and |
| 225 # implementing the ORDER BY clause using a B-Tree. | 225 # implementing the ORDER BY clause using a B-Tree. |
| 226 # |
| 227 # This test is sanitized data received from a user. The original unsanitized |
| 228 # data and STAT4 data is found in the th3private test repository. See one of |
| 229 # the th3private check-ins on 2016-02-25. The test is much more accurate when |
| 230 # STAT4 data is used. |
| 226 | 231 |
| 227 finish_test | 232 finish_test |
| OLD | NEW |