[R] is this an R bug or a DBI bug?

[Anthony Damico]

tested this out on 3.2.0, 3.2.1, and 3.2.2 -- only happens on 3.2.3, so i
assume it was an R bug not a DBI bug.  submitted here:

https://bugs.r-project.org/bugzilla/show_bug.cgi?id=16734




On Sat, Feb 27, 2016 at 6:20 PM, Anthony Damico <ajdamico at gmail.com> wrote:

> this happens with both SQLite and MonetDBLite, so i assume it is not an
> RSQLite bug.
>
> notice the gc() in the no-crash version..
>
> thanks
>
>
>     # initiate R with "C:\Program Files\R\R-3.2.3\bin\x64\Rterm.exe"
> --max-mem-size=35M
>     library(RSQLite)
>     db <- dbConnect( SQLite() )
>     for( i in 1:1000 ) { dbWriteTable( db , 'x' , mtcars , append = TRUE )
> }
>     # CRASH
>
>
>     # initiate R with "C:\Program Files\R\R-3.2.3\bin\x64\Rterm.exe"
> --max-mem-size=35M
>     library(RSQLite)
>     db <- dbConnect( SQLite() )
>     for( i in 1:1000 ) { dbWriteTable( db , 'x' , mtcars , append = TRUE )
> ; gc() }
>     # no crash
>
>
>
>
> ================
>
>
> > sessionInfo()
> R version 3.2.3 (2015-12-10)
> Platform: x86_64-w64-mingw32/x64 (64-bit)
> Running under: Windows 7 x64 (build 7601) Service Pack 1
>
> locale:
> [1] LC_COLLATE=English_United States.1252
> [2] LC_CTYPE=English_United States.1252
> [3] LC_MONETARY=English_United States.1252
> [4] LC_NUMERIC=C
> [5] LC_TIME=English_United States.1252
>
> attached base packages:
> [1] stats     graphics  grDevices utils     datasets  methods   base
>
> other attached packages:
> [1] RSQLite_1.0.0 DBI_0.3.1
>
>

	[[alternative HTML version deleted]]