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
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
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
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
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
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
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
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
8 matches
Mail list logo