<html><body><div style="color:#000; background-color:#fff; font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:10pt"><div><span>Hello All,</span></div><div style="color: rgb(0, 0, 0); font-size: 13px; font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: transparent; font-style: normal;"><span><span class="Apple-tab-span" style="white-space:pre"> </span>This is regarding bug #4356 https://sourceforge.net/p/phpmyadmin/bugs/4356</span></div><div style="color: rgb(0, 0, 0); font-size: 13px; font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: transparent; font-style: normal;"><span><br></span></div><div style="background-color: transparent;">It is true that total row count of a table is shown instead of count of rows returned by "GROUP BY" query. I have created a patch which tells the count of
on-screen rows in case of "GROUP BY" queries as shown in the attached image.</div><div style="background-color: transparent;">But this count is affected by the value of "Number of rows".</div><div style="background-color: transparent;"><br></div><div style="background-color: transparent;"><span></span></div><div style="background-color: transparent;">For instance as shown in the image, there are 7 rows returned and same is shown in the message above table which is less than "Number of rows = 25" value. But if this number of rows returned exceeds 25, then only 25 will be shown in place of 7. So here I would like to take some other opinions regarding what should be displayed: </div><div style="background-color: transparent;"><span class="Apple-tab-span" style="white-space:pre"> </span><span class="Apple-tab-span" style="white-space:pre"> </span>Real count of rows returned by the query (without LIMIT clause)</div><div style="background-color:
transparent; color: rgb(0, 0, 0); font-size: 13px; font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-style: normal;"><span class="Apple-tab-span" style="white-space:pre"> </span>Or </div><div style="background-color: transparent; color: rgb(0, 0, 0); font-size: 13px; font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-style: normal;">On-screen rows count as shown in image (with LIMIT clause) ?</div><div></div><div> </div><div>Regards,
<br>Ashutosh Dhundhara</div></div></body></html>