[SA 9.0.166 Pro] Show DDL pane shows some code green[FIXED]

[SA 9.0.166 Pro] Show DDL pane shows some code green[FIXED]

I'm working on a new stored proc and when I use "show ddl" on the proc there are parts of the DDL window that are green that maybe shouldn't be and parts that are not green that should be.

You can see here that "BEG" in BEGIN TRY is green, it follows a comment.

Likewise you can see that --RMQ is not green, but the rest of that comment is. Likewise the "SE" in the first SELECT statement is green (again it follows a comment).

Then if you go a bit further down you'll see it repeats itself in that fashion.

It's almost like the comment parser gets confused at times?

It gets even funkier further down my SPROC.

You can see here, UP is green, the E at the end of false and the closing quotation mark is green, then the FR in FROM is green.. even further down (not shown) another E and quotation mark are green in that same statement.

Last edited by Mindflux on Thu Nov 10, 2016 4:26 pm; edited 1 time in total

It only shows that some parts of your code aren't ripe yet :)

But heck, mine either. Have you tried that with code not containing any comments?

	gemisigo wrote:
	It only shows that some parts of your code aren't ripe yet :) But heck, mine either. Have you tried that with code not containing any comments?

Not yet.

*Edit: if I take the block comment out from the top of the SPROC (the SQL Assistant refactor comment) the rest of the code seems to now parse correctly in the Show DDL window.

Thank you for reporting it. I have logged this bug under #SA0029891

	Code:
	/* * * */

breaks the highlighting in "Show DDL" even more; The more lines the worse the 'logic creep' gets.

Conversion to:

	Code:
	-- multi -- line -- comments -- like -- this -- don't -- expose -- problem

Also works OK

This is fixed! yay!