So I wonder if "select null from sqlite_master limit 1" is the
cheapest, fastest, dirtiest way to make it work right now.
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]
-----------------------------------------------------------------------------
--
Ryan M. Lederman
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
