Bug in sql prompt GROUP BY suggestions (8.0.5.1758)

sdkssdks Posts: 44 Bronze 2
When you set your cursor after GROUP BY and hit ctrl + space and choose "All non-aggregate columns" then it breaks the code:
SELECT * FROM table1

ALTER FUNCTION [dbo].[fun] ()

returns table
return
(
SELECT i.INVOICE_REFERENCE                      AS lease_number
     , SUM(i.BALANCE_OUTSTANDING) balance_due_sum
  FROM dbo.invoices AS i
					  GROUP BY 
);

GO

And the output is:
SELECT * FROM table1

ALTER FUNCTION [dbo].[fun] ()

returns table
return
(
i.INVOICE_REFERENCE
);

GO
Tagged:

Comments

Sign In or Register to comment.