Toad World® Forums

TDP 3.7 / MySQL Column detail missing


#1

I actually noticed this in 3.6, but we really have not had to change TDP operation since then, so it had little or no impact on us.

It seems as though the column details do not display when you go to Object Explorer > Database Name > Table Name > View Details. Clicking on the Columns tab shows a blank screen. What is interesting is that if you click on the Data tab, you can see everything in the table including the Column Names.

Any comments?

See the following:

7384.TDA-Columns.png

2514.TDA-Data.png


#2

Hi Bill,

Does it happen for all tables and views or only for specific ones?

Could you please execute the following statement from the SQL editor

SHOW FULL COLUMNS FROM Table_Name FROM DB_Name

You should replace the DB and table names with the real ones.

Do you get the list of columns?

What privileges does the user have?

What is the TDP version? Is it 3.6? Could you try withthe latest 3.7?

What is the MySql version?

Regards

Aleksey


#3

Hi Aleksey,

It happens for all tables.

Executing the command does show the table columns:

1452.COLUMNS.jpeg

User has full privileges.

Running TDP 3.7

MySQL version:

  • Server version: 5.6.23 - MySQL Community Server (GPL)
    Thanks,

Bill


#4

Hi Bill

I tried this by Mysql 5.6.25 but can not reproduce your issue. Could you please let me know if this happens to all server or just the specific one?

Thanks

Andy


#5

We only have the one MySQL server. Seems like it might be some local setting either in TDP 3.7 or on the server itself.


#6

Create an ODBC DSN and connect in TDP using ODBC. If you get column info then the issue is with us.