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 seri
> 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" en
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 connection
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 th
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 help
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 p
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 retrie
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. Theore
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 th
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 t
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) th
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 dou
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
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?
Great, that's exactly what I need, I'll give it a try.
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.
16 matches
Mail list logo