SQL query table provider : Pagination not working in List View

I created a "virtual table" with an SQL query table, and then created a List View based on this table. Works fine except pagination.
Only first page works; every other return an empty list.
