🌐 AI搜索 & 代理 主页
Skip to content

Commit efcc757

Browse files
peterepetere
committed
Clean up date_part tests a bit
Some tests for timestamp and timestamptz were in the date.sql test file. Move them to their appropriate files, or drop tests cases that were already present there.
1 parent f37fec8 commit efcc757

File tree

6 files changed

+147
-235
lines changed

6 files changed

+147
-235
lines changed

‎src/test/regress/expected/date.out‎

Lines changed: 2 additions & 78 deletions
Original file line numberDiff line numberDiff line change
@@ -971,18 +971,6 @@ SELECT EXTRACT(EPOCH FROM DATE '1970-01-01'); -- 0
971971
0
972972
(1 row)
973973

974-
SELECT EXTRACT(EPOCH FROM TIMESTAMP '1970-01-01'); -- 0
975-
date_part
976-
-----------
977-
0
978-
(1 row)
979-
980-
SELECT EXTRACT(EPOCH FROM TIMESTAMPTZ '1970-01-01+00'); -- 0
981-
date_part
982-
-----------
983-
0
984-
(1 row)
985-
986974
--
987975
-- century
988976
--
@@ -1137,22 +1125,6 @@ SELECT EXTRACT(DECADE FROM DATE '0012-12-31 BC'); -- -2
11371125
-2
11381126
(1 row)
11391127

