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

Commit444734c

Browse files
committed
Fix tests for 32-bit platforms
1 parent9461b08 commit444734c

File tree

2 files changed

+9
-35
lines changed

2 files changed

+9
-35
lines changed

‎expected/orderby_1.out

Lines changed: 5 additions & 18 deletions
Original file line numberDiff line numberDiff line change
@@ -332,7 +332,7 @@ RESET enable_bitmapscan;
332332
SET enable_seqscan = off;
333333
DROP INDEX tsts_idx;
334334
CREATE INDEX tsts_id_idx ON tsts USING rum (t rum_tsvector_addon_ops, id, d)
335-
WITH (attach = 'd', to = 't');
335+
WITH (attach = 'd', to = 't');
336336
EXPLAIN (costs off)
337337
SELECT id, d FROM tsts WHERE t @@ 'wr&qh' AND id = 1::int ORDER BY d <=> '2016-05-16 14:21:25' LIMIT 5;
338338
QUERY PLAN
@@ -344,10 +344,7 @@ SELECT id, d FROM tsts WHERE t @@ 'wr&qh' AND id = 1::int ORDER BY d <=> '2016-0
344344
(4 rows)
345345

346346
SELECT id, d FROM tsts WHERE t @@ 'wr&qh' AND id = 1::int ORDER BY d <=> '2016-05-16 14:21:25' LIMIT 5;
347-
id | d
348-
----+---
349-
(0 rows)
350-
347+
ERROR: doesn't support order by over pass-by-reference column
351348
EXPLAIN (costs off)
352349
SELECT id, d FROM tsts WHERE t @@ 'wr&qh' AND id = 355::int ORDER BY d <=> '2016-05-16 14:21:25' LIMIT 5;
353350
QUERY PLAN
@@ -359,11 +356,7 @@ SELECT id, d FROM tsts WHERE t @@ 'wr&qh' AND id = 355::int ORDER BY d <=> '2016
359356
(4 rows)
360357

361358
SELECT id, d FROM tsts WHERE t @@ 'wr&qh' AND id = 355::int ORDER BY d <=> '2016-05-16 14:21:25' LIMIT 5;
362-
id | d
363-
-----+---------------------------------
364-
355 | Mon May 16 14:21:22.326724 2016
365-
(1 row)
366-
359+
ERROR: doesn't support order by over pass-by-reference column
367360
EXPLAIN (costs off)
368361
SELECT id, d FROM tsts WHERE t @@ 'wr&qh' AND d = '2016-05-11 11:21:22.326724'::timestamp ORDER BY d <=> '2016-05-16 14:21:25' LIMIT 5;
369362
QUERY PLAN
@@ -375,11 +368,7 @@ SELECT id, d FROM tsts WHERE t @@ 'wr&qh' AND d = '2016-05-11 11:21:22.326724'::
375368
(4 rows)
376369

377370
SELECT id, d FROM tsts WHERE t @@ 'wr&qh' AND d = '2016-05-11 11:21:22.326724'::timestamp ORDER BY d <=> '2016-05-16 14:21:25' LIMIT 5;
378-
id | d
379-
-----+---------------------------------
380-
232 | Wed May 11 11:21:22.326724 2016
381-
(1 row)
382-
371+
ERROR: doesn't support order by over pass-by-reference column
383372
EXPLAIN (costs off)
384373
SELECT id, d FROM tsts WHERE t @@ 'wr&qh' AND d = '2000-05-01'::timestamp ORDER BY d <=> '2016-05-16 14:21:25' LIMIT 5;
385374
QUERY PLAN
@@ -391,7 +380,5 @@ SELECT id, d FROM tsts WHERE t @@ 'wr&qh' AND d = '2000-05-01'::timestamp ORDER
391380
(4 rows)
392381

393382
SELECT id, d FROM tsts WHERE t @@ 'wr&qh' AND d = '2000-05-01'::timestamp ORDER BY d <=> '2016-05-16 14:21:25' LIMIT 5;
394-
id | d
395-
----+---
396-
(0 rows)
383+
ERROR: doesn't support order by over pass-by-reference column
397384

‎expected/orderby_hash_1.out

Lines changed: 4 additions & 17 deletions
Original file line numberDiff line numberDiff line change
@@ -344,10 +344,7 @@ SELECT id, d FROM tsts WHERE t @@ 'wr&qh' AND id = 1::int ORDER BY d <=> '2016-0
344344
(4 rows)
345345

346346
SELECT id, d FROM tsts WHERE t @@ 'wr&qh' AND id = 1::int ORDER BY d <=> '2016-05-16 14:21:25' LIMIT 5;
347-
id | d
348-
----+---
349-
(0 rows)
350-
347+
ERROR: doesn't support order by over pass-by-reference column
351348
EXPLAIN (costs off)
352349
SELECT id, d FROM tsts WHERE t @@ 'wr&qh' AND id = 355::int ORDER BY d <=> '2016-05-16 14:21:25' LIMIT 5;
353350
QUERY PLAN
@@ -359,11 +356,7 @@ SELECT id, d FROM tsts WHERE t @@ 'wr&qh' AND id = 355::int ORDER BY d <=> '2016
359356
(4 rows)
360357

361358
SELECT id, d FROM tsts WHERE t @@ 'wr&qh' AND id = 355::int ORDER BY d <=> '2016-05-16 14:21:25' LIMIT 5;
362-
id | d
363-
-----+---------------------------------
364-
355 | Mon May 16 14:21:22.326724 2016
365-
(1 row)
366-
359+
ERROR: doesn't support order by over pass-by-reference column
367360
EXPLAIN (costs off)
368361
SELECT id, d FROM tsts WHERE t @@ 'wr&qh' AND d = '2016-05-11 11:21:22.326724'::timestamp ORDER BY d <=> '2016-05-16 14:21:25' LIMIT 5;
369362
QUERY PLAN
@@ -375,11 +368,7 @@ SELECT id, d FROM tsts WHERE t @@ 'wr&qh' AND d = '2016-05-11 11:21:22.326724'::
375368
(4 rows)
376369

377370
SELECT id, d FROM tsts WHERE t @@ 'wr&qh' AND d = '2016-05-11 11:21:22.326724'::timestamp ORDER BY d <=> '2016-05-16 14:21:25' LIMIT 5;
378-
id | d
379-
-----+---------------------------------
380-
232 | Wed May 11 11:21:22.326724 2016
381-
(1 row)
382-
371+
ERROR: doesn't support order by over pass-by-reference column
383372
EXPLAIN (costs off)
384373
SELECT id, d FROM tsts WHERE t @@ 'wr&qh' AND d = '2000-05-01'::timestamp ORDER BY d <=> '2016-05-16 14:21:25' LIMIT 5;
385374
QUERY PLAN
@@ -391,7 +380,5 @@ SELECT id, d FROM tsts WHERE t @@ 'wr&qh' AND d = '2000-05-01'::timestamp ORDER
391380
(4 rows)
392381

393382
SELECT id, d FROM tsts WHERE t @@ 'wr&qh' AND d = '2000-05-01'::timestamp ORDER BY d <=> '2016-05-16 14:21:25' LIMIT 5;
394-
id | d
395-
----+---
396-
(0 rows)
383+
ERROR: doesn't support order by over pass-by-reference column
397384

0 commit comments

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