Bug #26614 Problem with editing field values and newlines in popup editor
Submitted: 24 Feb 2007 13:37 Modified: 25 Feb 2007 9:59
Reporter: Peter Pearson Email Updates:
Status: Closed Impact on me:
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.1.18 OS:Linux (linux 2.6.17)
Assigned to: Valeriy Kravchuk CPU Architecture:Any
Tags: Edit, field, new line

[24 Feb 2007 13:37] Peter Pearson
After selecting "Edit Field in Popup Editor" in the grid control after displaying the results of a SELECT query, you can't backspace at the beginning of a line in the text box of the popup editor. (For example to combine two separate lines). The only way to this is to go to the end of the line above and press delete so the newline is deleted.

How to repeat:
Do a SELECT query to display some results. Right-click on one of the field values with multiple lines, and select "Edit Field in Popup Editor". In the popup editor, try to backspace at the beginning of the second or third line.

Suggested fix:
Allow backspace at beginning of a line.
[24 Feb 2007 19:56] Valeriy Kravchuk
Thank you for a problem report. Please, try to repeat with a newer version, from MySQL GUI Tools 5.0r9, and inform about the results.
[24 Feb 2007 23:25] Peter Pearson
Okay, tried in 1.2.9rc and the same thing, but in testing it I found that pressing backspace twice had the desired effect, and I looked at the data in a hex editor, and the lines were separated by "\r\n", DOS format style, so I guess that was the problem.

I don't know how it got to be formatted that way, but that's my problem, so I guess this can be closed now.
[25 Feb 2007 9:59] Valeriy Kravchuk
Closed as, likely, the behaviour described is not a result of any bug in MySQL's code.