Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit7f1d68a

Browse files
committed
Fix the timestamptz test problem, by moving the tests that use the
timestamp_tbl table into the timestamp test. Also, restore a test thatused to exist as a valid test in the timestamptz test.
1 parent89b18bd commit7f1d68a

File tree

4 files changed

+287
-212
lines changed

4 files changed

+287
-212
lines changed

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

Lines changed: 205 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -1675,4 +1675,209 @@ SELECT '' AS to_timestamp_21, to_timestamp('2005364', 'IYYYIDDD');
16751675
| Sun Jan 01 00:00:00 2006 PST
16761676
(1 row)
16771677

1678+
SELECT '' AS "54", d1 as "timestamp",
1679+
date_part( 'isoyear', d1) AS isoyear, date_part( 'week', d1) AS week,
1680+
date_part( 'dow', d1) AS dow
1681+
FROM TIMESTAMP_TBL WHERE d1 BETWEEN '1902-01-01' AND '2038-01-01';
1682+
54 | timestamp | isoyear | week | dow
1683+
----+-----------------------------+---------+------+-----
1684+
| Thu Jan 01 00:00:00 1970 | 1970 | 1 | 4
1685+
| Mon Feb 10 17:32:01 1997 | 1997 | 7 | 1
1686+
| Mon Feb 10 17:32:01 1997 | 1997 | 7 | 1
1687+
| Mon Feb 10 17:32:02 1997 | 1997 | 7 | 1
1688+
| Mon Feb 10 17:32:01.40 1997 | 1997 | 7 | 1
1689+
| Mon Feb 10 17:32:01.50 1997 | 1997 | 7 | 1
1690+
| Mon Feb 10 17:32:01.60 1997 | 1997 | 7 | 1
1691+
| Thu Jan 02 00:00:00 1997 | 1997 | 1 | 4
1692+
| Thu Jan 02 03:04:05 1997 | 1997 | 1 | 4
1693+
| Mon Feb 10 17:32:01 1997 | 1997 | 7 | 1
1694+
| Mon Feb 10 17:32:01 1997 | 1997 | 7 | 1
1695+
| Mon Feb 10 17:32:01 1997 | 1997 | 7 | 1
1696+
| Mon Feb 10 17:32:01 1997 | 1997 | 7 | 1
1697+
| Tue Jun 10 17:32:01 1997 | 1997 | 24 | 2
1698+
| Sat Sep 22 18:19:20 2001 | 2001 | 38 | 6
1699+
| Wed Mar 15 08:14:01 2000 | 2000 | 11 | 3
1700+
| Wed Mar 15 13:14:02 2000 | 2000 | 11 | 3
1701+
| Wed Mar 15 12:14:03 2000 | 2000 | 11 | 3
1702+
| Wed Mar 15 03:14:04 2000 | 2000 | 11 | 3
1703+
| Wed Mar 15 02:14:05 2000 | 2000 | 11 | 3
1704+
| Mon Feb 10 17:32:01 1997 | 1997 | 7 | 1
1705+
| Mon Feb 10 17:32:01 1997 | 1997 | 7 | 1
1706+
| Mon Feb 10 17:32:00 1997 | 1997 | 7 | 1
1707+
| Mon Feb 10 17:32:01 1997 | 1997 | 7 | 1
1708+
| Mon Feb 10 17:32:01 1997 | 1997 | 7 | 1
1709+
| Mon Feb 10 17:32:01 1997 | 1997 | 7 | 1
1710+
| Mon Feb 10 17:32:01 1997 | 1997 | 7 | 1
1711+
| Mon Feb 10 17:32:01 1997 | 1997 | 7 | 1
1712+
| Mon Feb 10 17:32:01 1997 | 1997 | 7 | 1
1713+
| Mon Feb 10 17:32:01 1997 | 1997 | 7 | 1
1714+
| Mon Feb 10 17:32:01 1997 | 1997 | 7 | 1
1715+
| Mon Feb 10 17:32:01 1997 | 1997 | 7 | 1
1716+
| Tue Jun 10 18:32:01 1997 | 1997 | 24 | 2
1717+
| Mon Feb 10 17:32:01 1997 | 1997 | 7 | 1
1718+
| Tue Feb 11 17:32:01 1997 | 1997 | 7 | 2
1719+
| Wed Feb 12 17:32:01 1997 | 1997 | 7 | 3
1720+
| Thu Feb 13 17:32:01 1997 | 1997 | 7 | 4
1721+
| Fri Feb 14 17:32:01 1997 | 1997 | 7 | 5
1722+
| Sat Feb 15 17:32:01 1997 | 1997 | 7 | 6
1723+
| Sun Feb 16 17:32:01 1997 | 1997 | 7 | 0
1724+
| Sun Feb 16 17:32:01 1997 | 1997 | 7 | 0
1725+
| Wed Feb 28 17:32:01 1996 | 1996 | 9 | 3
1726+
| Thu Feb 29 17:32:01 1996 | 1996 | 9 | 4
1727+
| Fri Mar 01 17:32:01 1996 | 1996 | 9 | 5
1728+
| Mon Dec 30 17:32:01 1996 | 1997 | 1 | 1
1729+
| Tue Dec 31 17:32:01 1996 | 1997 | 1 | 2
1730+
| Wed Jan 01 17:32:01 1997 | 1997 | 1 | 3
1731+
| Fri Feb 28 17:32:01 1997 | 1997 | 9 | 5
1732+
| Sat Mar 01 17:32:01 1997 | 1997 | 9 | 6
1733+
| Tue Dec 30 17:32:01 1997 | 1998 | 1 | 2
1734+
| Wed Dec 31 17:32:01 1997 | 1998 | 1 | 3
1735+
| Fri Dec 31 17:32:01 1999 | 1999 | 52 | 5
1736+
| Sat Jan 01 17:32:01 2000 | 1999 | 52 | 6
1737+
| Sun Dec 31 17:32:01 2000 | 2000 | 52 | 0
1738+
| Mon Jan 01 17:32:01 2001 | 2001 | 1 | 1
1739+
(55 rows)
1740+
1741+
SELECT '' AS to_char_10, to_char(d1, 'IYYY IYY IY I IW IDDD ID')
1742+
FROM TIMESTAMP_TBL;
1743+
to_char_10 | to_char
1744+
------------+------------------------
1745+
|
1746+
|
1747+
| 1970 970 70 0 01 004 4
1748+
| 1997 997 97 7 07 043 1
1749+
| 1997 997 97 7 07 043 1
1750+
| 1997 997 97 7 07 043 1
1751+
| 1997 997 97 7 07 043 1
1752+
| 1997 997 97 7 07 043 1
1753+
| 1997 997 97 7 07 043 1
1754+
| 1997 997 97 7 01 004 4
1755+
| 1997 997 97 7 01 004 4
1756+
| 1997 997 97 7 07 043 1
1757+
| 1997 997 97 7 07 043 1
1758+
| 1997 997 97 7 07 043 1
1759+
| 1997 997 97 7 07 043 1
1760+
| 1997 997 97 7 24 163 2
1761+
| 2001 001 01 1 38 265 6
1762+
| 2000 000 00 0 11 073 3
1763+
| 2000 000 00 0 11 073 3
1764+
| 2000 000 00 0 11 073 3
1765+
| 2000 000 00 0 11 073 3
1766+
| 2000 000 00 0 11 073 3
1767+
| 1997 997 97 7 07 043 1
1768+
| 1997 997 97 7 07 043 1
1769+
| 1997 997 97 7 07 043 1
1770+
| 1997 997 97 7 07 043 1
1771+
| 1997 997 97 7 07 043 1
1772+
| 1997 997 97 7 07 043 1
1773+
| 1997 997 97 7 07 043 1
1774+
| 1997 997 97 7 07 043 1
1775+
| 1997 997 97 7 07 043 1
1776+
| 1997 997 97 7 07 043 1
1777+
| 1997 997 97 7 07 043 1
1778+
| 1997 997 97 7 07 043 1
1779+
| 1997 997 97 7 24 163 2
1780+
| 1997 997 97 7 07 043 1
1781+
| 1997 997 97 7 07 044 2
1782+
| 1997 997 97 7 07 045 3
1783+
| 1997 997 97 7 07 046 4
1784+
| 1997 997 97 7 07 047 5
1785+
| 1997 997 97 7 07 048 6
1786+
| 1997 997 97 7 07 049 7
1787+
| 0097 097 97 7 07 044 2
1788+
| 0097 097 97 7 07 048 6
1789+
| 0597 597 97 7 07 046 4
1790+
| 1097 097 97 7 07 044 2
1791+
| 1697 697 97 7 07 048 6
1792+
| 1797 797 97 7 07 046 4
1793+
| 1897 897 97 7 07 044 2
1794+
| 1997 997 97 7 07 049 7
1795+
| 2097 097 97 7 07 048 6
1796+
| 1996 996 96 6 09 059 3
1797+
| 1996 996 96 6 09 060 4
1798+
| 1996 996 96 6 09 061 5
1799+
| 1997 997 97 7 01 001 1
1800+
| 1997 997 97 7 01 002 2
1801+
| 1997 997 97 7 01 003 3
1802+
| 1997 997 97 7 09 061 5
1803+
| 1997 997 97 7 09 062 6
1804+
| 1998 998 98 8 01 002 2
1805+
| 1998 998 98 8 01 003 3
1806+
| 1999 999 99 9 52 362 5
1807+
| 1999 999 99 9 52 363 6
1808+
| 2000 000 00 0 52 364 7
1809+
| 2001 001 01 1 01 001 1
1810+
(65 rows)
1811+
1812+
SELECT '' AS to_char_11, to_char(d1, 'FMIYYY FMIYY FMIY FMI FMIW FMIDDD FMID')
1813+
FROM TIMESTAMP_TBL;
1814+
to_char_11 | to_char
1815+
------------+------------------------
1816+
|
1817+
|
1818+
| 1970 970 70 0 1 4 4
1819+
| 1997 997 97 7 7 43 1
1820+
| 1997 997 97 7 7 43 1
1821+
| 1997 997 97 7 7 43 1
1822+
| 1997 997 97 7 7 43 1
1823+
| 1997 997 97 7 7 43 1
1824+
| 1997 997 97 7 7 43 1
1825+
| 1997 997 97 7 1 4 4
1826+
| 1997 997 97 7 1 4 4
1827+
| 1997 997 97 7 7 43 1
1828+
| 1997 997 97 7 7 43 1
1829+
| 1997 997 97 7 7 43 1
1830+
| 1997 997 97 7 7 43 1
1831+
| 1997 997 97 7 24 163 2
1832+
| 2001 001 01 1 38 265 6
1833+
| 2000 000 00 0 11 73 3
1834+
| 2000 000 00 0 11 73 3
1835+
| 2000 000 00 0 11 73 3
1836+
| 2000 000 00 0 11 73 3
1837+
| 2000 000 00 0 11 73 3
1838+
| 1997 997 97 7 7 43 1
1839+
| 1997 997 97 7 7 43 1
1840+
| 1997 997 97 7 7 43 1
1841+
| 1997 997 97 7 7 43 1
1842+
| 1997 997 97 7 7 43 1
1843+
| 1997 997 97 7 7 43 1
1844+
| 1997 997 97 7 7 43 1
1845+
| 1997 997 97 7 7 43 1
1846+
| 1997 997 97 7 7 43 1
1847+
| 1997 997 97 7 7 43 1
1848+
| 1997 997 97 7 7 43 1
1849+
| 1997 997 97 7 7 43 1
1850+
| 1997 997 97 7 24 163 2
1851+
| 1997 997 97 7 7 43 1
1852+
| 1997 997 97 7 7 44 2
1853+
| 1997 997 97 7 7 45 3
1854+
| 1997 997 97 7 7 46 4
1855+
| 1997 997 97 7 7 47 5
1856+
| 1997 997 97 7 7 48 6
1857+
| 1997 997 97 7 7 49 7
1858+
| 97 097 97 7 7 44 2
1859+
| 97 097 97 7 7 48 6
1860+
| 597 597 97 7 7 46 4
1861+
| 1097 097 97 7 7 44 2
1862+
| 1697 697 97 7 7 48 6
1863+
| 1797 797 97 7 7 46 4
1864+
| 1897 897 97 7 7 44 2
1865+
| 1997 997 97 7 7 49 7
1866+
| 2097 097 97 7 7 48 6
1867+
| 1996 996 96 6 9 59 3
1868+
| 1996 996 96 6 9 60 4
1869+
| 1996 996 96 6 9 61 5
1870+
| 1997 997 97 7 1 1 1
1871+
| 1997 997 97 7 1 2 2
1872+
| 1997 997 97 7 1 3 3
1873+
| 1997 997 97 7 9 61 5
1874+
| 1997 997 97 7 9 62 6
1875+
| 1998 998 98 8 1 2 2
1876+
| 1998 998 98 8 1 3 3
1877+
| 1999 999 99 9 52 362 5
1878+
| 1999 999 99 9 52 363 6
1879+
| 2000 000 00 0 52 364 7
1880+
| 2001 001 01 1 1 1 1
1881+
(65 rows)
1882+
16781883
SET DateStyle TO DEFAULT;

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp