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

Commit784b948

Browse files
committed
Fix platform-dependency in recently added regression tests.
Per buildfarm results.
1 parent539bc9f commit784b948

File tree

2 files changed

+18
-18
lines changed

2 files changed

+18
-18
lines changed

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

Lines changed: 12 additions & 12 deletions
Original file line numberDiff line numberDiff line change
@@ -59,11 +59,11 @@ SET enable_indexscan = OFF;
5959
SET enable_bitmapscan = OFF;
6060
SELECT * FROM fast_emp4000
6161
WHERE home_base @ '(200,200),(2000,1000)'::box
62-
ORDER BY home_base USING <<;
62+
ORDER BY home_base USING <;
6363
home_base
6464
-----------------------
65-
(337,455),(240,359)
6665
(1444,403),(1346,344)
66+
(337,455),(240,359)
6767
(2 rows)
6868

6969
SELECT count(*) FROM fast_emp4000 WHERE home_base && '(1000,1000,0,0)'::box;
@@ -80,11 +80,11 @@ SET enable_bitmapscan = ON;
8080
-- changes too often for me to want to put an EXPLAIN in the test...)
8181
SELECT * FROM fast_emp4000
8282
WHERE home_base @ '(200,200),(2000,1000)'::box
83-
ORDER BY home_base USING <<;
83+
ORDER BY home_base USING <;
8484
home_base
8585
-----------------------
86-
(337,455),(240,359)
8786
(1444,403),(1346,344)
87+
(337,455),(240,359)
8888
(2 rows)
8989

9090
SELECT count(*) FROM fast_emp4000 WHERE home_base && '(1000,1000,0,0)'::box;
@@ -111,11 +111,11 @@ SET enable_indexscan = OFF;
111111
SET enable_bitmapscan = OFF;
112112
SELECT * FROM fast_emp4000
113113
WHERE home_base @ '(200,200),(2000,1000)'::box
114-
ORDER BY home_base USING <<;
114+
ORDER BY home_base USING <;
115115
home_base
116116
-----------------------
117-
(337,455),(240,359)
118117
(1444,403),(1346,344)
118+
(337,455),(240,359)
119119
(2 rows)
120120

121121
SELECT count(*) FROM fast_emp4000 WHERE home_base && '(1000,1000,0,0)'::box;
@@ -132,12 +132,12 @@ SELECT * FROM polygon_tbl WHERE f1 ~ '((1,1),(2,2),(2,1))'::polygon
132132
(1 row)
133133

134134
SELECT * FROM circle_tbl WHERE f1 && circle(point(1,-2), 1)
135-
ORDER BY f1 USING <<;
135+
ORDER BY f1 USING <;
136136
f1
137137
---------------
138+
<(1,2),3>
138139
<(1,3),5>
139140
<(1,2),100>
140-
<(1,2),3>
141141
<(100,1),115>
142142
(4 rows)
143143

@@ -161,11 +161,11 @@ SET enable_bitmapscan = ON;
161161
-- changes too often for me to want to put an EXPLAIN in the test...)
162162
SELECT * FROM fast_emp4000
163163
WHERE home_base @ '(200,200),(2000,1000)'::box
164-
ORDER BY home_base USING <<;
164+
ORDER BY home_base USING <;
165165
home_base
166166
-----------------------
167-
(337,455),(240,359)
168167
(1444,403),(1346,344)
168+
(337,455),(240,359)
169169
(2 rows)
170170

171171
SELECT count(*) FROM fast_emp4000 WHERE home_base && '(1000,1000,0,0)'::box;
@@ -182,12 +182,12 @@ SELECT * FROM polygon_tbl WHERE f1 ~ '((1,1),(2,2),(2,1))'::polygon
182182
(1 row)
183183

184184
SELECT * FROM circle_tbl WHERE f1 && circle(point(1,-2), 1)
185-
ORDER BY f1 USING <<;
185+
ORDER BY f1 USING <;
186186
f1
187187
---------------
188+
<(1,2),3>
188189
<(1,3),5>
189190
<(1,2),100>
190-
<(1,2),3>
191191
<(100,1),115>
192192
(4 rows)
193193

‎src/test/regress/sql/create_index.sql

Lines changed: 6 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -83,7 +83,7 @@ SET enable_bitmapscan = OFF;
8383

8484
SELECT*FROM fast_emp4000
8585
WHERE home_base @'(200,200),(2000,1000)'::box
86-
ORDER BY home_base USING<<;
86+
ORDER BY home_base USING<;
8787

8888
SELECTcount(*)FROM fast_emp4000WHERE home_base &&'(1000,1000,0,0)'::box;
8989

@@ -96,7 +96,7 @@ SET enable_bitmapscan = ON;
9696
-- changes too often for me to want to put an EXPLAIN in the test...)
9797
SELECT*FROM fast_emp4000
9898
WHERE home_base @'(200,200),(2000,1000)'::box
99-
ORDER BY home_base USING<<;
99+
ORDER BY home_base USING<;
100100

101101
SELECTcount(*)FROM fast_emp4000WHERE home_base &&'(1000,1000,0,0)'::box;
102102

@@ -128,15 +128,15 @@ SET enable_bitmapscan = OFF;
128128

129129
SELECT*FROM fast_emp4000
130130
WHERE home_base @'(200,200),(2000,1000)'::box
131-
ORDER BY home_base USING<<;
131+
ORDER BY home_base USING<;
132132

133133
SELECTcount(*)FROM fast_emp4000WHERE home_base &&'(1000,1000,0,0)'::box;
134134

135135
SELECT*FROM polygon_tblWHERE f1 ~'((1,1),(2,2),(2,1))'::polygon
136136
ORDER BY f1 USING<<;
137137

138138
SELECT*FROM circle_tblWHERE f1 &&circle(point(1,-2),1)
139-
ORDER BY f1 USING<<;
139+
ORDER BY f1 USING<;
140140

141141
SELECTcount(*)FROM gpolygon_tblWHERE f1 &&'(1000,1000,0,0)'::polygon;
142142

@@ -151,15 +151,15 @@ SET enable_bitmapscan = ON;
151151
-- changes too often for me to want to put an EXPLAIN in the test...)
152152
SELECT*FROM fast_emp4000
153153
WHERE home_base @'(200,200),(2000,1000)'::box
154-
ORDER BY home_base USING<<;
154+
ORDER BY home_base USING<;
155155

156156
SELECTcount(*)FROM fast_emp4000WHERE home_base &&'(1000,1000,0,0)'::box;
157157

158158
SELECT*FROM polygon_tblWHERE f1 ~'((1,1),(2,2),(2,1))'::polygon
159159
ORDER BY f1 USING<<;
160160

161161
SELECT*FROM circle_tblWHERE f1 &&circle(point(1,-2),1)
162-
ORDER BY f1 USING<<;
162+
ORDER BY f1 USING<;
163163

164164
SELECTcount(*)FROM gpolygon_tblWHERE f1 &&'(1000,1000,0,0)'::polygon;
165165

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp