[sqlite] Problem with sqldiff

2015-11-07 Thread John G
I saw sqldiff mentioned and decided to try it (compiled from sqlite-src-3090200) and got an SQL error. ./sqldiff: SQL statement error: near "1": syntax error "SELECT B.rowid, 1, -- changed row A.id IS NOT B.id, B.id, A."desc" IS NOT B."desc", B."desc" FROM main.A A, aux.A B WHERE

[sqlite] Simple Math Question

2015-11-07 Thread Keith Medcalf
On Saturday, 7 November, 2015 09:08, James K. Lowden wrote: > On Fri, 06 Nov 2015 22:16:57 -0700 > "Keith Medcalf" wrote: > > I wrote a function called "ulps" which can be used as an extension to > > SQLite3 > Bravo, Keith! > One suggestion, if I may. If you expect "ulps" to be used to test

[sqlite] Problem with sqldiff

2015-11-07 Thread Richard Hipp
On 11/7/15, John G wrote: > I saw sqldiff mentioned and decided to try it (compiled from > sqlite-src-3090200) and got an SQL error. > Please try the latest trunk version (https://www.sqlite.org/src/artifact/37ab2cd4f0c8b4f0) and let us know if that fails to solve your problem. -- D. Richard Hi

[sqlite] Simple Math Question

2015-11-07 Thread James K. Lowden
On Fri, 06 Nov 2015 22:16:57 -0700 "Keith Medcalf" wrote: > I wrote a function called "ulps" which can be used as an extension to > SQLite3 Bravo, Keith! One suggestion, if I may. If you expect "ulps" to be used to test for equality, perhaps it would be more convenient to ignore the sign. So

[sqlite] field name in UDF

2015-11-07 Thread Stephan Beal
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

[sqlite] Simple Math Question

2015-11-07 Thread Luuk
On 23-10-15 16:39, Dominique Devienne wrote: > On Fri, Oct 23, 2015 at 4:16 PM, Rousselot, Richard A < > Richard.A.Rousselot at centurylink.com> wrote: > >> So I decided to output 1000 digits, because why not? So now I am more >> perplexed with all these digits showing it is working the opposite

[sqlite] Simple Math Question

2015-11-07 Thread Igor Tandetnik
On 11/7/2015 3:47 AM, Luuk wrote: > I was reading this thread just now. > > sqlite> select 9.2+7.9+0+4.0+2.6+1.3-25.0, (9.2+7.9)+(0+4.0+2.6+1.3-25.0); > 3.5527136788005e-15|0.0 > > ;) > > > (the reasons are probably explained in the parts of the thread that i > did not read ;) Among other quir

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

2015-11-07 Thread Dan Kennedy
On 11/06/2015 11:57 PM, 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 update