Aha, yes, that does sound like exactly it. Thanks! On 7/11/07, Joe Wilson <[EMAIL PROTECTED]> wrote:
--- Scott Hess <[EMAIL PROTECTED]> wrote: > do_test test-1.1 { > execsql {PRAGMA encoding} > > sqlite3 db2 test.db > execsql {CREATE TABLE t (id int)} db2 > db2 close > > #execsql {SELECT * FROM sqlite_master} > catchsql {SELECT * FROM t} > } {1 {no such table: t}} > > Looks like the schema info is obviously being cached. The first > PRAGMA is to make sure this is happening - I originally wrote it with > the CREATE in db and the SELECT in db2, and the behaviour didn't > manifest unless I forced it to hit the database first. > > Uncommenting the commented line fixes things right up, presumably > because it forced sqlite to re-read things.Looks similar to http://www.sqlite.org/cvstrac/tktview?tn=2486 ____________________________________________________________________________________ Never miss an email again! Yahoo! Toolbar alerts you the instant new Mail arrives. http://tools.search.yahoo.com/toolbar/features/mail/ ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
