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

SQL Prompt version 8.0.0.1241 is moving comments between commas

When I format this statement with sql prompt 
SELECT * FROM sys.objects WHERE OBJECT_ID IN (/*1=*/ 0, /*2=*/ 0, /*3=*/ 0, /*4=*/ 0, /*5=*/ 0, /*6=*/ 0)

it formats to below, it moves comments around commas which should not happen 
SELECT * FROM [sys].[objects] WHERE [object_id] IN (/*1=*/ 0 /*2=*/, 0 /*3=*/, 0 /*4=*/, 0 /*5=*/, 0 /*6=*/, 0)
gvarol
0

Comments

1 comment

Sort by
  • James R
    Hi gvarol,

    Thanks for your post!
    I've managed to reproduce this issue here, it seems to be a bug with the "Place commas before items" option. I'll update you when we have a fix :)

    Thanks!
    James R
    0

Add comment

Please sign in to leave a comment.