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

Bug in sql prompt GROUP BY suggestions (8.0.5.1758)

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

Comments

2 comments

Sort by
  • 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
    0
  • 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
    FabiolaB
    0

Add comment

Please sign in to leave a comment.