Bug in sql prompt GROUP BY suggestions (8.0.5.1758)

sdks

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

FabiolaB

Hi @sdks,

Thank you for reporting this. I've managed to reproduce the problem locally and I've created a bug (reference: SP-6558) to track it.

Best regards,

Fabiola

FabiolaB

Hello @sdks,

This issue should be fixed in our latest version of SQL Prompt 9.0.3.3299 (installer here).

You can find more information about this release in this forum post.

Kind regards,
Fabiola