Changeset: dd1994d940bd for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=dd1994d940bd
Added Files:
        sql/test/BugTracker-2012/Tests/bart-crash.Bug-3057.sql
        sql/test/BugTracker-2012/Tests/bart-crash.Bug-3057.stable.err
        sql/test/BugTracker-2012/Tests/bart-crash.Bug-3057.stable.out
        sql/test/BugTracker-2012/Tests/delete-with-constant-where.Bug-3065.sql
        
sql/test/BugTracker-2012/Tests/delete-with-constant-where.Bug-3065.stable.err
        
sql/test/BugTracker-2012/Tests/delete-with-constant-where.Bug-3065.stable.out
        
sql/test/BugTracker-2012/Tests/multiple-arithmetic-operations.Bug-3048.sql
        
sql/test/BugTracker-2012/Tests/multiple-arithmetic-operations.Bug-3048.stable.err
        
sql/test/BugTracker-2012/Tests/multiple-arithmetic-operations.Bug-3048.stable.out
        sql/test/BugTracker-2012/Tests/parent-table-alias.Bug-3047.sql
        sql/test/BugTracker-2012/Tests/parent-table-alias.Bug-3047.stable.err
        sql/test/BugTracker-2012/Tests/parent-table-alias.Bug-3047.stable.out
        sql/test/BugTracker-2012/Tests/set_operation.Bug-3059.sql
        sql/test/BugTracker-2012/Tests/set_operation.Bug-3059.stable.err
        sql/test/BugTracker-2012/Tests/set_operation.Bug-3059.stable.out
Removed Files:
        
sql/test/BugDay_2005-10-06_2.9.3/Tests/alter_table_describe.SF-1146092.SQL.bat
        
sql/test/BugDay_2005-10-06_2.9.3/Tests/alter_table_describe.SF-1146092.SQL.sh
        
sql/test/BugDay_2005-10-06_2.9.3/Tests/alter_table_describe.SF-1146092.stable.err
        
sql/test/BugDay_2005-10-06_2.9.3/Tests/alter_table_describe.SF-1146092.stable.out
Modified Files:
        gdk/gdk_batop.mx
        java/tests/Test_PStimezone.java
        monetdb5/modules/mal/Tests/inspect05.stable.out.Windows
        monetdb5/tests/gdkTests/Tests/casts.stable.out
        sql/jdbc/tests/Tests/Test_PStimezone.stable.out
        sql/test/BugDay_2005-10-06_2.9.3/Tests/All
        sql/test/BugTracker-2012/Tests/All
Branch: default
Log Message:

Merge with Apr2012 branch.


diffs (truncated from 16336 to 300 lines):

diff --git a/gdk/gdk_batop.mx b/gdk/gdk_batop.mx
--- a/gdk/gdk_batop.mx
+++ b/gdk/gdk_batop.mx
@@ -1924,7 +1924,7 @@ BAT@6order@2(BAT *b)
        BATcheck(b, "BATorder@2");
        if (b->htype == TYPE_void && b->hseqbase == oid_nil) {
                /* b's head is void-nil, hence we return b as is */
-               return BATcopy(b, b->htype, b->ttype, FALSE);
+               return b;
        }
 #if 0 @5 1
        if (b->htype != TYPE_void && BATordered_rev(b))
