Changeset: a78a9f287a12 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=a78a9f287a12 Modified Files: clients/Tests/SQL-dump.stable.out clients/Tests/SQL-dump.stable.out.int128 sql/backends/monet5/Tests/simpleSQL.stable.err Branch: embedded Log Message:
Approvals. diffs (truncated from 12901 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 @@ -1381,246 +1381,246 @@ 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 -5682 "id" "int" 32 0 5681 NULL true 0 NULL -5683 "name" "varchar" 1024 0 5681 NULL true 1 NULL -5684 "schema_id" "int" 32 0 5681 NULL true 2 NULL -5685 "query" "varchar" 2048 0 5681 NULL true 3 NULL -5686 "type" "smallint" 16 0 5681 NULL true 4 NULL -5687 "system" "boolean" 1 0 5681 NULL true 5 NULL -5688 "commit_action" "smallint" 16 0 5681 NULL true 6 NULL -5689 "access" "smallint" 16 0 5681 NULL true 7 NULL -5690 "temporary" "smallint" 16 0 5681 NULL true 8 NULL -5692 "id" "int" 32 0 5691 NULL true 0 NULL -5693 "name" "varchar" 1024 0 5691 NULL true 1 NULL -5694 "type" "varchar" 1024 0 5691 NULL true 2 NULL -5695 "type_digits" "int" 32 0 5691 NULL true 3 NULL -5696 "type_scale" "int" 32 0 5691 NULL true 4 NULL -5697 "table_id" "int" 32 0 5691 NULL true 5 NULL -5698 "default" "varchar" 2048 0 5691 NULL true 6 NULL -5699 "null" "boolean" 1 0 5691 NULL true 7 NULL -5700 "number" "int" 32 0 5691 NULL true 8 NULL -5701 "storage" "varchar" 2048 0 5691 NULL true 9 NULL -5708 "name" "varchar" 1024 0 5707 NULL true 0 NULL -5709 "fullname" "varchar" 2048 0 5707 NULL true 1 NULL -5710 "default_schema" "int" 9 0 5707 NULL true 2 NULL -5714 "name" "varchar" 1024 0 5713 NULL true 0 NULL -5715 "fullname" "varchar" 2024 0 5713 NULL true 1 NULL -5716 "default_schema" "int" 9 0 5713 NULL true 2 NULL -5718 "login_id" "int" 32 0 5717 NULL true 0 NULL -5719 "role_id" "int" 32 0 5717 NULL true 1 NULL -5721 "id" "int" 32 0 5720 NULL true 0 NULL -5722 "name" "varchar" 1024 0 5720 NULL true 1 NULL -5723 "grantor" "int" 32 0 5720 NULL true 2 NULL -5725 "obj_id" "int" 32 0 5724 NULL true 0 NULL -5726 "auth_id" "int" 32 0 5724 NULL true 1 NULL -5727 "privileges" "int" 32 0 5724 NULL true 2 NULL -5728 "grantor" "int" 32 0 5724 NULL true 3 NULL -5729 "grantable" "int" 32 0 5724 NULL true 4 NULL -5938 "id" "oid" 63 0 5946 NULL true 0 NULL -5939 "owner" "clob" 0 0 5946 NULL true 1 NULL -5940 "defined" "timestamp" 7 0 5946 NULL true 2 NULL -5941 "query" "clob" 0 0 5946 NULL true 3 NULL -5942 "pipe" "clob" 0 0 5946 NULL true 4 NULL -5943 "plan" "clob" 0 0 5946 NULL true 5 NULL -5944 "mal" "int" 32 0 5946 NULL true 6 NULL -5945 "optimize" "bigint" 64 0 5946 NULL true 7 NULL -5948 "id" "oid" 63 0 5957 NULL true 0 NULL -5949 "start" "timestamp" 7 0 5957 NULL true 1 NULL -5950 "stop" "timestamp" 7 0 5957 NULL true 2 NULL -5951 "arguments" "clob" 0 0 5957 NULL true 3 NULL -5952 "tuples" "wrd" 64 0 5957 NULL true 4 NULL -5953 "run" "bigint" 64 0 5957 NULL true 5 NULL -5954 "ship" "bigint" 64 0 5957 NULL true 6 NULL -5955 "cpu" "int" 32 0 5957 NULL true 7 NULL -5956 "io" "int" 32 0 5957 NULL true 8 NULL -5959 "id" "oid" 63 0 5975 NULL true 0 NULL -5960 "owner" "clob" 0 0 5975 NULL true 1 NULL -5961 "defined" "timestamp" 7 0 5975 NULL true 2 NULL -5962 "query" "clob" 0 0 5975 NULL true 3 NULL -5963 "pipe" "clob" 0 0 5975 NULL true 4 NULL -5964 "plan" "clob" 0 0 5975 NULL true 5 NULL -5965 "mal" "int" 32 0 5975 NULL true 6 NULL -5966 "optimize" "bigint" 64 0 5975 NULL true 7 NULL -5967 "start" "timestamp" 7 0 5975 NULL true 8 NULL -5968 "stop" "timestamp" 7 0 5975 NULL true 9 NULL -5969 "arguments" "clob" 0 0 5975 NULL true 10 NULL -5970 "tuples" "wrd" 64 0 5975 NULL true 11 NULL -5971 "run" "bigint" 64 0 5975 NULL true 12 NULL -5972 "ship" "bigint" 64 0 5975 NULL true 13 NULL -5973 "cpu" "int" 32 0 5975 NULL true 14 NULL -5974 "io" "int" 32 0 5975 NULL true 15 NULL -6001 "event" "int" 32 0 6014 NULL true 0 NULL -6002 "clk" "varchar" 20 0 6014 NULL true 1 NULL -6003 "pc" "varchar" 50 0 6014 NULL true 2 NULL -6004 "thread" "int" 32 0 6014 NULL true 3 NULL -6005 "ticks" "bigint" 64 0 6014 NULL true 4 NULL -6006 "rrsmb" "bigint" 64 0 6014 NULL true 5 NULL -6007 "vmmb" "bigint" 64 0 6014 NULL true 6 NULL -6008 "reads" "bigint" 64 0 6014 NULL true 7 NULL -6009 "writes" "bigint" 64 0 6014 NULL true 8 NULL -6010 "minflt" "bigint" 64 0 6014 NULL true 9 NULL -6011 "majflt" "bigint" 64 0 6014 NULL true 10 NULL -6012 "nvcsw" "bigint" 64 0 6014 NULL true 11 NULL -6013 "stmt" "clob" 0 0 6014 NULL true 12 NULL -6141 "user" "clob" 0 0 6147 NULL true 0 NULL -6142 "login" "timestamp" 7 0 6147 NULL true 1 NULL -6143 "sessiontimeout" "bigint" 64 0 6147 NULL true 2 NULL -6144 "lastcommand" "timestamp" 7 0 6147 NULL true 3 NULL -6145 "querytimeout" "bigint" 64 0 6147 NULL true 4 NULL -6146 "active" "boolean" 1 0 6147 NULL true 5 NULL -6224 "name" "clob" 0 0 6227 NULL true 0 NULL -6225 "def" "clob" 0 0 6227 NULL true 1 NULL -6226 "status" "clob" 0 0 6227 NULL true 2 NULL -6233 "name" "clob" 0 0 6235 NULL true 0 NULL -6234 "value" "clob" 0 0 6235 NULL true 1 NULL -6275 "qtag" "bigint" 64 0 6283 NULL true 0 NULL -6276 "user" "clob" 0 0 6283 NULL true 1 NULL -6277 "started" "timestamp" 7 0 6283 NULL true 2 NULL -6278 "estimate" "timestamp" 7 0 6283 NULL true 3 NULL -6279 "progress" "int" 32 0 6283 NULL true 4 NULL -6280 "status" "clob" 0 0 6283 NULL true 5 NULL -6281 "tag" "oid" 63 0 6283 NULL true 6 NULL -6282 "query" "clob" 0 0 6283 NULL true 7 NULL -6309 "rowid" "bigint" 64 0 6313 NULL true 0 NULL -6310 "fldid" "int" 32 0 6313 NULL true 1 NULL -6311 "message" "clob" 0 0 6313 NULL true 2 NULL -6312 "input" "clob" 0 0 6313 NULL true 3 NULL -6624 "srid" "int" 32 0 6631 NULL false 0 NULL -6627 "auth_name" "varchar" 256 0 6631 NULL true 1 NULL -6628 "auth_srid" "int" 32 0 6631 NULL true 2 NULL -6629 "srtext" "varchar" 2048 0 6631 NULL true 3 NULL -6630 "proj4text" "varchar" 2048 0 6631 NULL true 4 NULL -6633 "f_table_catalog" "clob" 0 0 6640 NULL true 0 NULL -6634 "f_table_schema" "varchar" 1024 0 6640 NULL true 1 NULL -6635 "f_table_name" "varchar" 1024 0 6640 NULL true 2 NULL -6636 "f_geometry_column" "varchar" 1024 0 6640 NULL true 3 NULL -6637 "coord_dimension" "bigint" 64 0 6640 NULL true 4 NULL -6638 "srid" "int" 32 0 6640 NULL true 5 NULL -6639 "type" "clob" 0 0 6640 NULL true 6 NULL -7338 "keyword" "varchar" 40 0 7341 NULL false 0 NULL -7343 "table_type_id" "smallint" 16 0 7349 NULL false 0 NULL -7346 "table_type_name" "varchar" 25 0 7349 NULL false 1 NULL -7351 "dependency_type_id" "smallint" 16 0 7357 NULL false 0 NULL -7354 "dependency_type_name" "varchar" 15 0 7357 NULL false 1 NULL -7372 "file_id" "int" 32 0 7374 NULL true 0 NULL -7373 "location" "char" 256 0 7374 NULL true 1 NULL -7376 "dim_id" "int" 32 0 7380 NULL true 0 NULL -7377 "file_id" "int" 32 0 7380 NULL true 1 NULL -7378 "name" "varchar" 64 0 7380 NULL true 2 NULL -7379 "length" "int" 32 0 7380 NULL true 3 NULL -7382 "var_id" "int" 32 0 7388 NULL true 0 NULL -7383 "file_id" "int" 32 0 7388 NULL true 1 NULL -7384 "name" "varchar" 64 0 7388 NULL true 2 NULL -7385 "vartype" "varchar" 64 0 7388 NULL true 3 NULL -7386 "ndim" "int" 32 0 7388 NULL true 4 NULL -7387 "coord_dim_id" "int" 32 0 7388 NULL true 5 NULL -7390 "var_id" "int" 32 0 7394 NULL true 0 NULL -7391 "dim_id" "int" 32 0 7394 NULL true 1 NULL -7392 "file_id" "int" 32 0 7394 NULL true 2 NULL -7393 "dimpos" "int" 32 0 7394 NULL true 3 NULL -7396 "obj_name" "varchar" 256 0 7402 NULL true 0 NULL -7397 "att_name" "varchar" 256 0 7402 NULL true 1 NULL -7398 "att_type" "varchar" 64 0 7402 NULL true 2 NULL -7399 "value" "clob" 0 0 7402 NULL true 3 NULL -7400 "file_id" "int" 32 0 7402 NULL true 4 NULL -7401 "gr_name" "varchar" 256 0 7402 NULL true 5 NULL -7427 "schema" "clob" 0 0 7441 NULL true 0 NULL -7428 "table" "clob" 0 0 7441 NULL true 1 NULL -7429 "column" "clob" 0 0 7441 NULL true 2 NULL -7430 "type" "clob" 0 0 7441 NULL true 3 NULL -7431 "mode" "clob" 0 0 7441 NULL true 4 NULL -7432 "location" "clob" 0 0 7441 NULL true 5 NULL -7433 "count" "bigint" 64 0 7441 NULL true 6 NULL -7434 "typewidth" "int" 32 0 7441 NULL true 7 NULL -7435 "columnsize" "bigint" 64 0 7441 NULL true 8 NULL -7436 "heapsize" "bigint" 64 0 7441 NULL true 9 NULL -7437 "hashes" "bigint" 64 0 7441 NULL true 10 NULL -7438 "phash" "boolean" 1 0 7441 NULL true 11 NULL -7439 "imprints" "bigint" 64 0 7441 NULL true 12 NULL -7440 "sorted" "boolean" 1 0 7441 NULL true 13 NULL -7497 "schema" "clob" 0 0 7507 NULL true 0 NULL -7498 "table" "clob" 0 0 7507 NULL true 1 NULL -7499 "column" "clob" 0 0 7507 NULL true 2 NULL -7500 "type" "clob" 0 0 7507 NULL true 3 NULL -7501 "typewidth" "int" 32 0 7507 NULL true 4 NULL -7502 "count" "bigint" 64 0 7507 NULL true 5 NULL -7503 "distinct" "bigint" 64 0 7507 NULL true 6 NULL -7504 "atomwidth" "int" 32 0 7507 NULL true 7 NULL -7505 "reference" "boolean" 1 0 7507 NULL true 8 NULL -7506 "sorted" "boolean" 1 0 7507 NULL true 9 NULL -7545 "schema" "clob" 0 0 7555 NULL true 0 NULL -7546 "table" "clob" 0 0 7555 NULL true 1 NULL -7547 "column" "clob" 0 0 7555 NULL true 2 NULL -7548 "type" "clob" 0 0 7555 NULL true 3 NULL -7549 "count" "bigint" 64 0 7555 NULL true 4 NULL -7550 "columnsize" "bigint" 64 0 7555 NULL true 5 NULL -7551 "heapsize" "bigint" 64 0 7555 NULL true 6 NULL -7552 "hashes" "bigint" 64 0 7555 NULL true 7 NULL -7553 "imprints" "bigint" 64 0 7555 NULL true 8 NULL -7554 "sorted" "boolean" 1 0 7555 NULL true 9 NULL -7557 "schema" "clob" 0 0 7565 NULL true 0 NULL -7558 "table" "clob" 0 0 7565 NULL true 1 NULL -7559 "count" "bigint" 64 0 7565 NULL true 2 NULL -7560 "columnsize" "bigint" 64 0 7565 NULL true 3 NULL -7561 "heapsize" "bigint" 64 0 7565 NULL true 4 NULL -7562 "hashes" "bigint" 64 0 7565 NULL true 5 NULL -7563 "imprints" "bigint" 64 0 7565 NULL true 6 NULL -7564 "auxiliary" "bigint" 64 0 7565 NULL true 7 NULL -7567 "column_id" "int" 32 0 7578 NULL true 0 NULL -7568 "type" "clob" 0 0 7578 NULL true 1 NULL -7569 "width" "int" 32 0 7578 NULL true 2 NULL -7570 "stamp" "timestamp" 7 0 7578 NULL true 3 NULL -7571 "sample" "bigint" 64 0 7578 NULL true 4 NULL -7572 "count" "bigint" 64 0 7578 NULL true 5 NULL -7573 "unique" "bigint" 64 0 7578 NULL true 6 NULL -7574 "nils" "bigint" 64 0 7578 NULL true 7 NULL -7575 "minval" "clob" 0 0 7578 NULL true 8 NULL -7576 "maxval" "clob" 0 0 7578 NULL true 9 NULL -7577 "sorted" "boolean" 1 0 7578 NULL true 10 NULL -7668 "file_id" "bigint" 64 0 7676 NULL false 0 NULL -7669 "file_location" "clob" 0 0 7676 NULL false 1 NULL -7670 "dbschema" "smallint" 16 0 7676 NULL false 2 NULL -7671 "format_version" "varchar" 7 0 7676 NULL true 3 NULL -7672 "sorting_order" "varchar" 10 0 7676 NULL true 4 NULL -7673 "comments" "clob" 0 0 7676 NULL true 5 NULL -7678 "sn" "clob" 0 0 7689 NULL false 0 NULL -7679 "file_id" "bigint" 64 0 7689 NULL false 1 NULL -7680 "ln" "int" 32 0 7689 NULL true 2 NULL -7681 "as" "int" 32 0 7689 NULL true 3 NULL -7682 "m5" "clob" 0 0 7689 NULL true 4 NULL -7683 "sp" "clob" 0 0 7689 NULL true 5 NULL -7684 "ur" "clob" 0 0 7689 NULL true 6 NULL -7691 "id" "clob" 0 0 7708 NULL false 0 NULL -7692 "file_id" "bigint" 64 0 7708 NULL false 1 NULL -7693 "cn" "clob" 0 0 7708 NULL true 2 NULL -7694 "ds" "clob" 0 0 7708 NULL true 3 NULL -7695 "dt" "timestamp" 7 0 7708 NULL true 4 NULL -7696 "fo" "clob" 0 0 7708 NULL true 5 NULL -7697 "ks" "clob" 0 0 7708 NULL true 6 NULL -7698 "lb" "clob" 0 0 7708 NULL true 7 NULL -7699 "pg" "clob" 0 0 7708 NULL true 8 NULL -7700 "pi" "int" 32 0 7708 NULL true 9 NULL -7701 "pl" "clob" 0 0 7708 NULL true 10 NULL -7702 "pu" "clob" 0 0 7708 NULL true 11 NULL -7703 "sm" "clob" 0 0 7708 NULL true 12 NULL -7710 "id" "clob" 0 0 7720 NULL false 0 NULL -7711 "file_id" "bigint" 64 0 7720 NULL false 1 NULL -7712 "pn" "clob" 0 0 7720 NULL true 2 NULL -7713 "cl" "clob" 0 0 7720 NULL true 3 NULL -7714 "pp" "clob" 0 0 7720 NULL true 4 NULL -7715 "vn" "clob" 0 0 7720 NULL true 5 NULL -7722 "qname" "clob" 0 0 7733 NULL false 0 NULL -7723 "flag" "smallint" 16 0 7733 NULL false 1 NULL -7724 "rname" "clob" 0 0 7733 NULL false 2 NULL -7725 "pos" "int" 32 0 7733 NULL false 3 NULL -7726 "mapq" "smallint" 16 0 7733 NULL false 4 NULL -7727 "cigar" "clob" 0 0 7733 NULL false 5 NULL -7728 "rnext" "clob" 0 0 7733 NULL false 6 NULL -7729 "pnext" "int" 32 0 7733 NULL false 7 NULL -7730 "tlen" "int" 32 0 7733 NULL false 8 NULL -7731 "seq" "clob" 0 0 7733 NULL false 9 NULL -7732 "qual" "clob" 0 0 7733 NULL false 10 NULL -7803 "function_id" "int" 32 0 7804 NULL true 0 NULL +5724 "id" "int" 32 0 5723 NULL true 0 NULL +5725 "name" "varchar" 1024 0 5723 NULL true 1 NULL +5726 "schema_id" "int" 32 0 5723 NULL true 2 NULL +5727 "query" "varchar" 2048 0 5723 NULL true 3 NULL +5728 "type" "smallint" 16 0 5723 NULL true 4 NULL +5729 "system" "boolean" 1 0 5723 NULL true 5 NULL +5730 "commit_action" "smallint" 16 0 5723 NULL true 6 NULL +5731 "access" "smallint" 16 0 5723 NULL true 7 NULL +5732 "temporary" "smallint" 16 0 5723 NULL true 8 NULL +5734 "id" "int" 32 0 5733 NULL true 0 NULL +5735 "name" "varchar" 1024 0 5733 NULL true 1 NULL +5736 "type" "varchar" 1024 0 5733 NULL true 2 NULL +5737 "type_digits" "int" 32 0 5733 NULL true 3 NULL +5738 "type_scale" "int" 32 0 5733 NULL true 4 NULL +5739 "table_id" "int" 32 0 5733 NULL true 5 NULL +5740 "default" "varchar" 2048 0 5733 NULL true 6 NULL +5741 "null" "boolean" 1 0 5733 NULL true 7 NULL +5742 "number" "int" 32 0 5733 NULL true 8 NULL +5743 "storage" "varchar" 2048 0 5733 NULL true 9 NULL +5750 "name" "varchar" 1024 0 5749 NULL true 0 NULL +5751 "fullname" "varchar" 2048 0 5749 NULL true 1 NULL +5752 "default_schema" "int" 9 0 5749 NULL true 2 NULL +5756 "name" "varchar" 1024 0 5755 NULL true 0 NULL +5757 "fullname" "varchar" 2024 0 5755 NULL true 1 NULL +5758 "default_schema" "int" 9 0 5755 NULL true 2 NULL +5760 "login_id" "int" 32 0 5759 NULL true 0 NULL +5761 "role_id" "int" 32 0 5759 NULL true 1 NULL +5763 "id" "int" 32 0 5762 NULL true 0 NULL +5764 "name" "varchar" 1024 0 5762 NULL true 1 NULL +5765 "grantor" "int" 32 0 5762 NULL true 2 NULL +5767 "obj_id" "int" 32 0 5766 NULL true 0 NULL +5768 "auth_id" "int" 32 0 5766 NULL true 1 NULL +5769 "privileges" "int" 32 0 5766 NULL true 2 NULL +5770 "grantor" "int" 32 0 5766 NULL true 3 NULL +5771 "grantable" "int" 32 0 5766 NULL true 4 NULL +5980 "id" "oid" 63 0 5988 NULL true 0 NULL +5981 "owner" "clob" 0 0 5988 NULL true 1 NULL +5982 "defined" "timestamp" 7 0 5988 NULL true 2 NULL +5983 "query" "clob" 0 0 5988 NULL true 3 NULL +5984 "pipe" "clob" 0 0 5988 NULL true 4 NULL +5985 "plan" "clob" 0 0 5988 NULL true 5 NULL +5986 "mal" "int" 32 0 5988 NULL true 6 NULL +5987 "optimize" "bigint" 64 0 5988 NULL true 7 NULL +5990 "id" "oid" 63 0 5999 NULL true 0 NULL +5991 "start" "timestamp" 7 0 5999 NULL true 1 NULL +5992 "stop" "timestamp" 7 0 5999 NULL true 2 NULL +5993 "arguments" "clob" 0 0 5999 NULL true 3 NULL +5994 "tuples" "wrd" 64 0 5999 NULL true 4 NULL +5995 "run" "bigint" 64 0 5999 NULL true 5 NULL +5996 "ship" "bigint" 64 0 5999 NULL true 6 NULL +5997 "cpu" "int" 32 0 5999 NULL true 7 NULL +5998 "io" "int" 32 0 5999 NULL true 8 NULL +6001 "id" "oid" 63 0 6017 NULL true 0 NULL _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list