Changeset: bf494bbdee2d for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=bf494bbdee2d
Modified Files:
        NT/monetdb_config.h.in
        clients/R/MonetDB.R/DESCRIPTION
        clients/R/MonetDB.R/NEWS
        clients/R/MonetDB.R/R/control.R
        clients/R/MonetDB.R/R/monetdb.R
        clients/R/MonetDB.R/src/mapi.c
        clients/Tests/SQL-dump.stable.out.32bit
        clients/mapiclient/mclient.c
        configure.ag
        gdk/gdk_logger.c
        gdk/gdk_logger.h
        gdk/gdk_sample.c
        gdk/gdk_storage.c
        gdk/gdk_unique.c
        monetdb5/modules/atoms/json.c
        monetdb5/modules/atoms/json.mal
        monetdb5/optimizer/opt_centipede.c
        monetdb5/optimizer/opt_pushselect.c
        sql/backends/monet5/sql_scenario.c
        sql/benchmarks/tpch/Tests/01-explain.stable.out.32bit
        sql/benchmarks/tpch/Tests/17-plan.stable.out
        sql/benchmarks/tpch/Tests/21-explain.stable.out.32bit
        sql/benchmarks/tpch/Tests/22-plan.stable.out
        sql/common/sql_types.c
        sql/scripts/40_json.sql
        sql/storage/bat/bat_logger.c
        sql/storage/store.c
        
sql/test/BugTracker-2009/Tests/error_while_drop_func_returns_table_type.SF-2604573.sql
        
sql/test/BugTracker-2010/Tests/group-by_ordered_column.Bug-2564.stable.out.32bit
        
sql/test/BugTracker-2010/Tests/limit_in_prepare.Bug-2552.stable.out.32bit
        sql/test/BugTracker/Tests/between_with_column.SF-1959410.stable.err
        sql/test/Tests/zones.stable.out
        sql/test/centipede/Tests/olap.stable.out
        sql/test/json/Tests/aggregate01.sql
        sql/test/json/Tests/aggregate01.stable.out
Branch: transaction-replication
Log Message:

Merge with default branch


diffs (truncated from 2578 to 300 lines):

diff --git a/NT/monetdb_config.h.in b/NT/monetdb_config.h.in
--- a/NT/monetdb_config.h.in
+++ b/NT/monetdb_config.h.in
@@ -171,7 +171,7 @@
 
 /* Define to 1 if you have the `ftruncate' function. */
 #define HAVE_FTRUNCATE 1
-#define ftruncate(fd, sz)      (_chsize_s((fd), (__int64) (sz)) == 0 ? 0 : -1)
+#define ftruncate(fd, sz)      (-(_chsize_s((fd), (__int64) (sz)) != 0))
 
 /* Does your compiler support function attributes (__attribute__)? */
 /* #undef HAVE_FUNCTION_ATTRIBUTES */
diff --git a/clients/R/MonetDB.R/DESCRIPTION b/clients/R/MonetDB.R/DESCRIPTION
--- a/clients/R/MonetDB.R/DESCRIPTION
+++ b/clients/R/MonetDB.R/DESCRIPTION
@@ -1,6 +1,6 @@
 Package: MonetDB.R
