8000 Fix platform-dependency in recently added regression tests. · postgrespro/postgres_cluster@784b948 · GitHub
[go: up one dir, main page]
Skip to content

Commit 784b948

Browse files
tglsfdctglsfdc
committed
Fix platform-dependency in recently added regression tests.
Per buildfarm results.
1 parent 539bc9f commit 784b948

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+< 10000 /span>
(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
SELECT count(*) FROM fast_emp4000 WHERE 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
SELECT count(*) FROM fast_emp4000 WHERE 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
SELECT count(*) FROM fast_emp4000 WHERE home_base && '(1000,1000,0,0)'::box;
134134

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

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

141141
SELECT count(*) FROM gpolygon_tbl WHERE 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
SELECT count(*) FROM fast_emp4000 WHERE home_base && '(1000,1000,0,0)'::box;
157157

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

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

164164
SELECT count(*) FROM gpolygon_tbl WHERE f1 && '(1000,1000,0,0)'::polygon;
165165

0 commit comments

Comments
 (0)
0