Commit6131ffc

committed

Add tests for date_part of epoch near upper bound of timestamp range

This exercises a special case in the implementations ofdate_part('epoch', timestamp[tz]) that was previously not tested.

1 parent4753ef3 commit6131ffcCopy full SHA for 6131ffc

File tree

+20

-0

lines changed

+20

-0

lines changed

Lines changed: 7 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -1012,6 +1012,13 @@ SELECT d1 as "timestamp",`
`1012`	`1012`	`Mon Jan 01 17:32:01 2001 \| 200 \| 21 \| 3 \| 2451912 \| 978370321`
`1013`	`1013`	`(65 rows)`
`1014`	`1014`
	`1015`	`+-- value near upper bound uses special case in code`
	`1016`	`+SELECT date_part('epoch', '294270-01-01 00:00:00'::timestamp);`
	`1017`	`+ date_part`
	`1018`	`+---------------`
	`1019`	`+ 9224097091200`
	`1020`	`+(1 row)`
	`1021`	`+`
`1015`	`1022`	`-- TO_CHAR()`
`1016`	`1023`	`SELECT to_char(d1, 'DAY Day day DY Dy dy MONTH Month month RM MON Mon mon')`
`1017`	`1024`	`FROM TIMESTAMP_TBL;`

Lines changed: 7 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -1189,6 +1189,13 @@ SELECT d1 as timestamptz,`
`1189`	`1189`	`Mon Jan 01 17:32:01 2001 PST \| -28800 \| -8 \| 0`
`1190`	`1190`	`(66 rows)`
`1191`	`1191`
	`1192`	`+-- value near upper bound uses special case in code`
	`1193`	`+SELECT date_part('epoch', '294270-01-01 00:00:00+00'::timestamptz);`
	`1194`	`+ date_part`
	`1195`	`+---------------`
	`1196`	`+ 9224097091200`
	`1197`	`+(1 row)`
	`1198`	`+`
`1192`	`1199`	`-- TO_CHAR()`
`1193`	`1200`	`SELECT to_char(d1, 'DAY Day day DY Dy dy MONTH Month month RM MON Mon mon')`
`1194`	`1201`	`FROM TIMESTAMPTZ_TBL;`

Lines changed: 3 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -261,6 +261,9 @@ SELECT d1 as "timestamp",`
`261`	`261`	`date_part('epoch', d1)AS epoch`
`262`	`262`	`FROM TIMESTAMP_TBL;`
`263`	`263`
	`264`	`+-- value near upper bound uses special case in code`
	`265`	`+SELECT date_part('epoch','294270-01-01 00:00:00'::timestamp);`
	`266`	`+`
`264`	`267`	`-- TO_CHAR()`
`265`	`268`	`SELECT to_char(d1,'DAY Day day DY Dy dy MONTH Month month RM MON Mon mon')`
`266`	`269`	`FROM TIMESTAMP_TBL;`

Lines changed: 3 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -275,6 +275,9 @@ SELECT d1 as timestamptz,`
`275`	`275`	`date_part('timezone_minute', d1)AS timezone_minute`
`276`	`276`	`FROM TIMESTAMPTZ_TBL;`
`277`	`277`
	`278`	`+-- value near upper bound uses special case in code`
	`279`	`+SELECT date_part('epoch','294270-01-01 00:00:00+00'::timestamptz);`
	`280`	`+`
`278`	`281`	`-- TO_CHAR()`
`279`	`282`	`SELECT to_char(d1,'DAY Day day DY Dy dy MONTH Month month RM MON Mon mon')`
`280`	`283`	`FROM TIMESTAMPTZ_TBL;`

Comments

(0)