Syntax hinghlight error on MS SQL temp tables

[XhmikosR]

This is Issue 80 moved from a Google Code project.
Added by 2012-05-29T06:44:49.000Z by alexey.b...@gmail.com.
Please review that bug for more context and additional comments, but update this bug.

Original labels: Type-Defect, Priority-High

Original description

Enter sample script like this^

SELECT *
FROM (
  SELECT ID
  FROM Table m WITH(NOLOCK)
    LEFT JOIN (SELECT ID FROM #Table WHERE ID > 0) t ON t.ID = m.ID
) t

and move to the first brace "(". It seems to be an error matching brace. But is we rewrite script like

SELECT *
FROM (
  SELECT ID
  FROM Table m WITH(NOLOCK)
    LEFT JOIN (SELECT ID FROM #Table WHERE ID > 0
  ) t ON t.ID = m.ID
) t

it'll be all correct

Noteapd2-mod v.4.2.25 rev. 735
MS Windows XP SP3