Find Text on Server Search Results - Bug

[expired user #5285]'s profile image [expired user #5285] posted 13 years ago in General Permalink
Find Text on server works correctly when it comes to finding how many rows contain a specific search term, but it fails to show the results correctly when you hit the See Results button.

The queries that it generates are always one table off.

Take a database that has five tables and do a search.

Table1 - Found Rows 5
Table2 - Found Rows 0
Table3 - Found Rows 3
Table4 - Found Rows 0
Table5 - Found Rows 0

Hitting See Results at this point will build the queries to show results from Table2 and Table4 instead of from Table1 and Table3.
[expired user #5285]'s profile image [expired user #5285] posted 13 years ago Permalink
This error is occurring on v5.1.0.3584
[expired user #5285]'s profile image [expired user #5285] posted 13 years ago Permalink
One more piece of information. The bug appears to occur only when there is an error searching one of the tables. So the list would appear like this.

Table1 - Found Rows "Error"
Table2 - Found Rows 5
Table3 - Found Rows 0
Table4 - Found Rows 4
Table5 - Found Rows 0

The See Results button would then build the queries for Table3 and Table5 instead of Table2 and Table4
Code modification/commit from ansgar.becker, 13 years ago, revision 5.1.0.3592
Ensure SQL list has the same number of items as result list has, to avoid AVs when SELECT returned an error. See http://www.heidisql.com/forum.php?t=6824
ansgar's profile image ansgar posted 13 years ago Permalink
Fixed in r3592

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