No suggestion before analytical function

Provides intelligent code completion for SQL Server editors.

Moderators: Anu Deshpande, Aaron Law, David Priddle

No suggestion before analytical function

Postby buckley » Wed Feb 12, 2014 2:55 pm

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
 
Posts: 26
Joined: Thu Jan 26, 2006 2:45 pm

Postby Aaron Law » Thu Feb 13, 2014 10:41 am

I think you're correct and this is the same issue as your other post so hopefully a single fix will resolve both.
Aaron Law
 
Posts: 262
Joined: Fri Jun 28, 2013 10:56 am
Location: Red Gate Software

Postby buckley » Thu Feb 13, 2014 2:06 pm

OK, I'll report back if I found more similar cases
buckley
 
Posts: 26
Joined: Thu Jan 26, 2006 2:45 pm

Postby buckley » Thu Mar 06, 2014 3:53 pm

fixed with build 6.3.0.235. Thanks Aaron
buckley
 
Posts: 26
Joined: Thu Jan 26, 2006 2:45 pm


Return to SQL Prompt 6

Who is online

Users browsing this forum: No registered users and 0 guests