Bug #26617 Removing whitespace deletes last character of line
Submitted: 25 Feb 2007 5:06 Modified: 27 Apr 2007 9:45
Reporter: Jared S (Silver Quality Contributor) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.2.10, 1.2.9 OS:Windows (WinXP)
Assigned to: Mike Lischke CPU Architecture:Any
Tags: delete, qc, query browser, whitespace

[25 Feb 2007 5:06] Jared S
Description:
Hi,  Query Browser can go slightly overboard on deleting under certain conditions.  Looking at my test case it appears that when deleting blank lines in between other lines of code that are tab indented, Query Browser may delete the trailing ';' character from line above the cursor.

How to repeat:
1.  Copy and paste folling text into new Script Window..
2.  And, delete the blank line in between these 2 code lines

	INSERT INTO `sale-guests` (idpostcode, firstname, lastname, dateadded, ccdate) VALUES(233, '01', CONCAT('M-', zFirstName), NOW(), ADDDATE(CURDATE(), INTERVAL 1 YEAR);

	SELECT LAST_INSERT_ID() INTO zNewID;

-- RESULT the ';' is deleted
-- REQUEST the cursor should also be kept on same line
[25 Feb 2007 9:56] Valeriy Kravchuk
Thank you for a problem report. Please, specify how exactly you deleted that bland lime (where cursor was, what key you pressed etc). I was not able to repeat the behaviour described, hence the request.
[25 Feb 2007 21:26] Jared S
Try this file, has CRs in correct place

Attachment: bug.sql (text/plain), 210 bytes.

[25 Feb 2007 21:28] Jared S
I see the text was modified ounce posted, so you will have to use the file I gave you plus the BackSpace key.
[26 Feb 2007 13:16] MySQL Verification Team
Thank you for the feedback. I was not able also to repeat the behavior
reported using the the script file reported copy/paste. Some condition
we are missing for.
[26 Feb 2007 23:05] Jared S
step_1

Attachment: step1.JPG (image/pjpeg, text), 25.39 KiB.

[26 Feb 2007 23:05] Jared S
step 2

Attachment: step2.JPG (image/pjpeg, text), 12.66 KiB.

[26 Feb 2007 23:08] Jared S
Thanks for having a go Miguel, could you please confirm the problem I am reporting from the pictures I have now submitted.  I need to make sure we are both on same page.
[2 Mar 2007 19:12] Valeriy Kravchuk
Please, try to repeat with a newer version, 1.2.10 (from GUI Tools 5.0-r10), and inform about the results.
[3 Mar 2007 0:06] Jared S
Thanks, but still an issue!
[3 Mar 2007 19:37] Valeriy Kravchuk
Verified just as described and shown on pictures uploaded.
[29 Mar 2007 12:09] Sergey Morozov
MySQL Query Browser: 1.2.10

Steps:
1. Enter text:
===========================
select * from
test
===========================
2. Move cursor after word "test"
3. Press key "Del"
4. Second line will be removed 

Why?
[3 Apr 2007 1:42] Jared S
1. Please dont polute my bugs, instead log another
2. My case specifically refers to `script tab`
3. You scenarios doesnt repeat
4. What the hell are you entering = signs for?
[27 Apr 2007 9:45] 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