Re: [sqlite] A Descending Auto Increment Key

2017-07-21 Thread cindy estepp
annot be applied. > > > > -Original Message- > > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > > On Behalf Of sanhua.zh > > Sent: Wednesday, 19 July, 2017 20:07 > > To: sqlite-users > > Subject: [sqlite] A Descending Auto Incr

Re: [sqlite] A Descending Auto Increment Key

2017-07-20 Thread Don V Nielsen
" (ie, creating a unique index) and the > AUTOINCREMENT keyword cannot be applied. > > -Original Message- > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > On Behalf Of sanhua.zh > Sent: Wednesday, 19 July, 2017 20:07 > To: sqlite-users > Subjec

Re: [sqlite] A Descending Auto Increment Key

2017-07-19 Thread Keith Medcalf
ating a unique index) and the AUTOINCREMENT keyword cannot be applied. -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of sanhua.zh Sent: Wednesday, 19 July, 2017 20:07 To: sqlite-users Subject: [sqlite] A Descending Auto Increment Key

[sqlite] A Descending Auto Increment Key

2017-07-19 Thread sanhua.zh
When I call `CREATE TABLE test(i INTEGER PRIMARY KEY DESC AUTO INCREMENT)`, SQLite comes to an error "AUTOINCREMENT is only allowed on an INTEGER PRIMARY KEY". But as the document http://www.sqlite.org/lang_createtable.htmlsays, in the column-constraint, it shows that `PRIMARY DESC