Cursor Position Mis-interpreted When Escape Chars Present

[Giles]

Hi,

Found a Small but annoying bug in the query-editor when using escape characters. When the run statement under cursor button (f9/f5) is pressed it will often run the next statement if the cursor is near the end of the statement, try this bit of code:

 

   





;

--     | put cursor here, press f9 (or f5) to run the current statement

SELECT 1;

SELECT 2;

You should find that it runs the 2 select rather than the 1. How close to the end of the statement the cursor needs to be is directly related to the number of escaped characters, IE for 1 esc char the cursor must be 1 char back from the end to run the correct code, 2 esc chars it needs to be 2 back etc.

Now I know this I am avoiding using escaped chars.

 

Hope this is enough info.

Cheers,

Giles

 

[peterlaursen]

Pleae attach the SQL script as a file attachment (and please zip it).  Once it gets HTML-formatted as here, it is not he same.

 

Also please tell your SQLyog version. We have fixed such issues before so old versions may have this problem in some  cases.

[peterlaursen]

I cannot reproduce with SQLyog 11.52.  But some  formatting details that were lost in HTML may matter.  So still please attach a file with the script.

[Giles]

Sorry for not including the version, somehow forgot the top bug reporting rules. We are using 11.5. 64 and 32 bit.

 

Attached is the file, although I suspect it won`t help reproduce the problem, it is pretty clear as soon as you add some chars to the script.

 

We have seen this on several PCs and different versions of SQL-Yog, so it is not just one particular setup.

 

I hope you can reproduce it, if not though, I know to avoid using now.

 

 

[peterlaursen]

The file was not attached. You need to do in 2 steps: 1) upload 2) attach to post (the interface can be a little triggy to understand first time).

 

I have tried to reproduce this!

[peterlaursen]

You may also send a mail to [email protected] with the file attachment.

 

The SQLyog editor is based on the Scintilla library (http://www.scintilla.org/). I wonder if you have some other program runnng changing the behavior of  Scintilla.  Could you please try with no other program running – and preferably after a fresh reboot. 

[Author]

Posts