==32843== Memcheck, a memory error detector
==32843== Copyright (C) 2002-2017, and GNU GPL'd, by Julian Seward et al.
==32843== Using Valgrind-3.14.0 and LibVEX; rerun with -h for copyright info
==32843== Command: /data/blackswan/ripley/R/R-devel-vg/bin/exec/R --vanilla --encoding=UTF-8
==32843== 

R Under development (unstable) (2019-04-14 r76395) -- "Unsuffered Consequences"
Copyright (C) 2019 The R Foundation for Statistical Computing
Platform: x86_64-pc-linux-gnu (64-bit)

R is free software and comes with ABSOLUTELY NO WARRANTY.
You are welcome to redistribute it under certain conditions.
Type 'license()' or 'licence()' for distribution details.

  Natural language support but running in an English locale

R is a collaborative project with many contributors.
Type 'contributors()' for more information and
'citation()' on how to cite R or R packages in publications.

Type 'demo()' for some demos, 'help()' for on-line help, or
'help.start()' for an HTML browser interface to help.
Type 'q()' to quit R.

> pkgname <- "MonetDBLite"
> source(file.path(R.home("share"), "R", "examples-header.R"))
> options(warn = 1)
> library('MonetDBLite')
> 
> base::assign(".oldSearch", base::search(), pos = 'CheckExEnv')
> base::assign(".old_wd", base::getwd(), pos = 'CheckExEnv')
> cleanEx()
> nameEx("MonetDB.R")
> ### * MonetDB.R
> 
> flush(stderr()); flush(stdout())
> 
> ### Name: MonetDB.R
> ### Title: DBI database connector for external MonetDB database
> ### Aliases: MonetDB.R MonetDBR MonetDB MonetR RMonetDB
> ### Keywords: interface
> 
> ### ** Examples
> 
> ## Not run: 
> ##D library(DBI)
> ##D con <- dbConnect(MonetDBLite::MonetDB.R(), dbname = "demo")
> ##D dbWriteTable(con, "iris", iris)
> ##D dbListTables(con)
> ##D dbGetQuery(con, "SELECT COUNT(*) FROM iris")
> ##D d <- dbReadTable(con, "iris")
> ## End(Not run)
> 
> 
> cleanEx()
> nameEx("MonetDBLite")
> ### * MonetDBLite
> 
> flush(stderr()); flush(stdout())
> 
> ### Name: MonetDBLite
> ### Title: MonetDBLite DBI driver
> ### Aliases: MonetDBLite RMonetDBLite monetdblite rmonetdblite
> 
> ### ** Examples
> 
> library(DBI)
> con <- dbConnect(MonetDBLite::MonetDBLite())
==32843== Syscall param write(buf) points to uninitialised byte(s)
==32843==    at 0x7943A81: write (in /usr/lib64/libpthread-2.27.so)
==32843==    by 0x182F93C6: GDKsave (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_storage.c:445)
==32843==    by 0x1815C383: HEAPsave_intern (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_heap.c:715)
==32843==    by 0x182F9B2E: BATsave (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_storage.c:770)
==32843==    by 0x180B651E: BBPsync (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_bbp.c:3383)
==32843==    by 0x182FB251: TMsubcommit_list (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_tm.c:205)
==32843==    by 0x18177344: bm_subcommit (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_logger.c:1419)
==32843==    by 0x1817CC10: logger_load (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_logger.c:1757)
==32843==    by 0x1817DC2A: logger_new (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_logger.c:2098)
==32843==    by 0x1817DDE9: logger_create (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_logger.c:2124)
==32843==    by 0x1844BA18: bl_create (packages/tests-vg/MonetDBLite/src/monetdblite/src/sql/storage/bat/bat_logger.c:200)
==32843==    by 0x1845F689: store_init (packages/tests-vg/MonetDBLite/src/monetdblite/src/sql/storage/store.c:1680)
==32843==  Address 0x1c865b26 is 8,230 bytes inside a block of size 10,256 alloc'd
==32843==    at 0x4C2EE3B: malloc (/builddir/build/BUILD/valgrind-3.14.0/coregrind/m_replacemalloc/vg_replace_malloc.c:309)
==32843==    by 0x182FF4EE: GDKmalloc_internal (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_utils.c:1372)
==32843==    by 0x1815C693: HEAPalloc (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_heap.c:117)
==32843==    by 0x18097AD8: strHeap (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_atoms.c:1130)
==32843==    by 0x18098668: ATOMheap (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_atoms.c:292)
==32843==    by 0x1809B177: BATnewstorage (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_bat.c:200)
==32843==    by 0x1809B177: COLnew (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_bat.c:234)
==32843==    by 0x1809B177: COLnew (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_bat.c:218)
==32843==    by 0x181767EF: logbat_new (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_logger.c:163)
==32843==    by 0x1817C23F: logger_load (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_logger.c:1541)
==32843==    by 0x1817DC2A: logger_new (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_logger.c:2098)
==32843==    by 0x1817DDE9: logger_create (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_logger.c:2124)
==32843==    by 0x1844BA18: bl_create (packages/tests-vg/MonetDBLite/src/monetdblite/src/sql/storage/bat/bat_logger.c:200)
==32843==    by 0x1845F689: store_init (packages/tests-vg/MonetDBLite/src/monetdblite/src/sql/storage/store.c:1680)
==32843==  Uninitialised value was created by a heap allocation
==32843==    at 0x4C2EE3B: malloc (/builddir/build/BUILD/valgrind-3.14.0/coregrind/m_replacemalloc/vg_replace_malloc.c:309)
==32843==    by 0x182FF4EE: GDKmalloc_internal (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_utils.c:1372)
==32843==    by 0x1815C693: HEAPalloc (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_heap.c:117)
==32843==    by 0x18097AD8: strHeap (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_atoms.c:1130)
==32843==    by 0x18098668: ATOMheap (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_atoms.c:292)
==32843==    by 0x1809B177: BATnewstorage (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_bat.c:200)
==32843==    by 0x1809B177: COLnew (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_bat.c:234)
==32843==    by 0x1809B177: COLnew (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_bat.c:218)
==32843==    by 0x181767EF: logbat_new (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_logger.c:163)
==32843==    by 0x1817C23F: logger_load (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_logger.c:1541)
==32843==    by 0x1817DC2A: logger_new (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_logger.c:2098)
==32843==    by 0x1817DDE9: logger_create (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_logger.c:2124)
==32843==    by 0x1844BA18: bl_create (packages/tests-vg/MonetDBLite/src/monetdblite/src/sql/storage/bat/bat_logger.c:200)
==32843==    by 0x1845F689: store_init (packages/tests-vg/MonetDBLite/src/monetdblite/src/sql/storage/store.c:1680)
==32843== 
> dbDisconnect(con, shutdown=TRUE)
==32843== Syscall param write(buf) points to uninitialised byte(s)
==32843==    at 0x7943AB7: write (in /usr/lib64/libpthread-2.27.so)
==32843==    by 0x182F93C6: GDKsave (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_storage.c:445)
==32843==    by 0x1815BF88: HASHfree (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_hash.c:584)
==32843==    by 0x1809A0F5: BATfree (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_bat.c:568)
==32843==    by 0x180AEB8C: BBPexit (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_bbp.c:1714)
==32843==    by 0x182FFDA9: GDKreset (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_utils.c:568)
==32843==    by 0x18082E24: monetdb_shutdown (packages/tests-vg/MonetDBLite/src/monetdblite/src/embedded/embedded.c:489)
==32843==    by 0x18466448: monetdb_shutdown_R (packages/tests-vg/MonetDBLite/src/embeddedr/embeddedr.c:322)
==32843==    by 0x4CEB7F: bcEval (svn/R-devel/src/main/eval.c:7283)
==32843==    by 0x4D908F: Rf_eval (svn/R-devel/src/main/eval.c:620)
==32843==    by 0x4DAC3E: R_execClosure (svn/R-devel/src/main/eval.c:1780)
==32843==    by 0x4DB994: Rf_applyClosure (svn/R-devel/src/main/eval.c:1706)
==32843==  Address 0x1b70f4b8 is 104 bytes inside a block of size 696 alloc'd
==32843==    at 0x4C2EE3B: malloc (/builddir/build/BUILD/valgrind-3.14.0/coregrind/m_replacemalloc/vg_replace_malloc.c:309)
==32843==    by 0x182FF4EE: GDKmalloc_internal (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_utils.c:1372)
==32843==    by 0x1815C693: HEAPalloc (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_heap.c:117)
==32843==    by 0x181598CF: HASHnew (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_hash.c:99)
==32843==    by 0x1815A27E: BAThash (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_hash.c:391)
==32843==    by 0x1809A6F4: BUNfnd (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_bat.c:1356)
==32843==    by 0x1809A6F4: BUNfnd (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_bat.c:1316)
==32843==    by 0x18350717: MTIMEtimezone (packages/tests-vg/MonetDBLite/src/monetdblite/src/mal/modules/mtime.c:1513)
==32843==    by 0x18354066: MTIMEprelude (packages/tests-vg/MonetDBLite/src/monetdblite/src/mal/modules/mtime.c:1483)
==32843==    by 0x1830C26A: runMALsequence (packages/tests-vg/MonetDBLite/src/monetdblite/src/mal/mal/mal_interpreter.c:667)
==32843==    by 0x1830D5D6: runMAL (packages/tests-vg/MonetDBLite/src/monetdblite/src/mal/mal/mal_interpreter.c:347)
==32843==    by 0x1831A1B9: MALengine (packages/tests-vg/MonetDBLite/src/monetdblite/src/mal/mal/mal_session.c:400)
==32843==    by 0x183011A6: mal_init (packages/tests-vg/MonetDBLite/src/monetdblite/src/mal/mal/mal.c:104)
==32843==  Uninitialised value was created by a heap allocation
==32843==    at 0x4C2EE3B: malloc (/builddir/build/BUILD/valgrind-3.14.0/coregrind/m_replacemalloc/vg_replace_malloc.c:309)
==32843==    by 0x182FF4EE: GDKmalloc_internal (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_utils.c:1372)
==32843==    by 0x1815C693: HEAPalloc (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_heap.c:117)
==32843==    by 0x181598CF: HASHnew (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_hash.c:99)
==32843==    by 0x1815A27E: BAThash (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_hash.c:391)
==32843==    by 0x1809A6F4: BUNfnd (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_bat.c:1356)
==32843==    by 0x1809A6F4: BUNfnd (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_bat.c:1316)
==32843==    by 0x18350717: MTIMEtimezone (packages/tests-vg/MonetDBLite/src/monetdblite/src/mal/modules/mtime.c:1513)
==32843==    by 0x18354066: MTIMEprelude (packages/tests-vg/MonetDBLite/src/monetdblite/src/mal/modules/mtime.c:1483)
==32843==    by 0x1830C26A: runMALsequence (packages/tests-vg/MonetDBLite/src/monetdblite/src/mal/mal/mal_interpreter.c:667)
==32843==    by 0x1830D5D6: runMAL (packages/tests-vg/MonetDBLite/src/monetdblite/src/mal/mal/mal_interpreter.c:347)
==32843==    by 0x1831A1B9: MALengine (packages/tests-vg/MonetDBLite/src/monetdblite/src/mal/mal/mal_session.c:400)
==32843==    by 0x183011A6: mal_init (packages/tests-vg/MonetDBLite/src/monetdblite/src/mal/mal/mal.c:104)
==32843== 
> 
> 
> 
> cleanEx()
==32843== Conditional jump or move depends on uninitialised value(s)
==32843==    at 0x40320CB: ???
==32843==    by 0x142560F7: ???
==32843==    by 0x142560F7: ???
==32843==    by 0x14256112: ???
==32843==    by 0x1FFEFF2F2F: ???
==32843== 

