Bug in unpivot formatting fully qualified ?

[sov]

Formatting unpivot code below (which is correct T-SQL) results in failure "Error (6,21): '')'' expected"

Code: Select all

with SRC as
( select [1] = 1 )
select U.*
from SRC
unpivot
(Val for Col in (SRC.[1])) as U

Reason seems to be the alias SRC in SRC.[1]
Removing the alias (code below) and formatting is done without an error.

Code: Select all

with SRC as
( select [1] = 1 )
select U.*
from SRC
unpivot
(Val for Col in ([1])) as U

[alexa]

Could you please clarify what product you were referring to?

[sov]

Sorry, SQL Complete 4.0.72

[alexa]

This issue will be fixed in the next build of the product. We will notify you once it's available for downloading.