Re: After partition, query returns wrong result.

[yansheng lin]

Sorry, I need to add one more query in this post to illustrate the problem.

mysql> select department_id, book_id, log_hour from books where book_id = 266 and department_id = 1;

.
.
.
| 1 | 266 | 2006-05-19 03:00:00 |
| 1 | 266 | 2006-05-19 04:00:00 |
| 1 | 266 | 2006-05-19 05:00:00 |
| 1 | 266 | 2006-05-19 06:00:00 |
| 1 | 266 | 2006-05-19 07:00:00 |
| 1 | 266 | 2006-05-19 08:00:00 |
| 1 | 266 | 2006-05-19 09:00:00 |
+----------------+-------------+---------------------+
586 rows in set (0.02 sec)