detaching ‘package:DBI’

> nameEx("control")
> ### * control
> 
> flush(stderr()); flush(stdout())
> 
> ### Name: control
> ### Title: Control an external MonetDB server from the R shell.
> ### Aliases: control monetdb.server.setup monetdb.server.start
> ###   monetdb.server.stop monetdb.server.shutdown monetdb.server.getpid
> 
> ### ** Examples
> 
> ## Not run: 
> ##D library(DBI)
> ##D startscript <- monetdb.server.setup("/tmp/database","/usr/local/monetdb/", "db1", 50001)
> ##D pid <- monetdb.server.start(startscript)
> ##D monetdb.server.stop(pid)
> ##D con <- dbConnect(MonetDB.R(), "monetdb://localhost:50001/db1")
> ## End(Not run)
> 
> 
> cleanEx()
> nameEx("dbApply")
> ### * dbApply
> 
> flush(stderr()); flush(stdout())
> 
> ### Name: mdbapply
> ### Title: Apply a R function to an external MonetDB table.
> ### Aliases: mdbapply mdbapply,MonetDBConnection-method
> 
> ### ** Examples
> 
> ## Not run: 
> ##D library(DBI)
> ##D con <- dbConnect(MonetDB.R(), "demo")
> ##D data(mtcars)
> ##D dbWriteTable(con, "mtcars", mtcars)
> ##D 
> ##D mpgplus42 <- mdbapply(con, "mtcars", "double", function(d) {
> ##D 	d$mpg + 42
> ##D })
> ## End(Not run)
> 
> 
> cleanEx()
> nameEx("mc")
> ### * mc
> 
> flush(stderr()); flush(stdout())
> 
> ### Name: mc
> ### Title: Shorthand connection constructor for external MonetDB
> ### Aliases: mc
> 
> ### ** Examples
> 
> ## Not run: 
> ##D   con <- mc(dbname="demo",hostname="localhost")
> ## End(Not run)
> 
> 
> cleanEx()
> nameEx("ml")
> ### * ml
> 
> flush(stderr()); flush(stdout())
> 
> ### Name: ml
> ### Title: Shorthand connection constructor for embedded MonetDB
> ### Aliases: ml
> 
> ### ** Examples
> 
>   library(DBI)
>   dbdir <- file.path( tempdir() , "ml" )
>   con <- ml(dbdir)
==32843== Syscall param write(buf) points to uninitialised byte(s)
==32843==    at 0x7943AB7: write (in /usr/lib64/libpthread-2.27.so)
==32843==    by 0x182F93C6: GDKsave (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_storage.c:445)
==32843==    by 0x1815C383: HEAPsave_intern (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_heap.c:715)
==32843==    by 0x182F9B2E: BATsave (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_storage.c:770)
==32843==    by 0x180B651E: BBPsync (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_bbp.c:3383)
==32843==    by 0x182FB251: TMsubcommit_list (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_tm.c:205)
==32843==    by 0x18177344: bm_subcommit (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_logger.c:1419)
==32843==    by 0x1817CC10: logger_load (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_logger.c:1757)
==32843==    by 0x1817DC2A: logger_new (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_logger.c:2098)
==32843==    by 0x1817DDE9: logger_create (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_logger.c:2124)
==32843==    by 0x1844BA18: bl_create (packages/tests-vg/MonetDBLite/src/monetdblite/src/sql/storage/bat/bat_logger.c:200)
==32843==    by 0x1845F689: store_init (packages/tests-vg/MonetDBLite/src/monetdblite/src/sql/storage/store.c:1680)
==32843==  Address 0x1b491ef6 is 8,230 bytes inside a block of size 10,256 alloc'd
==32843==    at 0x4C2EE3B: malloc (/builddir/build/BUILD/valgrind-3.14.0/coregrind/m_replacemalloc/vg_replace_malloc.c:309)
==32843==    by 0x182FF4EE: GDKmalloc_internal (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_utils.c:1372)
==32843==    by 0x1815C693: HEAPalloc (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_heap.c:117)
==32843==    by 0x18097AD8: strHeap (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_atoms.c:1130)
==32843==    by 0x18098668: ATOMheap (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_atoms.c:292)
==32843==    by 0x1809B177: BATnewstorage (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_bat.c:200)
==32843==    by 0x1809B177: COLnew (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_bat.c:234)
==32843==    by 0x1809B177: COLnew (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_bat.c:218)
==32843==    by 0x181767EF: logbat_new (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_logger.c:163)
==32843==    by 0x1817C23F: logger_load (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_logger.c:1541)
==32843==    by 0x1817DC2A: logger_new (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_logger.c:2098)
==32843==    by 0x1817DDE9: logger_create (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_logger.c:2124)
==32843==    by 0x1844BA18: bl_create (packages/tests-vg/MonetDBLite/src/monetdblite/src/sql/storage/bat/bat_logger.c:200)
==32843==    by 0x1845F689: store_init (packages/tests-vg/MonetDBLite/src/monetdblite/src/sql/storage/store.c:1680)
==32843==  Uninitialised value was created by a heap allocation
==32843==    at 0x4C2EE3B: malloc (/builddir/build/BUILD/valgrind-3.14.0/coregrind/m_replacemalloc/vg_replace_malloc.c:309)
==32843==    by 0x182FF4EE: GDKmalloc_internal (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_utils.c:1372)
==32843==    by 0x1815C693: HEAPalloc (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_heap.c:117)
==32843==    by 0x18097AD8: strHeap (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_atoms.c:1130)
==32843==    by 0x18098668: ATOMheap (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_atoms.c:292)
==32843==    by 0x1809B177: BATnewstorage (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_bat.c:200)
==32843==    by 0x1809B177: COLnew (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_bat.c:234)
==32843==    by 0x1809B177: COLnew (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_bat.c:218)
==32843==    by 0x181767EF: logbat_new (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_logger.c:163)
==32843==    by 0x1817C23F: logger_load (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_logger.c:1541)
==32843==    by 0x1817DC2A: logger_new (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_logger.c:2098)
==32843==    by 0x1817DDE9: logger_create (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_logger.c:2124)
==32843==    by 0x1844BA18: bl_create (packages/tests-vg/MonetDBLite/src/monetdblite/src/sql/storage/bat/bat_logger.c:200)
==32843==    by 0x1845F689: store_init (packages/tests-vg/MonetDBLite/src/monetdblite/src/sql/storage/store.c:1680)
==32843== 
>   dbDisconnect(con, shutdown = TRUE)
> 
> 
> 
> cleanEx()
==32843== Conditional jump or move depends on uninitialised value(s)
==32843==    at 0x4041C03: ???
==32843==    by 0x1DD31117: ???
==32843==    by 0x1DD31117: ???
==32843==    by 0x1DD31132: ???
==32843==    by 0x1FFEFF2F2F: ???
==32843== 

