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.
Find Text on Server Search Results - Bug
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
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
Please login to leave a reply, or register at first.