Changeset: f86eeaf85319 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=f86eeaf85319 Modified Files: clients/Tests/SQL-dump.stable.out clients/Tests/SQL-dump.stable.out.int128 clients/mapiclient/tachograph.c 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-2013/Tests/sort_void_crash.Bug-3341.stable.out sql/test/BugTracker/Tests/with_row_number.SF-1898089.stable.out Branch: profiler Log Message:
Approve output after merge diffs (truncated from 12326 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 @@ -151,7 +151,6 @@ 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 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 @@ -147,7 +147,6 @@ 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 @@ -1529,234 +1528,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 -5610 "id" "int" 32 0 5609 NULL true 0 NULL -5611 "name" "varchar" 1024 0 5609 NULL true 1 NULL -5612 "schema_id" "int" 32 0 5609 NULL true 2 NULL -5613 "query" "varchar" 2048 0 5609 NULL true 3 NULL -5614 "type" "smallint" 16 0 5609 NULL true 4 NULL -5615 "system" "boolean" 1 0 5609 NULL true 5 NULL -5616 "commit_action" "smallint" 16 0 5609 NULL true 6 NULL -5617 "access" "smallint" 16 0 5609 NULL true 7 NULL -5618 "temporary" "smallint" 16 0 5609 NULL true 8 NULL -5620 "id" "int" 32 0 5619 NULL true 0 NULL -5621 "name" "varchar" 1024 0 5619 NULL true 1 NULL -5622 "type" "varchar" 1024 0 5619 NULL true 2 NULL -5623 "type_digits" "int" 32 0 5619 NULL true 3 NULL -5624 "type_scale" "int" 32 0 5619 NULL true 4 NULL -5625 "table_id" "int" 32 0 5619 NULL true 5 NULL -5626 "default" "varchar" 2048 0 5619 NULL true 6 NULL -5627 "null" "boolean" 1 0 5619 NULL true 7 NULL -5628 "number" "int" 32 0 5619 NULL true 8 NULL -5629 "storage" "varchar" 2048 0 5619 NULL true 9 NULL -5636 "name" "varchar" 1024 0 5635 NULL true 0 NULL -5637 "fullname" "varchar" 2048 0 5635 NULL true 1 NULL -5638 "default_schema" "int" 9 0 5635 NULL true 2 NULL -5642 "name" "varchar" 1024 0 5641 NULL true 0 NULL -5643 "fullname" "varchar" 2024 0 5641 NULL true 1 NULL -5644 "default_schema" "int" 9 0 5641 NULL true 2 NULL -5646 "login_id" "int" 32 0 5645 NULL true 0 NULL -5647 "role_id" "int" 32 0 5645 NULL true 1 NULL -5649 "id" "int" 32 0 5648 NULL true 0 NULL -5650 "name" "varchar" 1024 0 5648 NULL true 1 NULL -5651 "grantor" "int" 32 0 5648 NULL true 2 NULL -5653 "obj_id" "int" 32 0 5652 NULL true 0 NULL -5654 "auth_id" "int" 32 0 5652 NULL true 1 NULL -5655 "privileges" "int" 32 0 5652 NULL true 2 NULL -5656 "grantor" "int" 32 0 5652 NULL true 3 NULL -5657 "grantable" "int" 32 0 5652 NULL true 4 NULL -5866 "id" "oid" 63 0 5874 NULL true 0 NULL -5867 "owner" "clob" 0 0 5874 NULL true 1 NULL -5868 "defined" "timestamp" 7 0 5874 NULL true 2 NULL -5869 "query" "clob" 0 0 5874 NULL true 3 NULL -5870 "pipe" "clob" 0 0 5874 NULL true 4 NULL -5871 "plan" "clob" 0 0 5874 NULL true 5 NULL -5872 "mal" "int" 32 0 5874 NULL true 6 NULL -5873 "optimize" "bigint" 64 0 5874 NULL true 7 NULL -5876 "id" "oid" 63 0 5885 NULL true 0 NULL -5877 "start" "timestamp" 7 0 5885 NULL true 1 NULL -5878 "stop" "timestamp" 7 0 5885 NULL true 2 NULL -5879 "arguments" "clob" 0 0 5885 NULL true 3 NULL -5880 "tuples" "wrd" 64 0 5885 NULL true 4 NULL -5881 "run" "bigint" 64 0 5885 NULL true 5 NULL -5882 "ship" "bigint" 64 0 5885 NULL true 6 NULL -5883 "cpu" "int" 32 0 5885 NULL true 7 NULL -5884 "io" "int" 32 0 5885 NULL true 8 NULL -5887 "id" "oid" 63 0 5903 NULL true 0 NULL -5888 "owner" "clob" 0 0 5903 NULL true 1 NULL -5889 "defined" "timestamp" 7 0 5903 NULL true 2 NULL -5890 "query" "clob" 0 0 5903 NULL true 3 NULL -5891 "pipe" "clob" 0 0 5903 NULL true 4 NULL -5892 "plan" "clob" 0 0 5903 NULL true 5 NULL -5893 "mal" "int" 32 0 5903 NULL true 6 NULL -5894 "optimize" "bigint" 64 0 5903 NULL true 7 NULL -5895 "start" "timestamp" 7 0 5903 NULL true 8 NULL -5896 "stop" "timestamp" 7 0 5903 NULL true 9 NULL -5897 "arguments" "clob" 0 0 5903 NULL true 10 NULL -5898 "tuples" "wrd" 64 0 5903 NULL true 11 NULL -5899 "run" "bigint" 64 0 5903 NULL true 12 NULL -5900 "ship" "bigint" 64 0 5903 NULL true 13 NULL -5901 "cpu" "int" 32 0 5903 NULL true 14 NULL -5902 "io" "int" 32 0 5903 NULL true 15 NULL -5929 "event" "int" 32 0 5942 NULL true 0 NULL -5930 "clk" "varchar" 20 0 5942 NULL true 1 NULL -5931 "pc" "varchar" 50 0 5942 NULL true 2 NULL -5932 "thread" "int" 32 0 5942 NULL true 3 NULL -5933 "ticks" "bigint" 64 0 5942 NULL true 4 NULL -5934 "rrsmb" "bigint" 64 0 5942 NULL true 5 NULL -5935 "vmmb" "bigint" 64 0 5942 NULL true 6 NULL -5936 "reads" "bigint" 64 0 5942 NULL true 7 NULL -5937 "writes" "bigint" 64 0 5942 NULL true 8 NULL -5938 "minflt" "bigint" 64 0 5942 NULL true 9 NULL -5939 "majflt" "bigint" 64 0 5942 NULL true 10 NULL -5940 "nvcsw" "bigint" 64 0 5942 NULL true 11 NULL -5941 "stmt" "clob" 0 0 5942 NULL true 12 NULL -6076 "user" "clob" 0 0 6082 NULL true 0 NULL -6077 "login" "timestamp" 7 0 6082 NULL true 1 NULL -6078 "sessiontimeout" "bigint" 64 0 6082 NULL true 2 NULL -6079 "lastcommand" "timestamp" 7 0 6082 NULL true 3 NULL -6080 "querytimeout" "bigint" 64 0 6082 NULL true 4 NULL -6081 "active" "boolean" 1 0 6082 NULL true 5 NULL -6159 "name" "clob" 0 0 6162 NULL true 0 NULL -6160 "def" "clob" 0 0 6162 NULL true 1 NULL -6161 "status" "clob" 0 0 6162 NULL true 2 NULL -6168 "name" "clob" 0 0 6170 NULL true 0 NULL -6169 "value" "clob" 0 0 6170 NULL true 1 NULL -6202 "qtag" "bigint" 64 0 6210 NULL true 0 NULL -6203 "user" "clob" 0 0 6210 NULL true 1 NULL -6204 "started" "timestamp" 7 0 6210 NULL true 2 NULL -6205 "estimate" "timestamp" 7 0 6210 NULL true 3 NULL -6206 "progress" "int" 32 0 6210 NULL true 4 NULL -6207 "status" "clob" 0 0 6210 NULL true 5 NULL -6208 "tag" "oid" 63 0 6210 NULL true 6 NULL -6209 "query" "clob" 0 0 6210 NULL true 7 NULL -6236 "rowid" "bigint" 64 0 6240 NULL true 0 NULL -6237 "fldid" "int" 32 0 6240 NULL true 1 NULL -6238 "message" "clob" 0 0 6240 NULL true 2 NULL -6239 "input" "clob" 0 0 6240 NULL true 3 NULL -6895 "keyword" "varchar" 40 0 6898 NULL false 0 NULL -6900 "table_type_id" "smallint" 16 0 6906 NULL false 0 NULL -6903 "table_type_name" "varchar" 25 0 6906 NULL false 1 NULL -6908 "dependency_type_id" "smallint" 16 0 6914 NULL false 0 NULL -6911 "dependency_type_name" "varchar" 15 0 6914 NULL false 1 NULL -6929 "file_id" "int" 32 0 6931 NULL true 0 NULL -6930 "location" "char" 256 0 6931 NULL true 1 NULL -6933 "dim_id" "int" 32 0 6937 NULL true 0 NULL -6934 "file_id" "int" 32 0 6937 NULL true 1 NULL -6935 "name" "varchar" 64 0 6937 NULL true 2 NULL -6936 "length" "int" 32 0 6937 NULL true 3 NULL -6939 "var_id" "int" 32 0 6945 NULL true 0 NULL -6940 "file_id" "int" 32 0 6945 NULL true 1 NULL -6941 "name" "varchar" 64 0 6945 NULL true 2 NULL -6942 "vartype" "varchar" 64 0 6945 NULL true 3 NULL -6943 "ndim" "int" 32 0 6945 NULL true 4 NULL -6944 "coord_dim_id" "int" 32 0 6945 NULL true 5 NULL -6947 "var_id" "int" 32 0 6951 NULL true 0 NULL -6948 "dim_id" "int" 32 0 6951 NULL true 1 NULL -6949 "file_id" "int" 32 0 6951 NULL true 2 NULL -6950 "dimpos" "int" 32 0 6951 NULL true 3 NULL -6953 "obj_name" "varchar" 256 0 6959 NULL true 0 NULL -6954 "att_name" "varchar" 256 0 6959 NULL true 1 NULL -6955 "att_type" "varchar" 64 0 6959 NULL true 2 NULL -6956 "value" "clob" 0 0 6959 NULL true 3 NULL -6957 "file_id" "int" 32 0 6959 NULL true 4 NULL -6958 "gr_name" "varchar" 256 0 6959 NULL true 5 NULL -6984 "schema" "clob" 0 0 6998 NULL true 0 NULL -6985 "table" "clob" 0 0 6998 NULL true 1 NULL -6986 "column" "clob" 0 0 6998 NULL true 2 NULL -6987 "type" "clob" 0 0 6998 NULL true 3 NULL -6988 "mode" "clob" 0 0 6998 NULL true 4 NULL -6989 "location" "clob" 0 0 6998 NULL true 5 NULL -6990 "count" "bigint" 64 0 6998 NULL true 6 NULL -6991 "typewidth" "int" 32 0 6998 NULL true 7 NULL -6992 "columnsize" "bigint" 64 0 6998 NULL true 8 NULL -6993 "heapsize" "bigint" 64 0 6998 NULL true 9 NULL -6994 "hashes" "bigint" 64 0 6998 NULL true 10 NULL -6995 "phash" "boolean" 1 0 6998 NULL true 11 NULL -6996 "imprints" "bigint" 64 0 6998 NULL true 12 NULL -6997 "sorted" "boolean" 1 0 6998 NULL true 13 NULL -7000 "schema" "clob" 0 0 7010 NULL true 0 NULL -7001 "table" "clob" 0 0 7010 NULL true 1 NULL -7002 "column" "clob" 0 0 7010 NULL true 2 NULL -7003 "type" "clob" 0 0 7010 NULL true 3 NULL -7004 "typewidth" "int" 32 0 7010 NULL true 4 NULL -7005 "count" "bigint" 64 0 7010 NULL true 5 NULL -7006 "distinct" "bigint" 64 0 7010 NULL true 6 NULL -7007 "atomwidth" "int" 32 0 7010 NULL true 7 NULL -7008 "reference" "boolean" 1 0 7010 NULL true 8 NULL -7009 "sorted" "boolean" 1 0 7010 NULL true 9 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 _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
