[Phpmyadmin-devel] about explicit LIMIT

[cand. inf. Alexander M. Turek]

Hi again,

Sebastian Mendel schrieb:
>
> seeing what he queried, if he wrote LIMIT 0,2 we should show two lines
> per page
>

What should phpMyAdmin do, if he queries "LIMIT 0,1000000"? Or "LIMIT
1000000"? Displaying a page that might crash his browser might not be
his intention. ;-)

And what shall we do in the following case?

SELECT * FROM (SELECT * FROM table LIMIT 0,2) t;

This would be semantically identical to

SELECT * FROM table LIMIT 0,2;

Should we handle it differently? If not, do you really want to walk
through each query and collect all limits? :-/

If I wanted to browse the unlimited result, I would omit the LIMIT.

Regards,

Alexander

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 250 bytes
Desc: OpenPGP digital signature
URL: <http://lists.phpmyadmin.net/pipermail/developers/attachments/20071216/2fc08f4f/attachment.sig>