[R-sig-DB] RSQLite problems with SQLite versions 3.3.* -- but not 3.2.*

[Dirk Eddelbuettel]

When using the current RSQLite 0.4.1 along with the current SQLite version
3.3.6 (and I also testsed 3.3.5), dbWriteTable() never seems to actually put
content into the database. The schema gets created, but no more.  Seemingly,
the call 

  rc <- 
      try({
         skip <- skip + as.integer(header)
         conId <- as(con, "integer")
         .Call("RS_SQLite_importFile", conId, name, fn, sep, eol,
            as(skip, "integer"), PACKAGE = "RSQLite")
      })

and the end of sqliteImportFile (which is called from sqliteWriteTable, which
in turn is called from dbWriteTable). 

I just spent some scratching my head, and ended up avoiding the problem by
going back to the SQLite 3.2.8 version that comes with RSQLite.  

Did anybody else see something like this?  The problem seems to occur on both
Ubuntu Linux (05.10) at work and Debian Linux (testing) at home.

Regards, Dirk

-- 
Hell, there are no rules here - we're trying to accomplish something. 
                                                  -- Thomas A. Edison