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

Commit99d3e27

Browse files
committed
Update tinterval test to have correctly sorted results,
now that bugs in pg_operator that caused wrongly sorted results havebeen corrected (I hope ... it works here, anyway).
1 parent478d460 commit99d3e27

File tree

1 file changed

+12
-12
lines changed

1 file changed

+12
-12
lines changed

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

Lines changed: 12 additions & 12 deletions
Original file line numberDiff line numberDiff line change
@@ -98,10 +98,10 @@ QUERY: SELECT '' AS five, t1.f1, t2.f1
9898
five|f1 |f1
9999
----+---------------------------------------------------------------+---------------------------------------------------------------
100100
|["-infinity" "infinity"] |["-infinity" "infinity"]
101-
|["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]|["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]
102-
|["epoch" "Mon May 01 00:30:30 1995 PDT"] |["epoch" "Mon May 01 00:30:30 1995 PDT"]
103101
|["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"]|["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"]
104102
|["Thu Feb 15 12:15:03 1990 PST" "current"] |["Thu Feb 15 12:15:03 1990 PST" "current"]
103+
|["epoch" "Mon May 01 00:30:30 1995 PDT"] |["epoch" "Mon May 01 00:30:30 1995 PDT"]
104+
|["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]|["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]
105105
(5 rows)
106106

107107
QUERY: SELECT '' AS fourteen, t1.f1 AS interval1, t2.f1 AS interval2
@@ -110,20 +110,20 @@ QUERY: SELECT '' AS fourteen, t1.f1 AS interval1, t2.f1 AS interval2
110110
ORDER BY interval1, interval2;
111111
fourteen|interval1 |interval2
112112
--------+---------------------------------------------------------------+---------------------------------------------------------------
113-
|["-infinity" "infinity"] |["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]
114113
|["-infinity" "infinity"] |["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"]
115-
|["-infinity" "infinity"] |["epoch" "Mon May 01 00:30:30 1995 PDT"]
116114
|["-infinity" "infinity"] |["Thu Feb 15 12:15:03 1990 PST" "current"]
117-
|["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]|["-infinity" "infinity"]
118-
|["epoch" "Mon May 01 00:30:30 1995 PDT"]|["-infinity" "infinity"]
115+
|["-infinity" "infinity"] |["epoch" "Mon May 01 00:30:30 1995 PDT"]
116+
|["-infinity" "infinity"]|["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]
119117
|["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"]|["-infinity" "infinity"]
118+
|["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"]|["epoch" "Mon May 01 00:30:30 1995 PDT"]
120119
|["Thu Feb 15 12:15:03 1990 PST" "current"] |["-infinity" "infinity"]
121-
|["epoch" "Mon May 01 00:30:30 1995 PDT"]|["SatMay10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]
122-
|["SatMay10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]|["epoch" "Mon May 01 00:30:30 1995 PDT"]
120+
|["Thu Feb 15 12:15:03 1990 PST" "current"] |["epoch" "MonMay01 00:30:30 1995 PDT"]
121+
|["epoch" "MonMay01 00:30:30 1995 PDT"]|["-infinity" "infinity"]
123122
|["epoch" "Mon May 01 00:30:30 1995 PDT"] |["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"]
124123
|["epoch" "Mon May 01 00:30:30 1995 PDT"] |["Thu Feb 15 12:15:03 1990 PST" "current"]
125-
|["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"]|["epoch" "Mon May 01 00:30:30 1995 PDT"]
126-
|["Thu Feb 15 12:15:03 1990 PST" "current"] |["epoch" "Mon May 01 00:30:30 1995 PDT"]
124+
|["epoch" "Mon May 01 00:30:30 1995 PDT"] |["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]
125+
|["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]|["-infinity" "infinity"]
126+
|["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]|["epoch" "Mon May 01 00:30:30 1995 PDT"]
127127
(14 rows)
128128

129129
QUERY: SELECT '' AS five, t1.f1
@@ -133,9 +133,9 @@ QUERY: SELECT '' AS five, t1.f1
133133
ORDER BY t1.f1;
134134
five|f1
135135
----+---------------------------------------------------------------
136-
|["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]
137136
|["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"]
138137
|["Thu Feb 15 12:15:03 1990 PST" "current"]
138+
|["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]
139139
(3 rows)
140140

141141
QUERY: SELECT '' AS three, t1.f1
@@ -147,8 +147,8 @@ QUERY: SELECT '' AS three, t1.f1
147147
three|f1
148148
-----+---------------------------------------------------------------
149149
|["-infinity" "infinity"]
150-
|["epoch" "Mon May 01 00:30:30 1995 PDT"]
151150
|["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"]
151+
|["epoch" "Mon May 01 00:30:30 1995 PDT"]
152152
(3 rows)
153153

154154
QUERY: RESET geqo;

0 commit comments

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