Changeset: ec4163fad899 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=ec4163fad899
Modified Files:
        
Branch: sciql
Log Message:

Merge with default branch.


diffs (truncated from 1032 to 300 lines):

diff --git a/monetdb5/modules/mal/Tests/inspect05.stable.out 
b/monetdb5/modules/mal/Tests/inspect05.stable.out
--- a/monetdb5/modules/mal/Tests/inspect05.stable.out
+++ b/monetdb5/modules/mal/Tests/inspect05.stable.out
@@ -28,6 +28,8 @@
 # str                          str             str             str             
                                                                                
                                        str                                     
                  # type
 
#-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------#
 [ "main",                        "function",     "user",         "():void;",   
                                                                                
                                          "nil"                                 
                  ]
+[ "reverse",             "command",      "udf",          
"(b:bat[:oid,:str]):bat[:oid,:str] ",                                           
                                        "UDFBATreverse;"                        
        ]
+[ "reverse",             "command",      "udf",          "(ra1:str):str ",     
                                                                                
                  "UDFreverse;"                                   ]
 [ "angsep",                      "command",      "lsst",         
"(ra1:dbl,dec1:dbl,ra2:dbl,dec2:dbl):dbl ",                                     
                                "qserv_angSep;"                                 
]
 [ "ptinsphpoly",                 "pattern",      "lsst",         
"(ra:dbl,dec:dbl,list:dbl...):int ",                                            
                                "qserv_ptInSphPoly;"                            
]
 [ "ptinsphellipse",              "command",      "lsst",         
"(ra:dbl,dec:dbl,ra_cen:dbl,dec_cen:dbl,smaa:dbl,smia:dbl,ang:dbl):int ",       
                                "qserv_ptInSphEllipse;"                         
]
@@ -39,6 +41,7 @@
 [ "load",                "pattern",      "fits",                 
"(tablename:str):void ",                                                        
        "FITSloadTable;"                        ]
 [ "listdirpattern",              "pattern",      "fits",         
"(dirname:str,pattern:str):void ",                                              
                                        "FITSdirpat;"                           
]
 [ "listdir",             "pattern",      "fits",                 
"(dirname:str):void ",                                                          
        "FITSdir;"                              ]
+[ "alpha",               "command",      "batsql",       
"(dec:bat[:oid,:dbl],theta:dbl):bat[:oid,:dbl] ",                               
                                        "SQLbat_alpha;"                         
        ]
 [ "next_value",                  "pattern",      "batsql",       
"(sname:bat[:oid,:str],sequence:str):bat[:oid,:lng] ",                          
                "mvc_bat_next_value;"                   ]
 [ "Area",                "command",      "geom",                 "(g:wkb):dbl 
",                                                                         
"wkbArea;"                              ]
 [ "AsText",              "command",      "geom",                 "(w:wkb):str 
",                                                                         
"wkbAsText;"                            ]
@@ -184,6 +187,7 @@
 [ "table",                               "pattern",      "cluster",      
"(b:bat[:oid,:any]...):bat[:oid,:oid] ",                                        
                                        "CLUSTER_table;"                        
                ]
 [ "getCloud",                    "command",      "mapreduce",    
"(nme:str):bat[:oid,:str] ",                                                    
                                                        "MRgetCloud;"           
                                ]
 [ "multiplex",                   "pattern",      "mal",          
"(a:any...):any ",                                                              
                                                        "OPTremapMultiplex;"    
                                ]
+[ "alpha",               "command",      "sql",          
"(dec:dbl,theta:dbl):dbl ",                                                     
                                        "SQLdbl_alpha;"                         
        ]
 [ "argRecord",           "pattern",      "sql",                  
"(a:any...):str ",                                                              
        "SQLargRecord;"                         ]
 [ "argRecord",           "pattern",      "sql",                  "():str ",    
                                                                          
"SQLargRecord;"                         ]
 [ "affectedRows",                "pattern",      "sql",          
"(mvc:int,nr:wrd,w:str):int ",                                                  
                                "mvc_affected_rows_wrap;"                       
]
@@ -215,6 +219,7 @@
 [ "catalog",             "pattern",      "sql",                  
"(type:int,sname:str,t:ptr,restart:lng):void ",                                 
        "SQLcatalog;"                           ]
 [ "catalog",             "pattern",      "sql",                  
"(type:int,sname:str,t:ptr,temp:int):void ",                                    
        "SQLcatalog;"                           ]
 [ "catalog",             "pattern",      "sql",                  
"(type:int,sname:str,name:str,action:int):void ",                               
        "SQLcatalog;"                           ]
+[ "commit",              "pattern",      "sql",          "():void ",           
                                                                                
                  "SQLcommit;"                                    ]
 [ "dropdictionary",      "pattern",      "sql",                  
"(sch:str,tbl:str):void ",                                                      
        "SQLdropDictionary;"                    ]
 [ "drop_hash",           "pattern",      "sql",                  
"(sch:str,tbl:str):void ",                                                      
        "SQLdrop_hash;"                         ]
 [ "dense_rank",                  "command",      "sql",                  
"(b:bat[:oid,:any_1]):bat[:oid,:int] ",                                         
        "sql_dense_rank;"                       ]
@@ -285,6 +290,7 @@
 [ "resultSet",           "pattern",      "sql",                  
"(nr_cols:int,sep:str,rsep:str,ssep:str,ns:str,order:bat[:oid,:any_1]):int ",   
        "mvc_result_file_wrap;"                 ]
 [ "resultSet",           "pattern",      "sql",                  
"(nr_cols:int,sep:str,rsep:str,ssep:str,ns:str,order:any_1):int ",              
        "mvc_result_file_wrap;"                 ]
 [ "restart",             "pattern",      "sql",                  
"(sname:str,sequence:str,start:lng):lng ",                                      
        "mvc_restart_seq;"                      ]
+[ "ra",                          "pattern",      "sql",          
"(cmd:str,optimize:bit):void ",                                                 
                                        "RAstatement;"                          
        ]
 [ "shrink",              "pattern",      "sql",                  
"(sch:str,tbl:str):void ",                                                      
        "SQLshrink;"                            ]
 [ "storage",             "pattern",      "sql",                  
"():bat[:str,:BAT] ",                                                           
        "sql_storage;"                          ]
 [ "sql_variables",       "pattern",      "sql",                  
"():bat[:str,:BAT] ",                                                           
        "sql_variables;"                        ]
@@ -295,11 +301,15 @@
 [ "start",               "pattern",      "sql",                  "():void ",   
                                                                          
"SQLsession;"                           ]
 [ "times",               "factory",      "sql",                  "():void;",   
                                                                          "nil" 
                                  ]
 [ "times",               "function",     "sql",                  
"(elaps:int,inblock:lng,oublock:lng):void;",                                    
        "nil"                                   ]
+[ "transaction",         "pattern",      "sql",          "():void ",           
                                                                                
                  "SQLtransaction2;"                              ]
 [ "trans",               "pattern",      "sql",                  
"(type:int,chain:int,name:str):void ",                                          
        "SQLtransaction;"                       ]
 [ "update",                      "pattern",      "sql",          
"(mvc:int,sname:str,tname:str,cname:str,ins:any):int ",                         
                                "mvc_update_wrap;"                              
]
 [ "vacuum",              "pattern",      "sql",                  
"(sch:str,tbl:str):void ",                                                      
        "SQLvacuum;"                            ]
 [ "zero_or_one",         "function",     "sql",                  
"(b:bat[:oid,:any_1],gp:bat[:oid,:oid],gpe:bat[:oid,:oid]):bat[:oid,:any_1];",  
        "nil"                                   ]
 [ "zero_or_one",         "command",      "sql",                  
"(col:bat[:any_2,:any_1]):any_1 ",                                              
        "zero_or_one;"                          ]
+[ "bind_idxbat",         "function",     "octopus",      
"(conn:str,sch:str,tab:str,index:str,access:int,part_nr:int,nr_parts:int,version:int):bat[:oid,:oid];",
                 "nil"                                           ]
+[ "bind",                "function",     "octopus",      
"(conn:str,sch:str,tab:str,col:str,kind:int,part_nr:int,nr_parts:int,version:int):bat[:oid,:any_1];",
                   "nil"                                           ]
+[ "bind",                "function",     "octopus",      
"(mvc:int,sch:str,tab:str,col:str,kind:int,part_nr:int,nr_parts:int,version:int):bat[:oid,:any_1];",
                    "nil"                                           ]
 [ "bind_idxbat",         "function",     "octopus",              
"(conn:str,sch:str,tab:str,index:str,access:int,low:oid,hgh:oid,version:int):bat[:oid,:oid];",
 "nil"                                    ]
 [ "bind_idxbat",         "function",     "octopus",              
"(conn:str,sch:str,tab:str,index:str,access:int,version:int):bat[:oid,:oid];",  
        "nil"                                   ]
 [ "bind_idxbat",                 "function",     "octopus",      
"(mvc:int,sch:str,tab:str,index:str,access:int,version:int):bat[:oid,:oid];",   
                                "nil"                                           
]
@@ -346,8 +356,6 @@
 [ "coercions",                   "pattern",      "optimizer",    "():str ",    
                                                                                
                                          "OPTcoercion;"                        
                  ]
 [ "clrDebug",                    "pattern",      "optimizer",    "():void ",   
                                                                                
                                          "QOTclrdebugOptimizers;"              
                  ]
 [ "dumpQEP",                     "pattern",      "optimizer",    "():void ",   
                                                                                
                                          "OPTdumpQEP;"                         
                  ]
-[ "datacell",                            "pattern",      "optimizer",    
"(mod:str,fcn:str):str ",                                                       
                        "OPTdatacell;"                                  ]
-[ "datacell",                            "pattern",      "optimizer",    
"():str ",                                                                      
                        "OPTdatacell;"                                  ]
 [ "derivePath",                                  "pattern",      "optimizer",  
  "(mod:str,fcn:str):str ",                                                     
                                                                  
"OPTderivePath;"                                        ]
 [ "derivePath",                                  "pattern",      "optimizer",  
  "():str ",                                                                    
                                                                  
"OPTderivePath;"                                        ]
 [ "datacyclotron",                       "pattern",      "optimizer",    
"(mod:str,fcn:str):str ",                                                       
                        "OPTdatacyclotron;"                             ]
@@ -384,6 +392,8 @@
 [ "multiplex",                   "pattern",      "optimizer",    "():void ",   
                                                                                
                                          "OPTmultiplex;"                       
                  ]
 [ "macro",                       "pattern",      "optimizer",    
"(mod:str,fcn:str,targetmod:str,targetfcn:str):void ",                          
                                                        "OPTmacro;"             
                                ]
 [ "macro",                       "pattern",      "optimizer",    
"(targetmod:str,targetfcn:str):void ",                                          
                                                        "OPTmacro;"             
                                ]
+[ "origin",              "pattern",      "optimizer",    
"(mod:str,fcn:str):str ",                                                       
                                        "OPTorigin;"                            
        ]
+[ "origin",              "pattern",      "optimizer",    "():str ",            
                                                                                
                  "OPTorigin;"                                    ]
 [ "octopus",                     "pattern",      "optimizer",    
"(mod:str,fcn:str):str ",                                                       
                                                        "OPToctopus;"           
                                ]
 [ "octopus",                     "pattern",      "optimizer",    "():str ",    
                                                                                
                                          "OPToctopus;"                         
                  ]
 [ "orcam",                       "pattern",      "optimizer",    
"(mod:str,fcn:str,targetmod:str,targetfcn:str):void ",                          
                                                        "OPTorcam;"             
                                ]
