Re: [sqlite] Minor glitch in FTS5 docs

On 12/15/2018 08:45 AM, Jens Alfke wrote: At https://sqlite.org/fts5.html#synonym_support : There are several ways to approach this in FTS5: 1. By mapping all synonyms to a single token. […] 2. By adding multiple synonyms for a single term to the

Re: [sqlite] Question about floating point

On Dec 15, 2018, at 08.58, Jay Kreibich wrote: > > > On Dec 15, 2018, at 12:49 AM, Frank Millman wrote: > > > > I know that floating point is not precise and not suitable for financial > > uses. Even so, I am curious about the following - > > [...] > > > > With the same version of sqlite3

Re: [sqlite] Question about floating point

> On Dec 15, 2018, at 12:49 AM, Frank Millman wrote: > > Hi all > > I know that floating point is not precise and not suitable for financial > uses. Even so, I am curious about the following - > > SQLite version 3.26.0 2018-12-01 12:34:55 > Enter ".help" for usage hints. > Connected to a

[sqlite] Question about floating point

Hi all I know that floating point is not precise and not suitable for financial uses. Even so, I am curious about the following - SQLite version 3.26.0 2018-12-01 12:34:55 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent

[sqlite] Minor glitch in FTS5 docs

At https://sqlite.org/fts5.html#synonym_support : > There are several ways to approach this in FTS5: > 1. By mapping all synonyms to a single token. […] > 2. By adding multiple synonyms for a single term to the FTS index. […] > 3.

Re: [sqlite] Updating Folder_Path in Windows 10 Photos App

On Friday, 14 December, 2018 10:09, Luuk wrote: >On 14-12-2018 16:54, Keith Medcalf wrote: >> You get the message about missing collating sequences because the >> database is using collating sequences that you don't have (ie, are >> missing) in your version of SQLite3. >Extensioon in SQLite,

Re: [sqlite] Updating Folder_Path in Windows 10 Photos App

On 14-12-2018 16:54, Keith Medcalf wrote: You get the message about missing collating sequences because the database is using collating sequences that you don't have (ie, are missing) in your version of SQLite3. Extensioon in SQLite, thats somewhere on my TODO list ;) Is there any

Re: [sqlite] Updating Folder_Path in Windows 10 Photos App

You get the message about missing collating sequences because the database is using collating sequences that you don't have (ie, are missing) in your version of SQLite3. --- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume.

Re: [sqlite] Grouping guidance

https://xkcd.com/2078/ -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Joseph L. Casale Sent: Thursday, December 13, 2018 5:58 PM To: SQLite mailing list Subject: Re: [sqlite] Grouping guidance -Original Message- From:

Re: [sqlite] Updating Folder_Path in Windows 10 Photos App

On 14 Dec 2018, at 10:41am, Luuk wrote: > When SQLite realises it can't use that index, should it revert to a full > table scan? That's the bigger question. My theory is that SQLite doesn't want to touch that database unless it has all the collations it will need. So it errors out the

Re: [sqlite] Updating Folder_Path in Windows 10 Photos App

On 14-12-2018 11:22, Simon Slavin wrote: On 14 Dec 2018, at 10:15am, Luuk wrote: why do i get 'no collation sequence' with this statement: sqlite> select Folder_Path from Folder; Error: no such collation sequence: NoCaseUnicode There's a UNIQUE index for Folder_Path COLLATE NoCaseUnicode.

Re: [sqlite] Updating Folder_Path in Windows 10 Photos App

On 14 Dec 2018, at 10:15am, Luuk wrote: > why do i get 'no collation sequence' with this statement: > > sqlite> select Folder_Path from Folder; > Error: no such collation sequence: NoCaseUnicode There's a UNIQUE index for Folder_Path COLLATE NoCaseUnicode. Iterating through that index would

Re: [sqlite] Updating Folder_Path in Windows 10 Photos App

On 14-12-2018 11:15, Luuk wrote: On 13-12-2018 18:26, Simon Slavin wrote: On 13 Dec 2018, at 2:57pm, Carlo capaldo wrote: UPDATE folder     SET Folder_Path = 'E:\Photos' would change the directory references in all existing 16 rows currently containing Folder_Path references to the

Re: [sqlite] Updating Folder_Path in Windows 10 Photos App

On 13-12-2018 18:26, Simon Slavin wrote: On 13 Dec 2018, at 2:57pm, Carlo capaldo wrote: UPDATE folder SET Folder_Path = 'E:\Photos' would change the directory references in all existing 16 rows currently containing Folder_Path references to the wrong locations to the correct

Re: [sqlite] Updating Folder_Path in Windows 10 Photos App

Simon, Thank you again for the time you've spent on this and the recommendations below, it's really appreciated. Kind regards, Carlo. From: sqlite-users on behalf of Simon Slavin Sent: 13 December 2018 17:26 To: SQLite mailing list Subject: Re: [sqlite]