Changeset: 1020e1b87dae for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/1020e1b87dae
Modified Files:
        sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.test
        
sql/test/BugTracker-2012/Tests/rewrite_like_into_likesubselect.Bug-3179.test
        sql/test/BugTracker-2017/Tests/side-effect.Bug-6397.test
        sql/test/BugTracker/Tests/explain.SF-1739353.test
        sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.test
        
sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-0join-query.test
        
sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-0join-view.test
        
sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-1join-query.test
        
sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-1join-view.test
        
sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-query.test
        
sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-view.test
        sql/test/SQLancer/Tests/sqlancer10.test
        sql/test/SQLancer/Tests/sqlancer13.test
        sql/test/mapi/Tests/sql_int128.test
        sql/test/miscellaneous/Tests/simple_plans.test
        sql/test/remote/Tests/partition_elim.test
        testing/explain.py
Branch: Jul2021
Log Message:

Sort explain.function_histogram output (and also 
explain.function_with_more_than_one_result_bat)


diffs (truncated from 2260 to 300 lines):

diff --git 
a/sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.test 
b/sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.test
--- a/sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.test
+++ b/sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.test
@@ -105,174 +105,160 @@ top N (
 query T python .explain.function_histogram
 EXPLAIN select * from oblo
 ----
-user.main
-1
-querylog.define
-1
-sql.mvc
-1
-sql.tid
-1
-sql.bind
-1
-sql.emptybind
-1
-sql.delta
-1
 algebra.projection
 1
 bat.pack
 5
+querylog.define
+1
+sql.bind
+1
+sql.delta
+1
+sql.emptybind
+1
+sql.mvc
+1
 sql.resultSet
 1
+sql.tid
+1
+user.main
+1
 
 query T python .explain.function_histogram
 EXPLAIN select * from oblo OFFSET 2
 ----
-user.main
-1
-querylog.define
-1
-sql.mvc
-1
-sql.tid
-1
-sql.bind
-1
-sql.emptybind
-1
-sql.delta
-1
 algebra.projection
 2
 algebra.subslice
 1
 bat.pack
 5
+querylog.define
+1
+sql.bind
+1
+sql.delta
+1
+sql.emptybind
+1
+sql.mvc
+1
 sql.resultSet
 1
+sql.tid
+1
+user.main
+1
 
 query T python .explain.function_histogram
 EXPLAIN select * from oblo LIMIT 2
 ----
-user.main
-1
-querylog.define
-1
-sql.mvc
-1
-sql.tid
-1
-sql.bind
-1
-sql.emptybind
-1
-sql.delta
-1
 algebra.projection
 2
 algebra.subslice
 1
 bat.pack
 5
+querylog.define
+1
+sql.bind
+1
+sql.delta
+1
+sql.emptybind
+1
+sql.mvc
+1
 sql.resultSet
 1
+sql.tid
+1
+user.main
+1
 
 query T python .explain.function_histogram
 EXPLAIN select * from oblo LIMIT 1 OFFSET 2
 ----
-user.main
-1
-querylog.define
-1
-sql.mvc
-1
-sql.tid
-1
-sql.bind
-1
-sql.emptybind
-1
-sql.delta
-1
 algebra.projection
 2
 algebra.subslice
 1
 bat.pack
 5
+querylog.define
+1
+sql.bind
+1
+sql.delta
+1
+sql.emptybind
+1
+sql.mvc
+1
 sql.resultSet
 1
+sql.tid
+1
+user.main
+1
 
 query T python .explain.function_histogram
 EXPLAIN select * from oblo LIMIT 2 OFFSET 1
 ----
-user.main
-1
-querylog.define
-1
-sql.mvc
-1
-sql.tid
-1
-sql.bind
-1
-sql.emptybind
-1
-sql.delta
-1
 algebra.projection
 2
 algebra.subslice
 1
 bat.pack
 5
+querylog.define
+1
+sql.bind
+1
+sql.delta
+1
+sql.emptybind
+1
+sql.mvc
+1
 sql.resultSet
 1
+sql.tid
+1
+user.main
+1
 
 query T python .explain.function_histogram
 EXPLAIN select * from oblo ORDER BY a
 ----
-user.main
-1
-querylog.define
-1
-sql.mvc
-1
-sql.tid
-1
-sql.bind
-1
-sql.emptybind
-1
-sql.delta
-1
 algebra.projection
 2
 algebra.sort
 1
 bat.pack
 5
+querylog.define
+1
+sql.bind
+1
+sql.delta
+1
+sql.emptybind
+1
+sql.mvc
+1
 sql.resultSet
 1
+sql.tid
+1
+user.main
+1
 
 query T python .explain.function_histogram
 EXPLAIN select * from oblo ORDER BY a OFFSET 2
 ----
-user.main
-1
-querylog.define
-1
-sql.mvc
-1
-sql.tid
-1
-sql.bind
-1
-sql.emptybind
-1
-sql.delta
-1
 algebra.projection
 3
 algebra.sort
@@ -281,98 +267,112 @@ algebra.subslice
 1
 bat.pack
 5
+querylog.define
+1
+sql.bind
+1
+sql.delta
+1
+sql.emptybind
+1
+sql.mvc
+1
 sql.resultSet
 1
+sql.tid
+1
+user.main
+1
 
 query T python .explain.function_histogram
 EXPLAIN select * from oblo ORDER BY a LIMIT 2
 ----
-user.main
-1
-querylog.define
-1
-sql.mvc
-1
-sql.tid
-1
-sql.bind
-1
-sql.emptybind
-1
-sql.delta
+algebra.firstn
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to