Re: MonetDB: default - fixed bug in grant_role code (ie properly che...

On Oct 18, 2015, at 16:23, Niels Nes wrote:

Changeset: 6f3500c5cece for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=6f3500c5cece Modified Files: clients/Tests/MAL-signatures.stable.out clients/Tests/MAL-signatures.stable.out.int128 clients/Tests/SQL-dump.stable.out.int128 sql/backends/monet5/UDF/Tests/udf-fuse.stable.out sql/backends/monet5/UDF/Tests/udf-reverse.stable.out sql/backends/monet5/sql.c sql/backends/monet5/sql.mal sql/backends/monet5/sql_gencode.c sql/backends/monet5/sql_gencode.h sql/backends/monet5/sql_scenario.h sql/benchmarks/tpch/Tests/01-explain.stable.out sql/benchmarks/tpch/Tests/01-explain.stable.out.32bit sql/benchmarks/tpch/Tests/01-explain.stable.out.int128 sql/benchmarks/tpch/Tests/04-explain.stable.out sql/benchmarks/tpch/Tests/04-explain.stable.out.32bit sql/benchmarks/tpch/Tests/05-explain.stable.out sql/benchmarks/tpch/Tests/05-explain.stable.out.32bit sql/benchmarks/tpch/Tests/05-explain.stable.out.int128 sql/benchmarks/tpch/Tests/06-explain.stable.out sql/benchmarks/tpch/Tests/06-explain.stable.out.int128 sql/benchmarks/tpch/Tests/10-explain.stable.out sql/benchmarks/tpch/Tests/10-explain.stable.out.int128 sql/benchmarks/tpch/Tests/11-explain.stable.out.int128 sql/benchmarks/tpch/Tests/12-explain.stable.out sql/benchmarks/tpch/Tests/12-explain.stable.out.int128 sql/benchmarks/tpch/Tests/14-explain.stable.out.int128 sql/benchmarks/tpch/Tests/15-explain.stable.out sql/benchmarks/tpch/Tests/15-explain.stable.out.int128 sql/benchmarks/tpch/Tests/17-explain.stable.out.int128 sql/benchmarks/tpch/Tests/19-explain.stable.out sql/benchmarks/tpch/Tests/19-explain.stable.out.int128 sql/benchmarks/tpch/Tests/20-explain.stable.out sql/benchmarks/tpch/Tests/20-explain.stable.out.32bit sql/benchmarks/tpch/Tests/20-explain.stable.out.int128 sql/common/sql_types.c sql/server/rel_dump.c sql/server/rel_dump.h sql/server/rel_optimizer.c sql/server/sql_privileges.c sql/server/sql_semantic.c sql/server/sql_semantic.h sql/test/BugTracker-2008/Tests/auto_coersion_bug.SF-2075157.stable.out sql/test/BugTracker-2008/Tests/auto_coersion_bug.SF-2075157.stable.out.int128 sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.stable.out sql/test/BugTracker-2011/Tests/crash_on_alias.Bug-2798.stable.out.int128 sql/test/BugTracker-2011/Tests/func_iter_vs_bulk.Bug-2826.stable.out sql/test/BugTracker-2012/Tests/rewrite_like_into_likesubselect.Bug-3179.stable.out sql/test/BugTracker-2015/Tests/ambiguous.Bug-3803.stable.out.int128 sql/test/BugTracker-2015/Tests/backslash_predecing_separator.Bug-3775.stable.err sql/test/BugTracker-2015/Tests/incorrect_result_type.Bug-3687.stable.out.int128 sql/test/BugTracker-2015/Tests/sql2pcre.Bug-3800.stable.out sql/test/BugTracker-2015/Tests/useless_casts.Bug-3756.stable.out sql/test/Users/Tests/columnRights.stable.err sql/test/Users/Tests/columnRights.stable.out sql/test/Users/Tests/dropManyUsers.Bug-3764.stable.out sql/test/Users/Tests/grantAndRevokeUserLogedIN.Bug-3476.SQL.py sql/test/Users/Tests/grantAndRevokeUserLogedIN.Bug-3476.stable.err sql/test/Users/Tests/grantAndRevokeUserLogedIN.Bug-3476.stable.out sql/test/Users/Tests/grantMonetdb.SQL.py sql/test/Users/Tests/grantMonetdbToRegularUser.Bug-3771.SQL.py sql/test/Users/Tests/grantMonetdbToSchemaOwner.Bug-3771.SQL.py sql/test/Users/Tests/grantMonetdbToSchemaOwner.Bug-3771.stable.err sql/test/Users/Tests/grantPrivilegesNonDefaultRole.Bug-3365.stable.err sql/test/Users/Tests/grantRevokeAndGrantAgain.Bug-3765.SQL.py sql/test/Users/Tests/grantRevokeAndGrantAgain.Bug-3765.stable.err sql/test/Users/Tests/grantRevokeAndGrantAgain.Bug-3765.stable.out sql/test/leaks/Tests/check1.stable.out.int128 sql/test/leaks/Tests/check2.stable.out.int128 sql/test/leaks/Tests/check3.stable.out.int128 sql/test/leaks/Tests/check4.stable.out.int128 sql/test/leaks/Tests/check5.stable.out.int128 sql/test/mapi/Tests/sql_int128.stable.out sql/test/pg_regress/Tests/int2.stable.out sql/test/pg_regress/Tests/int8.stable.out sql/test/pg_regress/Tests/int8.stable.out.int128 sql/test/pg_regress/Tests/select_views.stable.out sql/test/pg_regress/Tests/strings.stable.err.int128 sql/test/pg_regress/Tests/strings.stable.out Branch: default Log Message:

fixed bug in grant_role code (ie properly check rights)

is this the same bug you just fixed in Jul2015? Can you give me a SQL query so I can add a test for it (if you think is necessary)? Or two SQL queries, if they are different problems. Jennie

added check to not grant 'role' rights when the role is a user (ie grant some_user to role_or_user, isn't allowed)

fixed bug in topn rewriter (in combination with distinct)

we now ship relational algebra instead of mal for remote execution

more explicit typing in code generation (fixes problems with R/Python)

diffs (truncated from 15187 to 300 lines):

diff --git a/clients/Tests/MAL-signatures.stable.out b/clients/Tests/MAL-signatures.stable.out --- a/clients/Tests/MAL-signatures.stable.out +++ b/clients/Tests/MAL-signatures.stable.out @@ -40743,6 +40743,10 @@ pattern sql.restart{unsafe}(sname:str,se address mvc_restart_seq; comment restart the sequence with value start

+pattern sql.register(mod:str,fname:str,rel_stmt:str,sig:str):int +address RAstatement2; +comment Compile the relational statement (rel_smt) and register it as mal function, mod.fname(signature) + function sql.sql_environment() (name:bat[:oid,:str],value:bat[:oid,:str]); pattern sql.shrink(sch:str,tbl:str):void address SQLshrink; diff --git a/clients/Tests/MAL-signatures.stable.out.int128 b/clients/Tests/MAL-signatures.stable.out.int128 --- a/clients/Tests/MAL-signatures.stable.out.int128 +++ b/clients/Tests/MAL-signatures.stable.out.int128 @@ -51682,6 +51682,10 @@ pattern sql.restart{unsafe}(sname:str,se address mvc_restart_seq; comment restart the sequence with value start

+pattern sql.register(mod:str,fname:str,rel_stmt:str,sig:str):int +address RAstatement2; +comment Compile the relational statement (rel_smt) and register it as mal function, mod.fname(signature) + function sql.sql_environment() (name:bat[:oid,:str],value:bat[:oid,:str]); pattern sql.shrink(sch:str,tbl:str):void address SQLshrink; 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 @@ -1534,234 +1534,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 -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 -5611 "type_digits" "int" 32 0 5607 NULL true 3 NULL -5612 "type_scale" "int" 32 0 5607 NULL true 4 NULL -5613 "table_id" "int" 32 0 5607 NULL true 5 NULL -5614 "default" "varchar" 2048 0 5607 NULL true 6 NULL -5615 "null" "boolean" 1 0 5607 NULL true 7 NULL -5616 "number" "int" 32 0 5607 NULL true 8 NULL -5617 "storage" "varchar" 2048 0 5607 NULL true 9 NULL -5624 "name" "varchar" 1024 0 5623 NULL true 0 NULL -5625 "fullname" "varchar" 2048 0 5623 NULL true 1 NULL -5626 "default_schema" "int" 9 0 5623 NULL true 2 NULL -5630 "name" "varchar" 1024 0 5629 NULL true 0 NULL -5631 "fullname" "varchar" 2024 0 5629 NULL true 1 NULL -5632 "default_schema" "int" 9 0 5629 NULL true 2 NULL -5634 "login_id" "int" 32 0 5633 NULL true 0 NULL -5635 "role_id" "int" 32 0 5633 NULL true 1 NULL -5637 "id" "int" 32 0 5636 NULL true 0 NULL -5638 "name" "varchar" 1024 0 5636 NULL true 1 NULL -5639 "grantor" "int" 32 0 5636 NULL true 2 NULL -5641 "obj_id" "int" 32 0 5640 NULL true 0 NULL -5642 "auth_id" "int" 32 0 5640 NULL true 1 NULL -5643 "privileges" "int" 32 0 5640 NULL true 2 NULL -5644 "grantor" "int" 32 0 5640 NULL true 3 NULL -5645 "grantable" "int" 32 0 5640 NULL true 4 NULL -5854 "id" "oid" 63 0 5862 NULL true 0 NULL -5855 "owner" "clob" 0 0 5862 NULL true 1 NULL -5856 "defined" "timestamp" 7 0 5862 NULL true 2 NULL -5857 "query" "clob" 0 0 5862 NULL true 3 NULL -5858 "pipe" "clob" 0 0 5862 NULL true 4 NULL -5859 "plan" "clob" 0 0 5862 NULL true 5 NULL -5860 "mal" "int" 32 0 5862 NULL true 6 NULL -5861 "optimize" "bigint" 64 0 5862 NULL true 7 NULL -5864 "id" "oid" 63 0 5873 NULL true 0 NULL -5865 "start" "timestamp" 7 0 5873 NULL true 1 NULL -5866 "stop" "timestamp" 7 0 5873 NULL true 2 NULL -5867 "arguments" "clob" 0 0 5873 NULL true 3 NULL -5868 "tuples" "wrd" 64 0 5873 NULL true 4 NULL -5869 "run" "bigint" 64 0 5873 NULL true 5 NULL -5870 "ship" "bigint" 64 0 5873 NULL true 6 NULL -5871 "cpu" "int" 32 0 5873 NULL true 7 NULL -5872 "io" "int" 32 0 5873 NULL true 8 NULL -5875 "id" "oid" 63 0 5891 NULL true 0 NULL -5876 "owner" "clob" 0 0 5891 NULL true 1 NULL -5877 "defined" "timestamp" 7 0 5891 NULL true 2 NULL -5878 "query" "clob" 0 0 5891 NULL true 3 NULL -5879 "pipe" "clob" 0 0 5891 NULL true 4 NULL -5880 "plan" "clob" 0 0 5891 NULL true 5 NULL -5881 "mal" "int" 32 0 5891 NULL true 6 NULL -5882 "optimize" "bigint" 64 0 5891 NULL true 7 NULL -5883 "start" "timestamp" 7 0 5891 NULL true 8 NULL -5884 "stop" "timestamp" 7 0 5891 NULL true 9 NULL -5885 "arguments" "clob" 0 0 5891 NULL true 10 NULL -5886 "tuples" "wrd" 64 0 5891 NULL true 11 NULL -5887 "run" "bigint" 64 0 5891 NULL true 12 NULL -5888 "ship" "bigint" 64 0 5891 NULL true 13 NULL -5889 "cpu" "int" 32 0 5891 NULL true 14 NULL -5890 "io" "int" 32 0 5891 NULL true 15 NULL -5917 "event" "int" 32 0 5930 NULL true 0 NULL -5918 "clk" "varchar" 20 0 5930 NULL true 1 NULL -5919 "pc" "varchar" 50 0 5930 NULL true 2 NULL -5920 "thread" "int" 32 0 5930 NULL true 3 NULL -5921 "ticks" "bigint" 64 0 5930 NULL true 4 NULL -5922 "rrsmb" "bigint" 64 0 5930 NULL true 5 NULL -5923 "vmmb" "bigint" 64 0 5930 NULL true 6 NULL -5924 "reads" "bigint" 64 0 5930 NULL true 7 NULL -5925 "writes" "bigint" 64 0 5930 NULL true 8 NULL -5926 "minflt" "bigint" 64 0 5930 NULL true 9 NULL -5927 "majflt" "bigint" 64 0 5930 NULL true 10 NULL -5928 "nvcsw" "bigint" 64 0 5930 NULL true 11 NULL -5929 "stmt" "clob" 0 0 5930 NULL true 12 NULL -6064 "user" "clob" 0 0 6070 NULL true 0 NULL -6065 "login" "timestamp" 7 0 6070 NULL true 1 NULL -6066 "sessiontimeout" "bigint" 64 0 6070 NULL true 2 NULL -6067 "lastcommand" "timestamp" 7 0 6070 NULL true 3 NULL -6068 "querytimeout" "bigint" 64 0 6070 NULL true 4 NULL -6069 "active" "boolean" 1 0 6070 NULL true 5 NULL -6147 "name" "clob" 0 0 6150 NULL true 0 NULL -6148 "def" "clob" 0 0 6150 NULL true 1 NULL -6149 "status" "clob" 0 0 6150 NULL true 2 NULL -6156 "name" "clob" 0 0 6158 NULL true 0 NULL -6157 "value" "clob" 0 0 6158 NULL true 1 NULL -6194 "qtag" "bigint" 64 0 6202 NULL true 0 NULL -6195 "user" "clob" 0 0 6202 NULL true 1 NULL -6196 "started" "timestamp" 7 0 6202 NULL true 2 NULL -6197 "estimate" "timestamp" 7 0 6202 NULL true 3 NULL -6198 "progress" "int" 32 0 6202 NULL true 4 NULL -6199 "status" "clob" 0 0 6202 NULL true 5 NULL -6200 "tag" "oid" 63 0 6202 NULL true 6 NULL -6201 "query" "clob" 0 0 6202 NULL true 7 NULL -6228 "rowid" "bigint" 64 0 6232 NULL true 0 NULL -6229 "fldid" "int" 32 0 6232 NULL true 1 NULL -6230 "message" "clob" 0 0 6232 NULL true 2 NULL -6231 "input" "clob" 0 0 6232 NULL true 3 NULL -6887 "keyword" "varchar" 40 0 6890 NULL false 0 NULL -6892 "table_type_id" "smallint" 16 0 6898 NULL false 0 NULL -6895 "table_type_name" "varchar" 25 0 6898 NULL false 1 NULL -6900 "dependency_type_id" "smallint" 16 0 6906 NULL false 0 NULL -6903 "dependency_type_name" "varchar" 15 0 6906 NULL false 1 NULL -6921 "file_id" "int" 32 0 6923 NULL true 0 NULL -6922 "location" "char" 256 0 6923 NULL true 1 NULL -6925 "dim_id" "int" 32 0 6929 NULL true 0 NULL -6926 "file_id" "int" 32 0 6929 NULL true 1 NULL -6927 "name" "varchar" 64 0 6929 NULL true 2 NULL -6928 "length" "int" 32 0 6929 NULL true 3 NULL -6931 "var_id" "int" 32 0 6937 NULL true 0 NULL -6932 "file_id" "int" 32 0 6937 NULL true 1 NULL -6933 "name" "varchar" 64 0 6937 NULL true 2 NULL -6934 "vartype" "varchar" 64 0 6937 NULL true 3 NULL -6935 "ndim" "int" 32 0 6937 NULL true 4 NULL -6936 "coord_dim_id" "int" 32 0 6937 NULL true 5 NULL -6939 "var_id" "int" 32 0 6943 NULL true 0 NULL -6940 "dim_id" "int" 32 0 6943 NULL true 1 NULL -6941 "file_id" "int" 32 0 6943 NULL true 2 NULL -6942 "dimpos" "int" 32 0 6943 NULL true 3 NULL -6945 "obj_name" "varchar" 256 0 6951 NULL true 0 NULL -6946 "att_name" "varchar" 256 0 6951 NULL true 1 NULL -6947 "att_type" "varchar" 64 0 6951 NULL true 2 NULL -6948 "value" "clob" 0 0 6951 NULL true 3 NULL -6949 "file_id" "int" 32 0 6951 NULL true 4 NULL -6950 "gr_name" "varchar" 256 0 6951 NULL true 5 NULL -6976 "schema" "clob" 0 0 6990 NULL true 0 NULL -6977 "table" "clob" 0 0 6990 NULL true 1 NULL -6978 "column" "clob" 0 0 6990 NULL true 2 NULL -6979 "type" "clob" 0 0 6990 NULL true 3 NULL -6980 "mode" "clob" 0 0 6990 NULL true 4 NULL -6981 "location" "clob" 0 0 6990 NULL true 5 NULL -6982 "count" "bigint" 64 0 6990 NULL true 6 NULL -6983 "typewidth" "int" 32 0 6990 NULL true 7 NULL -6984 "columnsize" "bigint" 64 0 6990 NULL true 8 NULL -6985 "heapsize" "bigint" 64 0 6990 NULL true 9 NULL -6986 "hashes" "bigint" 64 0 6990 NULL true 10 NULL -6987 "phash" "boolean" 1 0 6990 NULL true 11 NULL -6988 "imprints" "bigint" 64 0 6990 NULL true 12 NULL -6989 "sorted" "boolean" 1 0 6990 NULL true 13 NULL -6992 "schema" "clob" 0 0 7002 NULL true 0 NULL -6993 "table" "clob" 0 0 7002 NULL true 1 NULL -6994 "column" "clob" 0 0 7002 NULL true 2 NULL -6995 "type" "clob" 0 0 7002 NULL true 3 NULL -6996 "typewidth" "int" 32 0 7002 NULL true 4 NULL -6997 "count" "bigint" 64 0 7002 NULL true 5 NULL -6998 "distinct" "bigint" 64 0 7002 NULL true 6 NULL -6999 "atomwidth" "int" 32 0 7002 NULL true 7 NULL -7000 "reference" "boolean" 1 0 7002 NULL true 8 NULL -7001 "sorted" "boolean" 1 0 7002 NULL true 9 NULL -7040 "schema" "clob" 0 0 7050 NULL true 0 NULL -7041 "table" "clob" 0 0 7050 NULL true 1 NULL -7042 "column" "clob" 0 0 7050 NULL true 2 NULL -7043 "type" "clob" 0 0 7050 NULL true 3 NULL -7044 "count" "bigint" 64 0 7050 NULL true 4 NULL -7045 "columnsize" "bigint" 64 0 7050 NULL true 5 NULL -7046 "heapsize" "bigint" 64 0 7050 NULL true 6 NULL -7047 "hashes" "bigint" 64 0 7050 NULL true 7 NULL -7048 "imprints" "bigint" 64 0 7050 NULL true 8 NULL -7049 "sorted" "boolean" 1 0 7050 NULL true 9 NULL -7052 "schema" "clob" 0 0 7060 NULL true 0 NULL -7053 "table" "clob" 0 0 7060 NULL true 1 NULL -7054 "count" "bigint" 64 0 7060 NULL true 2 NULL -7055 "columnsize" "hugeint" 128 0 7060 NULL true 3 NULL -7056 "heapsize" "hugeint" 128 0 7060 NULL true 4 NULL -7057 "hashes" "hugeint" 128 0 7060 NULL true 5 NULL -7058 "imprints" "hugeint" 128 0 7060 NULL true 6 NULL -7059 "auxiliary" "hugeint" 128 0 7060 NULL true 7 NULL -7062 "column_id" "int" 32 0 7073 NULL true 0 NULL -7063 "type" "clob" 0 0 7073 NULL true 1 NULL -7064 "width" "int" 32 0 7073 NULL true 2 NULL -7065 "stamp" "timestamp" 7 0 7073 NULL true 3 NULL -7066 "sample" "bigint" 64 0 7073 NULL true 4 NULL -7067 "count" "bigint" 64 0 7073 NULL true 5 NULL -7068 "unique" "bigint" 64 0 7073 NULL true 6 NULL -7069 "nils" "bigint" 64 0 7073 NULL true 7 NULL -7070 "minval" "clob" 0 0 7073 NULL true 8 NULL -7071 "maxval" "clob" 0 0 7073 NULL true 9 NULL -7072 "sorted" "boolean" 1 0 7073 NULL true 10 NULL -7163 "file_id" "bigint" 64 0 7171 NULL false 0 NULL -7164 "file_location" "clob" 0 0 7171 NULL false 1 NULL -7165 "dbschema" "smallint" 16 0 7171 NULL false 2 NULL -7166 "format_version" "varchar" 7 0 7171 NULL true 3 NULL -7167 "sorting_order" "varchar" 10 0 7171 NULL true 4 NULL -7168 "comments" "clob" 0 0 7171 NULL true 5 NULL -7173 "sn" "clob" 0 0 7184 NULL false 0 NULL -7174 "file_id" "bigint" 64 0 7184 NULL false 1 NULL -7175 "ln" "int" 32 0 7184 NULL true 2 NULL -7176 "as" "int" 32 0 7184 NULL true 3 NULL -7177 "m5" "clob" 0 0 7184 NULL true 4 NULL -7178 "sp" "clob" 0 0 7184 NULL true 5 NULL -7179 "ur" "clob" 0 0 7184 NULL true 6 NULL -7186 "id" "clob" 0 0 7203 NULL false 0 NULL -7187 "file_id" "bigint" 64 0 7203 NULL false 1 NULL -7188 "cn" "clob" 0 0 7203 NULL true 2 NULL -7189 "ds" "clob" 0 0 7203 NULL true 3 NULL -7190 "dt" "timestamp" 7 0 7203 NULL true 4 NULL -7191 "fo" "clob" 0 0 7203 NULL true 5 NULL -7192 "ks" "clob" 0 0 7203 NULL true 6 NULL -7193 "lb" "clob" 0 0 7203 NULL true 7 NULL -7194 "pg" "clob" 0 0 7203 NULL true 8 NULL -7195 "pi" "int" 32 0 7203 NULL true 9 NULL -7196 "pl" "clob" 0 0 7203 NULL true 10 NULL -7197 "pu" "clob" 0 0 7203 NULL true 11 NULL -7198 "sm" "clob" 0 0 7203 NULL true 12 NULL -7205 "id" "clob" 0 0 7215 NULL false 0 NULL -7206 "file_id" "bigint" 64 0 7215 NULL false 1 NULL -7207 "pn" "clob" 0 0 7215 NULL true 2 NULL -7208 "cl" "clob" 0 0 7215 NULL true 3 NULL -7209 "pp" "clob" 0 0 7215 NULL true 4 NULL -7210 "vn" "clob" 0 0 7215 NULL true 5 NULL -7217 "qname" "clob" 0 0 7228 NULL false 0 NULL -7218 "flag" "smallint" 16 0 7228 NULL false 1 NULL -7219 "rname" "clob" 0 0 7228 NULL false 2 NULL -7220 "pos" "int" 32 0 7228 NULL false 3 NULL -7221 "mapq" "smallint" 16 0 7228 NULL false 4 NULL -7222 "cigar" "clob" 0 0 7228 NULL false 5 NULL -7223 "rnext" "clob" 0 0 7228 NULL false 6 NULL -7224 "pnext" "int" 32 0 7228 NULL false 7 NULL -7225 "tlen" "int" 32 0 7228 NULL false 8 NULL -7226 "seq" "clob" 0 0 7228 NULL false 9 NULL -7227 "qual" "clob" 0 0 7228 NULL false 10 NULL -7309 "function_id" "int" 32 0 7310 NULL true 0 NULL +5688 "id" "int" 32 0 5687 NULL true 0 NULL +5689 "name" "varchar" 1024 0 5687 NULL true 1 NULL +5690 "schema_id" "int" 32 0 5687 NULL true 2 NULL +5691 "query" "varchar" 2048 0 5687 NULL true 3 NULL +5692 "type" "smallint" 16 0 5687 NULL true 4 NULL +5693 "system" "boolean" 1 0 5687 NULL true 5 NULL +5694 "commit_action" "smallint" 16 0 5687 NULL true 6 NULL +5695 "access" "smallint" 16 0 5687 NULL true 7 NULL +5696 "temporary" "smallint" 16 0 5687 NULL true 8 NULL +5698 "id" "int" 32 0 5697 NULL true 0 NULL +5699 "name" "varchar" 1024 0 5697 NULL true 1 NULL +5700 "type" "varchar" 1024 0 5697 NULL true 2 NULL +5701 "type_digits" "int" 32 0 5697 NULL true 3 NULL +5702 "type_scale" "int" 32 0 5697 NULL true 4 NULL +5703 "table_id" "int" 32 0 5697 NULL true 5 NULL +5704 "default" "varchar" 2048 0 5697 NULL true 6 NULL +5705 "null" "boolean" 1 0 5697 NULL true 7 NULL +5706 "number" "int" 32 0 5697 NULL true 8 NULL +5707 "storage" "varchar" 2048 0 5697 NULL true 9 NULL +5714 "name" "varchar" 1024 0 5713 NULL true 0 NULL +5715 "fullname" "varchar" 2048 0 5713 NULL true 1 NULL +5716 "default_schema" "int" 9 0 5713 NULL true 2 NULL +5720 "name" "varchar" 1024 0 5719 NULL true 0 NULL +5721 "fullname" "varchar" 2024 0 5719 NULL true 1 NULL +5722 "default_schema" "int" 9 0 5719 NULL true 2 NULL +5724 "login_id" "int" 32 0 5723 NULL true 0 NULL +5725 "role_id" "int" 32 0 5723 NULL true 1 NULL +5727 "id" "int" 32 0 5726 NULL true 0 NULL +5728 "name" "varchar" 1024 0 5726 NULL true 1 NULL +5729 "grantor" "int" 32 0 5726 NULL true 2 NULL +5731 "obj_id" "int" 32 0 5730 NULL true 0 NULL +5732 "auth_id" "int" 32 0 5730 NULL true 1 NULL +5733 "privileges" "int" 32 0 5730 NULL true 2 NULL +5734 "grantor" "int" 32 0 5730 NULL true 3 NULL +5735 "grantable" "int" 32 0 5730 NULL true 4 NULL +5944 "id" "oid" 63 0 5952 NULL true 0 NULL +5945 "owner" "clob" 0 0 5952 NULL true 1 NULL _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list