How can we help you today? How can we help you today?

No suggestion before analytical function

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
buckley
0

Comments

3 comments

Sort by
  • 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.
    Aaron L
    0
  • buckley
    OK, I'll report back if I found more similar cases
    buckley
    0
  • buckley
    fixed with build 6.3.0.235. Thanks Aaron
    buckley
    0

Add comment

Please sign in to leave a comment.