Pavel Ivanov <paiva...@...> writes: > > > I can't understand why is it a bad practice to use database-provided >>features? > > You can use it when you are selecting. And even in this case you > should use caution because without explicit column declared by you > SQLite can change rowids without notice. And for foreign keys it's > mandatory to reference to real columns. > > > I think this is a bug. It should be fixed. > > Nope, it's not a bug. >
[...] Maybe it isn't a bug but the documentation should leave as little possibilities as feasible for interpretation. This seems to be a problem of wiggle room - it's the same if we talk about self reference in connection with foreign keys (http://thread.gmane.org/gmane.comp.db.sqlite.general/58688). You can't know that it is only applicable to two different(!) tables only reading the documentation. Oliver _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
