Re: [sqlite] [EXTERNAL] virtual tables, xBestIndex, pIdxInfo->aConstraint[].op, and 'NOT'...

2018-10-16 Thread Richard Hipp
On 10/16/18, dave wrote: > > And also the meaning/use of SQLITE_INDEX_CONSTRAINT_FUNCTION, that would be > super helpful. > The SQLITE_INDEX_CONSTRAINT_FUNCTION mechanism was added to support the new Geopoly extension, and the ability to index on things like "WHERE geopoly_within(_shape,...)"

Re: [sqlite] [EXTERNAL] virtual tables, xBestIndex, pIdxInfo->aConstraint[].op, and 'NOT'...

2018-10-16 Thread dave
> Behalf Of Keith Medcalf > Sent: Saturday, October 13, 2018 6:53 PM ... > > > Lastly, I'm assuming that 'IS' and 'IS NOT' is functionally > > equivalent to the '=' and '<>' operators? > > Or is there some subtle difference > > As long as neither the LHS or the RHS are null, then IS and > IS

Re: [sqlite] SQLITE_ENABLE_UPDATE_DELETE_LIMIT

2018-10-16 Thread Olivier Mascia
> Le 16 oct. 2018 à 16:39, Olivier Mascia a écrit : > > https://www.sqlite.org/compile.html#enable_update_delete_limit ... > I can manage to run the build tools properly, for the target sqlite3.c or > sqlite_analyzer.exe for instance. I'm just not confident yet as to where to > start to patch

[sqlite] SQLITE_ENABLE_UPDATE_DELETE_LIMIT

2018-10-16 Thread Olivier Mascia
https://www.sqlite.org/compile.html#enable_update_delete_limit > SQLITE_ENABLE_UPDATE_DELETE_LIMIT > > This option enables an optional ORDER BY and LIMIT clause on UPDATE and > DELETE statements. > > If this option is defined, then it must also be defined when using the Lemon > parser

[sqlite] [SQLITE] 3 questions.(tokenize in fts5)(number of highlights)(ignoring syntax errors for searching "symbols")

2018-10-16 Thread Maziar Parsijani
Hi, I have 3 questions on the below query: > SELECT searchsimpleenhanced.rowid, > > searchsimpleenhanced.*, > > fatrans.text AS trans, > > searchfast.text, > > highlight(fatrans, 0, '', '') mjp > > FROM searchsimpleenhanced > > JOIN > > fatrans ON fatrans.rowid = searchsimpleenhanced.rowid > >