postgrespro
diff --git a/‎expected/orderby.out
Copy file name to clipboardExpand all lines: expected/orderby.out
+9Lines changed: 9 additions & 0 deletions b/‎expected/orderby.out
Copy file name to clipboardExpand all lines: expected/orderby.out
+9Lines changed: 9 additions & 0 deletions
diff --git a/‎sql/orderby.sql
Copy file name to clipboardExpand all lines: sql/orderby.sql
+12Lines changed: 12 additions & 0 deletions b/‎sql/orderby.sql
Copy file name to clipboardExpand all lines: sql/orderby.sql
+12Lines changed: 12 additions & 0 deletions
@@ -460,6 +460,15 @@ SELECT id, d FROM tsts WHERE  t @@ 'wr&qh' AND d >= '2016-05-16 14:21:25' ORDER
  458 | Fri May 20 21:21:22.326724 2016
 (3 rows)
 
+-- Test "ORDER BY" error message 
+DROP INDEX tsts_idx;
+RESET enable_indexscan;
+RESET enable_indexonlyscan;
+RESET enable_bitmapscan;
+RESET enable_seqscan;
+CREATE INDEX tsts_idx ON tsts USING rum (t rum_tsvector_addon_ops, d);
+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;
+ERROR:  cannot order without attribute 2 in WHERE clause
 -- Test multicolumn index
 RESET enable_indexscan;
 RESET enable_indexonlyscan;
 
@@ -95,6 +95,18 @@ SELECT id, d FROM tsts WHERE  t @@ 'wr&qh' AND d <= '2016-05-16 14:21:25' ORDER
 SELECT id, d FROM tsts WHERE  t @@ 'wr&qh' AND d >= '2016-05-16 14:21:25' ORDER BY d ASC LIMIT 3;
 SELECT id, d FROM tsts WHERE  t @@ 'wr&qh' AND d >= '2016-05-16 14:21:25' ORDER BY d DESC LIMIT 3;
 
+-- Test "ORDER BY" error message 
+DROP INDEX tsts_idx;
+
+RESET enable_indexscan;
+RESET enable_indexonlyscan;
+RESET enable_bitmapscan;
+RESET enable_seqscan;
+
+CREATE INDEX tsts_idx ON tsts USING rum (t rum_tsvector_addon_ops, d);
+
+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;
+
 -- Test multicolumn index
 
 RESET enable_indexscan;