Fix tests

CherkashinSergey · CherkashinSergey · commit 054e746a43b0 · 2018-08-05T23:00:31.000+03:00
diff --git a/expected/pg_variables_trans.out b/expected/pg_variables_trans.out
@@ -1758,11 +1758,11 @@ SELECT pgv_free();
  
 (1 row)
 
-SELECT package FROM pgv_stats();
+SELECT package FROM pgv_stats() ORDER BY package;
  package 
 ---------
- vars2
  vars
+ vars2
 (2 rows)
 
 SELECT * FROM pgv_list() ORDER BY package, name;
@@ -1771,11 +1771,11 @@ SELECT * FROM pgv_list() ORDER BY package, name;
 (0 rows)
 
 RELEASE sp5;
-SELECT package FROM pgv_stats();
+SELECT package FROM pgv_stats() ORDER BY package;
  package 
 ---------
- vars2
  vars
+ vars2
 (2 rows)
 
 SELECT * FROM pgv_list() ORDER BY package, name;
@@ -1784,7 +1784,7 @@ SELECT * FROM pgv_list() ORDER BY package, name;
 (0 rows)
 
 RELEASE sp4;
-SELECT package FROM pgv_stats();
+SELECT package FROM pgv_stats() ORDER BY package;
  package 
 ---------
  vars
@@ -1796,7 +1796,7 @@ SELECT * FROM pgv_list() ORDER BY package, name;
 (0 rows)
 
 COMMIT;
-SELECT package FROM pgv_stats();
+SELECT package FROM pgv_stats() ORDER BY package;
  package 
 ---------
 (0 rows)
diff --git a/sql/pg_variables_trans.sql b/sql/pg_variables_trans.sql
@@ -441,16 +441,16 @@ SELECT pgv_set('vars2', 'trans2', 'trans2 variable exists'::text, true);
 SAVEPOINT sp4;
 SAVEPOINT sp5;
 SELECT pgv_free();
-SELECT package FROM pgv_stats();
+SELECT package FROM pgv_stats() ORDER BY package;
 SELECT * FROM pgv_list() ORDER BY package, name;
 RELEASE sp5;
-SELECT package FROM pgv_stats();
+SELECT package FROM pgv_stats() ORDER BY package;
 SELECT * FROM pgv_list() ORDER BY package, name;
 RELEASE sp4;
-SELECT package FROM pgv_stats();
+SELECT package FROM pgv_stats() ORDER BY package;
 SELECT * FROM pgv_list() ORDER BY package, name;
 COMMIT;
-SELECT package FROM pgv_stats();
+SELECT package FROM pgv_stats() ORDER BY package;
 
 BEGIN;
 SELECT pgv_set('vars', 'trans1', 'package created'::text, true);
