Bug #7001 Binary display problems in Field Viewer

• Submitted: 4 Dec 2004 0:09
• Modified: 4 Dec 2004 18:15
• Reporter: Bob Gunion
• Status: Closed
• Category: MySQL Query Browser
• Severity: S3 (Non-critical)
• Version: 1.1.2
• OS: Windows (Windows 2000)
• CPU Architecture: Any

[4 Dec 2004 0:09] Bob Gunion

Description:
Displaying binary data in a blob type column (in the Binary tab of the Field Viewer window) has a couple of problems.

First, the numbers on the left, that help count the number of bytes, should start from 0, not 1.

Second, the character display on the right-hand side is out of sync with the hexadecimal display.  The characters are shifted one byte to the left as compared to the hexadecimal display.

Here's a cheapo reproduction of the problem to clarify:  Suppose a blob field contains 26 bytes holding the ascii values of a to z.  The display would look something like this:

1      41 42 43 44 45 46 47 48 49 4a 4b 4c 4d 4e 4f 50       bcdefghijklmnopq
2      51 52 53 54 55 56 57 58 59 5a 5b                            rstuvwxyz

How to repeat:
View the contents of any blob type field in Query Browser.  Select the Binary tab in the Field Viewer window.

Suggested fix:
The example above should look like this:

0      41 42 43 44 45 46 47 48 49 4a 4b 4c 4d 4e 4f 50       abcdefghijklmnop
1      51 52 53 54 55 56 57 58 59 5a 5b                            qrstuvwxyz

[4 Dec 2004 18:15] Michael G. Zinner

Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html