Hello General, I was going to say I thought the docs were ambiguous but, on my 3rd reading I see they aren't. Still, I think this statement could be re-written to reduce confusion (at least mine).
https://www.sqlite.org/autoinc.html >>Because AUTOINCREMENT keyword changes the behavior of the ROWID >>selection algorithm, AUTOINCREMENT is not allowed on WITHOUT ROWID >>tables or on any table column other than INTEGER PRIMARY KEY. Any >>attempt to use AUTOINCREMENT on a WITHOUT ROWID table or on a column >>other than the INTEGER PRIMARY KEY column results in an error.-- I think this comment would be clearer if the "without rowid" part was pulled out and made absolute. >>The AUTOINCREMENT keyword is not allowed on WITHOUT ROWID tables. >>Because the AUTOINCREMENT keyword changes the behavior of the ROWID >>selection algorithm, Any attempt to use AUTOINCREMENT on a column >>other than the INTEGER PRIMARY KEY column results in an error.-- Best regards, Conrad mailto:t...@djii.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
