Changeset: 05807617f602 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=05807617f602 Modified Files: sql/test/BugTracker-2014/Tests/querylog.Bug-3607.sql sql/test/BugTracker-2014/Tests/querylog.Bug-3607.stable.out Branch: default Log Message:
Remove changeable data from output. diffs (66 lines): diff --git a/sql/test/BugTracker-2014/Tests/querylog.Bug-3607.sql b/sql/test/BugTracker-2014/Tests/querylog.Bug-3607.sql --- a/sql/test/BugTracker-2014/Tests/querylog.Bug-3607.sql +++ b/sql/test/BugTracker-2014/Tests/querylog.Bug-3607.sql @@ -5,9 +5,9 @@ select * from sys.querylog_calls; call querylog_enable(); select 1; -select * from sys.querylog_catalog; -select * from sys.querylog_calls; -select * from sys.querylog_history; +select owner, query, pipe, plan, mal from sys.querylog_catalog; +select arguments, tuples from sys.querylog_calls; +select owner, query, pipe, plan, mal, arguments, tuples from sys.querylog_history; call querylog_disable(); call sys.querylog_empty(); diff --git a/sql/test/BugTracker-2014/Tests/querylog.Bug-3607.stable.out b/sql/test/BugTracker-2014/Tests/querylog.Bug-3607.stable.out --- a/sql/test/BugTracker-2014/Tests/querylog.Bug-3607.stable.out +++ b/sql/test/BugTracker-2014/Tests/querylog.Bug-3607.stable.out @@ -74,24 +74,28 @@ Ready. % tinyint # type % 1 # length [ 1 ] -#select * from sys.querylog_catalog; -% .querylog_catalog, .querylog_catalog, .querylog_catalog, .querylog_catalog, .querylog_catalog, .querylog_catalog, .querylog_catalog, .querylog_catalog # table_name -% id, owner, defined, query, pipe, plan, mal, optimize # name -% oid, clob, timestamp, clob, clob, clob, int, bigint # type -% 5, 7, 26, 9, 12, 9, 2, 3 # length -[ 398@0, "monetdb", 2016-02-21 20:08:01.000000, "select 1;", "default_pipe", "user.s5_1", 21, 161 ] -#select * from sys.querylog_calls; -% .querylog_calls, .querylog_calls, .querylog_calls, .querylog_calls, .querylog_calls, .querylog_calls, .querylog_calls, .querylog_calls, .querylog_calls # table_name -% id, start, stop, arguments, tuples, run, ship, cpu, io # name -% oid, timestamp, timestamp, clob, wrd, bigint, bigint, int, int # type -% 5, 26, 26, 23, 1, 2, 1, 1, 1 # length -[ 398@0, 2016-02-21 20:08:01.000000, 2016-02-21 20:08:01.000000, "user.s5_1(A0:bte):void;", 1, 64, 0, 0, 0 ] -#select * from sys.querylog_history; -% .querylog_history, .querylog_history, .querylog_history, .querylog_history, .querylog_history, .querylog_history, .querylog_history, .querylog_history, .querylog_history, .querylog_history, .querylog_history, .querylog_history, .querylog_history, .querylog_history, .querylog_history, .querylog_history # table_name -% id, owner, defined, query, pipe, plan, mal, optimize, start, stop, arguments, tuples, run, ship, cpu, io # name -% oid, clob, timestamp, clob, clob, clob, int, bigint, timestamp, timestamp, clob, wrd, bigint, bigint, int, int # type -% 5, 7, 26, 9, 12, 9, 2, 3, 26, 26, 23, 1, 2, 1, 1, 1 # length -[ 398@0, "monetdb", 2016-02-21 20:08:01.000000, "select 1;", "default_pipe", "user.s5_1", 21, 161, 2016-02-21 20:08:01.000000, 2016-02-21 20:08:01.000000, "user.s5_1(A0:bte):void;", 1, 64, 0, 0, 0 ] +#select owner, query, pipe, plan, mal from sys.querylog_catalog; +% .querylog_catalog, .querylog_catalog, .querylog_catalog, .querylog_catalog, .querylog_catalog # table_name +% owner, query, pipe, plan, mal # name +% clob, clob, clob, clob, int # type +% 7, 63, 12, 9, 2 # length +[ "monetdb", "select 1;", "default_pipe", "user.s5_1", 21 ] +[ "monetdb", "select owner, query, pipe, plan, mal from sys.querylog_catalog;", "default_pipe", "user.s6_1", 53 ] +#select arguments, tuples from sys.querylog_calls; +% .querylog_calls, .querylog_calls # table_name +% arguments, tuples # name +% clob, wrd # type +% 23, 1 # length +[ "user.s5_1(A0:bte):void;", 1 ] +[ "user.s6_1():void;", 5 ] +#select owner, query, pipe, plan, mal, arguments, tuples from sys.querylog_history; +% .querylog_history, .querylog_history, .querylog_history, .querylog_history, .querylog_history, .querylog_history, .querylog_history # table_name +% owner, query, pipe, plan, mal, arguments, tuples # name +% clob, clob, clob, clob, int, clob, wrd # type +% 7, 63, 12, 9, 2, 23, 1 # length +[ "monetdb", "select 1;", "default_pipe", "user.s5_1", 21, "user.s5_1(A0:bte):void;", 1 ] +[ "monetdb", "select owner, query, pipe, plan, mal from sys.querylog_catalog;", "default_pipe", "user.s6_1", 53, "user.s6_1():void;", 5 ] +[ "monetdb", "select arguments, tuples from sys.querylog_calls;", "default_pipe", "user.s7_1", 38, "user.s7_1():void;", 2 ] #select * from sys.querylog_history; % .querylog_history, .querylog_history, .querylog_history, .querylog_history, .querylog_history, .querylog_history, .querylog_history, .querylog_history, .querylog_history, .querylog_history, .querylog_history, .querylog_history, .querylog_history, .querylog_history, .querylog_history, .querylog_history # table_name % id, owner, defined, query, pipe, plan, mal, optimize, start, stop, arguments, tuples, run, ship, cpu, io # name _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
