Bug #22577 Cursor skips while deleting characters
Submitted: 22 Sep 2006 0:52 Modified: 6 Dec 2006 15:53
Reporter: Clifton Kilby III Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.1.9, 1.2.3 beta OS:Windows (XP Pro SP 2)
Assigned to: Mike Lischke CPU Architecture:Any

[22 Sep 2006 0:52] Clifton Kilby III
Description:
When pasting a query into the box to execute, sometimes you will get an error about trying to execute an empty string, or the query will execute and error out. The error will then show that only part of the query was read in from the box. Deleting whitespace will solve this issue (\t, space, or \r\n), however, while deleting characters the cursor will skip forward a character so that part of the query is deleted.

This behavior was demonstrated in 1.1.9 as well as 1.2.3 beta.
Server for both is 5.0.18-nt via TCP/IP

How to repeat:
For example, paste in:
Select username, sum(gs.visible)
        	  	  	 	 
	 	  	  	  	  
		 	from users u

 (there should be spaces and tabs and newlines in the above query between ")" and "from" )
When trying to delete (by pressing backspace repeatedly) the whitespace in front of FROM (start with the cursor to the left of F) so it is located directly under SELECT the cursor will skip and you will end up with OM.

Suggested fix:
Ensure that manually backspacing only deletes the character to the left of the cursor and does not move the cursor to the right when encountering whitespace, or make the query browser more whitespace agnostic.
[22 Sep 2006 8:21] Sveta Smirnova
Thank you for the report.

Verified as described.
[6 Dec 2006 15:53] Mike Lischke
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