Re: [sqlite] Version 3.3.0 (alpha)

2006-01-23 Thread drh
"Roger Binns" <[EMAIL PROTECTED]> wrote: > >> ... But new databases created by > >> version 3.3.0 will not be readable by older versions > >> of SQLite. If this is a problem for your application, > >> compile SQLite using > >> > >> -DSQLITE_DEFAULT_FILE_FORMAT=1 > >> >

Re: [sqlite] Version 3.3.0 (alpha)

2006-01-22 Thread Roger Binns
... But new databases created by version 3.3.0 will not be readable by older versions of SQLite. If this is a problem for your application, compile SQLite using -DSQLITE_DEFAULT_FILE_FORMAT=1 and then version 3.3.0 will create new databases in the legacy

Re: [sqlite] Version 3.3.0 (alpha)

2006-01-22 Thread drh
Brett Wilson <[EMAIL PROTECTED]> wrote: > Does anybody know if there anything special we have to do to get the > new boolean optimization? Does it apply to any 0/1 integer values you > put in a cell, or does the column have to be declared as BOOLEAN? > If the column type is "TEXT" or "VARCHAR",

Re: [sqlite] Version 3.3.0 (alpha)

2006-01-21 Thread Brett Wilson
Does anybody know if there anything special we have to do to get the new boolean optimization? Does it apply to any 0/1 integer values you put in a cell, or does the column have to be declared as BOOLEAN? Thanks, Brett On 1/10/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > SQLite version

Re: [sqlite] Version 3.3.0 (alpha)

2006-01-21 Thread Weissmann Markus
On 21.01.2006, at 20:41, [EMAIL PROTECTED] wrote: Weissmann Markus <[EMAIL PROTECTED]> wrote: oh, well - thanks for this hint! Nevertheless sqlite 3.3.1 (still) does not complain: SQLite version 3.1.3 sqlite> create table t (a integer primary key, b integer, check(b > 0)); sqlite> insert

Re: [sqlite] Version 3.3.0 (alpha)

2006-01-21 Thread drh
Weissmann Markus <[EMAIL PROTECTED]> wrote: > > oh, well - thanks for this hint! Nevertheless sqlite 3.3.1 (still) > does not complain: > > SQLite version 3.1.3 > sqlite> create table t (a integer primary key, b integer, check(b > 0)); > sqlite> insert into t(b) values(-19); > sqlite> select *

Re: [sqlite] Version 3.3.0 (alpha)

2006-01-21 Thread Weissmann Markus
On 11.01.2006, at 02:55, [EMAIL PROTECTED] wrote: SQLite version 3.3.0 is now available on the website http://www.sqlite.org/ Version 3.3.0 incorporates many enhancements and changes. Among the changes in this release: * CHECK constraints are now enforced. could someone please

Re: [sqlite] Version 3.3.0 (alpha)

2006-01-20 Thread Jeff West
Does anyone have any more information or documentation on how to use the "READ UNCOMMITTED" feature of the latest version? Thanks, Jeff [EMAIL PROTECTED] wrote: SQLite version 3.3.0 is now available on the website http://www.sqlite.org/ Version 3.3.0 incorporates many enhancements and

[sqlite] Version 3.3.0 (alpha)

2006-01-10 Thread drh
SQLite version 3.3.0 is now available on the website http://www.sqlite.org/ Version 3.3.0 incorporates many enhancements and changes. Among the changes in this release: * CHECK constraints are now enforced. * The IF [NOT] EXISTS syntax of MySQL is now recognized on CREATE/DROP