Re: [sqlite] Unexpected "no such table" error.

2007-07-11 Thread Scott Hess
On 7/11/07, [EMAIL PROTECTED] <[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 *

Re: [sqlite] Unexpected "no such table" error.

2007-07-11 Thread drh
"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 s

Re: [sqlite] Unexpected "no such table" error.

2007-07-11 Thread Ryan M. Lederman
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 > e

Re: [sqlite] Unexpected "no such table" error.

2007-07-11 Thread Scott Hess
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 {SEL

Re: [sqlite] Unexpected "no such table" error.

2007-07-11 Thread Joe Wilson
--- 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

Re: [sqlite] Unexpected "no such table" error.

2007-07-11 Thread Ryan M. Lederman
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

[sqlite] Unexpected "no such table" error.

2007-07-11 Thread Scott Hess
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 su