chore!: Not getting all records when order by other columns apart from primary key

[kamalesh889]

I have two columns in my database . these are number{primary key} and name .

when i sort by number , the pagination works fine and i am getting all the records .
But when i sort by name , i am getting data only as per the limit in the request , apart from that all records having same name is not showing in the next page . It skipped those records and go to the records with other name .