No suggestion before analytical function

buckley

I took the time to come up with this self contained example.

Can you reproduce ?

SELECT
*,
d. -- no intellisense
COUNT(*) OVER (PARTITION BY col1) AS myCount

FROM
(SELECT
1 col1,
'A' col2
UNION ALL
SELECT
1 col1,
'B' col2
UNION ALL
SELECT
2 col1,
'A' col2
UNION ALL
SELECT
2 col1,
'B' col2) d


It's probably related to the following reported case

http://www.red-gate.com/MessageBoard/vi ... hp?p=67146

Aaron L

I think you're correct and this is the same issue as your other post so hopefully a single fix will resolve both.

buckley

OK, I'll report back if I found more similar cases

buckley

fixed with build 6.3.0.235. Thanks Aaron