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 TABLE

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

2007-11-29 Thread Griggs, Donald
ABOVE ON MY SYSTEM: C:\Data\zip5>sqlite3 newdb.db SQLite version 3.3.12 Enter ".help" for instructions sqlite> create table cat ( a, b); sqlite> insert into cat values (1, 2); sqlite> create table badboy as select * from cat limit 0; sqlite> pragma integrity_check; *** in d

Re: [sqlite] Version 3.3.12

2007-01-27 Thread Rich Shepard
On Sat, 27 Jan 2007, Rich Shepard wrote: I have a Slackware-11.0 package available for anyone who wants a copy. It includes the md5 sum for integrity checking. They are available using wget: wget http://www.appl-ecosys.com/temp-files/sqlite3-3.3.12-i486-1rbs.tgz wget http://www.appl-ecosys

Re: [sqlite] Version 3.3.12

2007-01-27 Thread Rich Shepard
On Sat, 27 Jan 2007, [EMAIL PROTECTED] wrote: Version 3.3.12 is now available on the website I have a Slackware-11.0 package available for anyone who wants a copy. It includes the md5 sum for integrity checking. Rich -- Richard B. Shepard, Ph.D. |The Environmental Permitt

[sqlite] Version 3.3.12

2007-01-27 Thread drh
Version 3.3.12 is now available on the website http://www.sqlite.org/download.html This version fixes another bug in the IS NULL optimization that was introduced in 3.3.9. And there is an enhancement to PRAGMA integrity_check that limits the amount of output. -- D. Richard Hipp <[EMAIL PROTE