@@ -677,6 +687,9 @@
 [ "slice",                               "pattern",      "mat",          
"(first:wrd,last:wrd,b:bat[:any_1,:any_2]...):bat[:any_1,:any_2] ",             
                                                                "MATpackSlice;" 
                                ]
 [ "makeBids",                    "pattern",      "trader",       
"(bidtype:sht,fnname1:str...):lng... ",                                         
                                                        "TRADERmakeBids;"       
                                ]
 [ "makeBid",                             "pattern",      "trader",       
"(fnname:str,bidtype:sht):lng ",                                                
                                                "TRADERmakeBid;"                
                        ]
+[ "bintype",             "pattern",      "remote",       "():void ",           
                                                                                
                  "RMTbintype;"                                   ]
+[ "batbincopy",                  "pattern",      "remote",       
"():bat[:void,:any] ",                                                          
                                        "RMTbincopyfrom;"                       
        ]
+[ "batbincopy",                  "pattern",      "remote",       "(b:BAT):void 
",                                                                              
                          "RMTbincopyto;"                                 ]
 [ "batload",                     "pattern",      "remote",       
"(ht:any_1,tt:any_2,size:int):bat[:any_1,:any_2] ",                             
                                                        "RMTbatload;"           
                                ]
 [ "connect",                             "command",      "remote",             
  "(uri:str,user:str,passwd:str,scen:str):str ",                                
                                                  "RMTconnectScen;"             
                          ]
 [ "connect",                             "command",      "remote",             
  "(uri:str,user:str,passwd:str):str ",                                         
                                                  "RMTconnect;"                 
                          ]
@@ -5349,6 +5362,7 @@
 [ "new",                         "pattern",      "bat",          
"(ht:any_1,tt:any_2,b:bat[:any_3,:any_4]):bat[:any_1,:any_2] ",                 
                                                        "CMDBATclone;"          
                                ]
 [ "orderReverse",                "command",      "bat",          
"(b:bat[:any_1,:any_2]):bat[:any_1,:any_2] ",                                   
                                                        "BKCorder_rev;"         
                                ]
 [ "order",                       "command",      "bat",          
"(b:bat[:any_1,:any_2]):bat[:any_1,:any_2] ",                                   
                                                        "BKCorder;"             
                                ]
+[ "pack",                "pattern",      "bat",          
"(v:any_1):bat[:oid,:any_1] ",                                                  
                                        "CMDbatsingleton;"                      
        ]
 [ "pack",                        "pattern",      "bat",          
"(h:any_1,t:any_2):bat[:any_1,:any_2] ",                                        
                                                        "CMDbatpack;"           
                                ]
 [ "partition",                   "pattern",      "bat",          
"(b:bat[:any_1,:any_2],pieces:int,part:int):bat[:any_1,:any_2] ",               
                                        "CMDbatpartition2;"                     
        ]
 [ "partition",                   "pattern",      "bat",          
"(b:bat[:any_1,:any_2]):bat[:any_1,:any_2]... ",                                
                                                                                
                        "CMDbatpartition;"                              ]
diff --git a/monetdb5/modules/mal/Tests/inspect05.stable.out.Windows 
b/monetdb5/modules/mal/Tests/inspect05.stable.out.Windows
--- a/monetdb5/modules/mal/Tests/inspect05.stable.out.Windows
+++ b/monetdb5/modules/mal/Tests/inspect05.stable.out.Windows
@@ -28,18 +28,33 @@
 # str                          str             str             str             
                                                                                
                                        str                                     
                  # type
 
#-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------#
 [ "main",                        "function",     "user",         "():void;",   
                                                                                
                                          "nil"                                 
                  ]
+[ "reverse",             "command",      "udf",          
"(b:bat[:oid,:str]):bat[:oid,:str] ",                                           
                                        "UDFBATreverse;"                        
        ]
+[ "reverse",             "command",      "udf",          "(ra1:str):str ",     
                                                                                
                  "UDFreverse;"                                   ]
+[ "reverse",             "command",      "udf",          
"(b:bat[:oid,:str]):bat[:oid,:str] ",                                           
                                        "UDFBATreverse;"                        
        ]
+[ "reverse",             "command",      "udf",          "(ra1:str):str ",     
                                                                                
                  "UDFreverse;"                                   ]
+[ "reverse",             "command",      "udf",          
"(b:bat[:oid,:str]):bat[:oid,:str] ",                                           
                                        "UDFBATreverse;"                        
        ]
+[ "reverse",             "command",      "udf",          "(ra1:str):str ",     
                                                                                
                  "UDFreverse;"                                   ]
+[ "reverse",             "command",      "udf",          
"(b:bat[:oid,:str]):bat[:oid,:str] ",                                           
                                        "UDFBATreverse;"                        
        ]
+[ "reverse",             "command",      "udf",          "(ra1:str):str ",     
                                                                                
                  "UDFreverse;"                                   ]
 [ "next_value",                  "pattern",      "batsql",       
"(sname:bat[:oid,:str],sequence:str):bat[:oid,:lng] ",                          
                "mvc_bat_next_value;"                           ]
+[ "reverse",             "command",      "udf",          
"(b:bat[:oid,:str]):bat[:oid,:str] ",                                           
                                        "UDFBATreverse;"                        
        ]
+[ "reverse",             "command",      "udf",          "(ra1:str):str ",     
                                                                                
                  "UDFreverse;"                                   ]
 [ "Area",                "command",      "geom",         "(g:wkb):dbl ",       
                                                                                
          "wkbArea;"                              ]
 [ "AsText",              "command",      "geom",         "(w:wkb):str ",       
                                                                                
          "wkbAsText;"                            ]
+[ "alpha",               "command",      "batsql",       
"(dec:bat[:oid,:dbl],theta:dbl):bat[:oid,:dbl] ",                               
                                        "SQLbat_alpha;"                         
        ]
 [ "Buffer",              "command",      "geom",         
"(a:wkb,distance:dbl):wkb ",                                                    
                                "wkbBuffer;"                            ]
 [ "Boundary",            "command",      "geom",         "(w:wkb):wkb ",       
                                                                                
          "wkbBoundary;"                          ]