1140-
--
1141-
-- some other types:
1142-
--
1143-
-- on a timestamp.
1144-
SELECT EXTRACT(CENTURY FROM NOW())>=21 AS True; -- true
1145-
true
1146-
------
1147-
t
1148-
(1 row)
1149-
1150-
SELECT EXTRACT(CENTURY FROM TIMESTAMP '1970-03-20 04:30:00.00000'); -- 20
1151-
date_part
1152-
-----------
1153-
20
1154-
(1 row)
1155-
11561128
--
11571129
-- all possible fields
11581130
--
@@ -1370,7 +1342,7 @@ select isfinite('infinity'::date), isfinite('-infinity'::date), isfinite('today'
13701342
(1 row)
13711343

13721344
--
1373-
-- oscillating fields from non-finite date/timestamptz:
1345+
-- oscillating fields from non-finite date:
13741346
--
13751347
SELECT EXTRACT(HOUR FROM DATE 'infinity'); -- NULL
13761348
date_part
@@ -1384,30 +1356,6 @@ SELECT EXTRACT(HOUR FROM DATE '-infinity'); -- NULL
13841356

13851357
(1 row)
13861358

1387-
SELECT EXTRACT(HOUR FROM TIMESTAMP 'infinity'); -- NULL
1388-
date_part
1389-
-----------
1390-
1391-
(1 row)
1392-
1393-
SELECT EXTRACT(HOUR FROM TIMESTAMP '-infinity'); -- NULL
1394-
date_part
1395-
-----------
1396-
1397-
(1 row)
1398-
1399-
SELECT EXTRACT(HOUR FROM TIMESTAMPTZ 'infinity'); -- NULL
1400-
date_part
1401-
-----------
1402-
1403-
(1 row)
1404-
1405-
SELECT EXTRACT(HOUR FROM TIMESTAMPTZ '-infinity'); -- NULL
1406-
date_part
1407-
-----------
1408-
1409-
(1 row)
1410-
14111359
-- all possible fields
14121360
SELECT EXTRACT(MICROSECONDS FROM DATE 'infinity'); -- NULL
14131361
date_part
@@ -1500,7 +1448,7 @@ SELECT EXTRACT(TIMEZONE_H FROM DATE 'infinity'); -- NULL
15001448
(1 row)
15011449

15021450
--
1503-
-- monotonic fields from non-finite date/timestamptz:
1451+
-- monotonic fields from non-finite date:
15041452
--
15051453
SELECT EXTRACT(EPOCH FROM DATE 'infinity'); -- Infinity
15061454
date_part
@@ -1514,30 +1462,6 @@ SELECT EXTRACT(EPOCH FROM DATE '-infinity'); -- -Infinity
15141462
-Infinity
15151463
(1 row)
15161464

1517-
SELECT EXTRACT(EPOCH FROM TIMESTAMP 'infinity'); -- Infinity
1518-
date_part
1519-
-----------
1520-
Infinity
1521-
(1 row)
1522-
1523-
SELECT EXTRACT(EPOCH FROM TIMESTAMP '-infinity'); -- -Infinity
1524-
date_part
1525-
-----------
1526-
-Infinity
1527-
(1 row)
1528-
1529-
SELECT EXTRACT(EPOCH FROM TIMESTAMPTZ 'infinity'); -- Infinity
1530-
date_part
1531-
-----------
1532-
Infinity
1533-
(1 row)
1534-
1535-
SELECT EXTRACT(EPOCH FROM TIMESTAMPTZ '-infinity'); -- -Infinity
1536-
date_part
1537-
-----------
1538-
-Infinity
1539-
(1 row)
1540-
15411465
-- all possible fields
15421466
SELECT EXTRACT(YEAR FROM DATE 'infinity'); -- Infinity
15431467
date_part

‎src/test/regress/expected/timestamp.out‎

Lines changed: 69 additions & 68 deletions
Original file line numberDiff line numberDiff line change
@@ -931,75 +931,76 @@ SELECT d1 as "timestamp",
931931
date_part( 'decade', d1) AS decade,
932932
date_part( 'century', d1) AS century,
933933
date_part( 'millennium', d1) AS millennium,
934-
round(date_part( 'julian', d1)) AS julian
934+
round(date_part( 'julian', d1)) AS julian,
935+
date_part( 'epoch', d1) AS epoch
935936
FROM TIMESTAMP_TBL;
936-
timestamp | decade | century | millennium | julian
937-
-----------------------------+-----------+-----------+------------+-----------
938-
-infinity | -Infinity | -Infinity | -Infinity | -Infinity
939-
infinity | Infinity | Infinity | Infinity | Infinity
940-
Thu Jan 01 00:00:00 1970 | 197 | 20 | 2 | 2440588
941-
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491
942-
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491
943-
Mon Feb 10 17:32:02 1997 | 199 | 20 | 2 | 2450491
944-
Mon Feb 10 17:32:01.4 1997 | 199 | 20 | 2 | 2450491
945-
Mon Feb 10 17:32:01.5 1997 | 199 | 20 | 2 | 2450491
946-
Mon Feb 10 17:32:01.6 1997 | 199 | 20 | 2 | 2450491
947-
Thu Jan 02 00:00:00 1997 | 199 | 20 | 2 | 2450451
948-
Thu Jan 02 03:04:05 1997 | 199 | 20 | 2 | 2450451
949-
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491
950-
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491
951-
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491
952-
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491
953-
Tue Jun 10 17:32:01 1997 | 199 | 20 | 2 | 2450611
954-
Sat Sep 22 18:19:20 2001 | 200 | 21 | 3 | 2452176
955-
Wed Mar 15 08:14:01 2000 | 200 | 20 | 2 | 2451619
956-
Wed Mar 15 13:14:02 2000 | 200 | 20 | 2 | 2451620
957-
Wed Mar 15 12:14:03 2000 | 200 | 20 | 2 | 2451620
958-
Wed Mar 15 03:14:04 2000 | 200 | 20 | 2 | 2451619
959-
Wed Mar 15 02:14:05 2000 | 200 | 20 | 2 | 2451619
960-
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491
961-
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491
962-
Mon Feb 10 17:32:00 1997 | 199 | 20 | 2 | 2450491
963-
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491
964-
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491
965-
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491
966-
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491
967-
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491
968-
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491
969-
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491
970-
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491
971-
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491
972-
Tue Jun 10 18:32:01 1997 | 199 | 20 | 2 | 2450611
973-
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491
974-
Tue Feb 11 17:32:01 1997 | 199 | 20 | 2 | 2450492
975-
Wed Feb 12 17:32:01 1997 | 199 | 20 | 2 | 2450493
976-
Thu Feb 13 17:32:01 1997 | 199 | 20 | 2 | 2450494
977-
Fri Feb 14 17:32:01 1997 | 199 | 20 | 2 | 2450495
978-
Sat Feb 15 17:32:01 1997 | 199 | 20 | 2 | 2450496
979-
Sun Feb 16 17:32:01 1997 | 199 | 20 | 2 | 2450497
980-
Tue Feb 16 17:32:01 0097 BC | -10 | -1 | -1 | 1686043
981-
Sat Feb 16 17:32:01 0097 | 9 | 1 | 1 | 1756537
982-
Thu Feb 16 17:32:01 0597 | 59 | 6 | 1 | 1939158
983-
Tue Feb 16 17:32:01 1097 | 109 | 11 | 2 | 2121779
984-
Sat Feb 16 17:32:01 1697 | 169 | 17 | 2 | 2340925
985-
Thu Feb 16 17:32:01 1797 | 179 | 18 | 2 | 2377449
986-
Tue Feb 16 17:32:01 1897 | 189 | 19 | 2 | 2413973
987-
Sun Feb 16 17:32:01 1997 | 199 | 20 | 2 | 2450497
988-
Sat Feb 16 17:32:01 2097 | 209 | 21 | 3 | 2487022
989-
Wed Feb 28 17:32:01 1996 | 199 | 20 | 2 | 2450143
990-
Thu Feb 29 17:32:01 1996 | 199 | 20 | 2 | 2450144
991-
Fri Mar 01 17:32:01 1996 | 199 | 20 | 2 | 2450145
992-
Mon Dec 30 17:32:01 1996 | 199 | 20 | 2 | 2450449
993-
Tue Dec 31 17:32:01 1996 | 199 | 20 | 2 | 2450450
994-
Wed Jan 01 17:32:01 1997 | 199 | 20 | 2 | 2450451
995-
Fri Feb 28 17:32:01 1997 | 199 | 20 | 2 | 2450509
996-
Sat Mar 01 17:32:01 1997 | 199 | 20 | 2 | 2450510
997-
Tue Dec 30 17:32:01 1997 | 199 | 20 | 2 | 2450814
998-
Wed Dec 31 17:32:01 1997 | 199 | 20 | 2 | 2450815
999-
Fri Dec 31 17:32:01 1999 | 199 | 20 | 2 | 2451545
1000-
Sat Jan 01 17:32:01 2000 | 200 | 20 | 2 | 2451546
1001-
Sun Dec 31 17:32:01 2000 | 200 | 20 | 2 | 2451911
1002-
Mon Jan 01 17:32:01 2001 | 200 | 21 | 3 | 2451912
937+
timestamp | decade | century | millennium | julian | epoch
938+
-----------------------------+-----------+-----------+------------+-----------+--------------
939+
-infinity | -Infinity | -Infinity | -Infinity | -Infinity | -Infinity
940+
infinity | Infinity | Infinity | Infinity | Infinity | Infinity
941+
Thu Jan 01 00:00:00 1970 | 197 | 20 | 2 | 2440588 | 0
942+
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491 | 855595921
943+
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491 | 855595921
944+
Mon Feb 10 17:32:02 1997 | 199 | 20 | 2 | 2450491 | 855595922
945+
Mon Feb 10 17:32:01.4 1997 | 199 | 20 | 2 | 2450491 | 855595921.4
946+
Mon Feb 10 17:32:01.5 1997 | 199 | 20 | 2 | 2450491 | 855595921.5
947+
Mon Feb 10 17:32:01.6 1997 | 199 | 20 | 2 | 2450491 | 855595921.6
948+
Thu Jan 02 00:00:00 1997 | 199 | 20 | 2 | 2450451 | 852163200
949+
Thu Jan 02 03:04:05 1997 | 199 | 20 | 2 | 2450451 | 852174245
950+
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491 | 855595921
951+
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491 | 855595921
952+
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491 | 855595921
953+
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491 | 855595921
954+
Tue Jun 10 17:32:01 1997 | 199 | 20 | 2 | 2450611 | 865963921
955+
Sat Sep 22 18:19:20 2001 | 200 | 21 | 3 | 2452176 | 1001182760
956+
Wed Mar 15 08:14:01 2000 | 200 | 20 | 2 | 2451619 | 953108041
957+
Wed Mar 15 13:14:02 2000 | 200 | 20 | 2 | 2451620 | 953126042
958+
Wed Mar 15 12:14:03 2000 | 200 | 20 | 2 | 2451620 | 953122443
959+
Wed Mar 15 03:14:04 2000 | 200 | 20 | 2 | 2451619 | 953090044
960+
Wed Mar 15 02:14:05 2000 | 200 | 20 | 2 | 2451619 | 953086445
961+
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491 | 855595921
962+
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491 | 855595921
963+
Mon Feb 10 17:32:00 1997 | 199 | 20 | 2 | 2450491 | 855595920
964+
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491 | 855595921
965+
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491 | 855595921
966+
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491 | 855595921
967+
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491 | 855595921
968+
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491 | 855595921
969+
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491 | 855595921
970+
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491 | 855595921
971+
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491 | 855595921
972+
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491 | 855595921
973+
Tue Jun 10 18:32:01 1997 | 199 | 20 | 2 | 2450611 | 865967521
974+
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491 | 855595921
975+
Tue Feb 11 17:32:01 1997 | 199 | 20 | 2 | 2450492 | 855682321
976+
Wed Feb 12 17:32:01 1997 | 199 | 20 | 2 | 2450493 | 855768721
977+
Thu Feb 13 17:32:01 1997 | 199 | 20 | 2 | 2450494 | 855855121
978+
Fri Feb 14 17:32:01 1997 | 199 | 20 | 2 | 2450495 | 855941521
979+
Sat Feb 15 17:32:01 1997 | 199 | 20 | 2 | 2450496 | 856027921
980+
Sun Feb 16 17:32:01 1997 | 199 | 20 | 2 | 2450497 | 856114321
981+
Tue Feb 16 17:32:01 0097 BC | -10 | -1 | -1 | 1686043 | -65192711279
982+
Sat Feb 16 17:32:01 0097 | 9 | 1 | 1 | 1756537 | -59102029679
983+
Thu Feb 16 17:32:01 0597 | 59 | 6 | 1 | 1939158 | -43323575279
984+
Tue Feb 16 17:32:01 1097 | 109 | 11 | 2 | 2121779 | -27545120879
985+
Sat Feb 16 17:32:01 1697 | 169 | 17 | 2 | 2340925 | -8610906479
986+
Thu Feb 16 17:32:01 1797 | 179 | 18 | 2 | 2377449 | -5455232879
987+
Tue Feb 16 17:32:01 1897 | 189 | 19 | 2 | 2413973 | -2299559279
988+
Sun Feb 16 17:32:01 1997 | 199 | 20 | 2 | 2450497 | 856114321
989+
Sat Feb 16 17:32:01 2097 | 209 | 21 | 3 | 2487022 | 4011874321
990+
Wed Feb 28 17:32:01 1996 | 199 | 20 | 2 | 2450143 | 825528721
991+
Thu Feb 29 17:32:01 1996 | 199 | 20 | 2 | 2450144 | 825615121
992+
Fri Mar 01 17:32:01 1996 | 199 | 20 | 2 | 2450145 | 825701521
993+
Mon Dec 30 17:32:01 1996 | 199 | 20 | 2 | 2450449 | 851967121
994+
Tue Dec 31 17:32:01 1996 | 199 | 20 | 2 | 2450450 | 852053521
995+
Wed Jan 01 17:32:01 1997 | 199 | 20 | 2 | 2450451 | 852139921
996+
Fri Feb 28 17:32:01 1997 | 199 | 20 | 2 | 2450509 | 857151121
997+
Sat Mar 01 17:32:01 1997 | 199 | 20 | 2 | 2450510 | 857237521
998+
Tue Dec 30 17:32:01 1997 | 199 | 20 | 2 | 2450814 | 883503121
999+
Wed Dec 31 17:32:01 1997 | 199 | 20 | 2 | 2450815 | 883589521
1000+
Fri Dec 31 17:32:01 1999 | 199 | 20 | 2 | 2451545 | 946661521
1001+
Sat Jan 01 17:32:01 2000 | 200 | 20 | 2 | 2451546 | 946747921
1002+
Sun Dec 31 17:32:01 2000 | 200 | 20 | 2 | 2451911 | 978283921
1003+
Mon Jan 01 17:32:01 2001 | 200 | 21 | 3 | 2451912 | 978370321
10031004
(65 rows)
10041005

10051006
-- TO_CHAR()

0 commit comments

Comments
 (0)