SQLite

All files named ”test/tableopts.test”
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

History for test/tableopts.test

2013-11-09
18:15
[dba698ba97] part of check-in [b1abb2b078] Throw an error if AUTOINCREMENT appears in a WITHOUT ROWID table. Updates to API documentation to discuss WITHOUT ROWID. (check-in: [b1abb2b078] user: drh branch: trunk, size: 1944)
2013-10-23
17:39
[2950f094a9] part of check-in [36bcc9cb88] Report an error when trying to resolve column name "rowid" in a WITHOUT ROWID table. (check-in: [36bcc9cb88] user: drh branch: omit-rowid, size: 1767)
2013-10-21
02:14
[b0aa6ebab4] part of check-in [131cc6e152] Simplification of the syntax: Merely append "WITHOUT rowid" to the end of the table definition. (check-in: [131cc6e152] user: drh branch: omit-rowid, size: 1464)
2013-10-19
23:31
Added: [28c869c559] part of check-in [0248ec5e6e] Experimental changes toward "index only" tables. Add the ability to specify options on CREATE TABLE statements using the WITH clause modeled after PostgreSQL and SQL Server. Only the "omit_rowid" option is currently recognized and that option is currently a no-op. (check-in: [0248ec5e6e] user: drh branch: omit-rowid, size: 1494)