-Version: 0.9.2
-Date: 2013-04-22
+Version: 0.9.3
+Date: 2013-06-12
 Title: Connect MonetDB to R
 Authors@R: c(person("Hannes Muehleisen", role = c("aut", "cre"),email = 
"han...@cwi.nl"),
        person("Thomas Lumley", role = "ctb"),
diff --git a/clients/R/MonetDB.R/NEWS b/clients/R/MonetDB.R/NEWS
--- a/clients/R/MonetDB.R/NEWS
+++ b/clients/R/MonetDB.R/NEWS
@@ -1,3 +1,7 @@
+0.9.3
+- Remove trailing slashes for monetdb.program.path parameter for 
monetdb.server.setup (Thanks, Anthony!)
+- fixed monetdbd.liststatus (Thanks, Bart)
+
 0.9.2
 - monetdb_queryinfo method to find out things about an arbitrary query cheaply
 - new options monetdb.sequential, monetdb.debug.query and monetdb.debug.mapi
diff --git a/clients/R/MonetDB.R/R/control.R b/clients/R/MonetDB.R/R/control.R
--- a/clients/R/MonetDB.R/R/control.R
+++ b/clients/R/MonetDB.R/R/control.R
@@ -114,6 +114,8 @@ monetdb.server.setup <-
 
     # switch all slashes to match windows
     monetdb.program.path <- normalizePath( monetdb.program.path , mustWork = 
FALSE )
+    # remove trailing slash from paths, otherwise the server won't start
+    monetdb.program.path <- gsub("\\\\$|/$", "", monetdb.program.path)
     database.directory <- normalizePath( database.directory , mustWork = FALSE 
)
         
     # if the database directory does not exist, print that it's being created
@@ -234,7 +236,8 @@ monetdbd.liststatus <- monetdb.liststatu
   lines <- lines[grepl("^=sabdb:2:", lines)] # make sure we get a db list 
here, protocol v.2
   lines <- sub("=sabdb:2:", "", lines, fixed=T)
   # convert value into propert types etc
-  dbdf <- as.data.frame(do.call("rbind", strsplit(lines, ", ", fixed=T)), 
stringsAsFactors=F)
+  dbdf <- as.data.frame(do.call("rbind", strsplit(lines, ",", fixed=T)), 
stringsAsFactors=F)
+
   names(dbdf) <- c("dbname", "uri", "locked", "state", "scenarios", 
"startCounter", "stopCounter", 
                    "crashCounter", "avgUptime", "maxUptime", "minUptime", 
"lastCrash", "lastStart", "lastStop", 
                    "crashAvg1", "crashAvg10", "crashAvg30")
@@ -266,4 +269,4 @@ monetdbd.liststatus <- monetdb.liststatu
   dbdf$scenarios <- gsub("'", ", ", dbdf$scenarios, fixed=T)
   
   return(dbdf[order(dbdf$dbname), ])
-}
\ No newline at end of file
+}
diff --git a/clients/R/MonetDB.R/R/monetdb.R b/clients/R/MonetDB.R/R/monetdb.R
--- a/clients/R/MonetDB.R/R/monetdb.R
+++ b/clients/R/MonetDB.R/R/monetdb.R
@@ -21,7 +21,7 @@ MonetR <- MonetDB <- MonetDBR <- MonetDB
 
 setMethod("dbGetInfo", "MonetDBDriver", def=function(dbObj, ...)
   list(name="MonetDBDriver", 
-       driver.version="0.9.2", 
+       driver.version="0.9.3", 
        DBI.version="0.2-7", 
        client.version=NA, 
        max.connections=NA)
diff --git a/clients/R/MonetDB.R/src/mapi.c b/clients/R/MonetDB.R/src/mapi.c
--- a/clients/R/MonetDB.R/src/mapi.c
+++ b/clients/R/MonetDB.R/src/mapi.c
@@ -257,8 +257,8 @@ SEXP mapiRead(SEXP conn) {
                while (response_buf_offset + block_length > response_buf_len) {
                        response_buf_len += ALLOCSIZE;
                        if (DEBUG) {
-                               printf("II: Reallocating memory, new size 
"SZFMT"\n",
-                                               response_buf_len);
+                               printf("II: Reallocating memory, new size 
%lu\n",
+                                               (unsigned long) 
response_buf_len);
                        }
                        response_buf = realloc(response_buf, response_buf_len);
                        if (response_buf == NULL) {
diff --git a/clients/Tests/SQL-dump.stable.out.32bit 
b/clients/Tests/SQL-dump.stable.out.32bit
--- a/clients/Tests/SQL-dump.stable.out.32bit
+++ b/clients/Tests/SQL-dump.stable.out.32bit
@@ -1680,60 +1680,60 @@ 5713    "progress"      "int"   32      0       5717    
NULL    tru
 5714   "status"        "clob"  0       0       5717    NULL    true    5       
NULL
 5715   "tag"   "oid"   31      0       5717    NULL    true    6       NULL
 5716   "query" "clob"  0       0       5717    NULL    true    7       NULL
-6352   "schema"        "clob"  0       0       6364    NULL    true    0       
NULL
-6353   "table" "clob"  0       0       6364    NULL    true    1       NULL
-6354   "column"        "clob"  0       0       6364    NULL    true    2       
NULL
-6355   "type"  "clob"  0       0       6364    NULL    true    3       NULL
-6356   "location"      "clob"  0       0       6364    NULL    true    4       
NULL
-6357   "count" "bigint"        64      0       6364    NULL    true    5       
NULL
-6358   "typewidth"     "int"   32      0       6364    NULL    true    6       
NULL
-6359   "columnsize"    "bigint"        64      0       6364    NULL    true    
7       NULL
-6360   "heapsize"      "bigint"        64      0       6364    NULL    true    
8       NULL
-6361   "hashes"        "bigint"        64      0       6364    NULL    true    
9       NULL
-6362   "imprints"      "bigint"        64      0       6364    NULL    true    
10      NULL
-6363   "sorted"        "boolean"       1       0       6364    NULL    true    
11      NULL
-6366   "schema"        "clob"  0       0       6376    NULL    true    0       
NULL
-6367   "table" "clob"  0       0       6376    NULL    true    1       NULL
-6368   "column"        "clob"  0       0       6376    NULL    true    2       
NULL
-6369   "type"  "clob"  0       0       6376    NULL    true    3       NULL
-6370   "typewidth"     "int"   32      0       6376    NULL    true    4       
NULL
-6371   "count" "bigint"        64      0       6376    NULL    true    5       
NULL
-6372   "distinct"      "bigint"        64      0       6376    NULL    true    
6       NULL
-6373   "atomwidth"     "int"   32      0       6376    NULL    true    7       
NULL
-6374   "reference"     "boolean"       1       0       6376    NULL    true    
8       NULL
-6375   "sorted"        "boolean"       1       0       6376    NULL    true    
9       NULL
-6414   "schema"        "clob"  0       0       6424    NULL    true    0       
NULL
-6415   "table" "clob"  0       0       6424    NULL    true    1       NULL
-6416   "column"        "clob"  0       0       6424    NULL    true    2       
NULL
-6417   "type"  "clob"  0       0       6424    NULL    true    3       NULL
-6418   "count" "bigint"        64      0       6424    NULL    true    4       
NULL
-6419   "columnsize"    "bigint"        64      0       6424    NULL    true    
5       NULL
-6420   "heapsize"      "bigint"        64      0       6424    NULL    true    
6       NULL
-6421   "hashes"        "bigint"        64      0       6424    NULL    true    
7       NULL
-6422   "imprints"      "bigint"        64      0       6424    NULL    true    
8       NULL
-6423   "sorted"        "boolean"       1       0       6424    NULL    true    
9       NULL
-6426   "schema"        "clob"  0       0       6434    NULL    true    0       
NULL
-6427   "table" "clob"  0       0       6434    NULL    true    1       NULL
-6428   "count" "bigint"        64      0       6434    NULL    true    2       
NULL
-6429   "columnsize"    "bigint"        64      0       6434    NULL    true    
3       NULL
-6430   "heapsize"      "bigint"        64      0       6434    NULL    true    
4       NULL
-6431   "hashes"        "bigint"        64      0       6434    NULL    true    
5       NULL
-6432   "imprints"      "bigint"        64      0       6434    NULL    true    
6       NULL
-6433   "auxillary"     "bigint"        53      0       6434    NULL    true    
7       NULL
-6436   "schema"        "clob"  0       0       6449    NULL    true    0       
NULL
-6437   "table" "clob"  0       0       6449    NULL    true    1       NULL
-6438   "column"        "clob"  0       0       6449    NULL    true    2       
NULL
-6439   "type"  "clob"  0       0       6449    NULL    true    3       NULL
-6440   "width" "int"   32      0       6449    NULL    true    4       NULL
-6441   "stamp" "timestamp"     7       0       6449    NULL    true    5       
NULL
-6442   "sample"        "bigint"        64      0       6449    NULL    true    
6       NULL
-6443   "count" "bigint"        64      0       6449    NULL    true    7       
NULL
-6444   "unique"        "bigint"        64      0       6449    NULL    true    
8       NULL
-6445   "nils"  "bigint"        64      0       6449    NULL    true    9       
NULL
-6446   "minval"        "clob"  0       0       6449    NULL    true    10      
NULL
-6447   "maxval"        "clob"  0       0       6449    NULL    true    11      
NULL
-6448   "sorted"        "boolean"       1       0       6449    NULL    true    
12      NULL
-6502   "function_id"   "int"   32      0       6503    NULL    true    0       
NULL
+6356   "schema"        "clob"  0       0       6368    NULL    true    0       
NULL
+6357   "table" "clob"  0       0       6368    NULL    true    1       NULL
+6358   "column"        "clob"  0       0       6368    NULL    true    2       
NULL
+6359   "type"  "clob"  0       0       6368    NULL    true    3       NULL
+6360   "location"      "clob"  0       0       6368    NULL    true    4       
NULL
+6361   "count" "bigint"        64      0       6368    NULL    true    5       
NULL
+6362   "typewidth"     "int"   32      0       6368    NULL    true    6       
NULL
+6363   "columnsize"    "bigint"        64      0       6368    NULL    true    
7       NULL
+6364   "heapsize"      "bigint"        64      0       6368    NULL    true    
8       NULL
+6365   "hashes"        "bigint"        64      0       6368    NULL    true    
9       NULL
+6366   "imprints"      "bigint"        64      0       6368    NULL    true    
10      NULL
+6367   "sorted"        "boolean"       1       0       6368    NULL    true    
11      NULL
+6370   "schema"        "clob"  0       0       6380    NULL    true    0       
NULL
+6371   "table" "clob"  0       0       6380    NULL    true    1       NULL
+6372   "column"        "clob"  0       0       6380    NULL    true    2       
NULL
+6373   "type"  "clob"  0       0       6380    NULL    true    3       NULL
+6374   "typewidth"     "int"   32      0       6380    NULL    true    4       
NULL
+6375   "count" "bigint"        64      0       6380    NULL    true    5       
NULL
+6376   "distinct"      "bigint"        64      0       6380    NULL    true    
6       NULL
+6377   "atomwidth"     "int"   32      0       6380    NULL    true    7       
NULL
+6378   "reference"     "boolean"       1       0       6380    NULL    true    
8       NULL
+6379   "sorted"        "boolean"       1       0       6380    NULL    true    
9       NULL
+6418   "schema"        "clob"  0       0       6428    NULL    true    0       
NULL
+6419   "table" "clob"  0       0       6428    NULL    true    1       NULL
+6420   "column"        "clob"  0       0       6428    NULL    true    2       
NULL
+6421   "type"  "clob"  0       0       6428    NULL    true    3       NULL
+6422   "count" "bigint"        64      0       6428    NULL    true    4       
NULL
+6423   "columnsize"    "bigint"        64      0       6428    NULL    true    
5       NULL
+6424   "heapsize"      "bigint"        64      0       6428    NULL    true    
6       NULL
+6425   "hashes"        "bigint"        64      0       6428    NULL    true    
7       NULL
+6426   "imprints"      "bigint"        64      0       6428    NULL    true    
8       NULL
+6427   "sorted"        "boolean"       1       0       6428    NULL    true    
9       NULL
+6430   "schema"        "clob"  0       0       6438    NULL    true    0       
NULL
+6431   "table" "clob"  0       0       6438    NULL    true    1       NULL
+6432   "count" "bigint"        64      0       6438    NULL    true    2       
NULL
+6433   "columnsize"    "bigint"        64      0       6438    NULL    true    
3       NULL
+6434   "heapsize"      "bigint"        64      0       6438    NULL    true    
4       NULL
+6435   "hashes"        "bigint"        64      0       6438    NULL    true    
5       NULL
+6436   "imprints"      "bigint"        64      0       6438    NULL    true    
6       NULL
+6437   "auxillary"     "bigint"        53      0       6438    NULL    true    
7       NULL
+6440   "schema"        "clob"  0       0       6453    NULL    true    0       
NULL
+6441   "table" "clob"  0       0       6453    NULL    true    1       NULL
+6442   "column"        "clob"  0       0       6453    NULL    true    2       
NULL
+6443   "type"  "clob"  0       0       6453    NULL    true    3       NULL
+6444   "width" "int"   32      0       6453    NULL    true    4       NULL
+6445   "stamp" "timestamp"     7       0       6453    NULL    true    5       
NULL
+6446   "sample"        "bigint"        64      0       6453    NULL    true    
6       NULL
+6447   "count" "bigint"        64      0       6453    NULL    true    7       
NULL
+6448   "unique"        "bigint"        64      0       6453    NULL    true    
8       NULL
+6449   "nils"  "bigint"        64      0       6453    NULL    true    9       
NULL
+6450   "minval"        "clob"  0       0       6453    NULL    true    10      
NULL
+6451   "maxval"        "clob"  0       0       6453    NULL    true    11      
NULL
+6452   "sorted"        "boolean"       1       0       6453    NULL    true    
12      NULL
+6506   "function_id"   "int"   32      0       6507    NULL    true    0       
NULL
 COMMIT;
 START TRANSACTION;
 CREATE TABLE "sys"."_tables" (
@@ -1781,12 +1781,12 @@ 5591    "sessions"      2000    "create view sys.se
 5671   "optimizers"    2000    "create view sys.optimizers as select * from 
sys.optimizers();" 1       true    0       false
 5679   "environment"   2000    "create view sys.environment as select * from 
sys.environment();"       1       true    0       false
 5717   "queue" 2000    "create view sys.queue as select * from sys.queue();"   
1       true    0       false
-6364   "storage"       2000    "create view sys.storage as select * from 
sys.storage();"       1       true    0       false
-6376   "storagemodelinput"     2000    NULL    0       true    0       false
-6424   "storagemodel"  2000    "create view sys.storagemodel as select * from 
sys.storagemodel();"     1       true    0       false
-6434   "tablestoragemodel"     2000    "-- A summary of the table storage 
requirement is is available as a table view.\n-- The auxillary column denotes 
the maximum space if all non-sorted columns\n-- would be augmented with a hash 
(rare situation)\ncreate view sys.tablestoragemodel\nas select 
""schema"",""table"",max(count) as ""count"",\n\tsum(columnsize) as 
columnsize,\n\tsum(heapsize) as heapsize,\n\tsum(hashes) as 
hashes,\n\tsum(imprints) as imprints,\n\tsum(case when sorted = false then 8 * 
count else 0 end) as auxillary\nfrom sys.storagemodel() group by 
""schema"",""table"";"   1       true    0       false
-6449   "statistics"    2000    NULL    0       true    0       false
-6503   "systemfunctions"       2000    NULL    0       true    0       false
+6368   "storage"       2000    "create view sys.storage as select * from 
sys.storage();"       1       true    0       false
+6380   "storagemodelinput"     2000    NULL    0       true    0       false
+6428   "storagemodel"  2000    "create view sys.storagemodel as select * from 
sys.storagemodel();"     1       true    0       false
+6438   "tablestoragemodel"     2000    "-- A summary of the table storage 
requirement is is available as a table view.\n-- The auxillary column denotes 
the maximum space if all non-sorted columns\n-- would be augmented with a hash 
(rare situation)\ncreate view sys.tablestoragemodel\nas select 
""schema"",""table"",max(count) as ""count"",\n\tsum(columnsize) as 
columnsize,\n\tsum(heapsize) as heapsize,\n\tsum(hashes) as 
hashes,\n\tsum(imprints) as imprints,\n\tsum(case when sorted = false then 8 * 
count else 0 end) as auxillary\nfrom sys.storagemodel() group by 
""schema"",""table"";"   1       true    0       false
+6453   "statistics"    2000    NULL    0       true    0       false
+6507   "systemfunctions"       2000    NULL    0       true    0       false
 COMMIT;
 START TRANSACTION;
 CREATE TABLE "sys"."args" (
@@ -1799,7 +1799,7 @@ CREATE TABLE "sys"."args" (
        "inout"       TINYINT,
        "number"      INTEGER
 );
-COPY 3654 RECORDS INTO "sys"."args" FROM stdin USING DELIMITERS '\t','\n','"';
+COPY 3656 RECORDS INTO "sys"."args" FROM stdin USING DELIMITERS '\t','\n','"';
 2155   28      "res_0" "oid"   31      0       0       0
 2156   28      "arg_1" "wrd"   32      0       1       1
 2157   29      "res_0" "oid"   31      0       0       0
@@ -5385,75 +5385,77 @@ 6316    6314    "js"    "json"  0       0       1       
1
 6319   6318    "result"        "clob"  0       0       0       0
 6320   6318    "x"     "clob"  0       0       1       1
 6323   6322    "result"        "clob"  0       0       0       0
-6324   6322    "v"     "clob"  0       0       1       1
-6328   6327    "result"        "uuid"  0       0       0       0
-6331   6330    "result"        "uuid"  0       0       0       0
-6332   6330    "u"     "uuid"  0       0       1       1
+6324   6322    "x"     "double"        53      0       1       1
+6327   6326    "result"        "clob"  0       0       0       0
+6328   6326    "v"     "clob"  0       0       1       1
+6332   6331    "result"        "uuid"  0       0       0       0
 6335   6334    "result"        "uuid"  0       0       0       0
-6336   6334    "u"     "clob"  0       0       1       1
-6339   6338    "schema"        "clob"  0       0       0       0
-6340   6338    "table" "clob"  0       0       0       1
-6341   6338    "column"        "clob"  0       0       0       2
-6342   6338    "type"  "clob"  0       0       0       3
-6343   6338    "location"      "clob"  0       0       0       4
-6344   6338    "count" "bigint"        64      0       0       5
-6345   6338    "typewidth"     "int"   32      0       0       6
-6346   6338    "columnsize"    "bigint"        64      0       0       7
-6347   6338    "heapsize"      "bigint"        64      0       0       8
-6348   6338    "hashes"        "bigint"        64      0       0       9
-6349   6338    "imprints"      "bigint"        64      0       0       10
-6350   6338    "sorted"        "boolean"       1       0       0       11
-6381   6380    "result"        "bigint"        64      0       0       0
-6382   6380    "nme"   "clob"  0       0       1       1
-6383   6380    "i"     "bigint"        64      0       1       2
-6384   6380    "d"     "bigint"        64      0       1       3
-6387   6386    "result"        "bigint"        64      0       0       0
-6388   6386    "tpe"   "clob"  0       0       1       1
-6389   6386    "i"     "bigint"        64      0       1       2
-6390   6386    "w"     "int"   32      0       1       3
-6393   6392    "result"        "bigint"        64      0       0       0
-6394   6392    "b"     "boolean"       1       0       1       1
-6395   6392    "i"     "bigint"        64      0       1       2
-6398   6397    "result"        "bigint"        64      0       0       0
-6399   6397    "i"     "bigint"        64      0       1       1
-6400   6397    "nme"   "clob"  0       0       1       2
-6403   6402    "schema"        "clob"  0       0       0       0
-6404   6402    "table" "clob"  0       0       0       1
-6405   6402    "column"        "clob"  0       0       0       2
-6406   6402    "type"  "clob"  0       0       0       3
-6407   6402    "count" "bigint"        64      0       0       4
-6408   6402    "columnsize"    "bigint"        64      0       0       5
-6409   6402    "heapsize"      "bigint"        64      0       0       6
-6410   6402    "hashes"        "bigint"        64      0       0       7
-6411   6402    "imprints"      "bigint"        64      0       0       8
-6412   6402    "sorted"        "boolean"       1       0       0       9
-6454   6453    "tbl"   "clob"  0       0       1       0
-6457   6456    "sch"   "clob"  0       0       1       0
-6458   6456    "tbl"   "clob"  0       0       1       1
+6336   6334    "u"     "uuid"  0       0       1       1
+6339   6338    "result"        "uuid"  0       0       0       0
+6340   6338    "u"     "clob"  0       0       1       1
+6343   6342    "schema"        "clob"  0       0       0       0
+6344   6342    "table" "clob"  0       0       0       1
+6345   6342    "column"        "clob"  0       0       0       2
+6346   6342    "type"  "clob"  0       0       0       3
+6347   6342    "location"      "clob"  0       0       0       4
+6348   6342    "count" "bigint"        64      0       0       5
+6349   6342    "typewidth"     "int"   32      0       0       6
+6350   6342    "columnsize"    "bigint"        64      0       0       7
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to