[Jimmie]

Thank you.

I look forward to those features.

It will reduce the bottlenecks in my workflow.

[Jimmie]

'peterlaursen' wrote:

As regards the second point open nodes in the Object Browser do not collapse for me. However I am not using the public 9.5 build but an internal development build, so this may be an issue that has been fixed in between.

It collapses the “Columns” tree node and the “Stored Procs” tree node. Probably the Triggers, Events, and Functions too.

When you click the Save button in the “Create Table” tab, you'll get the dialog box that says “Table Altered Successfully”.

After you click OK in that dialog, you'll see all your nodes collapse on you, and you have to open them all up again to continue with your work.

I am on version 9.50.

[Jimmie]

'peterlaursen' wrote:

Let us take the first point first.

Are you sure that the server is configured to allow for UPPERCASES. It is the server variable 'lower_case_table_names' that controls this, refer:

http://dev.mysql.com/doc/refman/5.5/en/identifier-case-sensitivity.html.

Please execute “SHOW GLOBAL VARIABLES LIKE ' 'lower_case_table_names';”

If it returns “1” then this (refer link) applies “Table names are stored in lowercase on disk and name comparisons are not case sensitive. MySQL converts all table names to lowercase on storage and lookup. This behavior also applies to database names and table aliases.” . So I guess what you experience is that the server converts the lettercase of table names.

For my server:

lower_case_table_names = 0

I believe this is the MySQL default value.

Another problem is that if I am in the “Create Table” tab, if I change the case of a table, for example, from “products” to “Products”, it won't work.

If I do this in the left tree pane, renaming through the F2 command, it works fine.

[Author]

Posts