Bug: Sqlyog Executes Wrong Query After "paste Sql Statements&quot

[vygi]

Greetings!

I have found out that the old bug hasn't really gone.

TO REPRODUCE:

1: do “Paste SQL Statements” / “SELECT ….” several (let's say 5) times from several different tables in the same query editor window.

2: place cursor in the lat but one (4th) SELECT statement, between the last character and the semicolon. Press F9 (or F5) to execute current query: LAST statement will be executed insted of current one!

3: place cursor near the end of the last statement and try to execute current query: error message will appear, saying that the cursor should be placed inside a query (although it is already inside).

greetings,

Vygi

[peterlaursen]

The problem was that the 'position count' for a statement was inaccurate because of mismatch between windows linebreaks and unix linebreaks (rn versus n). This was fixed with the formatter like this (formatter inserted unix linebreaks between statements).

Maybe the templates use unix-linebreaks (they are probably copied from some MySQL resource) and that could explain why it still occurs when inserting from templates. We will check!

[navyashree.r]

Hi,

We are looking into this issue. We will update shortly with the status.

Regards,

Navya

[navyashree.r]

Issue confirmed & added in our tarck list,

http://code.google.com/p/sqlyog/issues/detail?id=1095

Thank You.

Regards,

Navya

[Khushboo]

Hi,

This issue is fixed and available in 8.13 beta1 , released!

Please refer to:

http://www.webyog.com/blog/2009/06/19/sqly…-been-released/

Please let us know the status.

Thank you for your interest.

Regards,

Khushboo

[Author]

Posts