#3789 Erroneous LIMIT clause in prettyprinted SQL

[Madhura Jayaratne]

Execute the following SQL query and see the prettyprinted SQL
SELECT * FROM sakila.film LIMIT 0, 50;

The pretty printed SQL is:
SELECT * FROM sakila.film LIMIT 0, 30;

[shamika]

Should it be the pretty printed SQL,
SELECT *
FROM test.customers
LIMIT 0 , 50

when execute the SQL
SELECT * FROM sakila.film LIMIT 0, 50;

??

[Marc Delisle]

Yes.

[shamika]

I fix this bug.
https://github.com/phpmyadmin/phpmyadmin/pull/163
only for several test cases.
check more.

[Marc Delisle]

Fix from shamika was rejected.

[Samith Dassanayake]

I have fixed the bug and done a pull request
https://github.com/phpmyadmin/phpmyadmin/pull/169

[Marc Delisle]

Fixed with https://github.com/phpmyadmin/phpmyadmin/pull/169