[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:                |
--------------------------+------------------------------

Comment (by Viper007Bond):

 Interestingly I cannot reproduce this locally, so it may be 32bit vs 64bit
 or something. The same `paged` value results in this query:

 `SELECT SQL_CALC_FOUND_ROWS wp_trunk_posts.ID FROM wp_trunk_posts INNER
 JOIN wp_trunk_term_relationships ON (wp_trunk_posts.ID =
 wp_trunk_term_relationships.object_id) WHERE 1=1 AND (
 wp_trunk_term_relationships.term_taxonomy_id IN (1) ) AND
 wp_trunk_posts.post_type = 'post' AND (wp_trunk_posts.post_status =
 'publish' OR wp_trunk_posts.post_status = 'private') GROUP BY
 wp_trunk_posts.ID ORDER BY wp_trunk_posts.post_date DESC LIMIT
 21474836460, 10`

 No idea where this other `LIMIT` is coming from.

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