Adopt Bob Jenkins' improved hash function for hash_any(). This changes the

[postgresql] / src / test / regress / expected / polymorphism.out

diff --git a/src/test/regress/expected/polymorphism.out b/src/test/regress/expected/polymorphism.out
index aace99cb62554bee87ccecc95c414974c0c32749..7648ad610bce91a6838692a444712ce6774ef32f 100644 (file)
--- a/src/test/regress/expected/polymorphism.out
+++ b/src/test/regress/expected/polymorphism.out
@@ -352,188 +352,188 @@ insert into t values(2,array[222],'c');
 insert into t values(3,array[3],'a');
 insert into t values(3,array[3],'b');
 -- test the successfully created polymorphic aggregates
-select f3, myaggp01a(*) from t group by f3;
+select f3, myaggp01a(*) from t group by f3 order by f3;
  f3 | myaggp01a 
 ----+-----------
+ a  | {}
  b  | {}
  c  | {}
- a  | {}
 (3 rows)
 
-select f3, myaggp03a(*) from t group by f3;
+select f3, myaggp03a(*) from t group by f3 order by f3;
  f3 | myaggp03a 
 ----+-----------
+ a  | {}
  b  | {}
  c  | {}
- a  | {}
 (3 rows)
 
-select f3, myaggp03b(*) from t group by f3;
+select f3, myaggp03b(*) from t group by f3 order by f3;
  f3 | myaggp03b 
 ----+-----------
+ a  | {}
  b  | {}
  c  | {}
- a  | {}
 (3 rows)
 
-select f3, myaggp05a(f1) from t group by f3;
+select f3, myaggp05a(f1) from t group by f3 order by f3;
  f3 | myaggp05a 
 ----+-----------
+ a  | {1,2,3}
  b  | {1,2,3}
  c  | {1,2}
- a  | {1,2,3}
 (3 rows)
 
-select f3, myaggp06a(f1) from t group by f3;
+select f3, myaggp06a(f1) from t group by f3 order by f3;
  f3 | myaggp06a 
 ----+-----------
+ a  | {}
  b  | {}
  c  | {}
- a  | {}
 (3 rows)
 
-select f3, myaggp08a(f1) from t group by f3;
+select f3, myaggp08a(f1) from t group by f3 order by f3;
  f3 | myaggp08a 
 ----+-----------
+ a  | {}
  b  | {}
  c  | {}
- a  | {}
 (3 rows)
 
-select f3, myaggp09a(f1) from t group by f3;
+select f3, myaggp09a(f1) from t group by f3 order by f3;
  f3 | myaggp09a 
 ----+-----------
+ a  | {}
  b  | {}
  c  | {}
- a  | {}
 (3 rows)
 
-select f3, myaggp09b(f1) from t group by f3;
+select f3, myaggp09b(f1) from t group by f3 order by f3;
  f3 | myaggp09b 
 ----+-----------
+ a  | {}
  b  | {}
  c  | {}
- a  | {}
 (3 rows)
 
-select f3, myaggp10a(f1) from t group by f3;
+select f3, myaggp10a(f1) from t group by f3 order by f3;
  f3 | myaggp10a 
 ----+-----------
+ a  | {1,2,3}
  b  | {1,2,3}
  c  | {1,2}
- a  | {1,2,3}
 (3 rows)
 
-select f3, myaggp10b(f1) from t group by f3;
+select f3, myaggp10b(f1) from t group by f3 order by f3;
  f3 | myaggp10b 
 ----+-----------
+ a  | {1,2,3}
  b  | {1,2,3}
  c  | {1,2}
- a  | {1,2,3}
 (3 rows)
 
-select f3, myaggp20a(f1) from t group by f3;
+select f3, myaggp20a(f1) from t group by f3 order by f3;
  f3 | myaggp20a 
 ----+-----------
+ a  | {1,2,3}
  b  | {1,2,3}
  c  | {1,2}
- a  | {1,2,3}
 (3 rows)
 
-select f3, myaggp20b(f1) from t group by f3;
+select f3, myaggp20b(f1) from t group by f3 order by f3;
  f3 | myaggp20b 
 ----+-----------
+ a  | {1,2,3}
  b  | {1,2,3}
  c  | {1,2}
- a  | {1,2,3}
 (3 rows)
 
-select f3, myaggn01a(*) from t group by f3;
+select f3, myaggn01a(*) from t group by f3 order by f3;
  f3 | myaggn01a 
 ----+-----------
+ a  | {}
  b  | {}
  c  | {}
- a  | {}
 (3 rows)
 
-select f3, myaggn01b(*) from t group by f3;
+select f3, myaggn01b(*) from t group by f3 order by f3;
  f3 | myaggn01b 
 ----+-----------
+ a  | {}
  b  | {}
  c  | {}
- a  | {}
 (3 rows)
 
-select f3, myaggn03a(*) from t group by f3;
+select f3, myaggn03a(*) from t group by f3 order by f3;
  f3 | myaggn03a 
 ----+-----------
+ a  | {}
  b  | {}
  c  | {}
- a  | {}
 (3 rows)
 
-select f3, myaggn05a(f1) from t group by f3;
+select f3, myaggn05a(f1) from t group by f3 order by f3;
  f3 | myaggn05a 
 ----+-----------
+ a  | {1,2,3}
  b  | {1,2,3}
  c  | {1,2}
- a  | {1,2,3}
 (3 rows)
 
-select f3, myaggn05b(f1) from t group by f3;
+select f3, myaggn05b(f1) from t group by f3 order by f3;
  f3 | myaggn05b 
 ----+-----------
+ a  | {1,2,3}
  b  | {1,2,3}
  c  | {1,2}
- a  | {1,2,3}
 (3 rows)
 
-select f3, myaggn06a(f1) from t group by f3;
+select f3, myaggn06a(f1) from t group by f3 order by f3;
  f3 | myaggn06a 
 ----+-----------
+ a  | {}
  b  | {}
  c  | {}
- a  | {}
 (3 rows)
 
-select f3, myaggn06b(f1) from t group by f3;
+select f3, myaggn06b(f1) from t group by f3 order by f3;
  f3 | myaggn06b 
 ----+-----------
+ a  | {}
  b  | {}
  c  | {}
- a  | {}
 (3 rows)
 
-select f3, myaggn08a(f1) from t group by f3;
+select f3, myaggn08a(f1) from t group by f3 order by f3;
  f3 | myaggn08a 
 ----+-----------
+ a  | {}
  b  | {}
  c  | {}
- a  | {}
 (3 rows)
 
-select f3, myaggn08b(f1) from t group by f3;
+select f3, myaggn08b(f1) from t group by f3 order by f3;
  f3 | myaggn08b 
 ----+-----------
+ a  | {}
  b  | {}
  c  | {}
- a  | {}
 (3 rows)
 
-select f3, myaggn09a(f1) from t group by f3;
+select f3, myaggn09a(f1) from t group by f3 order by f3;
  f3 | myaggn09a 
 ----+-----------
+ a  | {}
  b  | {}
  c  | {}
- a  | {}
 (3 rows)
 
-select f3, myaggn10a(f1) from t group by f3;
+select f3, myaggn10a(f1) from t group by f3 order by f3;
  f3 | myaggn10a 
 ----+-----------
+ a  | {1,2,3}
  b  | {1,2,3}
  c  | {1,2}
- a  | {1,2,3}
 (3 rows)
 
 select mysum2(f1, f1 + 1) from t;