Changeset: 45d55ac4b0f9 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=45d55ac4b0f9 Modified Files: clients/Tests/SQL-dump.stable.out.int128 sql/test/Tests/systemfunctions.stable.out Branch: Jul2015 Log Message:
approved output diffs (truncated from 3040 to 300 lines): 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 @@ -1595,153 +1595,153 @@ 5989 "minflt" "bigint" 64 0 5993 NULL tr 5990 "majflt" "bigint" 64 0 5993 NULL true 10 NULL 5991 "nvcsw" "bigint" 64 0 5993 NULL true 11 NULL 5992 "stmt" "clob" 0 0 5993 NULL true 12 NULL -6123 "user" "clob" 0 0 6129 NULL true 0 NULL -6124 "login" "timestamp" 7 0 6129 NULL true 1 NULL -6125 "sessiontimeout" "bigint" 64 0 6129 NULL true 2 NULL -6126 "lastcommand" "timestamp" 7 0 6129 NULL true 3 NULL -6127 "querytimeout" "bigint" 64 0 6129 NULL true 4 NULL -6128 "active" "boolean" 1 0 6129 NULL true 5 NULL -6206 "name" "clob" 0 0 6209 NULL true 0 NULL -6207 "def" "clob" 0 0 6209 NULL true 1 NULL -6208 "status" "clob" 0 0 6209 NULL true 2 NULL -6215 "name" "clob" 0 0 6217 NULL true 0 NULL -6216 "value" "clob" 0 0 6217 NULL true 1 NULL -6247 "qtag" "bigint" 64 0 6255 NULL true 0 NULL -6248 "user" "clob" 0 0 6255 NULL true 1 NULL -6249 "started" "timestamp" 7 0 6255 NULL true 2 NULL -6250 "estimate" "timestamp" 7 0 6255 NULL true 3 NULL -6251 "progress" "int" 32 0 6255 NULL true 4 NULL -6252 "status" "clob" 0 0 6255 NULL true 5 NULL -6253 "tag" "oid" 63 0 6255 NULL true 6 NULL -6254 "query" "clob" 0 0 6255 NULL true 7 NULL -6281 "rowid" "bigint" 64 0 6285 NULL true 0 NULL -6282 "fldid" "int" 32 0 6285 NULL true 1 NULL -6283 "message" "clob" 0 0 6285 NULL true 2 NULL -6284 "input" "clob" 0 0 6285 NULL true 3 NULL -6940 "keyword" "varchar" 40 0 6943 NULL false 0 NULL -6945 "table_type_id" "smallint" 16 0 6951 NULL false 0 NULL -6948 "table_type_name" "varchar" 25 0 6951 NULL false 1 NULL -6953 "dependency_type_id" "smallint" 16 0 6959 NULL false 0 NULL -6956 "dependency_type_name" "varchar" 15 0 6959 NULL false 1 NULL -6974 "file_id" "int" 32 0 6976 NULL true 0 NULL -6975 "location" "char" 256 0 6976 NULL true 1 NULL -6978 "dim_id" "int" 32 0 6982 NULL true 0 NULL -6979 "file_id" "int" 32 0 6982 NULL true 1 NULL -6980 "name" "varchar" 64 0 6982 NULL true 2 NULL -6981 "length" "int" 32 0 6982 NULL true 3 NULL -6984 "var_id" "int" 32 0 6990 NULL true 0 NULL -6985 "file_id" "int" 32 0 6990 NULL true 1 NULL -6986 "name" "varchar" 64 0 6990 NULL true 2 NULL -6987 "vartype" "varchar" 64 0 6990 NULL true 3 NULL -6988 "ndim" "int" 32 0 6990 NULL true 4 NULL -6989 "coord_dim_id" "int" 32 0 6990 NULL true 5 NULL -6992 "var_id" "int" 32 0 6996 NULL true 0 NULL -6993 "dim_id" "int" 32 0 6996 NULL true 1 NULL -6994 "file_id" "int" 32 0 6996 NULL true 2 NULL -6995 "dimpos" "int" 32 0 6996 NULL true 3 NULL -6998 "obj_name" "varchar" 256 0 7004 NULL true 0 NULL -6999 "att_name" "varchar" 256 0 7004 NULL true 1 NULL -7000 "att_type" "varchar" 64 0 7004 NULL true 2 NULL -7001 "value" "clob" 0 0 7004 NULL true 3 NULL -7002 "file_id" "int" 32 0 7004 NULL true 4 NULL -7003 "gr_name" "varchar" 256 0 7004 NULL true 5 NULL -7029 "schema" "clob" 0 0 7043 NULL true 0 NULL -7030 "table" "clob" 0 0 7043 NULL true 1 NULL -7031 "column" "clob" 0 0 7043 NULL true 2 NULL -7032 "type" "clob" 0 0 7043 NULL true 3 NULL -7033 "mode" "clob" 0 0 7043 NULL true 4 NULL -7034 "location" "clob" 0 0 7043 NULL true 5 NULL -7035 "count" "bigint" 64 0 7043 NULL true 6 NULL -7036 "typewidth" "int" 32 0 7043 NULL true 7 NULL -7037 "columnsize" "bigint" 64 0 7043 NULL true 8 NULL -7038 "heapsize" "bigint" 64 0 7043 NULL true 9 NULL -7039 "hashes" "bigint" 64 0 7043 NULL true 10 NULL -7040 "phash" "boolean" 1 0 7043 NULL true 11 NULL -7041 "imprints" "bigint" 64 0 7043 NULL true 12 NULL -7042 "sorted" "boolean" 1 0 7043 NULL true 13 NULL -7045 "schema" "clob" 0 0 7055 NULL true 0 NULL -7046 "table" "clob" 0 0 7055 NULL true 1 NULL -7047 "column" "clob" 0 0 7055 NULL true 2 NULL -7048 "type" "clob" 0 0 7055 NULL true 3 NULL -7049 "typewidth" "int" 32 0 7055 NULL true 4 NULL -7050 "count" "bigint" 64 0 7055 NULL true 5 NULL -7051 "distinct" "bigint" 64 0 7055 NULL true 6 NULL -7052 "atomwidth" "int" 32 0 7055 NULL true 7 NULL -7053 "reference" "boolean" 1 0 7055 NULL true 8 NULL -7054 "sorted" "boolean" 1 0 7055 NULL true 9 NULL -7093 "schema" "clob" 0 0 7103 NULL true 0 NULL -7094 "table" "clob" 0 0 7103 NULL true 1 NULL -7095 "column" "clob" 0 0 7103 NULL true 2 NULL -7096 "type" "clob" 0 0 7103 NULL true 3 NULL -7097 "count" "bigint" 64 0 7103 NULL true 4 NULL -7098 "columnsize" "bigint" 64 0 7103 NULL true 5 NULL -7099 "heapsize" "bigint" 64 0 7103 NULL true 6 NULL -7100 "hashes" "bigint" 64 0 7103 NULL true 7 NULL -7101 "imprints" "bigint" 64 0 7103 NULL true 8 NULL -7102 "sorted" "boolean" 1 0 7103 NULL true 9 NULL -7105 "schema" "clob" 0 0 7113 NULL true 0 NULL -7106 "table" "clob" 0 0 7113 NULL true 1 NULL -7107 "count" "bigint" 64 0 7113 NULL true 2 NULL -7108 "columnsize" "hugeint" 128 0 7113 NULL true 3 NULL -7109 "heapsize" "hugeint" 128 0 7113 NULL true 4 NULL -7110 "hashes" "hugeint" 128 0 7113 NULL true 5 NULL -7111 "imprints" "hugeint" 128 0 7113 NULL true 6 NULL -7112 "auxiliary" "hugeint" 128 0 7113 NULL true 7 NULL -7115 "column_id" "int" 32 0 7126 NULL true 0 NULL -7116 "type" "clob" 0 0 7126 NULL true 1 NULL -7117 "width" "int" 32 0 7126 NULL true 2 NULL -7118 "stamp" "timestamp" 7 0 7126 NULL true 3 NULL -7119 "sample" "bigint" 64 0 7126 NULL true 4 NULL -7120 "count" "bigint" 64 0 7126 NULL true 5 NULL -7121 "unique" "bigint" 64 0 7126 NULL true 6 NULL -7122 "nils" "bigint" 64 0 7126 NULL true 7 NULL -7123 "minval" "clob" 0 0 7126 NULL true 8 NULL -7124 "maxval" "clob" 0 0 7126 NULL true 9 NULL -7125 "sorted" "boolean" 1 0 7126 NULL true 10 NULL -7216 "file_id" "bigint" 64 0 7224 NULL false 0 NULL -7217 "file_location" "clob" 0 0 7224 NULL false 1 NULL -7218 "dbschema" "smallint" 16 0 7224 NULL false 2 NULL -7219 "format_version" "varchar" 7 0 7224 NULL true 3 NULL -7220 "sorting_order" "varchar" 10 0 7224 NULL true 4 NULL -7221 "comments" "clob" 0 0 7224 NULL true 5 NULL -7226 "sn" "clob" 0 0 7237 NULL false 0 NULL -7227 "file_id" "bigint" 64 0 7237 NULL false 1 NULL -7228 "ln" "int" 32 0 7237 NULL true 2 NULL -7229 "as" "int" 32 0 7237 NULL true 3 NULL -7230 "m5" "clob" 0 0 7237 NULL true 4 NULL -7231 "sp" "clob" 0 0 7237 NULL true 5 NULL -7232 "ur" "clob" 0 0 7237 NULL true 6 NULL -7239 "id" "clob" 0 0 7256 NULL false 0 NULL -7240 "file_id" "bigint" 64 0 7256 NULL false 1 NULL -7241 "cn" "clob" 0 0 7256 NULL true 2 NULL -7242 "ds" "clob" 0 0 7256 NULL true 3 NULL -7243 "dt" "timestamp" 7 0 7256 NULL true 4 NULL -7244 "fo" "clob" 0 0 7256 NULL true 5 NULL -7245 "ks" "clob" 0 0 7256 NULL true 6 NULL -7246 "lb" "clob" 0 0 7256 NULL true 7 NULL -7247 "pg" "clob" 0 0 7256 NULL true 8 NULL -7248 "pi" "int" 32 0 7256 NULL true 9 NULL -7249 "pl" "clob" 0 0 7256 NULL true 10 NULL -7250 "pu" "clob" 0 0 7256 NULL true 11 NULL -7251 "sm" "clob" 0 0 7256 NULL true 12 NULL -7258 "id" "clob" 0 0 7268 NULL false 0 NULL -7259 "file_id" "bigint" 64 0 7268 NULL false 1 NULL -7260 "pn" "clob" 0 0 7268 NULL true 2 NULL -7261 "cl" "clob" 0 0 7268 NULL true 3 NULL -7262 "pp" "clob" 0 0 7268 NULL true 4 NULL -7263 "vn" "clob" 0 0 7268 NULL true 5 NULL -7270 "qname" "clob" 0 0 7281 NULL false 0 NULL -7271 "flag" "smallint" 16 0 7281 NULL false 1 NULL -7272 "rname" "clob" 0 0 7281 NULL false 2 NULL -7273 "pos" "int" 32 0 7281 NULL false 3 NULL -7274 "mapq" "smallint" 16 0 7281 NULL false 4 NULL -7275 "cigar" "clob" 0 0 7281 NULL false 5 NULL -7276 "rnext" "clob" 0 0 7281 NULL false 6 NULL -7277 "pnext" "int" 32 0 7281 NULL false 7 NULL -7278 "tlen" "int" 32 0 7281 NULL false 8 NULL -7279 "seq" "clob" 0 0 7281 NULL false 9 NULL -7280 "qual" "clob" 0 0 7281 NULL false 10 NULL -7362 "function_id" "int" 32 0 7363 NULL true 0 NULL +6127 "user" "clob" 0 0 6133 NULL true 0 NULL +6128 "login" "timestamp" 7 0 6133 NULL true 1 NULL +6129 "sessiontimeout" "bigint" 64 0 6133 NULL true 2 NULL +6130 "lastcommand" "timestamp" 7 0 6133 NULL true 3 NULL +6131 "querytimeout" "bigint" 64 0 6133 NULL true 4 NULL +6132 "active" "boolean" 1 0 6133 NULL true 5 NULL +6210 "name" "clob" 0 0 6213 NULL true 0 NULL +6211 "def" "clob" 0 0 6213 NULL true 1 NULL +6212 "status" "clob" 0 0 6213 NULL true 2 NULL +6219 "name" "clob" 0 0 6221 NULL true 0 NULL +6220 "value" "clob" 0 0 6221 NULL true 1 NULL +6251 "qtag" "bigint" 64 0 6259 NULL true 0 NULL +6252 "user" "clob" 0 0 6259 NULL true 1 NULL +6253 "started" "timestamp" 7 0 6259 NULL true 2 NULL +6254 "estimate" "timestamp" 7 0 6259 NULL true 3 NULL +6255 "progress" "int" 32 0 6259 NULL true 4 NULL +6256 "status" "clob" 0 0 6259 NULL true 5 NULL +6257 "tag" "oid" 63 0 6259 NULL true 6 NULL +6258 "query" "clob" 0 0 6259 NULL true 7 NULL +6285 "rowid" "bigint" 64 0 6289 NULL true 0 NULL +6286 "fldid" "int" 32 0 6289 NULL true 1 NULL +6287 "message" "clob" 0 0 6289 NULL true 2 NULL +6288 "input" "clob" 0 0 6289 NULL true 3 NULL +6944 "keyword" "varchar" 40 0 6947 NULL false 0 NULL +6949 "table_type_id" "smallint" 16 0 6955 NULL false 0 NULL +6952 "table_type_name" "varchar" 25 0 6955 NULL false 1 NULL +6957 "dependency_type_id" "smallint" 16 0 6963 NULL false 0 NULL +6960 "dependency_type_name" "varchar" 15 0 6963 NULL false 1 NULL +6978 "file_id" "int" 32 0 6980 NULL true 0 NULL +6979 "location" "char" 256 0 6980 NULL true 1 NULL +6982 "dim_id" "int" 32 0 6986 NULL true 0 NULL +6983 "file_id" "int" 32 0 6986 NULL true 1 NULL +6984 "name" "varchar" 64 0 6986 NULL true 2 NULL +6985 "length" "int" 32 0 6986 NULL true 3 NULL +6988 "var_id" "int" 32 0 6994 NULL true 0 NULL +6989 "file_id" "int" 32 0 6994 NULL true 1 NULL +6990 "name" "varchar" 64 0 6994 NULL true 2 NULL +6991 "vartype" "varchar" 64 0 6994 NULL true 3 NULL +6992 "ndim" "int" 32 0 6994 NULL true 4 NULL +6993 "coord_dim_id" "int" 32 0 6994 NULL true 5 NULL +6996 "var_id" "int" 32 0 7000 NULL true 0 NULL +6997 "dim_id" "int" 32 0 7000 NULL true 1 NULL +6998 "file_id" "int" 32 0 7000 NULL true 2 NULL +6999 "dimpos" "int" 32 0 7000 NULL true 3 NULL +7002 "obj_name" "varchar" 256 0 7008 NULL true 0 NULL +7003 "att_name" "varchar" 256 0 7008 NULL true 1 NULL +7004 "att_type" "varchar" 64 0 7008 NULL true 2 NULL +7005 "value" "clob" 0 0 7008 NULL true 3 NULL +7006 "file_id" "int" 32 0 7008 NULL true 4 NULL +7007 "gr_name" "varchar" 256 0 7008 NULL true 5 NULL +7033 "schema" "clob" 0 0 7047 NULL true 0 NULL +7034 "table" "clob" 0 0 7047 NULL true 1 NULL +7035 "column" "clob" 0 0 7047 NULL true 2 NULL +7036 "type" "clob" 0 0 7047 NULL true 3 NULL +7037 "mode" "clob" 0 0 7047 NULL true 4 NULL +7038 "location" "clob" 0 0 7047 NULL true 5 NULL +7039 "count" "bigint" 64 0 7047 NULL true 6 NULL +7040 "typewidth" "int" 32 0 7047 NULL true 7 NULL +7041 "columnsize" "bigint" 64 0 7047 NULL true 8 NULL +7042 "heapsize" "bigint" 64 0 7047 NULL true 9 NULL +7043 "hashes" "bigint" 64 0 7047 NULL true 10 NULL +7044 "phash" "boolean" 1 0 7047 NULL true 11 NULL +7045 "imprints" "bigint" 64 0 7047 NULL true 12 NULL +7046 "sorted" "boolean" 1 0 7047 NULL true 13 NULL +7049 "schema" "clob" 0 0 7059 NULL true 0 NULL +7050 "table" "clob" 0 0 7059 NULL true 1 NULL +7051 "column" "clob" 0 0 7059 NULL true 2 NULL +7052 "type" "clob" 0 0 7059 NULL true 3 NULL +7053 "typewidth" "int" 32 0 7059 NULL true 4 NULL +7054 "count" "bigint" 64 0 7059 NULL true 5 NULL +7055 "distinct" "bigint" 64 0 7059 NULL true 6 NULL +7056 "atomwidth" "int" 32 0 7059 NULL true 7 NULL +7057 "reference" "boolean" 1 0 7059 NULL true 8 NULL +7058 "sorted" "boolean" 1 0 7059 NULL true 9 NULL +7097 "schema" "clob" 0 0 7107 NULL true 0 NULL +7098 "table" "clob" 0 0 7107 NULL true 1 NULL +7099 "column" "clob" 0 0 7107 NULL true 2 NULL +7100 "type" "clob" 0 0 7107 NULL true 3 NULL +7101 "count" "bigint" 64 0 7107 NULL true 4 NULL +7102 "columnsize" "bigint" 64 0 7107 NULL true 5 NULL +7103 "heapsize" "bigint" 64 0 7107 NULL true 6 NULL +7104 "hashes" "bigint" 64 0 7107 NULL true 7 NULL +7105 "imprints" "bigint" 64 0 7107 NULL true 8 NULL +7106 "sorted" "boolean" 1 0 7107 NULL true 9 NULL +7109 "schema" "clob" 0 0 7117 NULL true 0 NULL +7110 "table" "clob" 0 0 7117 NULL true 1 NULL +7111 "count" "bigint" 64 0 7117 NULL true 2 NULL +7112 "columnsize" "hugeint" 128 0 7117 NULL true 3 NULL +7113 "heapsize" "hugeint" 128 0 7117 NULL true 4 NULL +7114 "hashes" "hugeint" 128 0 7117 NULL true 5 NULL +7115 "imprints" "hugeint" 128 0 7117 NULL true 6 NULL +7116 "auxiliary" "hugeint" 128 0 7117 NULL true 7 NULL +7119 "column_id" "int" 32 0 7130 NULL true 0 NULL +7120 "type" "clob" 0 0 7130 NULL true 1 NULL +7121 "width" "int" 32 0 7130 NULL true 2 NULL +7122 "stamp" "timestamp" 7 0 7130 NULL true 3 NULL +7123 "sample" "bigint" 64 0 7130 NULL true 4 NULL +7124 "count" "bigint" 64 0 7130 NULL true 5 NULL +7125 "unique" "bigint" 64 0 7130 NULL true 6 NULL +7126 "nils" "bigint" 64 0 7130 NULL true 7 NULL +7127 "minval" "clob" 0 0 7130 NULL true 8 NULL +7128 "maxval" "clob" 0 0 7130 NULL true 9 NULL +7129 "sorted" "boolean" 1 0 7130 NULL true 10 NULL +7220 "file_id" "bigint" 64 0 7228 NULL false 0 NULL +7221 "file_location" "clob" 0 0 7228 NULL false 1 NULL +7222 "dbschema" "smallint" 16 0 7228 NULL false 2 NULL +7223 "format_version" "varchar" 7 0 7228 NULL true 3 NULL +7224 "sorting_order" "varchar" 10 0 7228 NULL true 4 NULL +7225 "comments" "clob" 0 0 7228 NULL true 5 NULL +7230 "sn" "clob" 0 0 7241 NULL false 0 NULL +7231 "file_id" "bigint" 64 0 7241 NULL false 1 NULL +7232 "ln" "int" 32 0 7241 NULL true 2 NULL +7233 "as" "int" 32 0 7241 NULL true 3 NULL +7234 "m5" "clob" 0 0 7241 NULL true 4 NULL +7235 "sp" "clob" 0 0 7241 NULL true 5 NULL +7236 "ur" "clob" 0 0 7241 NULL true 6 NULL +7243 "id" "clob" 0 0 7260 NULL false 0 NULL +7244 "file_id" "bigint" 64 0 7260 NULL false 1 NULL +7245 "cn" "clob" 0 0 7260 NULL true 2 NULL +7246 "ds" "clob" 0 0 7260 NULL true 3 NULL +7247 "dt" "timestamp" 7 0 7260 NULL true 4 NULL +7248 "fo" "clob" 0 0 7260 NULL true 5 NULL +7249 "ks" "clob" 0 0 7260 NULL true 6 NULL +7250 "lb" "clob" 0 0 7260 NULL true 7 NULL +7251 "pg" "clob" 0 0 7260 NULL true 8 NULL +7252 "pi" "int" 32 0 7260 NULL true 9 NULL +7253 "pl" "clob" 0 0 7260 NULL true 10 NULL +7254 "pu" "clob" 0 0 7260 NULL true 11 NULL +7255 "sm" "clob" 0 0 7260 NULL true 12 NULL +7262 "id" "clob" 0 0 7272 NULL false 0 NULL +7263 "file_id" "bigint" 64 0 7272 NULL false 1 NULL +7264 "pn" "clob" 0 0 7272 NULL true 2 NULL +7265 "cl" "clob" 0 0 7272 NULL true 3 NULL +7266 "pp" "clob" 0 0 7272 NULL true 4 NULL +7267 "vn" "clob" 0 0 7272 NULL true 5 NULL +7274 "qname" "clob" 0 0 7285 NULL false 0 NULL +7275 "flag" "smallint" 16 0 7285 NULL false 1 NULL +7276 "rname" "clob" 0 0 7285 NULL false 2 NULL +7277 "pos" "int" 32 0 7285 NULL false 3 NULL +7278 "mapq" "smallint" 16 0 7285 NULL false 4 NULL +7279 "cigar" "clob" 0 0 7285 NULL false 5 NULL +7280 "rnext" "clob" 0 0 7285 NULL false 6 NULL +7281 "pnext" "int" 32 0 7285 NULL false 7 NULL +7282 "tlen" "int" 32 0 7285 NULL false 8 NULL +7283 "seq" "clob" 0 0 7285 NULL false 9 NULL +7284 "qual" "clob" 0 0 7285 NULL false 10 NULL _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
