RE: [sqlite] version 3.3.12 -- malformed schema after using "limit 0" ??

2007-11-30 Thread Griggs, Donald
regarding: "Problem fixed by check-in [3993] on 2007-05-14 14:05 GMT." Argh! I stupidly had downloaded the current version but somehow was using the old 3.3.12 version when encountering the error. My apologies to the list.

Re: [sqlite] version 3.3.12 -- malformed schema after using "limit 0" ??

2007-11-29 Thread drh
"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: >

RE: [sqlite] version 3.3.12 -- malformed schema after using "limit 0" ??

2007-11-29 Thread James Dennett
[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

[sqlite] version 3.3.12 -- malformed schema after using "limit 0" ??

2007-11-29 Thread Griggs, Donald
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