[wp-trac] [WordPress Trac] #23383: High archive page numbers cause invalid database queries

[WordPress Trac]

#23383: High archive page numbers cause invalid database queries
--------------------------+------------------------------
 Reporter:  Viper007Bond  |       Owner:
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  Awaiting Review
Component:  Database      |     Version:  trunk
 Severity:  normal        |  Resolution:
 Keywords:                |
--------------------------+------------------------------
Description changed by Viper007Bond:

Old description:

> Visiting
> `http://www.viper007bond.com/category/videos/page/6805063692754011230` on
> my site generates the following database query:
>
> {{{
> SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN
> wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id)
> WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (21) ) AND
> wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish' OR
> wp_posts.post_status = 'private') GROUP BY wp_posts.ID ORDER BY
> wp_posts.post_date DESC LIMIT 6.805063692754E+19, 10
> }}}
>
> Note the scientific notation `LIMIT` value.
>

> PHP: 5.3.15-pl0-gentoo
> MySQL: 5.2.12
> WordPress: r23386

New description:

 Visiting
 `http://www.viper007bond.com/category/videos/page/6805063692754011230` on
 my site generates the following database query:

 `SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN
 wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id)
 WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (21) ) AND
 wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish' OR
 wp_posts.post_status = 'private') GROUP BY wp_posts.ID ORDER BY
 wp_posts.post_date DESC LIMIT 6.805063692754E+19, 10`

 Note the scientific notation `LIMIT` value.


 PHP: 5.3.15-pl0-gentoo[[BR]]
 MySQL: 5.2.12[[BR]]
 WordPress: r23386

--

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/23383#comment:1>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software