Tariq - Please investigate & see if you can reproduce.

Would you please also include lines 1 to 60 in the Query Analyzer window?  Your screenshot shows lines 61 onward.  I wonder if there is some statement that makes us misinterpret what the current statement is.

Not able to reproduce in 14.0-dev-54. Did you execute select * from baseball before you select the Show Fields command?  

Can you attach collection_alter.sql?

It does not depend on previously ran statements. I have stable situation with this bug. I even close ADS and then open it again and then open my script in it. Then select with help of mouse statement and press CNTRL+ENTER. See new screenshot. Also I attached my script. Looks like this happens if script is long ( more than 1 screen)   

I was able to reproduce it - the key to reproduce was comment character. Thanks for the script.

This also occurs for some other DBMS like MySQL. Depends upon the option for Scripts --> Server Side Comments

Simplest reproducible example :

--T

use Test_Case

go
SHOW FIELDS Test_Case system_costs

Place cursor before the "S" in "SHOW" and ctrl-enter.  It will execute the "use Test_Case".  If you enable "--" as a Server Side Comment then it will execute correctly the "SHOW" command.

Bug exists in 12.0 and above.  It does not exist in 11.0.  Bug caused by SVN# 29702 to fix issue #7743

A script is broken up into multiple statements by a statement separator.  If the "--" or "//" are configured as a client side comment and a user used a client side comment in a statement, the end character count of that statement would be augmented by 1 incorrect count.  This would effect the starting character count of any subsequent statements.  This is now fixed in :

svn # 32847 - 14.0-beta-20
svn # 32848 - 13.0.2
svn # 32849 - 12.0.21

Verified in 12.0.21, 13.0.2 and 14.0-beta-20. Both cases 7743 and 8872 works fine

Slava, can you test in the latest build and close ?