Hi, I am seeking your input about the following issue. Normally if a user just browses a table, he can use the navigation << < > >> and "Page number" to move thru the table. LIMIT clause is generated accordingly.
Now if a user typed a LIMIT clause, what should he expect?
(1) To be able to move thru the entire table (2) or just thru the result set he chose in his LIMIT clause?
Reading this bug report https://sourceforge.net/tracker/index.php?func=detail&aid=1846013&gr...
the user expects (1). I am not sure but I tend to say (2) because of the explicit LIMIT.
Of course in this bug report there are real bugs to solve but to implement the current solution we have to decide about this issue first.
Marc