detaching ‘package:DBI’

> nameEx("monetdb.read.csv")
> ### * monetdb.read.csv
> 
> flush(stderr()); flush(stdout())
> 
> ### Name: monetdb.read.csv
> ### Title: Import a CSV file into MonetDBLite
> ### Aliases: monetdb.read.csv monet.read.csv
> ### Keywords: interface
> 
> ### ** Examples
> 
> 
> # initiate a MonetDBLite server
> library(DBI)
> dbdir <- file.path( tempdir() , 'readcsv' )
> con <- dbConnect( MonetDBLite::MonetDBLite() , dbdir )
> 
> # write test data to temporary CSV file
> file <- tempfile()
> write.table(iris, file, sep=",", row.names=FALSE)
> 
> # create table and import CSV
> monetdb.read.csv(con, file, "iris")
Identifier(s) "Sepal.Length", "Sepal.Width", "Petal.Length", "Petal.Width", "Species" contain uppercase or reserved SQL characters and need(s) to be quoted in queries.
> 
> dbDisconnect(con, shutdown=TRUE)
> 
> 
> 
> cleanEx()
==32843== Conditional jump or move depends on uninitialised value(s)
==32843==    at 0x4041C03: ???
==32843==    by 0x1F0D51D7: ???
==32843==    by 0x1F0D51D7: ???
==32843==    by 0x1F0D51F2: ???
==32843==    by 0x1FFEFF2F2F: ???
==32843== 

