G. Roderick Singleton a écrit :
On Sat, 2005-10-01 at 22:19 +0200, denys wrote:
Hi all,
I'm trying to create a table but I always get an "assertion failed"
crash :-(
Here is the statement:
CREATE TABLE Media (id INTEGER PRIMARY KEY, keywords TEXT, original
INTEGER, used INTEGER,
denys <[EMAIL PROTECTED]> wrote:
>
> Here is the statement:
> CREATE TABLE Media (id INTEGER PRIMARY KEY, keywords TEXT, original
> INTEGER, used INTEGER, picture TEXT, note INTEGER, comment BLOB, note
> INTEGER, type INTEGER, idSpec INTEGER);
>
> Assertion failed: pCol->zType==0, file
denys wrote:
Hi all,
I'm trying to create a table but I always get an "assertion failed"
crash :-(
Here is the statement:
CREATE TABLE Media (id INTEGER PRIMARY KEY, keywords TEXT, original
INTEGER, used INTEGER, picture TEXT, note INTEGER, comment BLOB, note
INTEGER, type INTEGER, idSpec
On Sat, 2005-10-01 at 22:19 +0200, denys wrote:
> Hi all,
>
> I'm trying to create a table but I always get an "assertion failed"
> crash :-(
>
> Here is the statement:
> CREATE TABLE Media (id INTEGER PRIMARY KEY, keywords TEXT, original
> INTEGER, used INTEGER, picture TEXT, note INTEGER,
Hi all,
I'm trying to create a table but I always get an "assertion failed"
crash :-(
Here is the statement:
CREATE TABLE Media (id INTEGER PRIMARY KEY, keywords TEXT, original
INTEGER, used INTEGER, picture TEXT, note INTEGER, comment BLOB, note
INTEGER, type INTEGER, idSpec INTEGER);
I'm experimenting with SQLite and found there's a big difference in speed
depending on the setting of PRAGMA SYNCHRONOUS.
I understand that settings other than"2" for this parameter don't guarantee
that data is safely stored on disk when che COMMIT statement terminates.
I wonder if it is
6 matches
Mail list logo