MySQL Bugs: #86004: Underscore not displayed in query results

Bug #86004	Underscore not displayed in query results
Submitted:	19 Apr 2017 12:29	Modified:	17 Jul 2017 14:11
Reporter:	David Benhur Kothapally	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Workbench	Severity:	S5 (Performance)
Version:	6.3.9	OS:	Windows (Microsoft Windows 10 Pro)
Assigned to:		CPU Architecture:	Any
Tags:	WBBugReporter

Description:
On Mysql workbench results view, the underscore in a string is invisible.

How to repeat:
try to view a column that has underscore in it.

I have a screen shot if that would help, but not sure if I can upload it here.

Hmm.. looks like they fixed it in 6.3.8, but it came back in 6.3.9 as per this ticket:
https://bugs.mysql.com/bug.php?id=76520

Hello  David,

Thank you for the bug report.
Verified this behavior on MySQL Workbench in 6.3.9 version

Thanks,
Chiranjeevi.

Screenshot

Attachment: 86004.png (image/png, text), 239.30 KiB.

I have the same problem with version 6.3.8. I could have tolerated the bug if we had an auto-fit feature for rows, such as we have for columns (where pointing between two columns exposes a double-sided arrow to auto-size). 

I unfortunately had to downgrade back to 6.3.8, because it was too difficult to overcome the bottom portion of each line of text being truncated. Most of my colleagues have rolled back to 6.3.8, for the time being. The reduced usability of this bug outweighs the positive gains of the 6.3.9 release. I look forward to this one being resolved, and do appreciate all the hard work of the MySQL team.

http://bugs.mysql.com/bug.php?id=86752  marked as duplicate of this one.

I wouldn't say this is an S5, I'd say its an S3 because it seriously reduces readability of the results grid. There are many characters which are cut off on the bottom of the glyph which could be miniterpreted as other categories if being read on the screen.

There are a couple of workarounds but depending what it is you're doing they are inconvienient:-

- You can export or copy the data. This becomes an issue if you have a large result set as workbench isn't great at exporting or copying large amounts of data (See #86578 and #86430).
- You can press the wrap cell content button. However, this has ~interesting~ results on rows which aren't visible at the time of pressing it. Only useful if you've got a resultset where all rows are visible.
- Tooltip - You can see (most, depending on length) of the data in a cell fine if you hover over it. Only really works with a small result set where you only need to see 1 cell, and the content of the cell isn't too long.

Another workaround is to change the font of the Resultset Grid in the Preferences > Fonts & Colors.  I used "Tahoma" without a number and it renders fine now -- a little big, but that's an acceptable compromise ;)
-I'm on Windows 10

Thanks for this excellent work around I changed it to "Tahoma 8" and it works well and closer to what my previous font size was.

-- x --
Another workaround is to change the font of the Resultset Grid in the Preferences > Fonts & Colors.  I used "Tahoma" without a number and it renders fine now -- a little big, but that's an acceptable compromise ;)
-I'm on Windows 10