detaching ‘package:DBI’

> nameEx("monetdbd.liststatus")
> ### * monetdbd.liststatus
> 
> flush(stderr()); flush(stdout())
> 
> ### Name: monetdbd.liststatus
> ### Title: Get list of available databases from external monetdbd
> ### Aliases: monetdbd.liststatus monetdb.liststatus
> 
> ### ** Examples
> 
> ## Not run: 
> ##D print(monetdbd.liststatus("mypasshprase")$dbname)
> ## End(Not run)
> 
> 
> cleanEx()
> nameEx("monetdblite_shutdown")
> ### * monetdblite_shutdown
> 
> flush(stderr()); flush(stdout())
> 
> ### Name: monetdblite_shutdown
> ### Title: Shutdown MonetDBLite
> ### Aliases: monetdblite_shutdown
> 
> ### ** Examples
> 
> library(DBI)
> con <- dbConnect(MonetDBLite::MonetDBLite())
==32843== Syscall param write(buf) points to uninitialised byte(s)
==32843==    at 0x7943AB7: write (in /usr/lib64/libpthread-2.27.so)
==32843==    by 0x182F93C6: GDKsave (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_storage.c:445)
==32843==    by 0x1815C383: HEAPsave_intern (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_heap.c:715)
==32843==    by 0x1815F720: BATimprints (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_imprints.c:458)
==32843==    by 0x182BE7A2: BAT_scanselect (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_select.c:887)
==32843==    by 0x182C3CD6: BATselect (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_select.c:1824)
==32843==    by 0x182C3CD6: BATselect (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_select.c:1184)
==32843==    by 0x184537AD: rids_select (packages/tests-vg/MonetDBLite/src/monetdblite/src/sql/storage/bat/bat_table.c:329)
==32843==    by 0x1845EE06: load_schema (packages/tests-vg/MonetDBLite/src/monetdblite/src/sql/storage/store.c:994)
==32843==    by 0x1845EE06: load_trans (packages/tests-vg/MonetDBLite/src/monetdblite/src/sql/storage/store.c:1080)
==32843==    by 0x1845EE06: store_load (packages/tests-vg/MonetDBLite/src/monetdblite/src/sql/storage/store.c:1625)
==32843==    by 0x1842C12C: mvc_init (packages/tests-vg/MonetDBLite/src/monetdblite/src/sql/server/sql_mvc.c:80)
==32843==    by 0x183CB159: SQLinit (packages/tests-vg/MonetDBLite/src/monetdblite/src/mal/sqlbackend/sql_scenario.c:239)
==32843==    by 0x183CB159: SQLprelude (packages/tests-vg/MonetDBLite/src/monetdblite/src/mal/sqlbackend/sql_scenario.c:152)
==32843==    by 0x1830C26A: runMALsequence (packages/tests-vg/MonetDBLite/src/monetdblite/src/mal/mal/mal_interpreter.c:667)
==32843==    by 0x1830D5D6: runMAL (packages/tests-vg/MonetDBLite/src/monetdblite/src/mal/mal/mal_interpreter.c:347)
==32843==  Address 0x12a2fe90 is 2,432 bytes inside a block of size 2,736 alloc'd
==32843==    at 0x4C2EE3B: malloc (/builddir/build/BUILD/valgrind-3.14.0/coregrind/m_replacemalloc/vg_replace_malloc.c:309)
==32843==    by 0x182FF4EE: GDKmalloc_internal (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_utils.c:1372)
==32843==    by 0x1815C693: HEAPalloc (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_heap.c:117)
==32843==    by 0x1815E521: BATimprints (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_imprints.c:386)
==32843==    by 0x182BE7A2: BAT_scanselect (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_select.c:887)
==32843==    by 0x182C3CD6: BATselect (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_select.c:1824)
==32843==    by 0x182C3CD6: BATselect (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_select.c:1184)
==32843==    by 0x184537AD: rids_select (packages/tests-vg/MonetDBLite/src/monetdblite/src/sql/storage/bat/bat_table.c:329)
==32843==    by 0x1845EE06: load_schema (packages/tests-vg/MonetDBLite/src/monetdblite/src/sql/storage/store.c:994)
==32843==    by 0x1845EE06: load_trans (packages/tests-vg/MonetDBLite/src/monetdblite/src/sql/storage/store.c:1080)
==32843==    by 0x1845EE06: store_load (packages/tests-vg/MonetDBLite/src/monetdblite/src/sql/storage/store.c:1625)
==32843==    by 0x1842C12C: mvc_init (packages/tests-vg/MonetDBLite/src/monetdblite/src/sql/server/sql_mvc.c:80)
==32843==    by 0x183CB159: SQLinit (packages/tests-vg/MonetDBLite/src/monetdblite/src/mal/sqlbackend/sql_scenario.c:239)
==32843==    by 0x183CB159: SQLprelude (packages/tests-vg/MonetDBLite/src/monetdblite/src/mal/sqlbackend/sql_scenario.c:152)
==32843==    by 0x1830C26A: runMALsequence (packages/tests-vg/MonetDBLite/src/monetdblite/src/mal/mal/mal_interpreter.c:667)
==32843==    by 0x1830D5D6: runMAL (packages/tests-vg/MonetDBLite/src/monetdblite/src/mal/mal/mal_interpreter.c:347)
==32843==  Uninitialised value was created by a heap allocation
==32843==    at 0x4C2EE3B: malloc (/builddir/build/BUILD/valgrind-3.14.0/coregrind/m_replacemalloc/vg_replace_malloc.c:309)
==32843==    by 0x182FF4EE: GDKmalloc_internal (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_utils.c:1372)
==32843==    by 0x1815C693: HEAPalloc (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_heap.c:117)
==32843==    by 0x1815E521: BATimprints (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_imprints.c:386)
==32843==    by 0x182BE7A2: BAT_scanselect (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_select.c:887)
==32843==    by 0x182C3CD6: BATselect (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_select.c:1824)
==32843==    by 0x182C3CD6: BATselect (packages/tests-vg/MonetDBLite/src/monetdblite/src/gdk/gdk_select.c:1184)
==32843==    by 0x184537AD: rids_select (packages/tests-vg/MonetDBLite/src/monetdblite/src/sql/storage/bat/bat_table.c:329)
==32843==    by 0x1845EE06: load_schema (packages/tests-vg/MonetDBLite/src/monetdblite/src/sql/storage/store.c:994)
==32843==    by 0x1845EE06: load_trans (packages/tests-vg/MonetDBLite/src/monetdblite/src/sql/storage/store.c:1080)
==32843==    by 0x1845EE06: store_load (packages/tests-vg/MonetDBLite/src/monetdblite/src/sql/storage/store.c:1625)
==32843==    by 0x1842C12C: mvc_init (packages/tests-vg/MonetDBLite/src/monetdblite/src/sql/server/sql_mvc.c:80)
==32843==    by 0x183CB159: SQLinit (packages/tests-vg/MonetDBLite/src/monetdblite/src/mal/sqlbackend/sql_scenario.c:239)
==32843==    by 0x183CB159: SQLprelude (packages/tests-vg/MonetDBLite/src/monetdblite/src/mal/sqlbackend/sql_scenario.c:152)
==32843==    by 0x1830C26A: runMALsequence (packages/tests-vg/MonetDBLite/src/monetdblite/src/mal/mal/mal_interpreter.c:667)
==32843==    by 0x1830D5D6: runMAL (packages/tests-vg/MonetDBLite/src/monetdblite/src/mal/mal/mal_interpreter.c:347)
==32843== 
> MonetDBLite::monetdblite_shutdown()
> 
> 
> 
> cleanEx()
==32843== Conditional jump or move depends on uninitialised value(s)
==32843==    at 0x4041C03: ???
==32843==    by 0x1F0D5137: ???
==32843==    by 0x1F0D5137: ???
==32843==    by 0x1F0D5152: ???
==32843==    by 0x1FFEFF2F2F: ???
==32843== 

