Stabilize the forced_stat_collection regression test. As a criteria of sorting table rows use md5(string) instead of string itself.

danolivo · Andrey Lepikhov · commit 4d08b21057ec · 2021-06-18T08:14:31.000+05:00
Tags: aqo.
diff --git a/expected/forced_stat_collection.out b/expected/forced_stat_collection.out
@@ -44,12 +44,12 @@ FROM aqo_queries JOIN aqo_query_stat USING (query_hash);
  f         | f       | f           | {2.9634630129852053} |   1
 (2 rows)
 
-SELECT query_text FROM aqo_query_texts ORDER BY (query_text);
+SELECT query_text FROM aqo_query_texts ORDER BY md5(query_text);
                              query_text                             
 --------------------------------------------------------------------
+ SELECT count(*) FROM person WHERE age<18;
  COMMON feature space (do not delete!)
  SELECT count(*) FROM person WHERE age<18 AND passport IS NOT NULL;
- SELECT count(*) FROM person WHERE age<18;
 (3 rows)
 
 DROP EXTENSION aqo;
diff --git a/sql/forced_stat_collection.sql b/sql/forced_stat_collection.sql
@@ -31,6 +31,6 @@ SELECT * FROM aqo_data;
 SELECT learn_aqo,use_aqo,auto_tuning,cardinality_error_without_aqo ce,executions_without_aqo nex
 FROM aqo_queries JOIN aqo_query_stat USING (query_hash);
 
-SELECT query_text FROM aqo_query_texts ORDER BY (query_text);
+SELECT query_text FROM aqo_query_texts ORDER BY md5(query_text);
 
 DROP EXTENSION aqo;
