schema mismatch error on db.execute()

[GoogleCodeExporter]

Here is the repro for Firefox:

var f = new GearsFactory();
var db = f.create("beta.database", "1.0");
db.open("foo");
var db2 = f.create("beta.database", "1.0");
db2.open("foo");
var t = new Date().getTime();
db.execute("create table t" + t + "(id int)");

// causes error "schema has changed"
var rs = db2.execute("select * from t" + t);

My understanding is that this should succeed?

Original issue reported on code.google.com by [email protected] on 11 Jul 2007 at 12:28

[GoogleCodeExporter]

Unfortunately, this is a by-design thing.  See
http://www.sqlite.org/cvstrac/tktview?tn=2486 and also the thread running at
http://article.gmane.org/gmane.comp.db.sqlite.general/30228 .  I can understand 
the
rational of why things are this way, but I'm still pondering on whether there's 
a
slick solution we can apply within Gears.

The best workaround for now is to force the handle to read the database.  This 
works:

  db.execute('select * from sqlite_master').close();

Original comment by Scott.Hess on 11 Jul 2007 at 11:11

[GoogleCodeExporter]

Original comment by [email protected] on 5 Sep 2007 at 7:56

• Added labels: Version-later
• Removed labels: Milestone-M3