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

Commitcf7da1a

Browse files
committed
Make tests pass in 32 bit OS. In 32 bit OS RUM doesn't support order by over pass-by-reference column
1 parent308bfdd commitcf7da1a

File tree

5 files changed

+570
-144
lines changed

5 files changed

+570
-144
lines changed

‎expected/altorder_1.out

Lines changed: 4 additions & 36 deletions
Original file line numberDiff line numberDiff line change
@@ -204,15 +204,7 @@ SELECT id, d, d <=> '2016-05-16 14:21:25' FROM atsts WHERE t @@ 'wr&qh' ORDER BY
204204
(5 rows)
205205

206206
SELECT id, d, d <=> '2016-05-16 14:21:25' FROM atsts WHERE t @@ 'wr&qh' ORDER BY d <=> '2016-05-16 14:21:25' LIMIT 5;
207-
id | d | ?column?
208-
-----+---------------------------------+---------------
209-
355 | Mon May 16 14:21:22.326724 2016 | 2.673276
210-
354 | Mon May 16 13:21:22.326724 2016 | 3602.673276
211-
371 | Tue May 17 06:21:22.326724 2016 | 57597.326724
212-
406 | Wed May 18 17:21:22.326724 2016 | 183597.326724
213-
415 | Thu May 19 02:21:22.326724 2016 | 215997.326724
214-
(5 rows)
215-
207+
ERROR: doesn't support order by over pass-by-reference column
216208
EXPLAIN (costs off)
217209
SELECT id, d, d <=| '2016-05-16 14:21:25' FROM atsts WHERE t @@ 'wr&qh' ORDER BY d <=| '2016-05-16 14:21:25' LIMIT 5;
218210
QUERY PLAN
@@ -225,15 +217,7 @@ SELECT id, d, d <=| '2016-05-16 14:21:25' FROM atsts WHERE t @@ 'wr&qh' ORDER BY
225217
(5 rows)
226218

227219
SELECT id, d, d <=| '2016-05-16 14:21:25' FROM atsts WHERE t @@ 'wr&qh' ORDER BY d <=| '2016-05-16 14:21:25' LIMIT 5;
228-
id | d | ?column?
229-
-----+---------------------------------+---------------
230-
355 | Mon May 16 14:21:22.326724 2016 | 2.673276
231-
354 | Mon May 16 13:21:22.326724 2016 | 3602.673276
232-
252 | Thu May 12 07:21:22.326724 2016 | 370802.673276
233-
232 | Wed May 11 11:21:22.326724 2016 | 442802.673276
234-
168 | Sun May 08 19:21:22.326724 2016 | 673202.673276
235-
(5 rows)
236-
220+
ERROR: doesn't support order by over pass-by-reference column
237221
EXPLAIN (costs off)
238222
SELECT id, d, d |=> '2016-05-16 14:21:25' FROM atsts WHERE t @@ 'wr&qh' ORDER BY d |=> '2016-05-16 14:21:25' LIMIT 5;
239223
QUERY PLAN
@@ -246,15 +230,7 @@ SELECT id, d, d |=> '2016-05-16 14:21:25' FROM atsts WHERE t @@ 'wr&qh' ORDER BY
246230
(5 rows)
247231

248232
SELECT id, d, d |=> '2016-05-16 14:21:25' FROM atsts WHERE t @@ 'wr&qh' ORDER BY d |=> '2016-05-16 14:21:25' LIMIT 5;
249-
id | d | ?column?
250-
-----+---------------------------------+---------------
251-
371 | Tue May 17 06:21:22.326724 2016 | 57597.326724
252-
406 | Wed May 18 17:21:22.326724 2016 | 183597.326724
253-
415 | Thu May 19 02:21:22.326724 2016 | 215997.326724
254-
428 | Thu May 19 15:21:22.326724 2016 | 262797.326724
255-
457 | Fri May 20 20:21:22.326724 2016 | 367197.326724
256-
(5 rows)
257-
233+
ERROR: doesn't support order by over pass-by-reference column
258234
EXPLAIN (costs off)
259235
SELECT id, d, d <=> '2016-05-16 14:21:25' FROM atsts ORDER BY d <=> '2016-05-16 14:21:25' LIMIT 5;
260236
QUERY PLAN
@@ -266,15 +242,7 @@ SELECT id, d, d <=> '2016-05-16 14:21:25' FROM atsts ORDER BY d <=> '2016-05-16
266242
(4 rows)
267243

268244
SELECT id, d, d <=> '2016-05-16 14:21:25' FROM atsts ORDER BY d <=> '2016-05-16 14:21:25' LIMIT 5;
269-
id | d | ?column?
270-
-----+---------------------------------+-------------
271-
355 | Mon May 16 14:21:22.326724 2016 | 2.673276
272-
356 | Mon May 16 15:21:22.326724 2016 | 3597.326724
273-
354 | Mon May 16 13:21:22.326724 2016 | 3602.673276
274-
357 | Mon May 16 16:21:22.326724 2016 | 7197.326724
275-
353 | Mon May 16 12:21:22.326724 2016 | 7202.673276
276-
(5 rows)
277-
245+
ERROR: doesn't support order by over pass-by-reference column
278246
EXPLAIN (costs off)
279247
SELECT id, d FROM atsts WHERE t @@ 'wr&qh' AND d <= '2016-05-16 14:21:25' ORDER BY d;
280248
QUERY PLAN

‎expected/altorder_hash_1.out

Lines changed: 4 additions & 36 deletions
Original file line numberDiff line numberDiff line change
@@ -204,15 +204,7 @@ SELECT id, d, d <=> '2016-05-16 14:21:25' FROM atstsh WHERE t @@ 'wr&qh' ORDER B
204204
(5 rows)
205205

206206
SELECT id, d, d <=> '2016-05-16 14:21:25' FROM atstsh WHERE t @@ 'wr&qh' ORDER BY d <=> '2016-05-16 14:21:25' LIMIT 5;
207-
id | d | ?column?
208-
-----+---------------------------------+---------------
209-
355 | Mon May 16 14:21:22.326724 2016 | 2.673276
210-
354 | Mon May 16 13:21:22.326724 2016 | 3602.673276
211-
371 | Tue May 17 06:21:22.326724 2016 | 57597.326724
212-
406 | Wed May 18 17:21:22.326724 2016 | 183597.326724
213-
415 | Thu May 19 02:21:22.326724 2016 | 215997.326724
214-
(5 rows)
215-
207+
ERROR: doesn't support order by over pass-by-reference column
216208
EXPLAIN (costs off)
217209
SELECT id, d, d <=| '2016-05-16 14:21:25' FROM atstsh WHERE t @@ 'wr&qh' ORDER BY d <=| '2016-05-16 14:21:25' LIMIT 5;
218210
QUERY PLAN
@@ -225,15 +217,7 @@ SELECT id, d, d <=| '2016-05-16 14:21:25' FROM atstsh WHERE t @@ 'wr&qh' ORDER B
225217
(5 rows)
226218

227219
SELECT id, d, d <=| '2016-05-16 14:21:25' FROM atstsh WHERE t @@ 'wr&qh' ORDER BY d <=| '2016-05-16 14:21:25' LIMIT 5;
228-
id | d | ?column?
229-
-----+---------------------------------+---------------
230-
355 | Mon May 16 14:21:22.326724 2016 | 2.673276
231-
354 | Mon May 16 13:21:22.326724 2016 | 3602.673276
232-
252 | Thu May 12 07:21:22.326724 2016 | 370802.673276
233-
232 | Wed May 11 11:21:22.326724 2016 | 442802.673276
234-
168 | Sun May 08 19:21:22.326724 2016 | 673202.673276
235-
(5 rows)
236-
220+
ERROR: doesn't support order by over pass-by-reference column
237221
EXPLAIN (costs off)
238222
SELECT id, d, d |=> '2016-05-16 14:21:25' FROM atstsh WHERE t @@ 'wr&qh' ORDER BY d |=> '2016-05-16 14:21:25' LIMIT 5;
239223
QUERY PLAN
@@ -246,15 +230,7 @@ SELECT id, d, d |=> '2016-05-16 14:21:25' FROM atstsh WHERE t @@ 'wr&qh' ORDER B
246230
(5 rows)
247231

248232
SELECT id, d, d |=> '2016-05-16 14:21:25' FROM atstsh WHERE t @@ 'wr&qh' ORDER BY d |=> '2016-05-16 14:21:25' LIMIT 5;
249-
id | d | ?column?
250-
-----+---------------------------------+---------------
251-
371 | Tue May 17 06:21:22.326724 2016 | 57597.326724
252-
406 | Wed May 18 17:21:22.326724 2016 | 183597.326724
253-
415 | Thu May 19 02:21:22.326724 2016 | 215997.326724
254-
428 | Thu May 19 15:21:22.326724 2016 | 262797.326724
255-
457 | Fri May 20 20:21:22.326724 2016 | 367197.326724
256-
(5 rows)
257-
233+
ERROR: doesn't support order by over pass-by-reference column
258234
EXPLAIN (costs off)
259235
SELECT id, d, d <=> '2016-05-16 14:21:25' FROM atstsh ORDER BY d <=> '2016-05-16 14:21:25' LIMIT 5;
260236
QUERY PLAN
@@ -266,15 +242,7 @@ SELECT id, d, d <=> '2016-05-16 14:21:25' FROM atstsh ORDER BY d <=> '2016-05-16
266242
(4 rows)
267243

268244
SELECT id, d, d <=> '2016-05-16 14:21:25' FROM atstsh ORDER BY d <=> '2016-05-16 14:21:25' LIMIT 5;
269-
id | d | ?column?
270-
-----+---------------------------------+-------------
271-
355 | Mon May 16 14:21:22.326724 2016 | 2.673276
272-
356 | Mon May 16 15:21:22.326724 2016 | 3597.326724
273-
354 | Mon May 16 13:21:22.326724 2016 | 3602.673276
274-
357 | Mon May 16 16:21:22.326724 2016 | 7197.326724
275-
353 | Mon May 16 12:21:22.326724 2016 | 7202.673276
276-
(5 rows)
277-
245+
ERROR: doesn't support order by over pass-by-reference column
278246
EXPLAIN (costs off)
279247
SELECT id, d FROM atstsh WHERE t @@ 'wr&qh' AND d <= '2016-05-16 14:21:25' ORDER BY d;
280248
QUERY PLAN

0 commit comments

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