[R-sig-DB] RSQLite segfault after adding column to table

[Seth Falcon]

Hi Noah,

"Noah Hoffman" <noah.hoffman using 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 using userprimary.net | blog: http://userprimary.net/user/