#4672 (ok 4.3.4) "Distinct values" does not page

[Steven Van Ingelgem]

When you click the "Distinct Values" button, the query is executed correctly.

But! You cannot sort the results (I like to sort them at the amount of Rows), and neither can I page (go to the xth page).
And neither do I see the total rows amount.

It looks like this query is interpreted as an insert-statement or so?

[Rakesh Kumar]

Hi

I am able to reproduce it. I think I can fix it. Should I try the same?

[Marc Delisle]

Rakesh,
please do.

[Rakesh Kumar]

Hi Marc,
Please see my pull request: https://github.com/phpmyadmin/phpmyadmin/pull/1438

and let me know if it looks fine.
Thanks.

[Marc Delisle]

Patch accepted, thanks.