Formatting bug when using windowed functions

eugenen

I would not expect the t.* or the tables to be aligned/placed where they are. If you comment the first line i.e the sum then it formats properly

select
	sum(t.Amount) over (),
						t.*
from
						payment.Applications as a
						inner join payment.Transactions as t
							on t.ApplicationId = a.ApplicationId
where
						a.ExternalId = '506EAE98-5C08-49D6-B6FB-59710A00000F'


select
	--sum(t.Amount) over (),
	t.*
from
	payment.Applications as a
	inner join payment.Transactions as t
		on t.ApplicationId = a.ApplicationId
where
	a.ExternalId = '506EAE98-5C08-49D6-B6FB-59710A00000F'

Aaron L

Thanks for reporting this, it definitely looks wrong to me and will be fixed in the next update to prompt which should be released next week.

In the meantime you can download a private build (only had some basic testing) with a fix from here.