Bug #22421 Multiline fields produce unaesthetic dots at the bottom of the cells
Submitted: 16 Sep 2006 21:21 Modified: 1 Feb 2007 9:08
Reporter: Cezary Okupski Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.2.3beta, 1.2.4beta, 1.2.6beta, 1.2.8beta OS:MacOS (Mac OS X)
Assigned to: Vladimir Kolesnikov CPU Architecture:Any
Tags: breaking, cells, dots, line, multiline, newline

[16 Sep 2006 21:21] Cezary Okupski 
Description:
I am not sure if you will consider this as a bug.

Multiline fields produce unaesthetic dots at the bottom of the cells on Mac OS X with default font settings. An image will show what I am talking about the best. I will be attaching in a minute.

How to repeat:
Put some long text in a table's column so that it does not fit in one line if you make a SELECT query.
Make a SELECT query.

Suggested fix:
Maybe rows should be lower…
[16 Sep 2006 21:21] Cezary Okupski 
screenshot with these unaesthetic dots

Attachment: MySQL Query Browser - dots of multiline strings.jpg (image/jpeg, text), 67.15 KiB.
[22 Oct 2006 10:30] Valeriy Kravchuk 
Thank you for a problem report. Please, try to repeat with a newer version, 1.2.4 rc, and inform about the results.
[31 Oct 2006 10:59] Cezary Okupski 
It still looks the same in 1.2.4beta.
[21 Nov 2006 13:19] Valeriy Kravchuk 
Please, try to repeat with a newer version, 1.2.5 rc, and inform about the results.
[10 Dec 2006 13:26] Cezary Okupski 
It remains to be fixed in 1.2.6beta.
[21 Dec 2006 7:17] Sveta Smirnova 
Thank you for the report.

I can not repeat it with last 1.0.7 GUI Tools
[23 Dec 2006 22:52] Cezary Okupski 
Actually this bug is still present in MySQL Query Browser 1.2.8beta (!). It occurs when using higher characters. I tried all easily-typeable characters on my keyboard (layout Polish Pro, i. e.

§1234567890-=][poiuytrewqasdfghjkl;\'\\/.,mnbvcxz`£!@#$%^&*()_+}{POIUYTREWQASDFGHJKL:\"|?><MNBVCXZ~`źżć√ļńĶ≤≥÷«ĺ…łŻ∆ķ©ń∂śąŌ∑ꮆī¨^óĻ„‚≠–ľĽ•¶§įß™ŃŕŘ‹›řŖŗ°Š‚—Ī’”łÓťŤÁś£Ę„őĄŚŽžŪÓÔūŁÚģ»ņýÝųŃű◊ĆŻŹŔ')

) and found out that all of the following characters produce the mentioned effect:

[]dfhkl'b`${}"|`źćķóľßőń∂śŃŕŘ°ŠŌřŃŕŘĪ’”łÓťŤÁśĺłŻļńĆŻŹŔŃűýÝÚģŚŽžŪÓÔ

Thus
CREATE TABLE test (c text);
and
INSERT INTO test VALUES
('[]dfhkl\'b`${}\"|`źćķóľßőń∂śŃŕŘ°ŠŌřŃŕŘĪ’”łÓťŤÁśĺłŻļńĆŻŹŔŃűýÝÚģŚŽžŪÓÔ');
will let you repeat the problem - presuming that your column is narrow enough.
[26 Dec 2006 11:29] Sveta Smirnova 
Thank you for the addition.

Verified as described.
[1 Feb 2007 9:08] Vladimir Kolesnikov 
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 bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html

An option was added to user preferences that controls resultset row height (works for all newly open resultset tabs)