"Griggs, Donald" <[EMAIL PROTECTED]> wrote: > I don't know if the following might be a problem with the new release, > or just something odd on my system. > > > In sqlite 3.3.12, I try to create an empty table copying the schema of > an existing table by using a command such as the following: > CREATE TABLE newtable AS SELECT * FROM oldtable LIMIT 0; > I seem to create an integrity_check failure (and the "newtable" is not > created, btw). > > If I then close the database and re-open it, the "malformed database > schema" error is returned for most any operation, and no table within > the database can be dumped. >
Problem fixed by check-in [3993] on 2007-05-14 14:05 GMT. http://www.sqlite.org/cvstrac/chngview?cn=3993 This was in between 3.3.17 and 3.4.0. In other words, the fix first appears in version 3.4.0. -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------