With sqlite provider paging does not work.

sqlite provider returns count as long and then no results are returned as conditions fills page items only if count was returned as int.