On 5/3/14, 1:04 PM, vetri_2020(at)yahoo(dot)com wrote:
> I'd encountered an issue in select query when using order by and limit.
>
> When I sort by a column which have same values for some data,then the row
> that appears in first page also appears in next page.
This is not a bug. The sort order of identical values is undefined
unless disambiguated by adding more sort expressions.
> And when I execute the below query, the issue occurs.
You didn't show the query you used here, but I'm assuming it had OFFSET
5 or something similar. And yes, that's still undefined behaviour, and
not a bug.
Regards,
Marko Tiikkaja