Re: [sqlite] Possibly a bug in SQLite?

> -Original Message- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Jay A. Kreibich > Sent: 02 December 2009 15:02 > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Possibly a bug in SQLite? > > On

Re: [sqlite] Possibly a bug in SQLite?

To: General Discussion of SQLite Database Subject: Re: [sqlite] Possibly a bug in SQLite? On Wed, Dec 02, 2009 at 09:38:54AM -, Nick Shaw scratched on the wall: > You don't need to define the PRIMARY KEY as NOT NULL - it's implied. Yes, you do. You shouldn't, but you do: h

Re: [sqlite] Possibly a bug in SQLite?

On Dec 2, 2009, at 4:38 AM, Nick Shaw wrote: > You don't need to define the PRIMARY KEY as NOT NULL - it's implied. > The column constraint flow diagram in the documentation in fact > doesn't > allow it: > http://www.sqlite.org/syntaxdiagrams.html#column-constraint > That diagram is the

Re: [sqlite] Possibly a bug in SQLite?

On Wed, Dec 02, 2009 at 09:38:54AM -, Nick Shaw scratched on the wall: > You don't need to define the PRIMARY KEY as NOT NULL - it's implied. Yes, you do. You shouldn't, but you do: http://sqlite.org/lang_createtable.html According to the SQL standard, PRIMARY KEY should imply

Re: [sqlite] Possibly a bug in SQLite?

t; Nick. > > -Original Message- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Brandon Wang > Sent: 01 December 2009 17:06 > To: sqlite-users@sqlite.org > Subject: [sqlite] Possibly a bug in SQLite? > > Hello, > &g

Re: [sqlite] Possibly a bug in SQLite?

on the "id" column and see if it works after that. Thanks, Nick. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Brandon Wang Sent: 01 December 2009 17:06 To: sqlite-users@sqlite.org Subject: [sqlite] Possibly a bug

Re: [sqlite] Possibly a bug in SQLite?

Brandon Wang wrote: > I've come upon a interesting scenerio. > > .sqlite> .schema rg_configuration > CREATE TABLE 'rg_configuration' ( >"id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, >"configurationName" TEXT NOT NULL, >"host" TEXT, >"user" TEXT, >

[sqlite] Possibly a bug in SQLite?

Hello, I've come upon a interesting scenerio. .sqlite> .schema rg_configuration CREATE TABLE 'rg_configuration' ( "id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "configurationName" TEXT NOT NULL, "host" TEXT, "user" TEXT, "parentArch" INTEGER NOT NULL, "parentJob"