"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
> >>
>
... 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
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",
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
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
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 *
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
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 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
9 matches
Mail list logo