Some New Bugs

[Jimmie]

1.

In alter table tab, in naming a table, any capitals do not show in the left side tree pane. All become lowercase.

2.

In the alter table tab, after clicking the save button, all the nodes on the left side collapse. Have to manually open them all up again.

[peterlaursen]

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.

[peterlaursen]

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.

[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.

[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.

[Author]

Posts