Bug #67597 Editing multiline comment in SQL Editor
Submitted: 15 Nov 2012 13:02 Modified: 11 Feb 2013 18:42
Reporter: Boris Plus Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:MySQL Workbench 5.2.44 CE OS:Microsoft Windows (7 SP1 64bit)
Assigned to: CPU Architecture:Any
Tags: multiline comment

[15 Nov 2012 13:02] Boris Plus
Description:
When you hide multiline comment and delete start comment lexeme '/*' you lost other lines of comment. They are become invisible. And you can see them only when you put start comment lexeme '/*' before position where it was deleted.

Sorry for my English.

With pleasure
BorisPlus

How to repeat:
Let's try in SQL Editor of MySQL Workbench

1   | SELECT '1'
2   | FROM dual
3   | WHERE '1'='1'
4   | OR '2'='2'
5   | OR '3'='3'

Execute. It's OK. Put comment like this

1   | SELECT '1'
2   | FROM dual
3   | WHERE '1'='1'
4[-]| /*OR '2'='2'
5 L | */
6   | OR '3'='3'

Execute. It's OK. 

In left click to [-] an see [+] afte hide line 5

1   | SELECT '1'
2   | FROM dual
3   | WHERE '1'='1'
4[+]| /*OR '2'='2'
6   | OR '3'='3'

Execute. It's OK. 

Remove "/*"

1   | SELECT '1'
2   | FROM dual
3   | WHERE '1'='1'
4   | OR '2'='2'
6   | OR '3'='3'

Execute. Error syntax - about invisible end comment lexeme '*/'. 

It is not indicate end of comment. Try put enter before and after line 4

1   | SELECT '1'
2   | FROM dual
3   | WHERE '1'='1'
4   | 
5   | OR '2'='2'
7   | 
8   | OR '3'='3'

End comment lexeme '*/' is invisible. 

Put start comment lexeme.

1   | SELECT '1'
2   | FROM dual
3[-]| WHERE '1'='1'/*
4 | | 
5 | | OR '2'='2'
7   | 
8   | OR '3'='3'

End comment lexeme '*/' is invisible. 

Click [-]

1   | SELECT '1'
2   | FROM dual
3[+]| WHERE '1'='1'/* 
7   | 
8   | OR '3'='3'

Click [+]

1   | SELECT '1'
2   | FROM dual
3[-]| WHERE '1'='1'/* 
4 | | 
5 | | OR '2'='2'
6 L |*/
7   | 
8   | OR '3'='3'

I lost more time to understand this situation of syntax error and invisible part of code.

With pleasure
BorisPlus
[11 Feb 2013 18:42] Ruben Dario Morquecho Valdez
windosw7x64
Workbench 5.2.46
----------------------
Bug able to reproduce. Bug being analisyng.

Thanks for tnteresting on Workbench.
[26 Jul 2015 7:05] Paul Weiss
Problem still occurs in 6.3.4.0 on Microsoft Windows 7 Home Premium SP 1, 64-bit. It would be great to put this in the documentation until the problem is fixed, to save people from spending a long time trouble-shooting this.