MySQL Bugs: #26614: Problem with editing field values and newlines in popup editor

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:	None
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

Description:
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.

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.

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.

Closed as, likely, the behaviour described is not a result of any bug in MySQL's code.