wp_get_archives invalid query

[westi]

wp_get_archives( array( 'limit' => 0 ) );

Generates:

SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts  WHERE post_type = 'post' AND post_status = 'publish' GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC 0

We should just ignore a limit of 0 and fallback to the default IMHO

[jjeaton]

27834 unit tests

[jjeaton]

Added logic that checks for 0 and sets it to the default. My first unit test for core, so feedback is welcome.

[wonderboymusic]

In 28560:

Truly check for ! empty() instead of falsey '' when determining whether to add LIMIT clause to SQL in wp_get_archives().

Props jjeaton for the initial patch.
Fixes #27834.