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 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
Note: I also see that the capitalization is wrong on TestTableB. I reported that to MariaDB already.
The text was updated successfully, but these errors were encountered:
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
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:
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)
Preconditions
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.
Screenshots or Crash reports
Note: I also see that the capitalization is wrong on TestTableB. I reported that to MariaDB already.
The text was updated successfully, but these errors were encountered: