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

Commit374b000

Browse files
author
Thomas G. Lockhart
committed
Fix predicted output for month boundary arithmetic problems in
 datetime +/- timespan. Only manifested when date is at end of month and time pushes the date into the next month.
1 parent2f09dd9 commit374b000

File tree

2 files changed

+13
-13
lines changed

2 files changed

+13
-13
lines changed

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

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -443,7 +443,7 @@ sixtythree|one_year
443443
|Wed Feb 16 17:32:01.00 1898
444444
|Mon Feb 16 17:32:01.00 1998 PST
445445
|Sun Feb 16 17:32:01.00 2098
446-
|Thu Feb27 17:32:01.00 1997 PST
446+
|Fri Feb28 17:32:01.00 1997 PST
447447
|Fri Feb 28 17:32:01.00 1997 PST
448448
|Sat Mar 01 17:32:01.00 1997 PST
449449
|Tue Dec 30 17:32:01.00 1997 PST
@@ -510,13 +510,13 @@ sixtythree|one_year
510510
|Sun Feb 16 17:32:01.00 1896
511511
|Fri Feb 16 17:32:01.00 1996 PST
512512
|Thu Feb 16 17:32:01.00 2096
513-
|Mon Feb27 17:32:01.00 1995 PST
513+
|Tue Feb28 17:32:01.00 1995 PST
514514
|Tue Feb 28 17:32:01.00 1995 PST
515515
|Wed Mar 01 17:32:01.00 1995 PST
516516
|Sat Dec 30 17:32:01.00 1995 PST
517517
|Sun Dec 31 17:32:01.00 1995 PST
518518
|Mon Jan 01 17:32:01.00 1996 PST
519-
|Thu Feb29 17:32:01.00 1996 PST
519+
|Wed Feb28 17:32:01.00 1996 PST
520520
|Fri Mar 01 17:32:01.00 1996 PST
521521
|Fri Mar 01 17:32:01.00 1996 PST
522522
|Mon Dec 30 17:32:01.00 1996 PST

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

Lines changed: 10 additions & 10 deletions
Original file line numberDiff line numberDiff line change
@@ -50,11 +50,11 @@ hundred|datetime |timespan |plus
5050
|Thu Feb 29 17:32:01.00 1996 PST|@ 10 days |Sun Mar 10 17:32:01.00 1996 PST
5151
|Fri Mar 01 17:32:01.00 1996 PST|@ 10 days |Mon Mar 11 17:32:01.00 1996 PST
5252
|Wed Feb 28 17:32:01.00 1996 PST|@ 3 mons |Tue May 28 18:32:01.00 1996 PDT
53-
|Thu Feb 29 17:32:01.00 1996 PST|@ 3 mons |Fri May31 18:32:01.00 1996 PDT
53+
|Thu Feb 29 17:32:01.00 1996 PST|@ 3 mons |Wed May29 18:32:01.00 1996 PDT
5454
|Fri Mar 01 17:32:01.00 1996 PST|@ 3 mons |Sat Jun 01 18:32:01.00 1996 PDT
5555
|Wed Feb 28 17:32:01.00 1996 PST|@ 5 mons |Sun Jul 28 18:32:01.00 1996 PDT
5656
|Wed Feb 28 17:32:01.00 1996 PST|@ 5 mons 12 hours |Mon Jul 29 06:32:01.00 1996 PDT
57-
|Thu Feb 29 17:32:01.00 1996 PST|@ 5 mons |Wed Jul31 18:32:01.00 1996 PDT
57+
|Thu Feb 29 17:32:01.00 1996 PST|@ 5 mons |Mon Jul29 18:32:01.00 1996 PDT
5858
|Thu Feb 29 17:32:01.00 1996 PST|@ 5 mons 12 hours |Thu Aug 01 06:32:01.00 1996 PDT
5959
|Fri Mar 01 17:32:01.00 1996 PST|@ 5 mons |Thu Aug 01 18:32:01.00 1996 PDT
6060
|Fri Mar 01 17:32:01.00 1996 PST|@ 5 mons 12 hours |Fri Aug 02 06:32:01.00 1996 PDT
@@ -106,8 +106,8 @@ hundred|datetime |timespan |plus
106106
|Sun Dec 31 17:32:01.00 2000 PST|@ 5 mons 12 hours |Fri Jun 01 06:32:01.00 2001 PDT
107107
|Mon Jan 01 17:32:01.00 2001 PST|@ 5 mons |Fri Jun 01 18:32:01.00 2001 PDT
108108
|Mon Jan 01 17:32:01.00 2001 PST|@ 5 mons 12 hours |Sat Jun 02 06:32:01.00 2001 PDT
109-
|Wed Feb 28 17:32:01.00 1996 PST|@ 6 years |Wed Feb 27 17:32:01.00 2002 PST
110109
|Thu Feb 29 17:32:01.00 1996 PST|@ 6 years |Thu Feb 28 17:32:01.00 2002 PST
110+
|Wed Feb 28 17:32:01.00 1996 PST|@ 6 years |Thu Feb 28 17:32:01.00 2002 PST
111111
|Fri Mar 01 17:32:01.00 1996 PST|@ 6 years |Fri Mar 01 17:32:01.00 2002 PST
112112
|Mon Dec 30 17:32:01.00 1996 PST|@ 6 years |Mon Dec 30 17:32:01.00 2002 PST
113113
|Tue Dec 31 17:32:01.00 1996 PST|@ 6 years |Tue Dec 31 17:32:01.00 2002 PST
@@ -116,8 +116,8 @@ hundred|datetime |timespan |plus
116116
|Sat Jan 01 17:32:01.00 2000 PST|@ 6 years |Sun Jan 01 17:32:01.00 2006 PST
117117
|Sun Dec 31 17:32:01.00 2000 PST|@ 6 years |Sun Dec 31 17:32:01.00 2006 PST
118118
|Mon Jan 01 17:32:01.00 2001 PST|@ 6 years |Mon Jan 01 17:32:01.00 2007 PST
119-
|Wed Feb 28 17:32:01.00 1996 PST|@ 34 years |Wed Feb 27 17:32:01.00 2030 PST
120119
|Thu Feb 29 17:32:01.00 1996 PST|@ 34 years |Thu Feb 28 17:32:01.00 2030 PST
120+
|Wed Feb 28 17:32:01.00 1996 PST|@ 34 years |Thu Feb 28 17:32:01.00 2030 PST
121121
|Fri Mar 01 17:32:01.00 1996 PST|@ 34 years |Fri Mar 01 17:32:01.00 2030 PST
122122
|Mon Dec 30 17:32:01.00 1996 PST|@ 34 years |Mon Dec 30 17:32:01.00 2030 PST
123123
|Tue Dec 31 17:32:01.00 1996 PST|@ 34 years |Tue Dec 31 17:32:01.00 2030 PST
@@ -134,8 +134,8 @@ QUERY: SELECT '' AS hundred, d.f1 AS datetime, t.f1 AS timespan, d.f1 - t.f1 AS
134134
hundred|datetime |timespan |minus
135135
-------+-------------------------------+-----------------------------+-------------------------------
136136
|epoch |@ 34 years |Tue Dec 31 16:00:00.00 1935 PST
137-
|Wed Feb 28 17:32:01.00 1996 PST|@ 34 years |Tue Feb 27 17:32:01.00 1962 PST
138137
|Thu Feb 29 17:32:01.00 1996 PST|@ 34 years |Wed Feb 28 17:32:01.00 1962 PST
138+
|Wed Feb 28 17:32:01.00 1996 PST|@ 34 years |Wed Feb 28 17:32:01.00 1962 PST
139139
|Fri Mar 01 17:32:01.00 1996 PST|@ 34 years |Thu Mar 01 17:32:01.00 1962 PST
140140
|Mon Dec 30 17:32:01.00 1996 PST|@ 34 years |Sun Dec 30 17:32:01.00 1962 PST
141141
|Tue Dec 31 17:32:01.00 1996 PST|@ 34 years |Mon Dec 31 17:32:01.00 1962 PST
@@ -152,8 +152,8 @@ hundred|datetime |timespan |minus
152152
|epoch |@ 5 hours |Wed Dec 31 11:00:00.00 1969 PST
153153
|epoch |@ 1 min |Wed Dec 31 15:59:00.00 1969 PST
154154
|epoch |@ 14 secs ago |Wed Dec 31 16:00:14.00 1969 PST
155-
|Wed Feb 28 17:32:01.00 1996 PST|@ 6 years |Tue Feb 27 17:32:01.00 1990 PST
156155
|Thu Feb 29 17:32:01.00 1996 PST|@ 6 years |Wed Feb 28 17:32:01.00 1990 PST
156+
|Wed Feb 28 17:32:01.00 1996 PST|@ 6 years |Wed Feb 28 17:32:01.00 1990 PST
157157
|Fri Mar 01 17:32:01.00 1996 PST|@ 6 years |Thu Mar 01 17:32:01.00 1990 PST
158158
|Mon Dec 30 17:32:01.00 1996 PST|@ 6 years |Sun Dec 30 17:32:01.00 1990 PST
159159
|Tue Dec 31 17:32:01.00 1996 PST|@ 6 years |Mon Dec 31 17:32:01.00 1990 PST
@@ -163,12 +163,12 @@ hundred|datetime |timespan |minus
163163
|Mon Jan 01 17:32:01.00 2001 PST|@ 6 years |Sun Jan 01 17:32:01.00 1995 PST
164164
|Wed Feb 28 17:32:01.00 1996 PST|@ 5 mons 12 hours |Thu Sep 28 06:32:01.00 1995 PDT
165165
|Wed Feb 28 17:32:01.00 1996 PST|@ 5 mons |Thu Sep 28 18:32:01.00 1995 PDT
166-
|Thu Feb 29 17:32:01.00 1996 PST|@ 5 mons 12 hours |Sat Sep30 06:32:01.00 1995 PDT
167-
|Thu Feb 29 17:32:01.00 1996 PST|@ 5 mons |Sat Sep30 18:32:01.00 1995 PDT
166+
|Thu Feb 29 17:32:01.00 1996 PST|@ 5 mons 12 hours |Fri Sep29 06:32:01.00 1995 PDT
167+
|Thu Feb 29 17:32:01.00 1996 PST|@ 5 mons |Fri Sep29 18:32:01.00 1995 PDT
168168
|Fri Mar 01 17:32:01.00 1996 PST|@ 5 mons 12 hours |Sun Oct 01 06:32:01.00 1995 PDT
169169
|Fri Mar 01 17:32:01.00 1996 PST|@ 5 mons |Sun Oct 01 18:32:01.00 1995 PDT
170170
|Wed Feb 28 17:32:01.00 1996 PST|@ 3 mons |Tue Nov 28 17:32:01.00 1995 PST
171-
|Thu Feb 29 17:32:01.00 1996 PST|@ 3 mons |Thu Nov30 17:32:01.00 1995 PST
171+
|Thu Feb 29 17:32:01.00 1996 PST|@ 3 mons |Wed Nov29 17:32:01.00 1995 PST
172172
|Fri Mar 01 17:32:01.00 1996 PST|@ 3 mons |Fri Dec 01 17:32:01.00 1995 PST
173173
|Wed Feb 28 17:32:01.00 1996 PST|@ 10 days |Sun Feb 18 17:32:01.00 1996 PST
174174
|Thu Feb 29 17:32:01.00 1996 PST|@ 10 days |Mon Feb 19 17:32:01.00 1996 PST
@@ -189,8 +189,8 @@ hundred|datetime |timespan |minus
189189
|Mon Dec 30 17:32:01.00 1996 PST|@ 5 mons |Tue Jul 30 18:32:01.00 1996 PDT
190190
|Tue Dec 31 17:32:01.00 1996 PST|@ 5 mons 12 hours |Wed Jul 31 06:32:01.00 1996 PDT
191191
|Tue Dec 31 17:32:01.00 1996 PST|@ 5 mons |Wed Jul 31 18:32:01.00 1996 PDT
192-
|Mon Dec 30 17:32:01.00 1996 PST|@ 3 mons |Sun Sep 29 18:32:01.00 1996 PDT
193192
|Tue Dec 31 17:32:01.00 1996 PST|@ 3 mons |Mon Sep 30 18:32:01.00 1996 PDT
193+
|Mon Dec 30 17:32:01.00 1996 PST|@ 3 mons |Mon Sep 30 18:32:01.00 1996 PDT
194194
|Mon Dec 30 17:32:01.00 1996 PST|@ 10 days |Fri Dec 20 17:32:01.00 1996 PST
195195
|Tue Dec 31 17:32:01.00 1996 PST|@ 10 days |Sat Dec 21 17:32:01.00 1996 PST
196196
|Mon Dec 30 17:32:01.00 1996 PST|@ 1 day 2 hours 3 mins 4 secs|Sun Dec 29 15:28:57.00 1996 PST

0 commit comments

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