detaching ‘package:DBI’

> nameEx("src_monetdb")
> ### * src_monetdb
> 
> flush(stderr()); flush(stdout())
> 
> ### Name: src_monetdb
> ### Title: dplyr integration from MonetDBLite
> ### Aliases: src_monetdb src_monetdblite
> 
> ### ** Examples
> 
> library(dplyr)

Attaching package: ‘dplyr’

==32843== Conditional jump or move depends on uninitialised value(s)
==32843==    at 0x4041C03: ???
==32843==    by 0x1E5A3807: ???
==32843==    by 0x1E5A3807: ???
==32843==    by 0x1E5A3812: ???
==32843==    by 0x1FFEFF44CF: ???
==32843== 
The following objects are masked from ‘package:stats’:

    filter, lag

==32843== Conditional jump or move depends on uninitialised value(s)
==32843==    at 0x4041C03: ???
==32843==    by 0x1C938927: ???
==32843==    by 0x1C938927: ???
==32843==    by 0x1C93894A: ???
==32843==    by 0x1FFEFF44CF: ???
==32843== 
The following objects are masked from ‘package:base’:

    intersect, setdiff, setequal, union

> # To connect to a database first create a src:
> dbdir <- file.path(tempdir(), "dplyrdir")
> my_db <- MonetDBLite::src_monetdblite(dbdir)
> 
> # copy some data to DB
> my_iris  <- copy_to(my_db, iris)
Identifier(s) "Sepal.Length", "Sepal.Width", "Petal.Length", "Petal.Width", "Species" contain uppercase or reserved SQL characters and need(s) to be quoted in queries.
> 
> # create table object
> my_iris2 <- tbl(my_db, 'iris')
> 
> # now you can call regular dplyr methods on table object
> 
> # ...
> 
> # shut down the database
> MonetDBLite::monetdblite_shutdown()
Warning in .Internal(gc(verbose, reset, full)) :
  Connection is garbage-collected, use dbDisconnect() to avoid this.
