On Thu, Jun 28, 2018 at 2:03 PM Richard Hipp wrote:
> On 6/28/18, Dominique Devienne wrote:
> > From reading this list, I've learned that for an index to have a change
> to
> > be used to consume an order by, the collation of the query and the index
> > must match.
> >
> > But in many
On 6/28/18, Dominique Devienne wrote:
> From reading this list, I've learned that for an index to have a change to
> be used to consume an order by, the collation of the query and the index
> must match.
>
> But in many instances, that index is one from a virtual table we implement.
> So is there
On Thu, Jun 28, 2018 at 10:59 AM Dominique Devienne
wrote:
> So is there a way to tell SQLite that vindex is of a given custom
> collation,
> to open the possibility of the index being used?
>
Note that there's no mention at all of "collation" or "collate" in
https://www.sqlite.org/vtab.html
so
From reading this list, I've learned that for an index to have a change to
be used to consume an order by, the collation of the query and the index
must match.
But in many instances, that index is one from a virtual table we implement.
So is there a way to tell SQLite that vindex is of a given
4 matches
Mail list logo