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

Reply via email to