diff --git a/java/tests/Test_PStimezone.java b/java/tests/Test_PStimezone.java
--- a/java/tests/Test_PStimezone.java
+++ b/java/tests/Test_PStimezone.java
@@ -23,6 +23,12 @@ import java.text.*;
 
 public class Test_PStimezone {
        public static void main(String[] args) throws Exception {
+               // make sure this test is reproducable regardless timezone
+               // setting, by overriding the VM's default
+               // we have to make sure that one doesn't have daylight
+               // savings corrections
+               TimeZone.setDefault(TimeZone.getTimeZone("UTC"));
+
                Class.forName("nl.cwi.monetdb.jdbc.MonetDriver");
                Connection con = DriverManager.getConnection(args[0]);
                Statement stmt = con.createStatement();
@@ -58,12 +64,6 @@ public class Test_PStimezone {
 
                        System.out.println("2. inserting records...");
 
-                       // make sure this test is reproducable regardless 
timezone
-                       // setting, by overriding the VM's default
-                       // we have to make sure that one doesn't have daylight
-                       // savings corrections
-                       TimeZone.setDefault(TimeZone.getTimeZone("UTC"));
-
                        SimpleDateFormat tsz =
                                new SimpleDateFormat("yyyy-MM-dd 
HH:mm:ss.SSSZ");
                        SimpleDateFormat tz =
diff --git a/monetdb5/modules/mal/Tests/inspect05.stable.out.Windows 
b/monetdb5/modules/mal/Tests/inspect05.stable.out.Windows
old mode 100755
new mode 100644
--- a/monetdb5/modules/mal/Tests/inspect05.stable.out.Windows
+++ b/monetdb5/modules/mal/Tests/inspect05.stable.out.Windows
@@ -27,7790 +27,5333 @@ function user.main():void;
     fs := bat.reverse(f2);
     s := inspect.getSignatures();
     a := inspect.getAddresses();
-    io.table(fs,k,m,s,a);
+    io.table(1,fs,k,m,s,a);
 end main;
-#---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------#
-# h                    symbol          symbol           symbol                 
                                                                 symbol         
                  # name
-# str                  str             str             str                     
                                                                str             
                  # type
-#---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------#
-[ "main",                "function",     "user",         "():void;",           
                                                                  "nil"         
                  ]
-[ "fuse",                "command",      "udf",          
"(one:int,two:int):lng ",                                                       
        "UDFfuse_int_lng;"              ]
-[ "fuse",                "command",      "udf",          
"(one:sht,two:sht):int ",                                                       
        "UDFfuse_sht_int;"              ]
-[ "fuse",                "command",      "udf",          
"(one:bte,two:bte):sht ",                                                       
        "UDFfuse_bte_sht;"              ]
-[ "reverse",             "command",      "udf",          "(ra1:str):str ",     
                                                                  "UDFreverse;" 
                  ]
-[ "fuse",                "command",      "batudf",       
"(one:bat[:oid,:int],two:bat[:oid,:int]):bat[:oid,:lng] ",                      
        "UDFBATfuse;"                   ]
-[ "fuse",                "command",      "batudf",       
"(one:bat[:oid,:sht],two:bat[:oid,:sht]):bat[:oid,:int] ",                      
        "UDFBATfuse;"                   ]
-[ "fuse",                "command",      "batudf",       
"(one:bat[:oid,:bte],two:bat[:oid,:bte]):bat[:oid,:sht] ",                      
        "UDFBATfuse;"                   ]
-[ "reverse",             "command",      "batudf",       
"(b:bat[:oid,:str]):bat[:oid,:str] ",                                           
        "UDFBATreverse;"                ]
-[ "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;"         ]
-[ "ptinsphcircle",       "command",      "lsst",         
"(ra:dbl,dec:dbl,ra_cen:dbl,dec_cen:dbl,radius:dbl):int ",                      
        "qserv_ptInSphCircle;"          ]
-[ "ptinsphbox",                  "command",      "lsst",         
"(ra:dbl,dec:dbl,ra_min:dbl,dec_min:dbl,ra_max:dbl,dec_max:dbl):int ",          
        "qserv_ptInSphBox;"             ]
-[ "xmatch",              "command",      "lsst",         
"(l:bat[:oid,:lng],r:bat[:oid,:lng],depth:int):bat[:oid,:oid] ",                
        "LSSTxmatch;"                   ]
-[ "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;"           ]
-[ "avg",                 "function",     "jaqlfunc",     
"(v:bat[:oid,:dbl]):bat[:oid,:dbl];",                                           
        "nil"                           ]
-[ "avg",                 "function",     "jaqlfunc",     
"(v:bat[:oid,:lng]):bat[:oid,:dbl];",                                           
        "nil"                           ]
-[ "arrayToRecord",       "function",     "jaqlfunc",     
"(kindn:bat[:oid,:bte],stringn:bat[:oid,:str],integern:bat[:oid,:lng],doublen:bat[:oid,:dbl],arrayn:bat[:oid,:oid],objectn:bat[:oid,:oid],namen:bat[:oid,:str],kindv:bat[:oid,:bte],stringv:bat[:oid,:str],integerv:bat[:oid,:lng],doublev:bat[:oid,:dbl],arrayv:bat[:oid,:oid],objectv:bat[:oid,:oid],namev:bat[:oid,:str])
 
(kind:bat[:oid,:bte],string:bat[:oid,:str],integer:bat[:oid,:lng],double:bat[:oid,:dbl],array:bat[:oid,:oid],object:bat[:oid,:oid],name:bat[:oid,:str]);",
 "nil"                           ]
-[ "count",               "function",     "jaqlfunc",     
"(v:bat[:oid,:any]):bat[:oid,:lng];",                                           
        "nil"                           ]
-[ "range",               "function",     "jaqlfunc",     
"(size:bat[:oid,:lng]):bat[:oid,:lng];",                                        
        "nil"                           ]
-[ "range",               "function",     "jaqlfunc",     
"(start:bat[:oid,:lng],vend:bat[:oid,:lng]):bat[:oid,:lng];",                   
        "nil"                           ]
-[ "range",               "function",     "jaqlfunc",     
"(start:bat[:oid,:lng],vend:bat[:oid,:lng],skip:bat[:oid,:lng]):bat[:oid,:lng];",
       "nil"                           ]
-[ "sum",                 "function",     "jaqlfunc",     
"(v:bat[:oid,:dbl]):bat[:oid,:dbl];",                                           
        "nil"                           ]
-[ "sum",                 "function",     "jaqlfunc",     
"(v:bat[:oid,:lng]):bat[:oid,:lng];",                                           
        "nil"                           ]
-[ "cast",                "pattern",      "jaql",         
"(b:bat[:oid,:any],t:any_1):bat[:oid,:any_1] ",                                 
        "JAQLcast;"                     ]
-[ "epilogue",            "command",      "jaql",         "():void ",           
                                                                  
"JAQLepilogue;"                 ]
-[ "execute",             "pattern",      "jaql",         "(jaql:str):void ",   
                                                                  
"JAQLexecute;"                  ]
-[ "getVar",              "pattern",      "jaql",         "(nme:str) 
(kind:bat[:oid,:bte],string:bat[:oid,:str],integer:bat[:oid,:lng],double:bat[:oid,:dbl],array:bat[:oid,:oid],object:bat[:oid,:oid],name:bat[:oid,:str])
 ", "JAQLgetVar;"                     ]
-[ "prelude",             "command",      "jaql",         "():void ",           
                                                                  
"JAQLprelude;"                  ]
-[ "select",              "function",     "jaql",         
"(b:bat[:oid,:any_1],v:any_1):bat[:oid,:any_1];",                               
        "nil"                           ]
-[ "setVar",              "pattern",      "jaql",         
"(nme:str,kind:bat[:oid,:bte],string:bat[:oid,:str],integer:bat[:oid,:lng],double:bat[:oid,:dbl],array:bat[:oid,:oid],object:bat[:oid,:oid],name:bat[:oid,:str]):void
 ", "JAQLsetVar;"                          ]
-[ "uselect",             "function",     "jaql",         
"(b:bat[:oid,:any_1],v:any_1):bat[:oid,:void];",                                
        "nil"                           ]
-[ "x",                   "pattern",      "jaql",         "(jaql:str):void ",   
                                                                  
"JAQLexecute;"                  ]
-[ "drop",                "command",      "json",         "(nme:str):void ",    
                                                                  "JSONdrop;"   
                  ]
-[ "extract",             "command",      "json",         
"(k:bat[:oid,:bte],s:bat[:oid,:str],i:bat[:oid,:lng],d:bat[:oid,:dbl],a:bat[:oid,:oid],o:bat[:oid,:oid],n:bat[:oid,:str],elems:bat[:oid,:oid],start:oid)
 
(kind:bat[:oid,:bte],string:bat[:oid,:str],integer:bat[:oid,:lng],double:bat[:oid,:dbl],array:bat[:oid,:oid],object:bat[:oid,:oid],name:bat[:oid,:str])
 ", "JSONextract;"              ]
-[ "exportResult",        "command",      "json",         
"(o:streams,kind:bat[:oid,:bte],string:bat[:oid,:str],integer:bat[:oid,:lng],double:bat[:oid,:dbl],array:bat[:oid,:oid],object:bat[:oid,:oid],name:bat[:oid,:str]):void
 ", "JSONexportResult;"                  ]
-[ "load",                "command",      "json",         "(nme:str) 
(kind:bat[:oid,:bte],string:bat[:oid,:str],integer:bat[:oid,:lng],double:bat[:oid,:dbl],array:bat[:oid,:oid],object:bat[:oid,:oid],name:bat[:oid,:str])
 ", "JSONload;"                       ]
-[ "nextid",              "command",      "json",         
"(kind:bat[:oid,:bte]):oid ",                                                   
        "JSONnextid;"                   ]
-[ "print",               "function",     "json",         
"(o:streams,kind:bat[:oid,:bte],string:bat[:oid,:str],integer:bat[:oid,:lng],double:bat[:oid,:dbl],array:bat[:oid,:oid],object:bat[:oid,:oid],name:bat[:oid,:str]):void;",
 "nil"                                ]
-[ "print",               "command",      "json",         
"(o:streams,kind:bat[:oid,:bte],string:bat[:oid,:str],integer:bat[:oid,:lng],double:bat[:oid,:dbl],array:bat[:oid,:oid],object:bat[:oid,:oid],name:bat[:oid,:str],pretty:bit):void
 ", "JSONprint;"                      ]
-[ "store",               "command",      "json",         
"(nme:str,kind:bat[:oid,:bte],string:bat[:oid,:str],integer:bat[:oid,:lng],double:bat[:oid,:dbl],array:bat[:oid,:oid],object:bat[:oid,:oid],name:bat[:oid,:str]):void
 ", "JSONstore;"                   ]
-[ "shred",               "command",      "json",         "(json:str) 
(kind:bat[:oid,:bte],string:bat[:oid,:str],integer:bat[:oid,:lng],double:bat[:oid,:dbl],array:bat[:oid,:oid],object:bat[:oid,:oid],name:bat[:oid,:str])
 ", "JSONshred;"                     ]
-[ "unwrap",              "pattern",      "json",         
"(kind:bat[:oid,:bte],string:bat[:oid,:str],integer:bat[:oid,:lng],double:bat[:oid,:dbl],array:bat[:oid,:oid],object:bat[:oid,:oid],name:bat[:oid,:str],arrid:oid,tpe:any_1):bat[:oid,:any_1]
 ", "JSONunwrap;"                          ]
-[ "unwraptype",                  "pattern",      "json",         
"(kind:bat[:oid,:bte],string:bat[:oid,:str],integer:bat[:oid,:lng],double:bat[:oid,:dbl],array:bat[:oid,:oid],object:bat[:oid,:oid],name:bat[:oid,:str],arrid:oid):str
 ", "JSONunwrap;"                         ]
-[ "wrap",                "command",      "json",         
"(elems:bat[:oid,:any]) 
(kind:bat[:oid,:bte],string:bat[:oid,:str],integer:bat[:oid,:lng],double:bat[:oid,:dbl],array:bat[:oid,:oid],object:bat[:oid,:oid],name:bat[:oid,:str])
 ", "JSONwrap;"                          ]
-[ "Area",                "command",      "geom",         "(g:wkb):dbl ",       
                                                                  "wkbArea;"    
                  ]
-[ "AsText",              "command",      "geom",         "(w:wkb):str ",       
                                                                  "wkbAsText;"  
                  ]
-[ "Buffer",              "command",      "geom",         
"(a:wkb,distance:dbl):wkb ",                                                    
        "wkbBuffer;"                    ]
-[ "Boundary",            "command",      "geom",         "(w:wkb):wkb ",       
                                                                  
"wkbBoundary;"                  ]
-[ "ConvexHull",                  "command",      "geom",         "(a:wkb):wkb 
",                                                                         
"wkbConvexHull;"                ]
-[ "Contains",            "command",      "geom",         "(a:wkb,b:wkb):bit ", 
                                                                  
"wkbContains;"                  ]
-[ "Crosses",             "command",      "geom",         "(a:wkb,b:wkb):bit ", 
                                                                  "wkbCrosses;" 
                  ]
-[ "CurveFromText",       "function",     "geom",         
"(wkt:str,srid:sht):wkb;",                                                      
        "nil"                           ]
-[ "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;"                  ]
-[ "Dimension",           "command",      "geom",         "(w:wkb):int ",       
                                                                  
"wkbDimension;"                 ]
-[ "Equals",              "command",      "geom",         "(a:wkb,b:wkb):bit ", 
                                                                  "wkbEquals;"  
                  ]
-[ "Envelope",            "command",      "geom",         "(w:wkb):wkb ",       
                                                                  
"wkbEnvelope;"                  ]
-[ "GeometryTypeId",      "command",      "geom",         "(w:wkb):int ",       
                                                                  
"wkbGeometryTypeId;"            ]
-[ "GeomCollectionFromText", "function",          "geom",         
"(wkt:str,srid:sht):wkb;",                                                      
        "nil"                           ]
-[ "GeomFromText",        "function",     "geom",         
"(wkt:str,srid:sht):wkb;",                                                      
        "nil"                           ]
-[ "Intersection",        "command",      "geom",         "(a:wkb,b:wkb):wkb ", 
                                                                  
"wkbIntersection;"              ]
-[ "Intersect",           "command",      "geom",         "(a:wkb,b:wkb):bit ", 
                                                                  
"wkbIntersect;"                 ]
-[ "IsSimple",            "command",      "geom",         "(w:wkb):bit ",       
                                                                  
"wkbIsSimple;"                  ]
-[ "IsEmpty",             "command",      "geom",         "(w:wkb):bit ",       
                                                                  "wkbIsEmpty;" 
                  ]
-[ "Length",              "command",      "geom",         "(g:wkb):dbl ",       
                                                                  "wkbLength;"  
                  ]
-[ "LineFromText",        "function",     "geom",         
"(wkt:str,srid:sht):wkb;",                                                      
        "nil"                           ]
-[ "MultiPolyFromText",   "function",     "geom",         
"(wkt:str,srid:sht):wkb;",                                                      
        "nil"                           ]
-[ "MultiSurfaceFromText", "function",    "geom",         
"(wkt:str,srid:sht):wkb;",                                                      
        "nil"                           ]
-[ "MultiLineFromText",   "function",     "geom",         
"(wkt:str,srid:sht):wkb;",                                                      
        "nil"                           ]
-[ "MultiCurveFromText",          "function",     "geom",         
"(wkt:str,srid:sht):wkb;",                                                      
        "nil"                           ]
-[ "MultiPointFromText",          "function",     "geom",         
"(wkt:str,srid:sht):wkb;",                                                      
        "nil"                           ]
-[ "Overlaps",            "command",      "geom",         "(a:wkb,b:wkb):bit ", 
                                                                  
"wkbOverlaps;"                  ]
-[ "PolyFromText",        "function",     "geom",         
"(wkt:str,srid:sht):wkb;",                                                      
        "nil"                           ]
-[ "PointFromText",       "function",     "geom",         
"(wkt:str,srid:sht):wkb;",                                                      
        "nil"                           ]
-[ "Relate",              "command",      "geom",         
"(a:wkb,b:wkb,intersectionPatternMatrix:str):bit ",                             
        "wkbRelate;"                    ]
-[ "SymDifference",       "command",      "geom",         "(a:wkb,b:wkb):wkb ", 
                                                                  
"wkbSymDifference;"             ]
-[ "SRID",                "command",      "geom",         "(w:wkb):int ",       
                                                                  "wkbSRID;"    
                  ]
-[ "SurfaceFromText",     "function",     "geom",         
"(wkt:str,srid:sht):wkb;",                                                      
        "nil"                           ]
-[ "Touches",             "command",      "geom",         "(a:wkb,b:wkb):bit ", 
                                                                  "wkbTouches;" 
                  ]
-[ "Union",               "command",      "geom",         "(a:wkb,b:wkb):wkb ", 
                                                                  "wkbUnion;"   
                  ]
-[ "Within",              "command",      "geom",         "(a:wkb,b:wkb):bit ", 
                                                                  "wkbWithin;"  
                  ]
-[ "X",                   "command",      "geom",         "(g:wkb):dbl ",       
                                                                  
"wkbgetcoordX;"                 ]
-[ "Y",                   "command",      "geom",         "(g:wkb):dbl ",       
                                                                  
"wkbgetcoordY;"                 ]
-[ "epilogue",            "command",      "geom",         "():void ",           
                                                                  
"geom_epilogue;"                ]
-[ "mbr",                 "command",      "geom",         "(X_1:wkb):mbr ",     
                                                                  "wkbMBR;"     
                  ]
-[ "mbr",                 "command",      "geom",         
"(X_1:flt,X_2:flt,X_3:flt,X_4:flt):mbr ",                                       
        "ordinatesMBR;"                 ]
-[ "mbroverlaps",         "command",      "geom",         "(a:mbr,b:mbr):bit ", 
                                                                  
"mbroverlaps;"                  ]
-[ "prelude",             "command",      "geom",         "():void ",           
                                                                  
"geom_prelude;"                 ]
-[ "point",               "command",      "geom",         "(x:dbl,y:dbl):wkb ", 
                                                                  
"wkbcreatepoint;"               ]
-[ "point",               "command",      "batgeom",      
"(x:bat[:oid,:dbl],y:bat[:oid,:dbl]):bat[:oid,:wkb] ",                          
        "wkbcreatepoint_bat;"           ]
-[ "#cmp",                "command",      "mbr",          "():int ",            
                                                                  "mbrCOMP;"    
                  ]
-[ "#fromstr",            "command",      "mbr",          "():mbr ",            
                                                                  "mbrFROMSTR;" 
                  ]
-[ "#hash",               "command",      "mbr",          "():int ",            
                                                                  "mbrHASH;"    
                  ]
-[ "mbr",                 "command",      "mbr",          "(v:str):mbr ",       
                                                                  
"mbrFromString;"                ]
-[ "#null",               "command",      "mbr",          "():int ",            
                                                                  "mbrNULL;"    
                  ]
-[ "#read",               "command",      "mbr",          "():void ",           
                                                                  "mbrREAD;"    
                  ]
-[ "#tostr",              "command",      "mbr",          "():str ",            
                                                                  "mbrTOSTR;"   
                  ]
-[ "#write",              "command",      "mbr",          "():void ",           
                                                                  "mbrWRITE;"   
                  ]
-[ "FromText",            "command",      "wkb",          "(w:str,type:int):wkb 
",                                                                
"wkbFromText;"                  ]
-[ "#cmp",                "command",      "wkb",          "():int ",            
                                                                  "wkbCOMP;"    
                  ]
-[ "#del",                "command",      "wkb",          "():int ",            
                                                                  "wkbDEL;"     
                  ]
-[ "#fromstr",            "command",      "wkb",          "():wkb ",            
                                                                  "wkbFROMSTR;" 
                  ]
-[ "#heap",               "command",      "wkb",          "():int ",            
                                                                  "wkbHEAP;"    
                  ]
-[ "#hash",               "command",      "wkb",          "():int ",            
                                                                  "wkbHASH;"    
                  ]
-[ "#length",             "command",      "wkb",          "():int ",            
                                                                  "wkbLENGTH;"  
                  ]
-[ "#null",               "command",      "wkb",          "():int ",            
                                                                  "wkbNULL;"    
                  ]
-[ "#put",                "command",      "wkb",          "():int ",            
                                                                  "wkbPUT;"     
                  ]
-[ "#read",               "command",      "wkb",          "():void ",           
                                                                  "wkbREAD;"    
                  ]
-[ "#tostr",              "command",      "wkb",          "():str ",            
                                                                  "wkbTOSTR;"   
                  ]
-[ "wkb",                 "command",      "wkb",          "(v:str):wkb ",       
                                                                  
"wkbFromString;"                ]
-[ "#write",              "command",      "wkb",          "():void ",           
                                                                  "wkbWRITE;"   
                  ]
-[ "connect",             "command",      "srvpool",      "(dbname:str):str ",  
                                                                  
"SRVPOOLconnect;"               ]
-[ "exec",                "pattern",      "srvpool",      
"(fname:str,arg:any...):any... ",                                               
        "SRVPOOLexec;"                  ]
-[ "local",               "command",      "srvpool",      "(b:bit):void ",      
                                                                  
"SRVPOOLlocal;"                 ]
-[ "query",               "pattern",      "srvpool",      "(plan:str):str... ", 
                                                                  
"SRVPOOLquery;"                 ]
-[ "reset",               "pattern",      "srvpool",      "(dbname:str):str ",  
                                                                  
"SRVPOOLreset;"                 ]
-[ "bidding",             "pattern",      "scheduler",    "():bit ",            
                                                                  
"OCTOPUSbidding;"               ]
-[ "costPrediction",      "pattern",      "scheduler",    "(a:any):lng ",       
                                                                  
"RUNcostPrediction;"            ]
-[ "choice",              "pattern",      "scheduler",    "(arg:any...):void ", 
                                                                  "RUNchoice;"  
                  ]
-[ "choice",              "pattern",      "scheduler",    "():void ",           
                                                                  "RUNchoice;"  
                  ]
-[ "isolation",           "pattern",      "scheduler",    "():void ",           
                                                                  
"RUNisolation;"                 ]
-[ "makeSchedule",        "pattern",      "scheduler",    
"(X_1:int,X_2:lng...):str... ",                                                 
        "OCTOPUSmakeSchedule;"          ]
-[ "octopus",             "pattern",      "scheduler",    "(t:int):bit ",       
                                                                  "OCTOPUSrun;" 
                  ]
-[ "peers",               "pattern",      "scheduler",    "(N:int):void ",      
                                                                  
"SRVsetServers;"                ]
-[ "pattern",             "pattern",      "scheduler",    "(pat:str):void ",    
                                                                  
"SRVsetServers;"                ]
-[ "pick",                "pattern",      "scheduler",    "(arg:any_1...):any_1 
",                                                                
"RUNpickResult;"                ]
-[ "register",            "pattern",      "scheduler",    "():bit ",            
                                                                  
"OCTOPUSdiscoverRegister;"      ]
-[ "srvpool",             "pattern",      "scheduler",    "():int ",            
                                                                  
"SRVPOOLscheduler;"             ]
-[ "volumeCost",                  "pattern",      "scheduler",    "(a:any):lng 
",                                                                         
"RUNvolumeCost;"                ]
-[ "alpha",               "command",      "transaction",  
"(b:bat[:any_1,:any_2]):bat[:any_1,:any_2] ",                                   
        "TRNtrans_alpha;"               ]
-[ "abort",               "pattern",      "transaction",  "(c:any...):void ",   
                                                                  
"TRNtrans_abort;"               ]
-[ "abort",               "command",      "transaction",  "():bit ",            
                                                                  
"TRNglobal_abort;"              ]
-[ "clean",               "pattern",      "transaction",  "(c:any...):void ",   
                                                                  
"TRNtrans_clean;"               ]
-[ "commit",              "pattern",      "transaction",  "(c:any...):void ",   
                                                                  
"TRNtrans_commit;"              ]
-[ "commit",              "command",      "transaction",  "():bit ",            
                                                                  
"TRNglobal_commit;"             ]
-[ "delta",               "command",      "transaction",  
"(b:bat[:any_1,:any_2]):bat[:any_1,:any_2] ",                                   
        "TRNtrans_delta;"               ]
-[ "prev",                "command",      "transaction",  
"(b:bat[:any_1,:any_2]):bat[:any_1,:any_2] ",                                   
        "TRNtrans_prev;"                ]
-[ "subcommit",           "command",      "transaction",  
"(b:bat[:any_1,:str]):bit ",                                                    
        "TRNsubcommit;"                 ]
-[ "sync",                "command",      "transaction",  "():bit ",            
                                                                  
"TRNglobal_sync;"               ]
-[ "decode_y",            "command",      "zorder",       
"(z:bat[:oid,:oid]):bat[:oid,:int] ",                                           
        "ZORDbatdecode_int_oid_y;"      ]
-[ "decode_y",            "command",      "zorder",       "(z:oid):int ",       
                                                                  
"ZORDdecode_int_oid_y;"         ]
-[ "decode_x",            "command",      "zorder",       
"(z:bat[:oid,:oid]):bat[:oid,:int] ",                                           
        "ZORDbatdecode_int_oid_x;"      ]
-[ "decode_x",            "command",      "zorder",       "(z:oid):int ",       
                                                                  
"ZORDdecode_int_oid_x;"         ]
-[ "decode",              "command",      "zorder",       "(z:bat[:oid,:oid]) 
(X_2:bat[:oid,:int],X_3:bat[:oid,:int]) ",                          
"ZORDbatdecode_int_oid;"        ]
-[ "decode",              "command",      "zorder",       "(z:oid) 
(x:int,y:int) ",                                                               
"ZORDdecode_int_oid;"           ]
-[ "encode",              "command",      "zorder",       
"(x:bat[:oid,:int],y:bat[:oid,:int]):bat[:oid,:oid] ",                          
        "ZORDbatencode_int_oid;"        ]
-[ "encode",              "command",      "zorder",       "(x:int,y:int):oid ", 
                                                                  
"ZORDencode_int_oid;"           ]
-[ "slice",               "command",      "zorder",       
"(xb:int,yb:int,xt:int,yt:int):bat[:oid,:oid] ",                                
        "ZORDslice_int;"                ]
-[ "sql_slice",           "command",      "zorder",       
"(xb:int,yb:int,xt:int,yt:int):bat[:str,:BAT] ",                                
        "ZORDsql_slice_int;"            ]
-[ "append",              "command",      "tokenizer",    "(u:str):oid ",       
                                                                  
"TKNZRappend;"                  ]
-[ "close",               "command",      "tokenizer",    "():void ",           
                                                                  "TKNZRclose;" 
                  ]
-[ "depositFile",         "command",      "tokenizer",    "(fnme:str):void ",   
                                                                  
"TKNZRdepositFile;"             ]
-[ "getCardinality",      "command",      "tokenizer",    "():bat[:void,:wrd] 
",                                                                  
"TKNZRgetCardinality;"          ]
-[ "getCount",            "command",      "tokenizer",    "():bat[:void,:wrd] 
",                                                                  
"TKNZRgetCount;"                ]
-[ "getIndex",            "command",      "tokenizer",    "():bat[:void,:oid] 
",                                                                  
"TKNZRgetIndex;"                ]
-[ "getLevel",            "command",      "tokenizer",    
"(i:int):bat[:oid,:str] ",                                                      
        "TKNZRgetLevel;"                ]
-[ "locate",              "pattern",      "tokenizer",    "(s:str):oid ",       
                                                                  
"TKNZRlocate;"                  ]
-[ "open",                "command",      "tokenizer",    "(name:str):void ",   
                                                                  "TKNZRopen;"  
                  ]
-[ "take",                "pattern",      "tokenizer",    "(i:oid):str ",       
                                                                  
"TKNZRtakeOid;"                 ]
-[ "editdistance2",       "command",      "txtsim",       "(s:str,t:str):int ", 
                                                                  
"levenshteinbasic2_impl;"       ]
-[ "editdistance",        "command",      "txtsim",       "(s:str,t:str):int ", 
                                                                  
"levenshteinbasic_impl;"        ]
-[ "levenshtein",         "command",      "txtsim",       "(s:str,t:str):int ", 
                                                                  
"levenshteinbasic_impl;"        ]
-[ "levenshtein",         "command",      "txtsim",       
"(s:str,t:str,insdel_cost:int,replace_cost:int,transpose_cost:int):int ",       
        "levenshtein_impl;"             ]
-[ "qgramselfjoin",       "command",      "txtsim",       
"(qgram:bat[:oid,:oid],id:bat[:oid,:oid],pos:bat[:oid,:int],len:bat[:oid,:int],c:flt,k:int):bat[:int,:int]
 ", "CMDqgramselfjoin;"               ]
-[ "qgramnormalize",      "command",      "txtsim",       "(input:str):str ",   
                                                                  
"CMDqgramnormalize;"            ]
-[ "str2qgrams",                  "function",     "txtsim",       
"(s:str):bat[:oid,:str];",                                                      
        "nil"                           ]
-[ "stringdiff",                  "command",      "txtsim",       
"(s1:str,s2:str):int ",                                                         
        "stringdiff_impl;"              ]
-[ "soundex",             "command",      "txtsim",       "(name:str):str ",    
                                                                  
"soundex_impl;"                 ]
-[ "similarity",                  "command",      "txtsim",       
"(string1:str,string2:str):dbl ",                                               
        "fstrcmp0_impl;"                ]
-[ "similarity",                  "command",      "txtsim",       
"(string1:str,string2:str,minimum:dbl):dbl ",                                   
        "fstrcmp_impl;"                 ]
-[ "column",              "pattern",      "cluster",      
"(m:bat[:oid,:oid],b:bat[:oid,:any_1]):bat[:oid,:any_1] ",                      
        "CLUSTER_column;"               ]
-[ "key",                 "command",      "cluster",      
"(b:bat[:oid,:any_1]):bat[:oid,:oid] ",                                         
        "CLUSTER_key;"                  ]
-[ "map",                 "command",      "cluster",      
"(psum:bat[:oid,:wrd],cluster:bat[:oid,:bte],b:bat[:oid,:any_1]):bat[:oid,:any_1]
 ",    "CLS_map2;"                     ]
-[ "map",                 "command",      "cluster",      
"(cluster:bat[:oid,:wrd],b:bat[:oid,:any_1]):bat[:oid,:any_1] ",                
        "CLS_map;"                      ]
-[ "map",                 "command",      "cluster",      
"(b:bat[:oid,:oid]):bat[:oid,:oid] ",                                           
        "CLUSTER_map;"                  ]
-[ "new",                 "command",      "cluster",      
"(b:bat[:oid,:dbl],bits:int,offset:int,order:bit) 
(psum:bat[:oid,:wrd],map:bat[:oid,:bte]) ", "CLS_create2_dbl;"                ]
-[ "new",                 "command",      "cluster",      
"(b:bat[:oid,:dbl],bits:int,offset:int) 
(psum:bat[:oid,:wrd],map:bat[:oid,:wrd]) ",     "CLS_create_dbl;"               
]
-[ "new",                 "command",      "cluster",      
"(b:bat[:oid,:flt],bits:int,offset:int,order:bit) 
(psum:bat[:oid,:wrd],map:bat[:oid,:bte]) ", "CLS_create2_flt;"                ]
-[ "new",                 "command",      "cluster",      
"(b:bat[:oid,:flt],bits:int,offset:int) 
(psum:bat[:oid,:wrd],map:bat[:oid,:wrd]) ",     "CLS_create_flt;"               
]
-[ "new",                 "command",      "cluster",      
"(b:bat[:oid,:lng],bits:int,offset:int,order:bit) 
(psum:bat[:oid,:wrd],map:bat[:oid,:bte]) ", "CLS_create2_lng;"                ]
-[ "new",                 "command",      "cluster",      
"(b:bat[:oid,:lng],bits:int,offset:int) 
(psum:bat[:oid,:wrd],map:bat[:oid,:wrd]) ",     "CLS_create_lng;"               
]
-[ "new",                 "command",      "cluster",      
"(b:bat[:oid,:wrd],bits:int,offset:int,order:bit) 
(psum:bat[:oid,:wrd],map:bat[:oid,:bte]) ", "CLS_create2_wrd;"                ]
-[ "new",                 "command",      "cluster",      
"(b:bat[:oid,:wrd],bits:int,offset:int) 
(psum:bat[:oid,:wrd],map:bat[:oid,:wrd]) ",     "CLS_create_wrd;"               
]
-[ "new",                 "command",      "cluster",      
"(b:bat[:oid,:int],bits:int,offset:int,order:bit) 
(psum:bat[:oid,:wrd],map:bat[:oid,:bte]) ", "CLS_create2_int;"                ]
-[ "new",                 "command",      "cluster",      
"(b:bat[:oid,:int],bits:int,offset:int) 
(psum:bat[:oid,:wrd],map:bat[:oid,:wrd]) ",     "CLS_create_int;"               
]
-[ "new",                 "command",      "cluster",      
"(b:bat[:oid,:sht],bits:int,offset:int,order:bit) 
(psum:bat[:oid,:wrd],map:bat[:oid,:bte]) ", "CLS_create2_sht;"                ]
-[ "new",                 "command",      "cluster",      
"(b:bat[:oid,:sht],bits:int,offset:int) 
(psum:bat[:oid,:wrd],map:bat[:oid,:wrd]) ",     "CLS_create_sht;"               
]
-[ "new",                 "command",      "cluster",      
"(b:bat[:oid,:bte],bits:int,offset:int,order:bit) 
(psum:bat[:oid,:wrd],map:bat[:oid,:bte]) ", "CLS_create2_bte;"                ]
-[ "new",                 "command",      "cluster",      
"(b:bat[:oid,:bte],bits:int,offset:int) 
(psum:bat[:oid,:wrd],map:bat[:oid,:wrd]) ",     "CLS_create_bte;"               
]
-[ "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;"                   ]
-[ "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;"       ]
-[ "append",              "pattern",      "sql",          
"(mvc:int,sname:str,tname:str,cname:str,ins:any):int ",                         
        "mvc_append_wrap;"              ]
-[ "assert",              "pattern",      "sql",          "(b:lng,msg:str):void 
",                                                                
"SQLassertLng;"                 ]
-[ "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;"  
                  ]
-[ "bbp",                 "function",     "sql",          "() 
(id:bat[:oid,:int],name:bat[:oid,:str],htype:bat[:oid,:str],ttype:bat[:oid,:str],count:bat[:oid,:lng],refcnt:bat[:oid,:int],lrefcnt:bat[:oid,:int],location:bat[:oid,:str],heat:bat[:oid,:int],dirty:bat[:oid,:str],status:bat[:oid,:str],kind:bat[:oid,:str]);",
 "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:int,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:int,schema:str,table:str,column:str,access:int,low:oid,hgh:oid):bat[:oid,:any_1]
 ", "mvc_bind_wrap;"              ]
-[ "bind",                "pattern",      "sql",          
"(mvc:int,schema:str,table:str,column:str,access:int):bat[:oid,:any_1] ",       
        "mvc_bind_wrap;"                ]
-[ "bind_idxbat",         "pattern",      "sql",          
"(mvc:int,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:int,schema:str,table:str,index:str,access:int,low:oid,hgh:oid):bat[:oid,:any_1]
 ", "mvc_bind_idxbat_wrap;"        ]
-[ "bind_idxbat",         "pattern",      "sql",          
"(mvc:int,schema:str,table:str,index:str,access:int):bat[:oid,:any_1] ",        
        "mvc_bind_idxbat_wrap;"         ]
-[ "bind_dbat",           "pattern",      "sql",          
"(mvc:int,schema:str,table:str,access:int):bat[:oid,:oid] ",                    
        "mvc_bind_dbat_wrap;"           ]
-[ "cluster2",            "pattern",      "sql",          
"(sch:str,tbl:str):void ",                                                      
        "SQLcluster2;"                  ]
-[ "cluster1",            "pattern",      "sql",          
"(sch:str,tbl:str):void ",                                                      
        "SQLcluster1;"                  ]
-[ "clients",             "function",     "sql",          "() 
(user:bat[:oid,:str],login:bat[:oid,:str],lastcommand:bat[:oid,:str],actions:bat[:oid,:int],seconds:bat[:oid,:lng]);",
 "nil"                                ]
-[ "copyfrom",            "pattern",      "sql",          
"(sname:str,tname:str,sep:str,rsep:str,ssep:str,ns:str,nr:lng,offset:lng,locked:int):bat[:oid,:any]...
 ", "mvc_import_table_stdin;"     ]
-[ "copy_from",           "pattern",      "sql",          
"(sname:str,tname:str,sep:str,rsep:str,ssep:str,ns:str,fname:str,nr:lng,offset:lng,locked:int):bat[:oid,:any]...
 ", "mvc_import_table_wrap;"    ]
-[ "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,sname:str,tname:str,grantee:str,privs:int,cname:str,grant:int,grantor:int):void
 ", "SQLcatalog;"                     ]
-[ "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;"                   ]
-[ "catalog",             "pattern",      "sql",          
"(type:int,sname:str,t:ptr):void ",                                             
        "SQLcatalog;"                   ]
-[ "catalog",             "pattern",      "sql",          
"(type:int,sname:str,name:str,tname:str,time:int,o:int,event:int,oname:str,nname:str,condition:str,query:str):void
 ", "SQLcatalog;"                     ]
-[ "catalog",             "pattern",      "sql",          
"(type:int,sname:str,name:str,funcid:int,ft:int,action: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;"               ]
-[ "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;"           ]
-[ "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",          "() 
(event:bat[:oid,:int],clk:bat[:oid,:str],pc:bat[:oid,:str],thread:bat[:oid,:int],user:bat[:oid,:int],ticks:bat[:oid,:lng],reads:bat[:oid,:lng],writes:bat[:oid,:lng],rbytes:bat[:oid,:lng],wbytes:bat[:oid,:lng],type:bat[:oid,:str],stmt:bat[:oid,:str])
 ", "dump_trace;"                          ]
_______________________________________________
Checkin-list mailing list
Checkin-list@monetdb.org
http://mail.monetdb.org/mailman/listinfo/checkin-list

Reply via email to