Commit23a1f01

committed

Adjust interval-addition test so that it won't fail on DST transition days.

Strange that we missed this DST dependence while fixing the others.

1 parentf7ae900 commit23a1f01Copy full SHA for 23a1f01

File tree

-6

lines changed

-6

lines changed

Lines changed: 4 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -855,11 +855,11 @@ SELECT time with time zone '02:30-08' + interval '36:01' AS "14:31:00-08";`
`855`	`855`	`-- SELECT time with time zone '01:30' + interval '02:01' AS "03:31:00-08";`
`856`	`856`	`-- SELECT time with time zone '03:30' + interval '1 month 04:01' AS "07:31:00-08";`
`857`	`857`	`-- Try the following two tests instead, as a poor substitute`
`858`		`-SELECT CAST(CAST(date 'today' + time with time zone '01:30'`
`859`		`- + interval '02:01' AS time with time zone) AS time) AS "03:31:00";`
`860`		`-03:31:00`
	`858`	`+SELECT CAST(CAST(date 'today' + time with time zone '05:30'`
	`859`	`+ + interval '02:01' AS time with time zone) AS time) AS "07:31:00";`
	`860`	`+07:31:00`
`861`	`861`	`----------`
`862`		`-03:31:00`
	`862`	`+07:31:00`
`863`	`863`	`(1 row)`
`864`	`864`
`865`	`865`	`SELECT CAST(cast(date 'today' + time with time zone '03:30'`

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -153,8 +153,8 @@ SELECT time with time zone '02:30-08' + interval '36:01' AS "14:31:00-08";`
`153`	`153`	`-- SELECT time with time zone '03:30' + interval '1 month 04:01' AS "07:31:00-08";`
`154`	`154`	`-- Try the following two tests instead, as a poor substitute`
`155`	`155`
`156`		`-SELECT CAST(CAST(date'today'+time with time zone'01:30'`
`157`		`-+ interval'02:01'AStime with time zone)AStime)AS"03:31:00";`
	`156`	`+SELECT CAST(CAST(date'today'+time with time zone'05:30'`
	`157`	`++ interval'02:01'AStime with time zone)AStime)AS"07:31:00";`
`158`	`158`
`159`	`159`	`SELECT CAST(cast(date'today'+time with time zone'03:30'`
`160`	`160`	`+ interval'1 month 04:01'astimestamp without time zone)AStime)AS"07:31:00";`

Comments

(0)