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

Formatting bug when using windowed functions

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'
eugenen
0

Comments

1 comment

Sort by
  • 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.
    Aaron L
    0

Add comment

Please sign in to leave a comment.