+[ "alpha",               "command",      "batsql",       
"(dec:bat[:oid,:dbl],theta:dbl):bat[:oid,:dbl] ",                               
                                        "SQLbat_alpha;"                         
        ]
 [ "ConvexHull",                  "command",      "geom",         "(a:wkb):wkb 
",                                                                              
                   "wkbConvexHull;"                        ]
 [ "Contains",            "command",      "geom",         "(a:wkb,b:wkb):bit ", 
                                                                                
          "wkbContains;"                          ]
+[ "alpha",               "command",      "batsql",       
"(dec:bat[:oid,:dbl],theta:dbl):bat[:oid,:dbl] ",                               
                                        "SQLbat_alpha;"                         
        ]
 [ "Crosses",             "command",      "geom",         "(a:wkb,b:wkb):bit ", 
                                                                                
          "wkbCrosses;"                           ]
 [ "CurveFromText",       "function",     "geom",         
"(wkt:str,srid:sht):wkb;",                                                      
                                "nil"                                   ]
+[ "alpha",               "command",      "batsql",       
"(dec:bat[:oid,:dbl],theta:dbl):bat[:oid,:dbl] ",                               
                                        "SQLbat_alpha;"                         
        ]
 [ "Difference",                  "command",      "geom",         
"(a:wkb,b:wkb):wkb ",                                                           
                                "wkbDifference;"                        ]
 [ "Distance",            "command",      "geom",         "(a:wkb,b:wkb):dbl ", 
                                                                                
          "wkbDistance;"                          ]
 [ "Disjoint",            "command",      "geom",         "(a:wkb,b:wkb):bit ", 
                                                                                
          "wkbDisjoint;"                          ]
+[ "alpha",               "command",      "batsql",       
"(dec:bat[:oid,:dbl],theta:dbl):bat[:oid,:dbl] ",                               
                                        "SQLbat_alpha;"                         
        ]
 [ "Dimension",           "command",      "geom",         "(w:wkb):int ",       
                                                                                
          "wkbDimension;"                         ]
 [ "Equals",              "command",      "geom",         "(a:wkb,b:wkb):bit ", 
                                                                                
          "wkbEquals;"                            ]
 [ "Envelope",            "command",      "geom",         "(w:wkb):wkb ",       
                                                                                
          "wkbEnvelope;"                          ]
@@ -172,19 +187,24 @@
 [ "split",                       "pattern",      "cluster",      
"(clustered:bat[:oid,:any_1],psum:bat[:oid,:wrd]):bat[:oid,:any_1]... ",        
                                                                                
                        "CLS_split;"                                    ]
 [ "table",                               "pattern",      "cluster",      
"(b:bat[:oid,:any]...):bat[:oid,:oid] ",                                        
                                        "CLUSTER_table;"                        
                ]
 [ "getCloud",                    "command",      "mapreduce",    
"(nme:str):bat[:oid,:str] ",                                                    
                                                        "MRgetCloud;"           
                                ]
+[ "alpha",               "command",      "sql",          
"(dec:dbl,theta:dbl):dbl ",                                                     
                                        "SQLdbl_alpha;"                         
        ]
 [ "multiplex",                   "pattern",      "mal",          
"(a:any...):any ",                                                              
                                                        "OPTremapMultiplex;"    
                                ]
 [ "argRecord",           "pattern",      "sql",          "(a:any...):str ",    
                                                                                
          "SQLargRecord;"                         ]
 [ "argRecord",           "pattern",      "sql",          "():str ",            
                                                                                
          "SQLargRecord;"                         ]
+[ "alpha",               "command",      "sql",          
"(dec:dbl,theta:dbl):dbl ",                                                     
                                        "SQLdbl_alpha;"                         
        ]
 [ "affectedRows",        "pattern",      "sql",          "(nr:wrd,w:str):void 
",                                                                              
           "mvc_affected_rows_wrap;"               ]
 [ "append",              "pattern",      "sql",          
"(mvc:ptr,sname:str,tname:str,cname:str,ins:any):ptr ",                         
                                "mvc_append_wrap;"                      ]
 [ "assert",              "pattern",      "sql",          "(b:lng,msg:str):void 
",                                                                              
          "SQLassertLng;"                         ]
+[ "alpha",               "command",      "sql",          
"(dec:dbl,theta:dbl):dbl ",                                                     
                                        "SQLdbl_alpha;"                         
        ]
 [ "assert",              "pattern",      "sql",          "(b:wrd,msg:str):void 
",                                                                              
          "SQLassertWrd;"                         ]
 [ "assert",              "pattern",      "sql",          "(b:int,msg:str):void 
",                                                                              
          "SQLassertInt;"                         ]
 [ "assert",              "pattern",      "sql",          "(b:bit,msg:str):void 
",                                                                              
          "SQLassert;"                            ]
