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:
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
Hi Aleksey,
It happens for all tables.
Executing the command does show the table columns:
User has full privileges.
Running TDP 3.7
MySQL version:
Bill
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
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.
Create an ODBC DSN and connect in TDP using ODBC. If you get column info then the issue is with us.
