On Fri, Nov 15, 2013 at 2:17 PM, Pepijn Van Eeckhoudt < pep...@vaneeckhoudt.net> wrote:
> Will without rowid introduce a new schema version number? > No. The syntax is fully compatible. A change in the schema version number would imply that there was some change in the meaning of the schema. In other words, a change in schema number would mean that an identical schema could result in different bits-on-disk, or a different answer to the same query. An example of changing the schema number is when SQLite started to honor the "DESC" modifier on column in CREATE INDEX, rather than ignoring it. With that change, the meaning changed for statements such as: CREATE INDEX ex1 ON tab1(a DESC, b ASC); The bits on disk are different for the same index, depending on the schema number. But that is not the case here. Bits-on-disk are unchanged for equivalent schemas. And the answers to queries are all the same. Yes, new schemas are allowed now that were rejected before. The same thing happened when we added support for partial indices. That is not a reason to bump the schema number, though. > > If so, we’ll be ok since GeoPackage requires schema version 4. > > Pepijn > > On 15 Nov 2013, at 16:33, Peter Aronson <pbaron...@att.net> wrote: > > > One additional thing not listed in this document -- use of a internal > rowid alias (OID, ROWID or _ROWID_) will produce a parse error on a query > against a WITHOUT ROWID table (unless, of course, it has an actual column > with the specified name), which makes sense, of course, but could be an > issue for generic table handling code that currently uses any of those. > > > > The fact that the presence of such a table makes a database containing > one unreadable at releases before 3.8.2 is a bit of an issue for those > using SQLite as a data exchange format (like GeoPackages), but then that's > true with partial indexes too. > > > > Peter > > > > On 11/15/2013 4:47 AM, Luís Simão wrote: > >> SQLite answers those question in: > >> > >> http://www.sqlite.org/draft/withoutrowid.html > >> > >> BR > >> _______________________________________________ > >> 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 > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users