MySQL Bugs: #49013: Lettercase mismatch in k/M dropdown

Bug #49013	Lettercase mismatch in k/M dropdown
Submitted:	24 Nov 2009 0:18	Modified:	21 Jan 2010 17:25
Reporter:	Kolbe Kegel	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	5.2.8 Beta	OS:	Any
Assigned to:	Maksym Yehorov	CPU Architecture:	Any
Tags:	regression

Description:
Unit dropdowns in WB Configuration editor show "k" and "M". (There is no "G" shown at all.)

How to repeat:
n/a

Suggested fix:
These should be consistent. Both should be uppercase. ("G" should be shown for some options.)

Bug #49015 is marked as duplicate of this bug here.

This is a regression of bug #31675

Added option 'G' to a list of ' ', 'k', 'M'

G identifier has been added to size-dropdowns.
included in 5.2.10

The bug reported here is that "k" is lowercase while "M" is uppercase. Has that been addressed?

I think lower case 'k' for kilobytes is correct isn't it? Please feel free to reopen if you think otherwise.

An entry has been added to the 5.2.10 changelog:

In the configuration editor in the Admin tab, the listboxes for displaying units, such as for the Sort buffer size option, did not show 'G', which represents Gigabytes.

I don't know what's "correct", but I do know these things:

1) The MySQL Reference Manual says "For options that take a numeric value, the value can be given with a suffix of K, M, or G (either uppercase or lowercase)", using the same lettercase for all three suffixes.

2) Example MySQL config files distributed with MySQL Server use uppercase 'K'.

3) The lack of consistency between 'k', 'M', and 'G' looks strange.

I believe that it would be appropriate to strive for consistency within the application and with the conventions used in other MySQL products.

http://en.wikipedia.org/wiki/Kilo-    Kilo (symbol: k) 
http://en.wikipedia.org/wiki/Mega-   mega (symbol M)
http://en.wikipedia.org/wiki/Giga-   Giga (symbol: G)

See previous comment, "I don't know what's 'correct'". All three of those points still apply.

Also, if we're quoting Wikipedia, http://en.wikipedia.org/wiki/Kilobyte notes that "It is abbreviated in a number of ways: KB, kB, K and Kbyte.".

It may also be worth noting that the article you linked to refers to the SI unit denoting 1000. The use of "K" in MySQL configuration files corresponds to 1024 rather than 1000.

I don't see why MySQL Workbench should be different than ever other MySQL product I know of in its handling of this abbreviation.

Letter-case is unified now.

change to uppercase confirmed. will be included in 5.2.13

The changelog entry has been updated accordingly.