[sqlite] fts4 support in distributions of SQLite?

Greetings, I'm working on an app that may end up open sourced and released publicly for others to use. It uses SQLite and the records have a comments field for which I'd like to use a fts4 vtable to enable search. My few test systems show that support for fts4 is present, but I'm trying to learn

[sqlite] db File Remains Open After Connection is Closed

Hi Ray, Sqlite.Net implements a connection pooling scheme. Even when your connection is closed, the unmanaged database handle may still be open. After you have disposed of your connection object and are ready to do file-level operations, do something like this:

[sqlite] Libstringmetrics

Dear all, I have some problems with https://github.com/aperi2007/libstringmetrics . For example: When I use "similarity" in qgrams_distance, I get good results. But when I use "metric", it works only if it is only once in the query. When there are 2 different usages, they somehow interfere

[sqlite] Virtual Table BestIndex Bug in system.data.sqlite/sqlite with 'like'

On 2015-03-06 03:19 PM, Richard Hipp wrote: > Yikes! Actually (1) cannot be determined for normal (non-virtual) > tables either because the value could be a BLOB even if the column > affinity is TEXT. And so the current LIKE optimization is not valid > *ever*. See ticket

[sqlite] Virtual Table BestIndex Bug in system.data.sqlite/sqlite with 'like'

Using LIKE on a BLOB is not the problem. It is the LIKE optimization that is broken, because it requires a BLOB to sort AFTER a text, which is never the case, while the LIKE function compares an expression that may contain wildcards to the raw data, which may be the case. -Urspr?ngliche

[sqlite] Virtual Table BestIndex Bug in system.data.sqlite/sqlite with 'like'

On Fri, Mar 6, 2015 at 1:21 PM, Hick Gunter wrote: > And then there remain to be considered the effects of the pragma > CASE_SENSITIVE_LIKE > Good point. But that's no different from the case when an application overrides the LIKE behavior via a custom function, and the vtable can similarly

[sqlite] Virtual Table BestIndex Bug in system.data.sqlite/sqlite with 'like'

And then there remain to be considered the effects of the pragma CASE_SENSITIVE_LIKE -Urspr?ngliche Nachricht- Von: Dominique Devienne [mailto:ddevienne at gmail.com] Gesendet: Freitag, 06. M?rz 2015 10:30 An: General Discussion of SQLite Database Betreff: Re: [sqlite] Virtual Table

[sqlite] Virtual Table BestIndex Bug in system.data.sqlite/sqlite with 'like'

On 2015-03-06 09:42 AM, Dominique Devienne wrote: > On Thu, Mar 5, 2015 at 7:45 PM, Richard Hipp wrote: > >> >> The LIKE operator can be overridden by the application to mean >> anything the application wants - it is not compelled to follow >> standard SQL semantics. For that reason, virtual

[sqlite] Virtual Table BestIndex Bug in system.data.sqlite/sqlite with 'like'

On Fri, Mar 6, 2015 at 10:12 AM, R.Smith wrote: > On 2015-03-06 09:42 AM, Dominique Devienne wrote: > >> On Thu, Mar 5, 2015 at 7:45 PM, Richard Hipp wrote: >> >> >>> The LIKE operator can be overridden by the application to mean >>> anything the application wants - it is not compelled to

[sqlite] update of view via trigger

On 3/5/2015 11:58 PM, Igor Tandetnik wrote: > If the latter is OK, then you can have a single trigger doing something > like this: > > insert or replace into Clean(X, Y, Z) > select > case when new.X = ifnull(c.X, d.X) then c.X else new.X end, > case when new.Y = ifnull(c.Y, d.Y) then c.Y

[sqlite] Corrupted database

Hi Dave, ? thanks. In fact, I know, how to repair the database and get access to the data. What I was trying to track down a bit, is the reason for the database to get corrupted. But as Simon explained, this might have to do with "in-order-writing" of the RAID we're using. ? Alex ? ?

[sqlite] Corrupted database

Hi Simon, >So from all the above it's likely that the data in your tables is okay >, and only the indexes in that file are corrupt. ?So dropping and >?recreating your indexes should fix the file perfectly unless the >?violation of the UNIQUE requirement is in the primary index for a table. ? Yes,

[sqlite] update of view via trigger

On Mar 6, 2015 7:33 AM, "Igor Tandetnik" wrote: A bunch of good stuff snipped... Thanks for the alternative suggestions. In thinking it over since my message, I've decided the multiple trigger approach isn't at all bad. A little verbose, but each column of the view has its own callback and

[sqlite] Virtual Table BestIndex Bug in system.data.sqlite/sqlite with 'like'

On Thu, Mar 5, 2015 at 7:45 PM, Richard Hipp wrote: > On 3/5/15, Mike Nicolino wrote: > > I'm using System.Data.SQLite version 1.0.95.0 and have what appears to > be a > > bug with Virtual Tables. Queries using 'like' in the where clause are > not > > getting the like clause passed to

[sqlite] Sqlite3 Bug Found

Hello, I was working on version 3.8.8.2 of sqlite3 and I found a bug that is trace related. It can be reproduced in 3 steps: 1. ".t log" - opens log for tracing 2. ".t" - no argument. Closes the file descriptor that was previously opened (Problem) 3. ".d" - dumps into the

[sqlite] Virtual Table BestIndex Bug in system.data.sqlite/sqlite with 'like'

On 3/6/15, Dominique Devienne wrote: > > Sure. But SQLite knows whether LIKE is overriden by the application or not, > so shouldn't it only hide LIKE from the virtual table when it detects it, > instead of wholesale preventing the vtable from optimizing the "normal > semantic" LIKE case? It's

[sqlite] db File Remains Open After Connection is Closed

Please also note that setting an object to 'nothing' does _not_ dispose it! This was the case back in the VB6 days, but in the .NET world you need to enclose all objects implementing 'IDisposable' in a 'using' block or call Dispose() explicitly on all your objects to properly release any

[sqlite] db File Remains Open After Connection is Closed

Hi Ray, At the point when you attempt to delete the folder, if you brake your program there, are you able to delete it via standard windows explorer? If not, how about closing your program, and trying directly after you exit your program? Sometimes an anti-virus or other tool (such as