Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Data tab shows data from wrong table when new table fails to load #1883

Open
Germs2004 opened this issue Dec 18, 2023 · 0 comments
Open

Data tab shows data from wrong table when new table fails to load #1883

Germs2004 opened this issue Dec 18, 2023 · 0 comments

Comments

@Germs2004
Copy link

Preconditions

  • HeidiSQL version: 12.6.0.6782 (64 bit)
  • Database type and version: MariaDB 11.2.2
  • OS: Windows 10 Pro x64 22H2

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.
image

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant