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

Commit36379d3

Browse files
author
Ekaterina Sokolova
committed
Update alternative output for 32-bit systems.
Commit34619f9 changed orderby.sql and orderby.out.But this test has alternative output orderby_1.sql for32-bit systems. Fix comments for files with alternatives.
1 parent6edd4b5 commit36379d3

File tree

6 files changed

+52
-21
lines changed

6 files changed

+52
-21
lines changed

‎expected/array.out

Lines changed: 6 additions & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -1,12 +1,11 @@
11
/*
2-
* ---------------------------------------------
3-
* NOTE: This test behaves differenly on PgPro
4-
* ---------------------------------------------
2+
* ------------------------------------
3+
* NOTE: This test behaves differenly
4+
* ------------------------------------
5+
*
6+
* array.out - test output for 64-bit systems and
7+
* array_1.out - test output for 32-bit systems.
58
*
6-
* --------------------
7-
* array.sql and array_1.sql
8-
* --------------------
9-
* Test output for 64-bit and 32-bit systems respectively.
109
*/
1110
set enable_seqscan=off;
1211
set enable_sort=off;

‎expected/array_1.out

Lines changed: 6 additions & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -1,12 +1,11 @@
11
/*
2-
* ---------------------------------------------
3-
* NOTE: This test behaves differenly on PgPro
4-
* ---------------------------------------------
2+
* ------------------------------------
3+
* NOTE: This test behaves differenly
4+
* ------------------------------------
5+
*
6+
* array.out - test output for 64-bit systems and
7+
* array_1.out - test output for 32-bit systems.
58
*
6-
* --------------------
7-
* array.sql and array_1.sql
8-
* --------------------
9-
* Test output for 64-bit and 32-bit systems respectively.
109
*/
1110
set enable_seqscan=off;
1211
set enable_sort=off;

‎expected/orderby.out

Lines changed: 9 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -1,3 +1,12 @@
1+
/*
2+
* ------------------------------------
3+
* NOTE: This test behaves differenly
4+
* ------------------------------------
5+
*
6+
* orderby.out - test output for 64-bit systems and
7+
* orderby_1.out - test output for 32-bit systems.
8+
*
9+
*/
110
CREATE TABLE tsts (id int, t tsvector, d timestamp);
211
\copy tsts from 'data/tsts.data'
312
CREATE INDEX tsts_idx ON tsts USING rum (t rum_tsvector_addon_ops, d)

‎expected/orderby_1.out

Lines changed: 14 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -1,3 +1,12 @@
1+
/*
2+
* ------------------------------------
3+
* NOTE: This test behaves differenly
4+
* ------------------------------------
5+
*
6+
* orderby.out - test output for 64-bit systems and
7+
* orderby_1.out - test output for 32-bit systems.
8+
*
9+
*/
110
CREATE TABLE tsts (id int, t tsvector, d timestamp);
211
\copy tsts from 'data/tsts.data'
312
CREATE INDEX tsts_idx ON tsts USING rum (t rum_tsvector_addon_ops, d)
@@ -420,6 +429,11 @@ SELECT id, d FROM tsts WHERE t @@ 'wr&qh' AND d >= '2016-05-16 14:21:25' ORDER
420429
458 | Fri May 20 21:21:22.326724 2016
421430
(3 rows)
422431

432+
-- Test "ORDER BY" error message
433+
DROP INDEX tsts_idx;
434+
CREATE INDEX tsts_idx ON tsts USING rum (t rum_tsvector_addon_ops, d);
435+
SELECT id, d, d <=> '2016-05-16 14:21:25' FROM tsts WHERE t @@ 'wr&qh' ORDER BY d <=> '2016-05-16 14:21:25' LIMIT 5;
436+
ERROR: doesn't support order by over pass-by-reference column
423437
-- Test multicolumn index
424438
RESET enable_indexscan;
425439
RESET enable_indexonlyscan;

‎sql/array.sql

Lines changed: 6 additions & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -1,12 +1,11 @@
11
/*
2-
* ---------------------------------------------
3-
* NOTE: This test behaves differenly on PgPro
4-
* ---------------------------------------------
2+
* ------------------------------------
3+
* NOTE: This test behaves differenly
4+
* ------------------------------------
5+
*
6+
* array.out - test output for 64-bit systems and
7+
* array_1.out - test output for 32-bit systems.
58
*
6-
* --------------------
7-
* array.sql and array_1.sql
8-
* --------------------
9-
* Test output for 64-bit and 32-bit systems respectively.
109
*/
1110

1211

‎sql/orderby.sql

Lines changed: 11 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -1,3 +1,14 @@
1+
/*
2+
* ------------------------------------
3+
* NOTE: This test behaves differenly
4+
* ------------------------------------
5+
*
6+
* orderby.out - test output for 64-bit systems and
7+
* orderby_1.out - test output for 32-bit systems.
8+
*
9+
*/
10+
11+
112
CREATETABLEtsts (idint, t tsvector, dtimestamp);
213

314
\copy tstsfrom'data/tsts.data'

0 commit comments

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