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

Ying Zhang Y.Zhang at cwi.nl
Sun Oct 18 17:43:14 CEST 2015


> On Oct 18, 2015, at 16:23, Niels Nes <commits at monetdb.org> 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 at monetdb.org
> https://www.monetdb.org/mailman/listinfo/checkin-list



More information about the developers-list mailing list