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

Table and Data tabs are blank for MariaDB temporary tables #1882

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

Table and Data tabs are blank for MariaDB temporary tables #1882

Germs2004 opened this issue Dec 18, 2023 · 2 comments

Comments

@Germs2004
Copy link

Germs2004 commented Dec 18, 2023

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 regular table, I can see its list of columns on HeidiSQL's Table tab, and its data on the Data tab. But, if I create a temporary table, those two tabs are blank. In both cases, I can see the columns when I type "DESCRIBE", and the tables' data when I write a SELECT query, so the MariaDB server appears to be working correctly. And, HeidiSQL is able to show the table name on the list of tables, and the column names on the Indexes area, so it seems the blank column list and blank data rows is a bug.

To Reproduce
I have "lower_case_table_names=2" in my.ini, in case that matters.

CREATE TABLE TestTableA (`ID` INT PRIMARY KEY,`Name` VARCHAR(255));
CREATE TEMPORARY TABLE TestTableB (`ID` INT PRIMARY KEY,`Name` VARCHAR(255));
SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_NAME LIKE 'TestTable%';
DESCRIBE TestTableA;
DESCRIBE TestTableB;
INSERT INTO TestTableA (ID, NAME) VALUES (1, 'John Smith - TableA');
INSERT INTO TestTableB (ID, NAME) VALUES (1, 'John Smith - TableB');
SELECT * FROM TestTableA;
SELECT * FROM TestTableB;

Screenshots or Crash reports
image
image
image
image
image
image
image
image

Note: I also see that the capitalization is wrong on TestTableB. I reported that to MariaDB already.

@Germs2004 Germs2004 changed the title Table column list tab is blank for MariaDB temporary tables Table and Data tabs are blank for MariaDB temporary tables Dec 18, 2023
@ansgarbecker
Copy link
Collaborator

The docs say:

On Unix, the default value of lower_case_table_names is 0. On Windows, the default value is 1. On macOS, the default value is 2.

Please verify your this issue does not depend on an unusual setting here.

@Germs2004
Copy link
Author

The docs say:

On Unix, the default value of lower_case_table_names is 0. On Windows, the default value is 1. On macOS, the default value is 2.

Please verify your this issue does not depend on an unusual setting here.

Affirmative. I just uninstalled MariaDB, deleted its Data directory, reinstalled it with defaults (no override of lower_case_table_names), created a new database, and was able to confirm this issue still occurs in HeidiSQL. The only difference is now the table names are lowercase:
image
image

Incidentally, if my MariaDB server is running on Windows, how else can I allow capital letters in table names without setting lower_case_table_names to 2? I read that that is the correct way to do it.

(re-posted this since I accidentally posted from wrong GitHub account last time)

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

2 participants