+[ "alpha",               "command",      "sql",          
"(dec:dbl,theta:dbl):dbl ",                                                     
                                        "SQLdbl_alpha;"                         
        ]
 [ "bbp",                 "function",     "sql",          "():bat[:str,:BAT];", 
                                                                                
          "nil"                                   ]
 [ "bind_dbat",           "command",      "sql",          
"(clientid:int,schema:str,table:str,access:int,oldversion:lng,version:lng):bat[:oid,:oid]
 ",                    "mvc_diff_dbat_wrap;"                   ]
 [ "bind",                "pattern",      "sql",          
"(mvc:ptr,schema:str,table:str,column:str,access:int,part_nr:int,nr_parts:int):bat[:oid,:any_1]
 ",              "mvc_bind_wrap;"                        ]
 [ "bind",                "pattern",      "sql",          
"(mvc:ptr,schema:str,table:str,column:str,access:int,low:oid,hgh:oid):bat[:oid,:any_1]
 ",                       "mvc_bind_wrap;"                        ]
+[ "alpha",               "command",      "sql",          
"(dec:dbl,theta:dbl):dbl ",                                                     
                                        "SQLdbl_alpha;"                         
        ]
 [ "bind",                "pattern",      "sql",          
"(mvc:ptr,schema:str,table:str,column:str,access:int):bat[:oid,:any_1] ",       
                                "mvc_bind_wrap;"                        ]
 [ "bind_idxbat",         "pattern",      "sql",          
"(mvc:ptr,schema:str,table:str,index:str,access:int,part_nr:int,nr_parts:int):bat[:oid,:any_1]
 ",               "mvc_bind_idxbat_wrap;"                 ]
 [ "bind_idxbat",         "pattern",      "sql",          
"(mvc:ptr,schema:str,table:str,index:str,access:int,low:oid,hgh:oid):bat[:oid,:any_1]
 ",                        "mvc_bind_idxbat_wrap;"                 ]
@@ -199,23 +219,28 @@
 [ "clear_table",         "pattern",      "sql",          
"(sname:str,tname:str):wrd ",                                                   
                                "mvc_clear_table_wrap;"                 ]
 [ "catalog",             "pattern",      "sql",          
"(type:int,iname:str,itype:int,sname:str,tname:str...):void ",                  
                                "SQLcatalog;"                           ]
 [ "catalog",             "pattern",      "sql",          
"(type:int,tname:str,grantee:str,privs:int,cname:str,grant:int,grantor:int):void
 ",                             "SQLcatalog;"                           ]
+[ "commit",              "pattern",      "sql",          "():void ",           
                                                                                
                  "SQLcommit;"                                    ]
 [ "catalog",             "pattern",      "sql",          
"(type:int,user:str,passwd:str,enc:int,schema:str,fullname:str):void ",         
                                "SQLcatalog;"                           ]
 [ "catalog",             "pattern",      "sql",          
"(type:int,grantee:str,role:str):void ",                                        
                                "SQLcatalog;"                           ]
 [ "catalog",             "pattern",      "sql",          
"(type:int,sname:str,t:ptr,restart:lng):void ",                                 
                                "SQLcatalog;"                           ]
 [ "catalog",             "pattern",      "sql",          
"(type:int,sname:str,t:ptr,temp:int):void ",                                    
                                "SQLcatalog;"                           ]
+[ "commit",              "pattern",      "sql",          "():void ",           
                                                                                
                  "SQLcommit;"                                    ]
 [ "catalog",             "pattern",      "sql",          
"(type:int,sname:str,name:str,action:int):void ",                               
                                "SQLcatalog;"                           ]
 [ "dropdictionary",      "pattern",      "sql",          
"(sch:str,tbl:str):void ",                                                      
                                "SQLdropDictionary;"                    ]
 [ "drop_hash",           "pattern",      "sql",          
"(sch:str,tbl:str):void ",                                                      
                                "SQLdrop_hash;"                         ]
 [ "dense_rank",                  "command",      "sql",          
"(b:bat[:oid,:any_1]):bat[:oid,:int] ",                                         
                                "sql_dense_rank;"                       ]
+[ "commit",              "pattern",      "sql",          "():void ",           
                                                                                
                  "SQLcommit;"                                    ]
 [ "dense_rank_grp",      "command",      "sql",          
"(b:bat[:oid,:any_1],gp:bat[:oid,:oid],gpe:bat[:oid,:oid]):bat[:oid,:int] ",    
                                "sql_dense_rank_grp;"                   ]
 [ "dec_round",           "command",      "sql",          "(v:dbl,r:dbl):dbl ", 
                                                                                
          "dbl_dec_round_wrap;"                   ]
 [ "dec_round",           "command",      "sql",          "(v:flt,r:flt):flt ", 
                                                                                
          "flt_dec_round_wrap;"                   ]
 [ "dec_round",           "command",      "sql",          "(v:lng,r:lng):lng ", 
                                                                                
          "lng_dec_round_wrap;"                   ]
+[ "commit",              "pattern",      "sql",          "():void ",           
                                                                                
                  "SQLcommit;"                                    ]
 [ "dec_round",           "command",      "sql",          "(v:int,r:int):int ", 
                                                                                
          "int_dec_round_wrap;"                   ]
 [ "dec_round",           "command",      "sql",          "(v:sht,r:sht):sht ", 
                                                                                
          "sht_dec_round_wrap;"                   ]
 [ "dec_round",           "command",      "sql",          "(v:bte,r:bte):bte ", 
                                                                                
          "bte_dec_round_wrap;"                   ]
 [ "dump_trace",                  "pattern",      "sql",          
"():bat[:str,:BAT] ",                                                           
                                "dump_trace;"                           ]
 [ "dump_opt_stats",      "pattern",      "sql",          "():bat[:str,:BAT] ", 
                                                                                
          "dump_opt_stats;"                       ]
+[ "commit",              "pattern",      "sql",          "():void ",           
                                                                                
                  "SQLcommit;"                                    ]
 [ "dump_cache",                  "pattern",      "sql",          
"():bat[:str,:BAT] ",                                                           
                                "dump_cache;"                           ]
 [ "db_users",            "pattern",      "sql",          "():bat[:str,:BAT] ", 
                                                                                
          "db_users_wrap;"                        ]
 [ "dropDeclaredTables",          "pattern",      "sql",          
"(nr:int):void ",                                                               
                                "mvc_drop_declared_tables_wrap;"        ]
@@ -265,42 +290,67 @@
 [ "round",               "command",      "sql",          "(v:flt,r:bte):flt ", 
                                                                                
          "flt_round_wrap;"                       ]
 [ "round",               "command",      "sql",          
"(v:lng,d:int,s:int,r:bte):lng ",                                               
                                "lng_round_wrap;"                       ]
 [ "round",               "command",      "sql",          
"(v:int,d:int,s:int,r:bte):int ",                                               
                                "int_round_wrap;"                       ]
+[ "ra",                          "pattern",      "sql",          
"(cmd:str,optimize:bit):void ",                                                 
                                        "RAstatement;"                          
        ]
 [ "round",               "command",      "sql",          
"(v:sht,d:int,s:int,r:bte):sht ",                                               
                                "sht_round_wrap;"                       ]
 [ "round",               "command",      "sql",          
"(v:bte,d:int,s:int,r:bte):bte ",                                               
                                "bte_round_wrap;"                       ]
 [ "rsColumn",            "pattern",      "sql",          
"(rs:int,tname:str,name:str,typename:str,digits:int,scale:int,col:bat[:oid,:any_1]):void
 ",                     "mvc_result_column_wrap;"               ]
 [ "rsColumn",            "pattern",      "sql",          
"(rs:int,tname:str,name:str,typename:str,digits:int,scale:int,val:any_1):void 
",                                "mvc_result_value_wrap;"                ]
 [ "resultSet",           "pattern",      "sql",          
"(nr_cols:int,qtype:int,order:bat[:oid,:any_1]):int ",                          
                                "mvc_result_table_wrap;"                ]
+[ "ra",                          "pattern",      "sql",          
"(cmd:str,optimize:bit):void ",                                                 
                                        "RAstatement;"                          
        ]
 [ "resultSet",           "pattern",      "sql",          
"(nr_cols:int,qtype:int,order:any_1):int ",                                     
                                "mvc_result_row_wrap;"                  ]
 [ "resultSet",           "pattern",      "sql",          
"(nr_cols:int,sep:str,rsep:str,ssep:str,ns:str,order:bat[:oid,:any_1]):int ",   
                                "mvc_result_file_wrap;"                 ]
 [ "resultSet",           "pattern",      "sql",          
"(nr_cols:int,sep:str,rsep:str,ssep:str,ns:str,order:any_1):int ",              
                                "mvc_result_file_wrap;"                 ]
 [ "restart",             "pattern",      "sql",          
"(sname:str,sequence:str,start:lng):lng ",                                      
                                "mvc_restart_seq;"                      ]
+[ "transaction",         "pattern",      "sql",          "():void ",           
                                                                                
                  "SQLtransaction2;"                              ]
 [ "shrink",              "pattern",      "sql",          
"(sch:str,tbl:str):void ",                                                      
                                "SQLshrink;"                            ]
+[ "ra",                          "pattern",      "sql",          
"(cmd:str,optimize:bit):void ",                                                 
                                        "RAstatement;"                          
        ]
 [ "storage",             "pattern",      "sql",          "():bat[:str,:BAT] ", 
                                                                                
          "sql_storage;"                          ]
 [ "sql_variables",       "pattern",      "sql",          "():bat[:str,:BAT] ", 
                                                                                
          "sql_variables;"                        ]
 [ "sql_environment",     "function",     "sql",          "():bat[:str,:BAT];", 
                                                                                
          "nil"                                   ]
+[ "bind_idxbat",         "function",     "octopus",      
"(conn:str,sch:str,tab:str,index:str,access:int,part_nr:int,nr_parts:int,version:int):bat[:oid,:oid];",
                 "nil"                                           ]
+[ "bind",                "function",     "octopus",      
"(conn:str,sch:str,tab:str,col:str,kind:int,part_nr:int,nr_parts:int,version:int):bat[:oid,:any_1];",
                   "nil"                                           ]
+[ "bind",                "function",     "octopus",      
"(mvc:int,sch:str,tab:str,col:str,kind:int,part_nr:int,nr_parts:int,version:int):bat[:oid,:any_1];",
                    "nil"                                           ]
 [ "single",              "function",     "sql",          
"(x:any_2):bat[:oid,:any_2];",                                                  
                                "nil"                                   ]
+[ "transaction",         "pattern",      "sql",          "():void ",           
                                                                                
                  "SQLtransaction2;"                              ]
 [ "setVariable",         "pattern",      "sql",          
"(mvc:ptr,varname:str,value:any_1):ptr ",                                       
                                "setVariable;"                          ]
+[ "ra",                          "pattern",      "sql",          
"(cmd:str,optimize:bit):void ",                                                 
                                        "RAstatement;"                          
        ]
 [ "start2",              "pattern",      "sql",          "():void ",           
                                                                                
          "SQLsession2;"                          ]
 [ "start",               "pattern",      "sql",          "():void ",           
                                                                                
          "SQLsession;"                           ]
 [ "times",               "factory",      "sql",          "():void;",           
                                                                                
          "nil"                                   ]
+[ "bind_idxbat",         "function",     "octopus",      
"(conn:str,sch:str,tab:str,index:str,access:int,part_nr:int,nr_parts:int,version:int):bat[:oid,:oid];",
                 "nil"                                           ]
+[ "bind",                "function",     "octopus",      
"(conn:str,sch:str,tab:str,col:str,kind:int,part_nr:int,nr_parts:int,version:int):bat[:oid,:any_1];",
                   "nil"                                           ]
+[ "bind",                "function",     "octopus",      
"(mvc:int,sch:str,tab:str,col:str,kind:int,part_nr:int,nr_parts:int,version:int):bat[:oid,:any_1];",
                    "nil"                                           ]
 [ "times",               "function",     "sql",          
"(elaps:int,inblock:lng,oublock:lng):void;",                                    
                                "nil"                                   ]
+[ "transaction",         "pattern",      "sql",          "():void ",           
                                                                                
                  "SQLtransaction2;"                              ]
 [ "trans",               "pattern",      "sql",          
"(type:int,chain:int,name:str):void ",                                          
                                "SQLtransaction;"                       ]
 [ "update",              "pattern",      "sql",          
"(mvc:ptr,sname:str,tname:str,cname:str,ins:any):ptr ",                         
                                "mvc_update_wrap;"                      ]
+[ "ra",                          "pattern",      "sql",          
"(cmd:str,optimize:bit):void ",                                                 
                                        "RAstatement;"                          
        ]
 [ "vacuum",              "pattern",      "sql",          
"(sch:str,tbl:str):void ",                                                      
                                "SQLvacuum;"                            ]
 [ "zero_or_one",         "function",     "sql",          
"(b:bat[:oid,:any_1],gp:bat[:oid,:oid],gpe:bat[:oid,:oid]):bat[:oid,:any_1];",  
                                "nil"                                   ]
+[ "bind_idxbat",         "function",     "octopus",      
"(conn:str,sch:str,tab:str,index:str,access:int,part_nr:int,nr_parts:int,version:int):bat[:oid,:oid];",
                 "nil"                                           ]
+[ "bind",                "function",     "octopus",      
"(conn:str,sch:str,tab:str,col:str,kind:int,part_nr:int,nr_parts:int,version:int):bat[:oid,:any_1];",
                   "nil"                                           ]
+[ "bind",                "function",     "octopus",      
"(mvc:int,sch:str,tab:str,col:str,kind:int,part_nr:int,nr_parts:int,version:int):bat[:oid,:any_1];",
                    "nil"                                           ]
 [ "zero_or_one",         "command",      "sql",          
"(col:bat[:any_2,:any_1]):any_1 ",                                              
                                "zero_or_one;"                          ]
+[ "transaction",         "pattern",      "sql",          "():void ",           
                                                                                
                  "SQLtransaction2;"                              ]
 [ "bind_idxbat",         "function",     "octopus",      
"(conn:str,sch:str,tab:str,index:str,access:int,low:oid,hgh:oid,version:int):bat[:oid,:oid];",
                  "nil"                                   ]
 [ "bind_idxbat",         "function",     "octopus",      
"(conn:str,sch:str,tab:str,index:str,access:int,version:int):bat[:oid,:oid];",  
                                "nil"                                   ]
 [ "bind_idxbat",         "function",     "octopus",      
"(mvc:ptr,sch:str,tab:str,index:str,access:int,version:int):bat[:oid,:oid];",   
                                "nil"                                   ]
 [ "bind_dbat",           "function",     "octopus",      
"(conn:str,sch:str,tab:str,access:int,version:int):bat[:oid,:oid];",            
                                "nil"                                   ]
 [ "bind_dbat",           "function",     "octopus",      
"(mvc:ptr,sch:str,tab:str,access:int,version:int):bat[:oid,:oid];",             
                                "nil"                                   ]
+[ "bind_idxbat",         "function",     "octopus",      
"(conn:str,sch:str,tab:str,index:str,access:int,part_nr:int,nr_parts:int,version:int):bat[:oid,:oid];",
                 "nil"                                           ]
+[ "bind",                "function",     "octopus",      
"(conn:str,sch:str,tab:str,col:str,kind:int,part_nr:int,nr_parts:int,version:int):bat[:oid,:any_1];",
                   "nil"                                           ]
+[ "bind",                "function",     "octopus",      
"(mvc:int,sch:str,tab:str,col:str,kind:int,part_nr:int,nr_parts:int,version:int):bat[:oid,:any_1];",
                    "nil"                                           ]
 [ "bind",                "function",     "octopus",      
"(conn:str,sch:str,tab:str,col:str,kind:int,version:int):bat[:oid,:any_1];",    
                                "nil"                                   ]
 [ "bind",                "function",     "octopus",      
"(conn:str,sch:str,tab:str,col:str,kind:int,low:oid,hgh:oid,version:int):bat[:oid,:any_1];",
                    "nil"                                   ]
+[ "transaction",         "pattern",      "sql",          "():void ",           
                                                                                
                  "SQLtransaction2;"                              ]
 [ "bind",                "function",     "octopus",      
"(mvc:ptr,sch:str,tab:str,col:str,kind:int,version:int):bat[:oid,:any_1];",     
                                "nil"                                   ]
 [ "bind",                "function",     "octopus",      
"(mvc:ptr,sch:str,tab:str,col:str,kind:int,low:oid,hgh:oid,version:int):bat[:oid,:any_1];",
                     "nil"                                   ]
 [ "connect",                     "command",      "octopus",      
"(dbname:str):str ",                                                            
                                "OCTOPUSconnect;"                               
]
 [ "getBid",              "function",     "octopus",      
"(dbname:str,fn:str,bidtype:sht):lng;",                                         
                                "nil"                                   ]
 [ "getVariable",         "function",     "octopus",      
"(conn:str,name:str):any_1;",                                                   
                                "nil"                                   ]
+[ "bind_idxbat",         "function",     "octopus",      
"(conn:str,sch:str,tab:str,index:str,access:int,part_nr:int,nr_parts:int,version:int):bat[:oid,:oid];",
                 "nil"                                           ]
+[ "bind",                "function",     "octopus",      
"(conn:str,sch:str,tab:str,col:str,kind:int,part_nr:int,nr_parts:int,version:int):bat[:oid,:any_1];",
                   "nil"                                           ]
+[ "bind",                "function",     "octopus",      
"(mvc:int,sch:str,tab:str,col:str,kind:int,part_nr:int,nr_parts:int,version:int):bat[:oid,:any_1];",
                    "nil"                                           ]
 [ "getVersion",                  "command",      "octopus",      "():int ",    
                                                                                
                  "OCTOPUSgetVersion;"                    ]
 [ "legAdvice",                           "pattern",      "octopus",      
"(mod:str,fcn:str):int ",                                                       
                                                "OPTlegAdvice;"                 
                        ]
 [ "register",                    "pattern",      "octopus",      
"(dbname:str,fname:str...):void ",                                              
                                "OCTOPUSregister;"                              
]
@@ -335,8 +385,6 @@
 [ "coercions",                   "pattern",      "optimizer",    "():str ",    
                                                                                
                                          "OPTcoercion;"                        
                  ]
 [ "clrDebug",                    "pattern",      "optimizer",    "():void ",   
                                                                                
                                          "QOTclrdebugOptimizers;"              
                  ]
 [ "dumpQEP",                     "pattern",      "optimizer",    "():void ",   
                                                                                
                                          "OPTdumpQEP;"                         
                  ]
-[ "datacell",                            "pattern",      "optimizer",    
"(mod:str,fcn:str):str ",                                                       
                        "OPTdatacell;"                                  ]
-[ "datacell",                            "pattern",      "optimizer",    
"():str ",                                                                      
                        "OPTdatacell;"                                  ]
 [ "derivePath",                                  "pattern",      "optimizer",  
  "(mod:str,fcn:str):str ",                                                     
                                                                  
"OPTderivePath;"                                        ]
 [ "derivePath",                                  "pattern",      "optimizer",  
  "():str ",                                                                    
                                                                  
"OPTderivePath;"                                        ]
 [ "datacyclotron",                       "pattern",      "optimizer",    
"(mod:str,fcn:str):str ",                                                       
                        "OPTdatacyclotron;"                             ]
@@ -346,6 +394,8 @@
 [ "dictionary",                                  "pattern",      "optimizer",  
  "(mod:str,fcn:str):str ",                                                     
                                                          "OPTdictionary;"      
                                  ]
 [ "dictionary",                                  "pattern",      "optimizer",  
  "():str ",                                                                    
                                                          "OPTdictionary;"      
                                  ]
 [ "dataflow",                    "pattern",      "optimizer",    
"(mod:str,fcn:str):str ",                                                       
                                                        "OPTdataflow;"          
                                ]
+[ "origin",              "pattern",      "optimizer",    
"(mod:str,fcn:str):str ",                                                       
                                        "OPTorigin;"                            
        ]
+[ "origin",              "pattern",      "optimizer",    "():str ",            
                                                                                
                  "OPTorigin;"                                    ]
 [ "dataflow",                    "pattern",      "optimizer",    "():str ",    
                                                                                
                                          "OPTdataflow;"                        
                  ]
 [ "evaluate",                    "pattern",      "optimizer",    
"(mod:str,fcn:str):str ",                                                       
                                                        "OPTevaluate;"          
                                ]
 [ "evaluate",                    "pattern",      "optimizer",    "():str ",    
                                                                                
                                          "OPTevaluate;"                        
                  ]
@@ -356,6 +406,8 @@
 [ "garbageCollector",            "pattern",      "optimizer",    
"(mod:str,fcn:str):str ",                                                       
                                                        "OPTgarbageCollector;"  
                                ]
 [ "garbageCollector",            "pattern",      "optimizer",    "():str ",    
                                                                                
                                          "OPTgarbageCollector;"                
                  ]
 [ "history",                             "pattern",      "optimizer",    
"(mod:str,fcn:str):str ",                                                       
                                                        "OPThistory;"           
                        ]
+[ "origin",              "pattern",      "optimizer",    
"(mod:str,fcn:str):str ",                                                       
                                        "OPTorigin;"                            
        ]
+[ "origin",              "pattern",      "optimizer",    "():str ",            
                                                                                
                  "OPTorigin;"                                    ]
 [ "history",                             "pattern",      "optimizer",    
"():str ",                                                                      
                                                        "OPThistory;"           
                        ]
 [ "heuristics",                          "pattern",      "optimizer",    
"(mod:str,fcn:str):str ",                                                       
                                                        "OPTheuristics;"        
                                ]
 [ "heuristics",                          "pattern",      "optimizer",    
"():str ",                                                                      
                                                        "OPTheuristics;"        
                                ]
@@ -366,6 +418,8 @@
 [ "mapreduce",                   "pattern",      "optimizer",    
"(mod:str,fcn:str):str ",                                                       
                                                        "OPTmapreduce;"         
                                ]
 [ "mapreduce",                   "pattern",      "optimizer",    "():str ",    
                                                                                
                                          "OPTmapreduce;"                       
                  ]
 [ "mitosis",                     "pattern",      "optimizer",    
"(mod:str,fcn:str):str ",                                                       
                                                        "OPTmitosis;"           
                                ]
+[ "origin",              "pattern",      "optimizer",    
"(mod:str,fcn:str):str ",                                                       
                                        "OPTorigin;"                            
        ]
+[ "origin",              "pattern",      "optimizer",    "():str ",            
                                                                                
                  "OPTorigin;"                                    ]
 [ "mitosis",                     "pattern",      "optimizer",    "():str ",    
                                                                                
                                          "OPTmitosis;"                         
                  ]
 [ "mergetable",                          "pattern",      "optimizer",    
"(mod:str,fcn:str):str ",                                                       
                                                        "OPTmergetable;"        
                                ]
 [ "mergetable",                          "pattern",      "optimizer",    
"():str ",                                                                      
                                                        "OPTmergetable;"        
                                ]
@@ -373,7 +427,11 @@
 [ "multiplex",                   "pattern",      "optimizer",    "():void ",   
                                                                                
                                          "OPTmultiplex;"                       
                  ]
 [ "macro",                       "pattern",      "optimizer",    
"(mod:str,fcn:str,targetmod:str,targetfcn:str):void ",                          
                                                        "OPTmacro;"             
                                ]
 [ "macro",                       "pattern",      "optimizer",    
"(targetmod:str,targetfcn:str):void ",                                          
                                                        "OPTmacro;"             
                                ]
+[ "origin",              "pattern",      "optimizer",    
"(mod:str,fcn:str):str ",                                                       
                                        "OPTorigin;"                            
        ]
+[ "origin",              "pattern",      "optimizer",    "():str ",            
                                                                                
                  "OPTorigin;"                                    ]
 [ "octopus",                     "pattern",      "optimizer",    
"(mod:str,fcn:str):str ",                                                       
                                                        "OPToctopus;"           
                                ]
+[ "origin",              "pattern",      "optimizer",    
"(mod:str,fcn:str):str ",                                                       
                                        "OPTorigin;"                            
        ]
+[ "origin",              "pattern",      "optimizer",    "():str ",            
                                                                                
                  "OPTorigin;"                                    ]
_______________________________________________
Checkin-list mailing list
Checkin-list@monetdb.org
http://mail.monetdb.org/mailman/listinfo/checkin-list

Reply via email to