[sqlite] Database corruption using zipvfs on android 64 bits (x86_64)

Alexandre Mainville wrote: > Hi, > > I am experiencing database corruption using zipvfs on android 64 > bits (x86_64). > The same program executing on 32 bits runs without problems. > > The program creates a new database on every run and does a series of > inserts and updates (always the same

[sqlite] Simple Math Question

> On Thursday, 22 October, 2015, at 13:45, Rousselot, Richard A > said: > Doing the following math, why is it that the results are not all returning > "yes"? > > SELECT > (9.2+7.9+0+4.0+2.6+1.3), > case when (9.2+7.9+0+4.0+2.6+1.3)=25.0 then "yes" else > "no"

[sqlite] FTS5 rank configuration option

On 11/06/2015 02:26 PM, chromedout64 at yahoo.com wrote: > The documentation says that a persistent rank can be set with > INSERT INTO ft(ft, rank) VALUES('rank', 'bm25(10.0, 5.0)'); > However, I can only get it to work on the same database connection as the > query. Subsequent database

[sqlite] field name in UDF

On Fri, Nov 6, 2015 at 7:04 PM, Nelson, Erik - 2 < erik.l.nelson at bankofamerica.com> wrote: > select quarter(t1.a) from t1 ; > > I might hope to get 'a' or 't1.a'. Any ideas? > UDFs (in any scripting environment) don't get that level of info. They only get passed the values resolved by

[sqlite] field name in UDF

On Fri, Nov 6, 2015 at 6:50 PM, Nelson, Erik - 2 < erik.l.nelson at bankofamerica.com> wrote: > I have a user-defined function something like > > void quarter_sqlite3(sqlite3_context *context, int argc, sqlite3_value > **argv); > > for each sqlite3_value being passed in, it would sometimes be

[sqlite] field name in UDF

Stephan Beal wrote on Friday, November 06, 2015 1:00 PM > On Fri, Nov 6, 2015 at 6:50 PM, Nelson, Erik - 2 wrote: > > > I have a user-defined function something like > > > > void quarter_sqlite3(sqlite3_context *context, int argc, > sqlite3_value > > **argv); > > > > for each sqlite3_value being

[sqlite] field name in UDF

I have a user-defined function something like void quarter_sqlite3(sqlite3_context *context, int argc, sqlite3_value **argv); for each sqlite3_value being passed in, it would sometimes be helpful to have the associated field (if any) that the value is associated with. Is there any way to

[sqlite] Non-transitive numeric equality

On 6 Nov 2015, at 2:20pm, Wade, William wrote: > I have an engineering application, where double can be part of a key. So do I, using Longitude and Latitude in GPS coordinates. A lot of things done inside GPS devices amount to "List everything in this rectangle". This is the problem.

[sqlite] Non-transitive numeric equality

I have an engineering application, where double can be part of a key. In cases where I do a comparison that implies a test for equality, I don't necessarily care what happens in the really close cases. SELECT x,y FROM mytable WHERE x >= 1234 AND x < 5678 There may be about a 1 records in

[sqlite] FTS5 External Content Table - REPLACE - SQL logic error or missing database

On 11/06/2015 12:36 PM, chromedout64 at yahoo.com wrote: > I noticed that this update is not included in the official 3.9.2 release. How > is it determined when an update such as this one gets included in a release? > Thanks for any info. Most likely as part of 3.10.0. You can always download

[sqlite] field name in UDF

On 11/6/2015 12:50 PM, Nelson, Erik - 2 wrote: > I have a user-defined function something like > > void quarter_sqlite3(sqlite3_context *context, int argc, sqlite3_value > **argv); > > for each sqlite3_value being passed in, it would sometimes be helpful to have > the associated field (if any)

[sqlite] Non-transitive numeric equality

On 11/6/2015 9:20 AM, Wade, William wrote: > However I do depend on getting consistent answers, and on (x >= 1234) being > disjoint from (x < 1234) and that those two ranges cover the number line. I > suspect that sqlite makes that kind of guarantee, at least if I explicitly > cast values to

[sqlite] Database corruption using zipvfs on android 64 bits (x86_64)

Hi, I am experiencing database corruption using zipvfs on android 64 bits (x86_64). The same program executing on 32 bits runs without problems. The program creates a new database on every run and does a series of inserts and updates (always the same series of operations). Both programs produce

[sqlite] FTS5 rank configuration option

The documentation says that a persistent rank can be set with INSERT INTO ft(ft, rank) VALUES('rank', 'bm25(10.0, 5.0)'); However, I can only get it to work on the same database connection as the query. Subsequent database connections seem to use the standard default ranking. Is this by design?

[sqlite] FTS5 External Content Table - REPLACE - SQL logic error or missing database

Great, that's exactly what I need, I'll give it a try.

[sqlite] FTS5 External Content Table - REPLACE - SQL logic error or missing database

I noticed that this update is not included in the official 3.9.2 release. How is it determined when an update such as this one gets included in a release? Thanks for any info.