RSQLite segfault after adding column to table
Hi Noah, "Noah Hoffman" <noah.hoffman at gmail.com> writes:
I've noticed a segfault caused by attempting to select from a table after a column of unspecified type is added. I've only tested this using the single R installation described below. Here's some info about my environment:
sessionInfo()
R version 2.7.0 Under development (unstable) (2007-09-24 r42964) x86_64-unknown-linux-gnu ... other attached packages: [1] RSQLite_0.6-0 DBI_0.2-3
Can you try upgrading to RSQLite 0.6-3? I'm seeing the following:
library(RSQLite)
Loading required package: DBI
con <- dbConnect(dbDriver("SQLite"), dbname = ":memory:")
dbGetQuery(con, "create table s (col1 INTEGER)")
NULL
dbGetQuery(con, "insert into s (col1) values (1)")
NULL
dbGetQuery(con, "select * from s")
col1 1 1
dbGetQuery(con, "alter table s add column col2")
NULL
dbGetQuery(con, "select * from s")
col1 col2 1 1 <NA>
sessionInfo()
R version 2.6.0 beta (--) i386-apple-darwin8.10.1 locale: C attached base packages: [1] stats graphics grDevices datasets utils methods base other attached packages: [1] RSQLite_0.6-3 DBI_0.3-0 loaded via a namespace (and not attached): [1] tools_2.6.0
Seth Falcon | seth at userprimary.net | blog: http://userprimary.net/user/