Bug in total rows, and total rows filtered

juanlu's profile image juanlu posted 10 months ago in General Permalink

There is some kind of bug on that interface showing the total rows number and total rows matching filter, on top of the table showned and under the Data tab.

I add two printscreen. Where you can see total rows with out any where clause applied, and then other printscreen where the data is filtered, and where the total number is less than total matching filter, which is imposible.

2 attachment(s):
  • total
  • total_filtered
ansgar's profile image ansgar posted 10 months ago Permalink

Yes, the total number is taken from the estimated row count in the result of SHOW TABLE STATUS. It's very normal that this is not the precise number. But HeidiSQL should definitely not show it, if the filter matches more rows.

Please login to leave a reply, or register at first.