File tree 6 files changed +52
-21
lines changed
Filter options
6 files changed +52
-21
lines changed
Original file line number Diff line number Diff line change 1
1
/*
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.
5
8
*
6
- * --------------------
7
- * array.sql and array_1.sql
8
- * --------------------
9
- * Test output for 64-bit and 32-bit systems respectively.
10
9
*/
11
10
set enable_seqscan=off;
12
11
set enable_sort=off;
Original file line number Diff line number Diff line change 1
1
/*
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.
5
8
*
6
- * --------------------
7
- * array.sql and array_1.sql
8
- * --------------------
9
- * Test output for 64-bit and 32-bit systems respectively.
10
9
*/
11
10
set enable_seqscan=off;
12
11
set enable_sort=off;
Original file line number Diff line number Diff line change
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
+ */
1
10
CREATE TABLE tsts (id int, t tsvector, d timestamp);
2
11
\copy tsts from 'data/tsts.data'
3
12
CREATE INDEX tsts_idx ON tsts USING rum (t rum_tsvector_addon_ops, d)
Original file line number Diff line number Diff line change
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
+ */
1
10
CREATE TABLE tsts (id int, t tsvector, d timestamp);
2
11
\copy tsts from 'data/tsts.data'
3
12
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
420
429
458 | Fri May 20 21:21:22.326724 2016
421
430
(3 rows)
422
431
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
423
437
-- Test multicolumn index
424
438
RESET enable_indexscan;
425
439
RESET enable_indexonlyscan;
Original file line number Diff line number Diff line change 1
1
/*
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.
5
8
*
6
- * --------------------
7
- * array.sql and array_1.sql
8
- * --------------------
9
- * Test output for 64-bit and 32-bit systems respectively.
10
9
*/
11
10
12
11
Original file line number Diff line number Diff line change
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
+
1
12
CREATE TABLE tsts (id int , t tsvector, d timestamp );
2
13
3
14
\copy tsts from ' data/tsts.data'
You can’t perform that action at this time.
0 commit comments