Changeset: d8898b76e4ee for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=d8898b76e4ee Modified Files: clients/Tests/SQL-dump.stable.out clients/Tests/SQL-dump.stable.out.int128 clients/Tests/exports.stable.out clients/mapiclient/Tests/mclient--help.stable.err clients/mapiclient/Tests/mclient--help.stable.err.Windows clients/mapiclient/Tests/tachograph--help.stable.err monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.err monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out monetdb5/mal/Tests/tst272.stable.out monetdb5/mal/Tests/tst275.stable.out sql/jdbc/tests/Tests/Test_Dobjects.stable.out sql/test/BugTracker-2010/Tests/crash_on_complex_join_exp.Bug-2353.stable.out sql/test/BugTracker-2010/Tests/rank-over-crash.SF-2926454.stable.out.int128 sql/test/BugTracker-2010/Tests/with_row_number_crash.Bug-2631.stable.out sql/test/BugTracker-2012/Tests/table_functions_fail_after_restart-0.Bug-3063.stable.out sql/test/BugTracker-2012/Tests/table_functions_fail_after_restart-1.Bug-3063.stable.out sql/test/BugTracker-2013/Tests/sort_void_crash.Bug-3341.stable.out sql/test/BugTracker/Tests/with_row_number.SF-1898089.stable.out sql/test/Dependencies/Tests/Dependencies.stable.err sql/test/Dependencies/Tests/Dependencies.stable.out sql/test/Dependencies/Tests/Dependencies.stable.out.int128 sql/test/Tests/systemfunctions.stable.out sql/test/Tests/systemfunctions.stable.out.int128 sql/test/bugs/Tests/groupby_having_charlength-bug-sf-943566.stable.out sql/test/leaks/Tests/check0.stable.out sql/test/leaks/Tests/check0.stable.out.int128 sql/test/leaks/Tests/check1.stable.out sql/test/leaks/Tests/check1.stable.out.int128 sql/test/leaks/Tests/check2.stable.out sql/test/leaks/Tests/check2.stable.out.int128 sql/test/leaks/Tests/check3.stable.out sql/test/leaks/Tests/check3.stable.out.int128 sql/test/leaks/Tests/check4.stable.out sql/test/leaks/Tests/check4.stable.out.int128 sql/test/leaks/Tests/check5.stable.out sql/test/leaks/Tests/check5.stable.out.int128 sql/test/leaks/Tests/drop3.stable.out.int128 sql/test/leaks/Tests/select1.stable.out.int128 sql/test/leaks/Tests/select2.stable.out.int128 sql/test/leaks/Tests/temp1.stable.out.int128 sql/test/leaks/Tests/temp2.stable.out.int128 sql/test/leaks/Tests/temp3.stable.out.int128 Branch: profiler Log Message:
Approve output diffs (truncated from 13739 to 300 lines): diff --git a/clients/Tests/SQL-dump.stable.out b/clients/Tests/SQL-dump.stable.out --- a/clients/Tests/SQL-dump.stable.out +++ b/clients/Tests/SQL-dump.stable.out @@ -60,6 +60,7 @@ Ready. SYSTEM SCHEMA bam SYSTEM SCHEMA json +SYSTEM SCHEMA profiler SYSTEM SCHEMA sys SYSTEM SCHEMA tmp SYSTEM TABLE sys._columns @@ -155,6 +156,7 @@ SYSTEM FUNCTION sys.equals SYSTEM FUNCTION sys.evalalgebra SYSTEM FUNCTION sys.fitsattach SYSTEM FUNCTION sys.fitsload +SYSTEM FUNCTION sys.flush_log SYSTEM FUNCTION sys.fuse SYSTEM FUNCTION sys.generate_series SYSTEM FUNCTION sys.geomcollectionfromtext @@ -217,8 +219,6 @@ SYSTEM FUNCTION sys.point SYSTEM FUNCTION sys.pointfromtext SYSTEM FUNCTION sys.polyfromtext SYSTEM FUNCTION sys.polygonfromtext -SYSTEM FUNCTION sys.profiler_openstream -SYSTEM FUNCTION sys.profiler_stethoscope SYSTEM FUNCTION sys.quantile SYSTEM FUNCTION sys.querycache SYSTEM FUNCTION sys.querylog diff --git a/clients/Tests/SQL-dump.stable.out.int128 b/clients/Tests/SQL-dump.stable.out.int128 --- a/clients/Tests/SQL-dump.stable.out.int128 +++ b/clients/Tests/SQL-dump.stable.out.int128 @@ -56,6 +56,7 @@ Ready. SYSTEM SCHEMA bam SYSTEM SCHEMA json +SYSTEM SCHEMA profiler SYSTEM SCHEMA sys SYSTEM SCHEMA tmp SYSTEM TABLE sys._columns @@ -151,6 +152,7 @@ SYSTEM FUNCTION sys.equals SYSTEM FUNCTION sys.evalalgebra SYSTEM FUNCTION sys.fitsattach SYSTEM FUNCTION sys.fitsload +SYSTEM FUNCTION sys.flush_log SYSTEM FUNCTION sys.fuse SYSTEM FUNCTION sys.generate_series SYSTEM FUNCTION sys.geomcollectionfromtext @@ -213,8 +215,6 @@ SYSTEM FUNCTION sys.point SYSTEM FUNCTION sys.pointfromtext SYSTEM FUNCTION sys.polyfromtext SYSTEM FUNCTION sys.polygonfromtext -SYSTEM FUNCTION sys.profiler_openstream -SYSTEM FUNCTION sys.profiler_stethoscope SYSTEM FUNCTION sys.quantile SYSTEM FUNCTION sys.querycache SYSTEM FUNCTION sys.querylog @@ -1532,234 +1532,234 @@ 2149 "statement" "varchar" 2048 0 2139 N 2151 "id" "int" 32 0 2150 NULL true 0 NULL 2152 "name" "varchar" 1024 0 2150 NULL true 1 NULL 2153 "nr" "int" 32 0 2150 NULL true 2 NULL -5660 "id" "int" 32 0 5659 NULL true 0 NULL -5661 "name" "varchar" 1024 0 5659 NULL true 1 NULL -5662 "schema_id" "int" 32 0 5659 NULL true 2 NULL -5663 "query" "varchar" 2048 0 5659 NULL true 3 NULL -5664 "type" "smallint" 16 0 5659 NULL true 4 NULL -5665 "system" "boolean" 1 0 5659 NULL true 5 NULL -5666 "commit_action" "smallint" 16 0 5659 NULL true 6 NULL -5667 "access" "smallint" 16 0 5659 NULL true 7 NULL -5668 "temporary" "smallint" 16 0 5659 NULL true 8 NULL -5670 "id" "int" 32 0 5669 NULL true 0 NULL -5671 "name" "varchar" 1024 0 5669 NULL true 1 NULL -5672 "type" "varchar" 1024 0 5669 NULL true 2 NULL -5673 "type_digits" "int" 32 0 5669 NULL true 3 NULL -5674 "type_scale" "int" 32 0 5669 NULL true 4 NULL -5675 "table_id" "int" 32 0 5669 NULL true 5 NULL -5676 "default" "varchar" 2048 0 5669 NULL true 6 NULL -5677 "null" "boolean" 1 0 5669 NULL true 7 NULL -5678 "number" "int" 32 0 5669 NULL true 8 NULL -5679 "storage" "varchar" 2048 0 5669 NULL true 9 NULL -5686 "name" "varchar" 1024 0 5685 NULL true 0 NULL -5687 "fullname" "varchar" 2048 0 5685 NULL true 1 NULL -5688 "default_schema" "int" 9 0 5685 NULL true 2 NULL -5692 "name" "varchar" 1024 0 5691 NULL true 0 NULL -5693 "fullname" "varchar" 2024 0 5691 NULL true 1 NULL -5694 "default_schema" "int" 9 0 5691 NULL true 2 NULL -5696 "login_id" "int" 32 0 5695 NULL true 0 NULL -5697 "role_id" "int" 32 0 5695 NULL true 1 NULL -5699 "id" "int" 32 0 5698 NULL true 0 NULL -5700 "name" "varchar" 1024 0 5698 NULL true 1 NULL -5701 "grantor" "int" 32 0 5698 NULL true 2 NULL -5703 "obj_id" "int" 32 0 5702 NULL true 0 NULL -5704 "auth_id" "int" 32 0 5702 NULL true 1 NULL -5705 "privileges" "int" 32 0 5702 NULL true 2 NULL -5706 "grantor" "int" 32 0 5702 NULL true 3 NULL -5707 "grantable" "int" 32 0 5702 NULL true 4 NULL -5916 "id" "oid" 63 0 5924 NULL true 0 NULL -5917 "owner" "clob" 0 0 5924 NULL true 1 NULL -5918 "defined" "timestamp" 7 0 5924 NULL true 2 NULL -5919 "query" "clob" 0 0 5924 NULL true 3 NULL -5920 "pipe" "clob" 0 0 5924 NULL true 4 NULL -5921 "plan" "clob" 0 0 5924 NULL true 5 NULL -5922 "mal" "int" 32 0 5924 NULL true 6 NULL -5923 "optimize" "bigint" 64 0 5924 NULL true 7 NULL -5926 "id" "oid" 63 0 5935 NULL true 0 NULL -5927 "start" "timestamp" 7 0 5935 NULL true 1 NULL -5928 "stop" "timestamp" 7 0 5935 NULL true 2 NULL -5929 "arguments" "clob" 0 0 5935 NULL true 3 NULL -5930 "tuples" "wrd" 64 0 5935 NULL true 4 NULL -5931 "run" "bigint" 64 0 5935 NULL true 5 NULL -5932 "ship" "bigint" 64 0 5935 NULL true 6 NULL -5933 "cpu" "int" 32 0 5935 NULL true 7 NULL -5934 "io" "int" 32 0 5935 NULL true 8 NULL -5937 "id" "oid" 63 0 5953 NULL true 0 NULL -5938 "owner" "clob" 0 0 5953 NULL true 1 NULL -5939 "defined" "timestamp" 7 0 5953 NULL true 2 NULL -5940 "query" "clob" 0 0 5953 NULL true 3 NULL -5941 "pipe" "clob" 0 0 5953 NULL true 4 NULL -5942 "plan" "clob" 0 0 5953 NULL true 5 NULL -5943 "mal" "int" 32 0 5953 NULL true 6 NULL -5944 "optimize" "bigint" 64 0 5953 NULL true 7 NULL -5945 "start" "timestamp" 7 0 5953 NULL true 8 NULL -5946 "stop" "timestamp" 7 0 5953 NULL true 9 NULL -5947 "arguments" "clob" 0 0 5953 NULL true 10 NULL -5948 "tuples" "wrd" 64 0 5953 NULL true 11 NULL -5949 "run" "bigint" 64 0 5953 NULL true 12 NULL -5950 "ship" "bigint" 64 0 5953 NULL true 13 NULL -5951 "cpu" "int" 32 0 5953 NULL true 14 NULL -5952 "io" "int" 32 0 5953 NULL true 15 NULL -5979 "event" "int" 32 0 5992 NULL true 0 NULL -5980 "clk" "varchar" 20 0 5992 NULL true 1 NULL -5981 "pc" "varchar" 50 0 5992 NULL true 2 NULL -5982 "thread" "int" 32 0 5992 NULL true 3 NULL -5983 "ticks" "bigint" 64 0 5992 NULL true 4 NULL -5984 "rrsmb" "bigint" 64 0 5992 NULL true 5 NULL -5985 "vmmb" "bigint" 64 0 5992 NULL true 6 NULL -5986 "reads" "bigint" 64 0 5992 NULL true 7 NULL -5987 "writes" "bigint" 64 0 5992 NULL true 8 NULL -5988 "minflt" "bigint" 64 0 5992 NULL true 9 NULL -5989 "majflt" "bigint" 64 0 5992 NULL true 10 NULL -5990 "nvcsw" "bigint" 64 0 5992 NULL true 11 NULL -5991 "stmt" "clob" 0 0 5992 NULL true 12 NULL -6126 "user" "clob" 0 0 6132 NULL true 0 NULL -6127 "login" "timestamp" 7 0 6132 NULL true 1 NULL -6128 "sessiontimeout" "bigint" 64 0 6132 NULL true 2 NULL -6129 "lastcommand" "timestamp" 7 0 6132 NULL true 3 NULL -6130 "querytimeout" "bigint" 64 0 6132 NULL true 4 NULL -6131 "active" "boolean" 1 0 6132 NULL true 5 NULL -6209 "name" "clob" 0 0 6212 NULL true 0 NULL -6210 "def" "clob" 0 0 6212 NULL true 1 NULL -6211 "status" "clob" 0 0 6212 NULL true 2 NULL -6218 "name" "clob" 0 0 6220 NULL true 0 NULL -6219 "value" "clob" 0 0 6220 NULL true 1 NULL -6250 "qtag" "bigint" 64 0 6258 NULL true 0 NULL -6251 "user" "clob" 0 0 6258 NULL true 1 NULL -6252 "started" "timestamp" 7 0 6258 NULL true 2 NULL -6253 "estimate" "timestamp" 7 0 6258 NULL true 3 NULL -6254 "progress" "int" 32 0 6258 NULL true 4 NULL -6255 "status" "clob" 0 0 6258 NULL true 5 NULL -6256 "tag" "oid" 63 0 6258 NULL true 6 NULL -6257 "query" "clob" 0 0 6258 NULL true 7 NULL -6284 "rowid" "bigint" 64 0 6288 NULL true 0 NULL -6285 "fldid" "int" 32 0 6288 NULL true 1 NULL -6286 "message" "clob" 0 0 6288 NULL true 2 NULL -6287 "input" "clob" 0 0 6288 NULL true 3 NULL -6943 "keyword" "varchar" 40 0 6946 NULL false 0 NULL -6948 "table_type_id" "smallint" 16 0 6954 NULL false 0 NULL -6951 "table_type_name" "varchar" 25 0 6954 NULL false 1 NULL -6956 "dependency_type_id" "smallint" 16 0 6962 NULL false 0 NULL -6959 "dependency_type_name" "varchar" 15 0 6962 NULL false 1 NULL -6977 "file_id" "int" 32 0 6979 NULL true 0 NULL -6978 "location" "char" 256 0 6979 NULL true 1 NULL -6981 "dim_id" "int" 32 0 6985 NULL true 0 NULL -6982 "file_id" "int" 32 0 6985 NULL true 1 NULL -6983 "name" "varchar" 64 0 6985 NULL true 2 NULL -6984 "length" "int" 32 0 6985 NULL true 3 NULL -6987 "var_id" "int" 32 0 6993 NULL true 0 NULL -6988 "file_id" "int" 32 0 6993 NULL true 1 NULL -6989 "name" "varchar" 64 0 6993 NULL true 2 NULL -6990 "vartype" "varchar" 64 0 6993 NULL true 3 NULL -6991 "ndim" "int" 32 0 6993 NULL true 4 NULL -6992 "coord_dim_id" "int" 32 0 6993 NULL true 5 NULL -6995 "var_id" "int" 32 0 6999 NULL true 0 NULL -6996 "dim_id" "int" 32 0 6999 NULL true 1 NULL -6997 "file_id" "int" 32 0 6999 NULL true 2 NULL -6998 "dimpos" "int" 32 0 6999 NULL true 3 NULL -7001 "obj_name" "varchar" 256 0 7007 NULL true 0 NULL -7002 "att_name" "varchar" 256 0 7007 NULL true 1 NULL -7003 "att_type" "varchar" 64 0 7007 NULL true 2 NULL -7004 "value" "clob" 0 0 7007 NULL true 3 NULL -7005 "file_id" "int" 32 0 7007 NULL true 4 NULL -7006 "gr_name" "varchar" 256 0 7007 NULL true 5 NULL -7032 "schema" "clob" 0 0 7046 NULL true 0 NULL -7033 "table" "clob" 0 0 7046 NULL true 1 NULL -7034 "column" "clob" 0 0 7046 NULL true 2 NULL -7035 "type" "clob" 0 0 7046 NULL true 3 NULL -7036 "mode" "clob" 0 0 7046 NULL true 4 NULL -7037 "location" "clob" 0 0 7046 NULL true 5 NULL -7038 "count" "bigint" 64 0 7046 NULL true 6 NULL -7039 "typewidth" "int" 32 0 7046 NULL true 7 NULL -7040 "columnsize" "bigint" 64 0 7046 NULL true 8 NULL -7041 "heapsize" "bigint" 64 0 7046 NULL true 9 NULL -7042 "hashes" "bigint" 64 0 7046 NULL true 10 NULL -7043 "phash" "boolean" 1 0 7046 NULL true 11 NULL -7044 "imprints" "bigint" 64 0 7046 NULL true 12 NULL -7045 "sorted" "boolean" 1 0 7046 NULL true 13 NULL -7048 "schema" "clob" 0 0 7058 NULL true 0 NULL -7049 "table" "clob" 0 0 7058 NULL true 1 NULL -7050 "column" "clob" 0 0 7058 NULL true 2 NULL -7051 "type" "clob" 0 0 7058 NULL true 3 NULL -7052 "typewidth" "int" 32 0 7058 NULL true 4 NULL -7053 "count" "bigint" 64 0 7058 NULL true 5 NULL -7054 "distinct" "bigint" 64 0 7058 NULL true 6 NULL -7055 "atomwidth" "int" 32 0 7058 NULL true 7 NULL -7056 "reference" "boolean" 1 0 7058 NULL true 8 NULL -7057 "sorted" "boolean" 1 0 7058 NULL true 9 NULL -7096 "schema" "clob" 0 0 7106 NULL true 0 NULL -7097 "table" "clob" 0 0 7106 NULL true 1 NULL -7098 "column" "clob" 0 0 7106 NULL true 2 NULL -7099 "type" "clob" 0 0 7106 NULL true 3 NULL -7100 "count" "bigint" 64 0 7106 NULL true 4 NULL -7101 "columnsize" "bigint" 64 0 7106 NULL true 5 NULL -7102 "heapsize" "bigint" 64 0 7106 NULL true 6 NULL -7103 "hashes" "bigint" 64 0 7106 NULL true 7 NULL -7104 "imprints" "bigint" 64 0 7106 NULL true 8 NULL -7105 "sorted" "boolean" 1 0 7106 NULL true 9 NULL -7108 "schema" "clob" 0 0 7116 NULL true 0 NULL -7109 "table" "clob" 0 0 7116 NULL true 1 NULL -7110 "count" "bigint" 64 0 7116 NULL true 2 NULL -7111 "columnsize" "hugeint" 128 0 7116 NULL true 3 NULL -7112 "heapsize" "hugeint" 128 0 7116 NULL true 4 NULL -7113 "hashes" "hugeint" 128 0 7116 NULL true 5 NULL -7114 "imprints" "hugeint" 128 0 7116 NULL true 6 NULL -7115 "auxiliary" "hugeint" 128 0 7116 NULL true 7 NULL -7118 "column_id" "int" 32 0 7129 NULL true 0 NULL -7119 "type" "clob" 0 0 7129 NULL true 1 NULL -7120 "width" "int" 32 0 7129 NULL true 2 NULL -7121 "stamp" "timestamp" 7 0 7129 NULL true 3 NULL -7122 "sample" "bigint" 64 0 7129 NULL true 4 NULL -7123 "count" "bigint" 64 0 7129 NULL true 5 NULL -7124 "unique" "bigint" 64 0 7129 NULL true 6 NULL -7125 "nils" "bigint" 64 0 7129 NULL true 7 NULL -7126 "minval" "clob" 0 0 7129 NULL true 8 NULL -7127 "maxval" "clob" 0 0 7129 NULL true 9 NULL -7128 "sorted" "boolean" 1 0 7129 NULL true 10 NULL -7219 "file_id" "bigint" 64 0 7227 NULL false 0 NULL -7220 "file_location" "clob" 0 0 7227 NULL false 1 NULL -7221 "dbschema" "smallint" 16 0 7227 NULL false 2 NULL -7222 "format_version" "varchar" 7 0 7227 NULL true 3 NULL -7223 "sorting_order" "varchar" 10 0 7227 NULL true 4 NULL -7224 "comments" "clob" 0 0 7227 NULL true 5 NULL -7229 "sn" "clob" 0 0 7240 NULL false 0 NULL -7230 "file_id" "bigint" 64 0 7240 NULL false 1 NULL -7231 "ln" "int" 32 0 7240 NULL true 2 NULL -7232 "as" "int" 32 0 7240 NULL true 3 NULL -7233 "m5" "clob" 0 0 7240 NULL true 4 NULL -7234 "sp" "clob" 0 0 7240 NULL true 5 NULL -7235 "ur" "clob" 0 0 7240 NULL true 6 NULL -7242 "id" "clob" 0 0 7259 NULL false 0 NULL -7243 "file_id" "bigint" 64 0 7259 NULL false 1 NULL -7244 "cn" "clob" 0 0 7259 NULL true 2 NULL -7245 "ds" "clob" 0 0 7259 NULL true 3 NULL -7246 "dt" "timestamp" 7 0 7259 NULL true 4 NULL -7247 "fo" "clob" 0 0 7259 NULL true 5 NULL -7248 "ks" "clob" 0 0 7259 NULL true 6 NULL -7249 "lb" "clob" 0 0 7259 NULL true 7 NULL -7250 "pg" "clob" 0 0 7259 NULL true 8 NULL -7251 "pi" "int" 32 0 7259 NULL true 9 NULL -7252 "pl" "clob" 0 0 7259 NULL true 10 NULL -7253 "pu" "clob" 0 0 7259 NULL true 11 NULL -7254 "sm" "clob" 0 0 7259 NULL true 12 NULL -7261 "id" "clob" 0 0 7271 NULL false 0 NULL -7262 "file_id" "bigint" 64 0 7271 NULL false 1 NULL -7263 "pn" "clob" 0 0 7271 NULL true 2 NULL -7264 "cl" "clob" 0 0 7271 NULL true 3 NULL -7265 "pp" "clob" 0 0 7271 NULL true 4 NULL -7266 "vn" "clob" 0 0 7271 NULL true 5 NULL -7273 "qname" "clob" 0 0 7284 NULL false 0 NULL -7274 "flag" "smallint" 16 0 7284 NULL false 1 NULL -7275 "rname" "clob" 0 0 7284 NULL false 2 NULL -7276 "pos" "int" 32 0 7284 NULL false 3 NULL -7277 "mapq" "smallint" 16 0 7284 NULL false 4 NULL -7278 "cigar" "clob" 0 0 7284 NULL false 5 NULL -7279 "rnext" "clob" 0 0 7284 NULL false 6 NULL -7280 "pnext" "int" 32 0 7284 NULL false 7 NULL -7281 "tlen" "int" 32 0 7284 NULL false 8 NULL -7282 "seq" "clob" 0 0 7284 NULL false 9 NULL -7283 "qual" "clob" 0 0 7284 NULL false 10 NULL -7365 "function_id" "int" 32 0 7366 NULL true 0 NULL +5598 "id" "int" 32 0 5597 NULL true 0 NULL +5599 "name" "varchar" 1024 0 5597 NULL true 1 NULL +5600 "schema_id" "int" 32 0 5597 NULL true 2 NULL +5601 "query" "varchar" 2048 0 5597 NULL true 3 NULL +5602 "type" "smallint" 16 0 5597 NULL true 4 NULL +5603 "system" "boolean" 1 0 5597 NULL true 5 NULL +5604 "commit_action" "smallint" 16 0 5597 NULL true 6 NULL +5605 "access" "smallint" 16 0 5597 NULL true 7 NULL +5606 "temporary" "smallint" 16 0 5597 NULL true 8 NULL +5608 "id" "int" 32 0 5607 NULL true 0 NULL +5609 "name" "varchar" 1024 0 5607 NULL true 1 NULL +5610 "type" "varchar" 1024 0 5607 NULL true 2 NULL _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
