[Phpmyadmin-devel] about explicit LIMIT

Marc Delisle Marc.Delisle at cegepsherbrooke.qc.ca
Sat Dec 15 15:58:16 CET 2007


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&group_id=23067&atid=377408

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




More information about the Developers mailing list