> 
> 
> 
> ### * <FOOTER>
> ###
> cleanEx()
==32843== Conditional jump or move depends on uninitialised value(s)
==32843==    at 0x4041C03: ???
==32843==    by 0x1F0D52C7: ???
==32843==    by 0x1F0D52C7: ???
==32843==    by 0x1F0D52E4: ???
==32843==    by 0x1FFEFF2F2F: ???
==32843== 

detaching ‘package:dplyr’

> options(digits = 7L)
> base::cat("Time elapsed: ", proc.time() - base::get("ptime", pos = 'CheckExEnv'),"\n")
Time elapsed:  152.882 1.987 155.287 0 0 
> grDevices::dev.off()
null device 
          1 
> ###
> ### Local variables: ***
> ### mode: outline-minor ***
> ### outline-regexp: "\\(> \\)?### [*]+" ***
> ### End: ***
> quit('no')
==32843== 
==32843== HEAP SUMMARY:
==32843==     in use at exit: 94,991,672 bytes in 18,239 blocks
==32843==   total heap usage: 925,302 allocs, 907,063 frees, 1,043,941,550 bytes allocated
==32843== 
==32843== LEAK SUMMARY:
==32843==    definitely lost: 0 bytes in 0 blocks
==32843==    indirectly lost: 0 bytes in 0 blocks
==32843==      possibly lost: 0 bytes in 0 blocks
==32843==    still reachable: 94,991,672 bytes in 18,239 blocks
==32843==         suppressed: 0 bytes in 0 blocks
==32843== Reachable blocks (those to which a pointer was found) are not shown.
==32843== To see them, rerun with: --leak-check=full --show-leak-kinds=all
==32843== 
==32843== For counts of detected and suppressed errors, rerun with: -v
==32843== ERROR SUMMARY: 67 errors from 11 contexts (suppressed: 0 from 0)