You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Describe the bug
If I create a temporary table and insert rows into it, then when I select the temporary table, HeidiSQL's Data tab continues to show the data from the previously selected table instead of clearing those results. It adds the phrase "No data available for this item" overlapping those old results, which can be hard to read.
Expected Behavior
Even if HeidiSQL fails to load a table, it should at least clear the results of the previous table before attempting to load the next table. That way, if it fails to load, it's better to see a blank table with the error message than to see wrong data.
To Reproduce
CREATE TABLE TestTableA (`ID` INT PRIMARY KEY,`Name` VARCHAR(255));
CREATE TEMPORARY TABLE TestTableB (`ID` INT PRIMARY KEY,`Name` VARCHAR(255));
INSERT INTO TestTableA (ID, NAME) VALUES
(1, 'This is in TableA. Text to fill the screen better. Text to fill the screen better.'),
(2, 'This is in TableA. Text to fill the screen better. Text to fill the screen better.'),
(3, 'This is in TableA. Text to fill the screen better. Text to fill the screen better.'),
(4, 'This is in TableA. Text to fill the screen better. Text to fill the screen better.'),
(5, 'This is in TableA. Text to fill the screen better. Text to fill the screen better.'),
(6, 'This is in TableA. Text to fill the screen better. Text to fill the screen better.'),
(7, 'This is in TableA. Text to fill the screen better. Text to fill the screen better.');
INSERT INTO TestTableB (ID, NAME) VALUES (1, 'This is in TableB');
Screenshots or Crash reports
Note in this screenshot that I have TestTableB selected, but HeidiSQL is showing the results from TestTableA, and its error message overlaps the existing text. I shrunk my window a bit to demonstrate the overlapping text, but you get the same result with a maximized window if your table has more rows and columns than this demo.
The text was updated successfully, but these errors were encountered:
Preconditions
Describe the bug
If I create a temporary table and insert rows into it, then when I select the temporary table, HeidiSQL's Data tab continues to show the data from the previously selected table instead of clearing those results. It adds the phrase "No data available for this item" overlapping those old results, which can be hard to read.
Expected Behavior
Even if HeidiSQL fails to load a table, it should at least clear the results of the previous table before attempting to load the next table. That way, if it fails to load, it's better to see a blank table with the error message than to see wrong data.
To Reproduce
Screenshots or Crash reports
Note in this screenshot that I have TestTableB selected, but HeidiSQL is showing the results from TestTableA, and its error message overlaps the existing text. I shrunk my window a bit to demonstrate the overlapping text, but you get the same result with a maximized window if your table has more rows and columns than this demo.
The text was updated successfully, but these errors were encountered: