Hmm, I wonder if this is the same problem I'm having. I randomly get
"no such table" errors too. Anyone have experience with this
particular problem?
On 7/11/07, 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.
-scott
[Sorry if I'm missing something. Feels like I'm missing something.
But I can't see what :-).]
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
--
Ryan M. Lederman
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
