Changeset: 36044e02b031 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=36044e02b031 Added Files: sql/scripts/96_oltp.sql sql/test/Tests/oltp.sql.src sql/test/Tests/oltp.stable.err sql/test/Tests/oltp.stable.out sql/test/oltp.sql Modified Files: clients/Tests/MAL-signatures.stable.out clients/Tests/MAL-signatures.stable.out.int128 clients/Tests/SQL-dump.stable.out clients/Tests/SQL-dump.stable.out.int128 clients/Tests/exports.stable.out monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out monetdb5/modules/mal/oltp.c monetdb5/modules/mal/oltp.h monetdb5/modules/mal/oltp.mal sql/backends/monet5/sql_upgrades.c sql/scripts/Makefile.ag sql/test/Tests/All sql/test/Tests/setoptimizer.stable.out sql/test/Tests/setoptimizer.stable.out.Windows 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 Branch: oltp Log Message:
Add SQL interface and test case diffs (truncated from 2066 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 @@ -8156,6 +8156,13 @@ Ready. [ "netcdf", "importvar", "command netcdf.importvar(filename:str,varid:int):str ", "NCDFimportVarStmt;", "Import variable: compose create array string" ] [ "netcdf", "importvariable", "pattern netcdf.importvariable(fileid:int,varname:str):void ", "NCDFimportVariable;", "Import variable: create array and load data from variable varname of file fileid" ] [ "netcdf", "test", "command netcdf.test(filename:str):int ", "NCDFtest;", "Returns number of variables in a given NetCDF dataset (file)" ] +[ "oltp", "disable", "pattern oltp.disable():void ", "OLTPdisable;", "Disable the OLTP delay monitor" ] +[ "oltp", "enable", "pattern oltp.enable():void ", "OLTPenable;", "Enable the OLTP delay monitor" ] +[ "oltp", "init", "pattern oltp.init():void ", "OLTPinit;", "Initialize the lock table" ] +[ "oltp", "lock", "pattern oltp.lock(lck:str...):void ", "OLTPlock;", "Wait for all write locks needed" ] +[ "oltp", "release", "pattern oltp.release(lck:str...):void ", "OLTPrelease;", "Release for all write locks needed" ] +[ "oltp", "reset", "pattern oltp.reset():void ", "OLTPreset;", "Reset the OLTP lock table" ] +[ "oltp", "table", "pattern oltp.table() (start:bat[:timestamp],usr:bat[:str],lck:bat[:str],cnt:bat[:int],qry:bat[:str]) ", "OLTPtable;", "Show status of lock table" ] [ "optimizer", "aliases", "pattern optimizer.aliases():str ", "OPTwrapper;", "" ] [ "optimizer", "aliases", "pattern optimizer.aliases(mod:str,fcn:str):str ", "OPTwrapper;", "Alias removal optimizer" ] [ "optimizer", "candidates", "pattern optimizer.candidates():str ", "OPTwrapper;", "" ] @@ -8204,6 +8211,8 @@ Ready. [ "optimizer", "mitosis", "pattern optimizer.mitosis(mod:str,fcn:str):str ", "OPTwrapper;", "Modify the plan to exploit parallel processing on multiple cores" ] [ "optimizer", "multiplex", "pattern optimizer.multiplex():void ", "OPTwrapper;", "Compiler for multiplexed instructions." ] [ "optimizer", "multiplex", "pattern optimizer.multiplex(mod:str,fcn:str):void ", "OPTwrapper;", "Compiler for multiplexed instructions." ] +[ "optimizer", "oltp", "pattern optimizer.oltp():str ", "OPTwrapper;", "" ] +[ "optimizer", "oltp", "pattern optimizer.oltp(mod:str,fcn:str):str ", "OPTwrapper;", "Inject the OLTP locking primitives." ] [ "optimizer", "optimize", "pattern optimizer.optimize(mod:str,fcn:str):void ", "QOToptimize;", "Optimize a specific operation" ] [ "optimizer", "orcam", "pattern optimizer.orcam(mod:str,fcn:str,targetmod:str,targetfcn:str):void ", "OPTorcam;", "Inverse macro, find pattern and replace with a function call." ] [ "optimizer", "orcam", "pattern optimizer.orcam(targetmod:str,targetfcn:str):void ", "OPTorcam;", "Inverse macro processor for current function" ] @@ -8508,6 +8517,41 @@ Ready. [ "sqlblob", "#tostr", "command sqlblob.#tostr():void ", "SQLBLOBtostr;", "" ] [ "sqlblob", "sqlblob", "command sqlblob.sqlblob(s:sqlblob):sqlblob ", "BLOBblob_blob;", "Noop routine." ] [ "sqlblob", "sqlblob", "command sqlblob.sqlblob(s:str):sqlblob ", "BLOBsqlblob_fromstr;", "" ] +[ "sqlcatalog", "alter_add_table", "pattern sqlcatalog.alter_add_table(sname:str,mtnme:str,psnme:str,ptnme:str,action:int):void ", "SQLalter_add_table;", "Catalog operation alter_add_table" ] +[ "sqlcatalog", "alter_del_table", "pattern sqlcatalog.alter_del_table(sname:str,mtnme:str,psnme:str,ptnme:str,action:int):void ", "SQLalter_del_table;", "Catalog operation alter_del_table" ] +[ "sqlcatalog", "alter_seq", "pattern sqlcatalog.alter_seq(sname:str,seq:ptr,val:lng):void ", "SQLalter_seq;", "Catalog operation alter_seq" ] +[ "sqlcatalog", "alter_set_table", "pattern sqlcatalog.alter_set_table(sname:str,tnme:str,access:int):void ", "SQLalter_set_table;", "Catalog operation alter_set_table" ] +[ "sqlcatalog", "alter_table", "pattern sqlcatalog.alter_table(sname:str,tbl:ptr,action:int):void ", "SQLalter_table;", "Catalog operation alter_table" ] +[ "sqlcatalog", "alter_user", "pattern sqlcatalog.alter_user(sname:str,passwrd:str,enc:int,schema:str,oldpasswrd:str):void ", "SQLalter_user;", "Catalog operation alter_user" ] +[ "sqlcatalog", "create_function", "pattern sqlcatalog.create_function(sname:str,fcn:ptr):void ", "SQLcreate_function;", "Catalog operation create_function" ] +[ "sqlcatalog", "create_role", "pattern sqlcatalog.create_role(sname:str,role:str,grator:int):void ", "SQLcreate_role;", "Catalog operation create_role" ] +[ "sqlcatalog", "create_schema", "pattern sqlcatalog.create_schema(sname:str,auth:str,action:int):void ", "SQLcreate_schema;", "Catalog operation create_schema" ] +[ "sqlcatalog", "create_seq", "pattern sqlcatalog.create_seq(sname:str,seq:ptr,action:int):void ", "SQLcreate_seq;", "Catalog operation create_seq" ] +[ "sqlcatalog", "create_table", "pattern sqlcatalog.create_table(sname:str,tbl:ptr,temp:int):void ", "SQLcreate_table;", "Catalog operation create_table" ] +[ "sqlcatalog", "create_trigger", "pattern sqlcatalog.create_trigger(sname:str,tname:str,triggername:str,time:int,orientation:int,event:int,old:str,new:str,cond:str,qry:str):void ", "SQLcreate_trigger;", "Catalog operation create_trigger" ] +[ "sqlcatalog", "create_type", "pattern sqlcatalog.create_type(sname:str,nme:str,impl:str):void ", "SQLcreate_type;", "Catalog operation create_type" ] +[ "sqlcatalog", "create_user", "pattern sqlcatalog.create_user(sname:str,passwrd:str,enc:int,schema:str,fullname:str):void ", "SQLcreate_user;", "Catalog operation create_user" ] +[ "sqlcatalog", "create_view", "pattern sqlcatalog.create_view(sname:str,tbl:ptr,temp:int):void ", "SQLcreate_view;", "Catalog operation create_view" ] +[ "sqlcatalog", "drop_constraint", "pattern sqlcatalog.drop_constraint(sname:str,name:str,action:int):void ", "SQLdrop_constraint;", "Catalog operation drop_constraint" ] +[ "sqlcatalog", "drop_function", "pattern sqlcatalog.drop_function(sname:str,fname:str,fid:int,type:int,action:int):void ", "SQLdrop_function;", "Catalog operation drop_function" ] +[ "sqlcatalog", "drop_index", "pattern sqlcatalog.drop_index(sname:str,iname:str,action:int):void ", "SQLdrop_index;", "Catalog operation drop_index" ] +[ "sqlcatalog", "drop_role", "pattern sqlcatalog.drop_role(auth:str,role:str,action:int):void ", "SQLdrop_role;", "Catalog operation drop_role" ] +[ "sqlcatalog", "drop_role", "pattern sqlcatalog.drop_role(role:str,action:int):void ", "SQLdrop_role;", "Catalog operation drop_role" ] +[ "sqlcatalog", "drop_schema", "pattern sqlcatalog.drop_schema(sname:str,s:str,action:int):void ", "SQLdrop_schema;", "Catalog operation drop_schema" ] +[ "sqlcatalog", "drop_seq", "pattern sqlcatalog.drop_seq(sname:str,nme:str,action:int):void ", "SQLdrop_seq;", "Catalog operation drop_seq" ] +[ "sqlcatalog", "drop_table", "pattern sqlcatalog.drop_table(sname:str,name:str,action:int):void ", "SQLdrop_table;", "Catalog operation drop_table" ] +[ "sqlcatalog", "drop_trigger", "pattern sqlcatalog.drop_trigger(sname:str,nme:str):void ", "SQLdrop_trigger;", "Catalog operation drop_trigger" ] +[ "sqlcatalog", "drop_type", "pattern sqlcatalog.drop_type(sname:str,nme:str,action:int):void ", "SQLdrop_type;", "Catalog operation drop_type" ] +[ "sqlcatalog", "drop_user", "pattern sqlcatalog.drop_user(sname:str,action:int):void ", "SQLdrop_user;", "Catalog operation drop_user" ] +[ "sqlcatalog", "drop_user", "pattern sqlcatalog.drop_user(sname:str,auth:str,action:int):void ", "SQLdrop_user;", "Catalog operation drop_user" ] +[ "sqlcatalog", "drop_view", "pattern sqlcatalog.drop_view(sname:str,name:str,action:int):void ", "SQLdrop_view;", "Catalog operation drop_view" ] +[ "sqlcatalog", "grant", "pattern sqlcatalog.grant(sname:str,tbl:str,grantee:str,privs:int,cname:str,gr:int,grantor:int):void ", "SQLgrant;", "Catalog operation grant" ] +[ "sqlcatalog", "grant_function", "pattern sqlcatalog.grant_function(sname:str,fcnid:int,grantee:str,privs:int,grant:int,grantor:int):void ", "SQLgrant_function;", "Catalog operation grant_function" ] +[ "sqlcatalog", "grant_roles", "pattern sqlcatalog.grant_roles(sname:str,auth:str,grantor:int,admin:int):void ", "SQLgrant_roles;", "Catalog operation grant_roles" ] +[ "sqlcatalog", "rename_user", "pattern sqlcatalog.rename_user(sname:str,newnme:str,action:int):void ", "SQLrename_user;", "Catalog operation rename_user" ] +[ "sqlcatalog", "revoke", "pattern sqlcatalog.revoke(sname:str,tbl:str,grantee:str,privs:int,cname:str,grant:int,grantor:int):void ", "SQLrevoke;", "Catalog operation revoke" ] +[ "sqlcatalog", "revoke_function", "pattern sqlcatalog.revoke_function(sname:str,fcnid:int,grantee:str,privs:int,grant:int,grantor:int):void ", "SQLrevoke_function;", "Catalog operation revoke_function" ] +[ "sqlcatalog", "revoke_roles", "pattern sqlcatalog.revoke_roles(sname:str,auth:str,grantor:int,admin:int):void ", "SQLrevoke_roles;", "Catalog operation revoke_roles" ] [ "srvpool", "connect", "command srvpool.connect(dbname:str):str ", "SRVPOOLconnect;", "Returns the connection to the server dbname." ] [ "srvpool", "exec", "pattern srvpool.exec(fname:str,arg:any...):any... ", "SRVPOOLexec;", "Remote execution of the function on dbname if channel is free." ] [ "srvpool", "local", "command srvpool.local(b:bit):void ", "SRVPOOLlocal;", "Change location from remote to local execution" ] 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 @@ -10523,6 +10523,13 @@ Ready. [ "netcdf", "importvar", "command netcdf.importvar(filename:str,varid:int):str ", "NCDFimportVarStmt;", "Import variable: compose create array string" ] [ "netcdf", "importvariable", "pattern netcdf.importvariable(fileid:int,varname:str):void ", "NCDFimportVariable;", "Import variable: create array and load data from variable varname of file fileid" ] [ "netcdf", "test", "command netcdf.test(filename:str):int ", "NCDFtest;", "Returns number of variables in a given NetCDF dataset (file)" ] +[ "oltp", "disable", "pattern oltp.disable():void ", "OLTPdisable;", "Disable the OLTP delay monitor" ] +[ "oltp", "enable", "pattern oltp.enable():void ", "OLTPenable;", "Enable the OLTP delay monitor" ] +[ "oltp", "init", "pattern oltp.init():void ", "OLTPinit;", "Initialize the lock table" ] +[ "oltp", "lock", "pattern oltp.lock(lck:str...):void ", "OLTPlock;", "Wait for all write locks needed" ] +[ "oltp", "release", "pattern oltp.release(lck:str...):void ", "OLTPrelease;", "Release for all write locks needed" ] +[ "oltp", "reset", "pattern oltp.reset():void ", "OLTPreset;", "Reset the OLTP lock table" ] +[ "oltp", "table", "pattern oltp.table() (start:bat[:timestamp],usr:bat[:str],lck:bat[:str],cnt:bat[:int],qry:bat[:str]) ", "OLTPtable;", "Show status of lock table" ] [ "optimizer", "aliases", "pattern optimizer.aliases():str ", "OPTwrapper;", "" ] [ "optimizer", "aliases", "pattern optimizer.aliases(mod:str,fcn:str):str ", "OPTwrapper;", "Alias removal optimizer" ] [ "optimizer", "candidates", "pattern optimizer.candidates():str ", "OPTwrapper;", "" ] @@ -10571,6 +10578,8 @@ Ready. [ "optimizer", "mitosis", "pattern optimizer.mitosis(mod:str,fcn:str):str ", "OPTwrapper;", "Modify the plan to exploit parallel processing on multiple cores" ] [ "optimizer", "multiplex", "pattern optimizer.multiplex():void ", "OPTwrapper;", "Compiler for multiplexed instructions." ] [ "optimizer", "multiplex", "pattern optimizer.multiplex(mod:str,fcn:str):void ", "OPTwrapper;", "Compiler for multiplexed instructions." ] +[ "optimizer", "oltp", "pattern optimizer.oltp():str ", "OPTwrapper;", "" ] +[ "optimizer", "oltp", "pattern optimizer.oltp(mod:str,fcn:str):str ", "OPTwrapper;", "Inject the OLTP locking primitives." ] [ "optimizer", "optimize", "pattern optimizer.optimize(mod:str,fcn:str):void ", "QOToptimize;", "Optimize a specific operation" ] [ "optimizer", "orcam", "pattern optimizer.orcam(mod:str,fcn:str,targetmod:str,targetfcn:str):void ", "OPTorcam;", "Inverse macro, find pattern and replace with a function call." ] [ "optimizer", "orcam", "pattern optimizer.orcam(targetmod:str,targetfcn:str):void ", "OPTorcam;", "Inverse macro processor for current function" ] @@ -10877,6 +10886,41 @@ Ready. [ "sqlblob", "#tostr", "command sqlblob.#tostr():void ", "SQLBLOBtostr;", "" ] [ "sqlblob", "sqlblob", "command sqlblob.sqlblob(s:sqlblob):sqlblob ", "BLOBblob_blob;", "Noop routine." ] [ "sqlblob", "sqlblob", "command sqlblob.sqlblob(s:str):sqlblob ", "BLOBsqlblob_fromstr;", "" ] +[ "sqlcatalog", "alter_add_table", "pattern sqlcatalog.alter_add_table(sname:str,mtnme:str,psnme:str,ptnme:str,action:int):void ", "SQLalter_add_table;", "Catalog operation alter_add_table" ] +[ "sqlcatalog", "alter_del_table", "pattern sqlcatalog.alter_del_table(sname:str,mtnme:str,psnme:str,ptnme:str,action:int):void ", "SQLalter_del_table;", "Catalog operation alter_del_table" ] +[ "sqlcatalog", "alter_seq", "pattern sqlcatalog.alter_seq(sname:str,seq:ptr,val:lng):void ", "SQLalter_seq;", "Catalog operation alter_seq" ] +[ "sqlcatalog", "alter_set_table", "pattern sqlcatalog.alter_set_table(sname:str,tnme:str,access:int):void ", "SQLalter_set_table;", "Catalog operation alter_set_table" ] +[ "sqlcatalog", "alter_table", "pattern sqlcatalog.alter_table(sname:str,tbl:ptr,action:int):void ", "SQLalter_table;", "Catalog operation alter_table" ] +[ "sqlcatalog", "alter_user", "pattern sqlcatalog.alter_user(sname:str,passwrd:str,enc:int,schema:str,oldpasswrd:str):void ", "SQLalter_user;", "Catalog operation alter_user" ] +[ "sqlcatalog", "create_function", "pattern sqlcatalog.create_function(sname:str,fcn:ptr):void ", "SQLcreate_function;", "Catalog operation create_function" ] +[ "sqlcatalog", "create_role", "pattern sqlcatalog.create_role(sname:str,role:str,grator:int):void ", "SQLcreate_role;", "Catalog operation create_role" ] +[ "sqlcatalog", "create_schema", "pattern sqlcatalog.create_schema(sname:str,auth:str,action:int):void ", "SQLcreate_schema;", "Catalog operation create_schema" ] +[ "sqlcatalog", "create_seq", "pattern sqlcatalog.create_seq(sname:str,seq:ptr,action:int):void ", "SQLcreate_seq;", "Catalog operation create_seq" ] +[ "sqlcatalog", "create_table", "pattern sqlcatalog.create_table(sname:str,tbl:ptr,temp:int):void ", "SQLcreate_table;", "Catalog operation create_table" ] +[ "sqlcatalog", "create_trigger", "pattern sqlcatalog.create_trigger(sname:str,tname:str,triggername:str,time:int,orientation:int,event:int,old:str,new:str,cond:str,qry:str):void ", "SQLcreate_trigger;", "Catalog operation create_trigger" ] +[ "sqlcatalog", "create_type", "pattern sqlcatalog.create_type(sname:str,nme:str,impl:str):void ", "SQLcreate_type;", "Catalog operation create_type" ] +[ "sqlcatalog", "create_user", "pattern sqlcatalog.create_user(sname:str,passwrd:str,enc:int,schema:str,fullname:str):void ", "SQLcreate_user;", "Catalog operation create_user" ] +[ "sqlcatalog", "create_view", "pattern sqlcatalog.create_view(sname:str,tbl:ptr,temp:int):void ", "SQLcreate_view;", "Catalog operation create_view" ] +[ "sqlcatalog", "drop_constraint", "pattern sqlcatalog.drop_constraint(sname:str,name:str,action:int):void ", "SQLdrop_constraint;", "Catalog operation drop_constraint" ] +[ "sqlcatalog", "drop_function", "pattern sqlcatalog.drop_function(sname:str,fname:str,fid:int,type:int,action:int):void ", "SQLdrop_function;", "Catalog operation drop_function" ] +[ "sqlcatalog", "drop_index", "pattern sqlcatalog.drop_index(sname:str,iname:str,action:int):void ", "SQLdrop_index;", "Catalog operation drop_index" ] +[ "sqlcatalog", "drop_role", "pattern sqlcatalog.drop_role(auth:str,role:str,action:int):void ", "SQLdrop_role;", "Catalog operation drop_role" ] +[ "sqlcatalog", "drop_role", "pattern sqlcatalog.drop_role(role:str,action:int):void ", "SQLdrop_role;", "Catalog operation drop_role" ] +[ "sqlcatalog", "drop_schema", "pattern sqlcatalog.drop_schema(sname:str,s:str,action:int):void ", "SQLdrop_schema;", "Catalog operation drop_schema" ] +[ "sqlcatalog", "drop_seq", "pattern sqlcatalog.drop_seq(sname:str,nme:str,action:int):void ", "SQLdrop_seq;", "Catalog operation drop_seq" ] +[ "sqlcatalog", "drop_table", "pattern sqlcatalog.drop_table(sname:str,name:str,action:int):void ", "SQLdrop_table;", "Catalog operation drop_table" ] +[ "sqlcatalog", "drop_trigger", "pattern sqlcatalog.drop_trigger(sname:str,nme:str):void ", "SQLdrop_trigger;", "Catalog operation drop_trigger" ] +[ "sqlcatalog", "drop_type", "pattern sqlcatalog.drop_type(sname:str,nme:str,action:int):void ", "SQLdrop_type;", "Catalog operation drop_type" ] +[ "sqlcatalog", "drop_user", "pattern sqlcatalog.drop_user(sname:str,action:int):void ", "SQLdrop_user;", "Catalog operation drop_user" ] +[ "sqlcatalog", "drop_user", "pattern sqlcatalog.drop_user(sname:str,auth:str,action:int):void ", "SQLdrop_user;", "Catalog operation drop_user" ] +[ "sqlcatalog", "drop_view", "pattern sqlcatalog.drop_view(sname:str,name:str,action:int):void ", "SQLdrop_view;", "Catalog operation drop_view" ] +[ "sqlcatalog", "grant", "pattern sqlcatalog.grant(sname:str,tbl:str,grantee:str,privs:int,cname:str,gr:int,grantor:int):void ", "SQLgrant;", "Catalog operation grant" ] +[ "sqlcatalog", "grant_function", "pattern sqlcatalog.grant_function(sname:str,fcnid:int,grantee:str,privs:int,grant:int,grantor:int):void ", "SQLgrant_function;", "Catalog operation grant_function" ] +[ "sqlcatalog", "grant_roles", "pattern sqlcatalog.grant_roles(sname:str,auth:str,grantor:int,admin:int):void ", "SQLgrant_roles;", "Catalog operation grant_roles" ] +[ "sqlcatalog", "rename_user", "pattern sqlcatalog.rename_user(sname:str,newnme:str,action:int):void ", "SQLrename_user;", "Catalog operation rename_user" ] +[ "sqlcatalog", "revoke", "pattern sqlcatalog.revoke(sname:str,tbl:str,grantee:str,privs:int,cname:str,grant:int,grantor:int):void ", "SQLrevoke;", "Catalog operation revoke" ] +[ "sqlcatalog", "revoke_function", "pattern sqlcatalog.revoke_function(sname:str,fcnid:int,grantee:str,privs:int,grant:int,grantor:int):void ", "SQLrevoke_function;", "Catalog operation revoke_function" ] +[ "sqlcatalog", "revoke_roles", "pattern sqlcatalog.revoke_roles(sname:str,auth:str,grantor:int,admin:int):void ", "SQLrevoke_roles;", "Catalog operation revoke_roles" ] [ "srvpool", "connect", "command srvpool.connect(dbname:str):str ", "SRVPOOLconnect;", "Returns the connection to the server dbname." ] [ "srvpool", "exec", "pattern srvpool.exec(fname:str,arg:any...):any... ", "SRVPOOLexec;", "Remote execution of the function on dbname if channel is free." ] [ "srvpool", "local", "command srvpool.local(b:bit):void ", "SRVPOOLlocal;", "Change location from remote to local execution" ] 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 @@ -220,6 +220,10 @@ Ready. \dSf sys."netmask" \dSf sys."network" \dSf sys."newurl" +\dSf sys."oltp_disable" +\dSf sys."oltp_enable" +\dSf sys."oltp_locks" +\dSf sys."oltp_reset" \dSf sys."optimizer_stats" \dSf sys."optimizers" \dSf sys."password_hash" @@ -597,6 +601,10 @@ SYSTEM FUNCTION sys.not_like SYSTEM FUNCTION sys.not_unique SYSTEM FUNCTION sys.not_uniques SYSTEM FUNCTION sys.octet_length +SYSTEM FUNCTION sys.oltp_disable +SYSTEM FUNCTION sys.oltp_enable +SYSTEM FUNCTION sys.oltp_locks +SYSTEM FUNCTION sys.oltp_reset SYSTEM FUNCTION sys.optimizer_stats SYSTEM FUNCTION sys.optimizers SYSTEM FUNCTION sys.or @@ -978,6 +986,10 @@ create function "netmask" (p inet) retur create function "network" (p inet) returns inet external name inet."network"; create function newurl(protocol string, hostname string, "port" int, file string) returns url external name url."new"; create function newurl(protocol string, hostname string, file string) returns url external name url."new"; +create procedure sys.oltp_disable() external name oltp.disable; +create procedure sys.oltp_enable() external name oltp.enable; +create function sys.oltp_locks() returns table(started timestamp, username string, lockid string, cnt integer, query string) external name oltp."table"; +create procedure sys.oltp_reset() external name oltp.reset; create function sys.optimizer_stats () returns table (rewrite string, count int) external name sql.dump_opt_stats; create function sys.optimizers () returns table (name string, def string, status string) external name sql.optimizers; create function sys.password_hash (username string) returns string external name sql.password; @@ -2191,6 +2203,10 @@ drop function pcre_replace(string, strin [ "sys", "octet_length", "nbytes", "str", 0, 1, false, false, false ] [ "sys", "octet_length", "nbytes", "str", 0, 1, false, false, false ] [ "sys", "octet_length", "nbytes", "str", 0, 1, false, false, false ] +[ "sys", "oltp_disable", "create procedure sys.oltp_disable() external name oltp.disable;", "oltp", 1, 2, true, false, false ] +[ "sys", "oltp_enable", "create procedure sys.oltp_enable() external name oltp.enable;", "oltp", 1, 2, true, false, false ] +[ "sys", "oltp_locks", "create function sys.oltp_locks() returns table(started timestamp, username string, lockid string, cnt integer, query string) external name oltp.\"table\";", "oltp", 1, 5, false, false, false ] +[ "sys", "oltp_reset", "create procedure sys.oltp_reset() external name oltp.reset;", "oltp", 1, 2, true, false, false ] [ "sys", "optimizer_stats", "create function sys.optimizer_stats () returns table (rewrite string, count int) external name sql.dump_opt_stats;", "sql", 1, 5, false, false, false ] [ "sys", "optimizers", "create function sys.optimizers () returns table (name string, def string, status string) external name sql.optimizers;", "sql", 1, 5, false, false, false ] [ "sys", "or", "or", "calc", 0, 1, false, false, false ] @@ -3738,6 +3754,10 @@ drop function pcre_replace(string, strin [ "sys", "octet_length", "arg_1", "char", 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys", "octet_length", "arg_1", "clob", 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys", "octet_length", "arg_1", "varchar", 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] +[ "sys", "oltp_disable", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] +[ "sys", "oltp_enable", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] +[ "sys", "oltp_locks", "username", "clob", 0, 0, 0, "lockid", "clob", 0, 0, 0, "cnt", "int", 32, 0, 0, "query", "clob", 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] +[ "sys", "oltp_reset", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys", "optimizer_stats", "count", "int", 32, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys", "optimizers", "def", "clob", 0, 0, 0, "status", "clob", 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys", "or", "arg_1", "boolean", 1, 0, 1, "arg_2", "boolean", 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] @@ -4856,7 +4876,6 @@ drop function pcre_replace(string, strin % name, name, name, name, name # name % varchar, varchar, varchar, varchar, char # type % 3, 17, 3, 13, 20 # length -[ "sys", "ms_trunc", "sys", "ms_round", "FUNC_DEPENDENCY" ] [ "sys", "st_numgeometries", "sys", "st_numpatches", "FUNC_DEPENDENCY" ] [ "sys", "st_geometryn", "sys", "st_patchn", "FUNC_DEPENDENCY" ] [ "sys", "getproj4", "sys", "st_transform", "FUNC_DEPENDENCY" ] @@ -4918,92 +4937,198 @@ drop function pcre_replace(string, strin [ "sys", "triggers", "sys", "dependencies_views_on_triggers", "FUNC_DEPENDENCY" ] [ "sys", "spatial_ref_sys", "sys", "getproj4", "FUNC_DEPENDENCY" ] [ "sys", "storagemodelinput", "sys", "storagemodel", "FUNC_DEPENDENCY" ] +[ "sys", "keys", "sys", "storagemodelinit", "PROC_DEPENDENCY" ] +[ "sys", "objects", "sys", "storagemodelinit", "PROC_DEPENDENCY" ] +[ "sys", "schemas", "sys", "storagemodelinit", "PROC_DEPENDENCY" ] [ "sys", "storagemodelinput", "sys", "storagemodelinit", "PROC_DEPENDENCY" ] +[ "sys", "tables", "sys", "storagemodelinit", "PROC_DEPENDENCY" ] #select s1.name, t.name, c.name, s2.name, f.name, dt.name from (values (1, 'SCHEMA_DEPENDENCY'), (2, 'TABLE_DEPENDENCY'), (3, 'COLUMN_DEPENDENCY'), (4, 'KEY_DEPENDENCY'), (5, 'VIEW_DEPENDENCY'), (6, 'USER_DEPENDENCY'), (7, 'FUNC_DEPENDENCY'), (8, 'TRIGGER_DEPENDENCY'), (9, 'OWNER_DEPENDENCY'), (10, 'INDEX_DEPENDENCY'), (11, 'FKEY_DEPENDENCY'), (12, 'SEQ_DEPENDENCY'), (13, 'PROC_DEPENDENCY'), (14, 'BEDROPPED_DEPENDENCY'), (15, 'TYPE_DEPENDENCY')) as dt (id, name), sys.dependencies d, sys._columns c, sys._tables t, sys.schemas s1, sys.functions f, sys.schemas s2 where d.depend_type = dt.id and d.id = c.id and d.depend_id = f.id and c.table_id = t.id and t.schema_id = s1.id and f.schema_id = s2.id order by s2.name, f.name, s1.name, t.name, c.name; % sys.s1, sys.t, sys.c, sys.s2, sys.f, .dt # table_name % name, name, name, name, name, name # name % varchar, varchar, varchar, varchar, varchar, char # type -% 3, 17, 11, 3, 35, 20 # length +% 3, 17, 13, 3, 35, 20 # length [ "sys", "dependencies", "depend_id", "sys", "dependencies_columns_on_functions", "FUNC_DEPENDENCY" ] [ "sys", "dependencies", "depend_type", "sys", "dependencies_columns_on_functions", "FUNC_DEPENDENCY" ] [ "sys", "dependencies", "id", "sys", "dependencies_columns_on_functions", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "func", "sys", "dependencies_columns_on_functions", "FUNC_DEPENDENCY" ] [ "sys", "functions", "id", "sys", "dependencies_columns_on_functions", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "language", "sys", "dependencies_columns_on_functions", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "mod", "sys", "dependencies_columns_on_functions", "FUNC_DEPENDENCY" ] [ "sys", "functions", "name", "sys", "dependencies_columns_on_functions", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "schema_id", "sys", "dependencies_columns_on_functions", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "side_effect", "sys", "dependencies_columns_on_functions", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "type", "sys", "dependencies_columns_on_functions", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "vararg", "sys", "dependencies_columns_on_functions", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "varres", "sys", "dependencies_columns_on_functions", "FUNC_DEPENDENCY" ] [ "sys", "idxs", "id", "sys", "dependencies_columns_on_indexes", "FUNC_DEPENDENCY" ] [ "sys", "idxs", "name", "sys", "dependencies_columns_on_indexes", "FUNC_DEPENDENCY" ] [ "sys", "idxs", "table_id", "sys", "dependencies_columns_on_indexes", "FUNC_DEPENDENCY" ] +[ "sys", "idxs", "type", "sys", "dependencies_columns_on_indexes", "FUNC_DEPENDENCY" ] +[ "sys", "keys", "action", "sys", "dependencies_columns_on_indexes", "FUNC_DEPENDENCY" ] +[ "sys", "keys", "id", "sys", "dependencies_columns_on_indexes", "FUNC_DEPENDENCY" ] [ "sys", "keys", "name", "sys", "dependencies_columns_on_indexes", "FUNC_DEPENDENCY" ] +[ "sys", "keys", "rkey", "sys", "dependencies_columns_on_indexes", "FUNC_DEPENDENCY" ] +[ "sys", "keys", "table_id", "sys", "dependencies_columns_on_indexes", "FUNC_DEPENDENCY" ] +[ "sys", "keys", "type", "sys", "dependencies_columns_on_indexes", "FUNC_DEPENDENCY" ] [ "sys", "objects", "id", "sys", "dependencies_columns_on_indexes", "FUNC_DEPENDENCY" ] [ "sys", "objects", "name", "sys", "dependencies_columns_on_indexes", "FUNC_DEPENDENCY" ] +[ "sys", "objects", "nr", "sys", "dependencies_columns_on_indexes", "FUNC_DEPENDENCY" ] +[ "sys", "keys", "action", "sys", "dependencies_columns_on_keys", "FUNC_DEPENDENCY" ] [ "sys", "keys", "id", "sys", "dependencies_columns_on_keys", "FUNC_DEPENDENCY" ] [ "sys", "keys", "name", "sys", "dependencies_columns_on_keys", "FUNC_DEPENDENCY" ] [ "sys", "keys", "rkey", "sys", "dependencies_columns_on_keys", "FUNC_DEPENDENCY" ] [ "sys", "keys", "table_id", "sys", "dependencies_columns_on_keys", "FUNC_DEPENDENCY" ] +[ "sys", "keys", "type", "sys", "dependencies_columns_on_keys", "FUNC_DEPENDENCY" ] [ "sys", "objects", "id", "sys", "dependencies_columns_on_keys", "FUNC_DEPENDENCY" ] [ "sys", "objects", "name", "sys", "dependencies_columns_on_keys", "FUNC_DEPENDENCY" ] +[ "sys", "objects", "nr", "sys", "dependencies_columns_on_keys", "FUNC_DEPENDENCY" ] [ "sys", "dependencies", "depend_id", "sys", "dependencies_columns_on_triggers", "FUNC_DEPENDENCY" ] [ "sys", "dependencies", "depend_type", "sys", "dependencies_columns_on_triggers", "FUNC_DEPENDENCY" ] [ "sys", "dependencies", "id", "sys", "dependencies_columns_on_triggers", "FUNC_DEPENDENCY" ] +[ "sys", "triggers", "condition", "sys", "dependencies_columns_on_triggers", "FUNC_DEPENDENCY" ] +[ "sys", "triggers", "event", "sys", "dependencies_columns_on_triggers", "FUNC_DEPENDENCY" ] [ "sys", "triggers", "id", "sys", "dependencies_columns_on_triggers", "FUNC_DEPENDENCY" ] [ "sys", "triggers", "name", "sys", "dependencies_columns_on_triggers", "FUNC_DEPENDENCY" ] +[ "sys", "triggers", "new_name", "sys", "dependencies_columns_on_triggers", "FUNC_DEPENDENCY" ] +[ "sys", "triggers", "old_name", "sys", "dependencies_columns_on_triggers", "FUNC_DEPENDENCY" ] +[ "sys", "triggers", "orientation", "sys", "dependencies_columns_on_triggers", "FUNC_DEPENDENCY" ] +[ "sys", "triggers", "statement", "sys", "dependencies_columns_on_triggers", "FUNC_DEPENDENCY" ] +[ "sys", "triggers", "table_id", "sys", "dependencies_columns_on_triggers", "FUNC_DEPENDENCY" ] +[ "sys", "triggers", "time", "sys", "dependencies_columns_on_triggers", "FUNC_DEPENDENCY" ] [ "sys", "dependencies", "depend_id", "sys", "dependencies_columns_on_views", "FUNC_DEPENDENCY" ] [ "sys", "dependencies", "depend_type", "sys", "dependencies_columns_on_views", "FUNC_DEPENDENCY" ] [ "sys", "dependencies", "id", "sys", "dependencies_columns_on_views", "FUNC_DEPENDENCY" ] [ "sys", "dependencies", "depend_id", "sys", "dependencies_functions_on_functions", "FUNC_DEPENDENCY" ] [ "sys", "dependencies", "depend_type", "sys", "dependencies_functions_on_functions", "FUNC_DEPENDENCY" ] [ "sys", "dependencies", "id", "sys", "dependencies_functions_on_functions", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "func", "sys", "dependencies_functions_on_functions", "FUNC_DEPENDENCY" ] [ "sys", "functions", "id", "sys", "dependencies_functions_on_functions", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "language", "sys", "dependencies_functions_on_functions", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "mod", "sys", "dependencies_functions_on_functions", "FUNC_DEPENDENCY" ] [ "sys", "functions", "name", "sys", "dependencies_functions_on_functions", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "schema_id", "sys", "dependencies_functions_on_functions", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "side_effect", "sys", "dependencies_functions_on_functions", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "type", "sys", "dependencies_functions_on_functions", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "vararg", "sys", "dependencies_functions_on_functions", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "varres", "sys", "dependencies_functions_on_functions", "FUNC_DEPENDENCY" ] [ "sys", "dependencies", "depend_id", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] [ "sys", "dependencies", "depend_type", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] [ "sys", "dependencies", "id", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "func", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] [ "sys", "functions", "id", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "language", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "mod", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] [ "sys", "functions", "name", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "schema_id", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "side_effect", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "type", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "vararg", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "varres", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] +[ "sys", "triggers", "condition", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] +[ "sys", "triggers", "event", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] [ "sys", "triggers", "id", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] [ "sys", "triggers", "name", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] +[ "sys", "triggers", "new_name", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] +[ "sys", "triggers", "old_name", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list