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)
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
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
