SQL Prompt version 8.0.0.1241 is moving comments between commas

gvarol@corelogic.com

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)

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!