Erroneous quote added on indent

AndyIrving

This may have been present in V4, can't be sure.

Steps to reproduce:

SELECT blah
FROM (
	SELECT 'blah' AS blah
) AS b
WHERE blah = 'blah'

select the whole line of the where clause and increase the indent of it, either by the toolbar icon or the menu item. then place the mouse cursor at the end of the line (where the 'blah' is - make sure you click at the very last character)

Result:
Extra quote is added:

WHERE blah = 'blah''

Versions:

SQL Prompt 5.0.1.7

Microsoft SQL Server Management Studio 10.0.4000.0
Microsoft Analysis Services Client Tools 10.0.4000.0
Microsoft Data Access Components (MDAC) 3.85.1132
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 7.0.5730.11
Microsoft .NET Framework 2.0.50727.3615
Operating System 5.1.2600

MikeyC

I have found at least two ways to replicate this:

1) click in the left margin to select the entire WHERE line and hit TAB. The line is indented, the text is unselected, the cursor position is put at the end of the line, and a ' is added.
2) Select the WHERE line starting from the end and hit TAB, then click at the end of the line fairly quickly after it is indented. and the extra ' is added.

At least a portion of this is related to a bug I reported in v4: SP-2881

Anu D

Many thanks for your post Andy and apologies for inconvenience caused.

As specified by Micheal it is already logged in our internal tracking System (SP-2881) and I have added your comments to it.

I will update this forum thread as soon as it is fixed.