Re: [sqlite] vtable and usable constraint

2017-05-23 Thread Hick Gunter
ill be visited. HTH Gunter -Ursprüngliche Nachricht- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von petern Gesendet: Montag, 22. Mai 2017 22:49 An: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> Betreff: Re: [sqlite] vtable and usable

Re: [sqlite] vtable and usable constraint

2017-05-22 Thread petern
ble WHERE value = 4711; ---assuming valueis not > contained in an index > > Always the cost of a full table scan. > > > -Ursprüngliche Nachricht- > Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > Im Auftrag von graf0 post.pl > Gesendet: Sam

Re: [sqlite] vtable and usable constraint

2017-05-22 Thread Hick Gunter
n. -Ursprüngliche Nachricht- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von graf0 post.pl Gesendet: Samstag, 20. Mai 2017 13:18 An: sqlite-users@mailinglists.sqlite.org Betreff: [sqlite] vtable and usable constraint Hello, I'm trying to implem

Re: [sqlite] vtable and usable constraint

2017-05-20 Thread Dan Kennedy
On 05/20/2017 06:17 PM, graf0 post.pl wrote: Hello, I'm trying to implement vtable, and I don't understand what is meaning of usable field in sqlite3_index_constraint struct? Can I assume it will be false when my vtable is joined by that field with some other table? Basically just that. Say

[sqlite] vtable and usable constraint

2017-05-20 Thread graf0 post.pl
Hello, I'm trying to implement vtable, and I don't understand what is meaning of usable field in sqlite3_index_constraint struct? Can I assume it will be false when my vtable is joined by that field with some other table? If yes - in what other situations this filed will be false? If not - so