Joomla 2.5 Select All as page limit gives zero result

Joomla 2.5 Select All as page limit gives zero result

I developed a joomla 2.5 custom component for showing data table that
implemented filtering, shorting, and pagination. But in the middle of
pagination I selected page limit as All.It doesn't gives me any
result.When I select All as page limit it works well except only above
scenario.Seams page limit is set to 0.Then db query will like SELECT* FROM
_tebleName LIMIT 0,0.