What are the challenges you face when working across database platforms? Take the survey
Options

Formatting bug when using windowed functions

eugeneneugenen Posts: 6 Bronze 1
edited November 12, 2013 1:47PM in SQL Prompt
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'

Comments

  • Options
    Aaron LAaron L Posts: 596 New member
    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.
Sign In or Register to comment.