Re: [sqlite] Is this a bug? autoincrement in int primary key vs integer primary key
Thanks for the link Bernard Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit -Forensic Toolkit for SQLite http://sandersonforensics.com/forum/content.php?168-Reconnoitre - VSC processing made easy On 16 November 2014 16:07, Bernardo Sulzbach wrote: > You are supposing that INT PRIMARY KEY == INTEGER PRIMARY KEY. Which, > clearly, is not true. > http://stackoverflow.com/questions/20289410/difference-between-int-primary-key-and-integer-primary-key-sqlite > see this link for more on the subject. > > 2014-11-16 13:56 GMT-02:00 Igor Tandetnik : > >> On 11/16/2014 10:51 AM, Paul Sanderson wrote: >> >>> AUTOINCREMENT is only allowed on an INTEGER PRIMARY KEY >>> >> >> No it's not a bug. AUTOINCREMENT is only allowed on INTEGER PRIMARY KEY. >> Which part of the error message do you find unclear? >> >> For details, see http://www.sqlite.org/autoinc.html >> >> >> ___ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > > > > -- > Bernardo Sulzbach > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Is this a bug? autoincrement in int primary key vs integer primary key
You are supposing that INT PRIMARY KEY == INTEGER PRIMARY KEY. Which, clearly, is not true. http://stackoverflow.com/questions/20289410/difference-between-int-primary-key-and-integer-primary-key-sqlite see this link for more on the subject. 2014-11-16 13:56 GMT-02:00 Igor Tandetnik : > On 11/16/2014 10:51 AM, Paul Sanderson wrote: > >> AUTOINCREMENT is only allowed on an INTEGER PRIMARY KEY >> > > No it's not a bug. AUTOINCREMENT is only allowed on INTEGER PRIMARY KEY. > Which part of the error message do you find unclear? > > For details, see http://www.sqlite.org/autoinc.html > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Bernardo Sulzbach ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Is this a bug? autoincrement in int primary key vs integer primary key
On 11/16/2014 10:51 AM, Paul Sanderson wrote: AUTOINCREMENT is only allowed on an INTEGER PRIMARY KEY No it's not a bug. AUTOINCREMENT is only allowed on INTEGER PRIMARY KEY. Which part of the error message do you find unclear? For details, see http://www.sqlite.org/autoinc.html ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users