Re: [sqlite] sha256sum function

2011-04-30 Thread Nico Williams
On Sat, Apr 30, 2011 at 3:19 PM, Mike Power wrote: > Does this exist in sqlite, my searching seems to indicate no.  Sqlite Right, SQLite3 doesn't ship with such a function. > has the ability to import functions has someone already done the work to > import a sha256sum function?  How is that done

Re: [sqlite] Clarification of ON CONFLICT in trigger bodies?

2011-04-30 Thread Nico Williams
A quick test shows that, indeed, an INSERT OR IGNORE inside a trigger that fails will not be ignored if the top-level statement has an OR ABORT (or rollback, or fail) clause. I can't imagine why one would ever want such behavior, but since I can live with it (as shown below), I'll just conclude th

[sqlite] sha256sum function

2011-04-30 Thread Mike Power
I could not seem to find a search function on the mailing list. So the question probably has already been answered. I want to have a sha256sum function that I can call in sqlite something like: select sha256sum('texty texty'); Does this exist in sqlite, my searching seems to indicate no. Sql

Re: [sqlite] BUG : round(x,y) not consistent

2011-04-30 Thread Luuk
On 30-04-2011 20:48, Simon Slavin wrote: > > On 29 Apr 2011, at 9:09pm, Jean-Marie CUAZ wrote: > >> Win XP + SQLite 3.7.4 >> >> SELECT round(8.875,2)-> 8.88 >> SELECT round(16.875,2) -> 16.87 >> SELECT round(32.875,2) -> 32.88 >> SELECT round(64.875,2) -> 64.87 > > T

Re: [sqlite] BUG : round(x,y) not consistent

2011-04-30 Thread Simon Slavin
On 29 Apr 2011, at 9:09pm, Jean-Marie CUAZ wrote: > Win XP + SQLite 3.7.4 > > SELECT round(8.875,2)-> 8.88 > SELECT round(16.875,2) -> 16.87 > SELECT round(32.875,2) -> 32.88 > SELECT round(64.875,2) -> 64.87 The documentation for SQLite does not mention what roundi

[sqlite] 1.0.71.0 and VB 2008 Express Edition - SQLite.Interop.dll cannot be found

2011-04-30 Thread Cyrille
Dear all, Until now, I was using the version 1.0.66.0 from phxsoftware website. I would like now to upgrade to version 1.0.71.0 as my software seems to have a bug linked to the dll. To use the last version with my application, I have proceeded like I did with the phxsoftware website. I have do

Re: [sqlite] Set minimum word/character length in FTS4?

2011-04-30 Thread Alexey Pechnikov
No. But you can create custom tokenizer for ignoring short words. 2011/4/28 skibulk : > > Hi, I know that you can set the minimum word size in MySQL. I.E. if you > querry "dog" and the Minimum character length is set to 4 you won't get any > results. Is this same customization option avaliable in

Re: [sqlite] BUG : round(x,y) not consistent

2011-04-30 Thread Pete Attkins
On 2011-04-30, at 13:36, Jos Groot Lipman wrote: > The rounding problem is documented in the FAQ: > http://www.sqlite.org/faq.html#q16 That reference does not address the issue of the four rounding modes of the Intel FPUs. SQLite being a library rather than a process, does SQLite control the

Re: [sqlite] EXT :Re: BUG : round(x,y) not consistent

2011-04-30 Thread Thilo Jeremias
On 30/04/2011 3:36 PM, Stephan Beal wrote: > On Sat, Apr 30, 2011 at 2:45 PM, Black, Michael (IS) > wrote: >> 3.75 on Redhat 5.6 does not have a problem. >> I get >> >> 8.88 >> 16.88 >> 32.88 >> 64.88 >> > Same on Ubuntu 11.04 x86/64 w/ sqlite3 3.7.4. > > Fixed in 3.7.5 maybe? I don't think so

Re: [sqlite] EXT :Re: BUG : round(x,y) not consistent

2011-04-30 Thread Stephan Beal
On Sat, Apr 30, 2011 at 2:45 PM, Black, Michael (IS) wrote: > 3.75 on Redhat 5.6 does not have a problem. > I get > > 8.88 > 16.88 > 32.88 > 64.88 > Same on Ubuntu 11.04 x86/64 w/ sqlite3 3.7.4. Fixed in 3.7.5 maybe? > It would seem to be platform-dependent. -- - stephan beal http://w

Re: [sqlite] BUG : round(x,y) not consistent

2011-04-30 Thread Luuk
On 30-04-2011 14:04, Luuk wrote: > On 29-04-2011 22:09, Jean-Marie CUAZ wrote: >> Win XP + SQLite 3.7.4 >> >> SELECT round(8.875,2)-> 8.88 >> SELECT round(16.875,2) -> 16.87 >> SELECT round(32.875,2) -> 32.88 >> SELECT round(64.875,2) -> 64.87 >> >> I'm not sure SQLite

Re: [sqlite] EXT :Re: BUG : round(x,y) not consistent

2011-04-30 Thread Black, Michael (IS)
3.75 on Redhat 5.6 does not have a problem. I get 8.88 16.88 32.88 64.88 Fixed in 3.7.5 maybe? Michael D. Black Senior Scientist NG Information Systems Advanced Analytics Directorate From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sq

Re: [sqlite] BUG : round(x,y) not consistent

2011-04-30 Thread Jos Groot Lipman
The rounding problem is documented in the FAQ: http://www.sqlite.org/faq.html#q16 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] BUG : round(x,y) not consistent

2011-04-30 Thread Luuk
On 29-04-2011 22:09, Jean-Marie CUAZ wrote: > Win XP + SQLite 3.7.4 > > SELECT round(8.875,2)-> 8.88 > SELECT round(16.875,2) -> 16.87 > SELECT round(32.875,2) -> 32.88 > SELECT round(64.875,2) -> 64.87 > > I'm not sure SQLite is the actual culprit (and I'm aware the su

[sqlite] SQLite FAQ typo

2011-04-30 Thread Jay Riddle
Let me know if this is not the right place for a typo on the SQLite FAQ. Should "...a UNIQUE constraint be enforced even of one or more of the columns..." instead read "...even if one or more..."? Thanks --JayR ___ sqlite-users mailing list sq

[sqlite] BUG : round(x,y) not consistent

2011-04-30 Thread Jean-Marie CUAZ
Win XP + SQLite 3.7.4 SELECT round(8.875,2)-> 8.88 SELECT round(16.875,2) -> 16.87 SELECT round(32.875,2) -> 32.88 SELECT round(64.875,2) -> 64.87 I'm not sure SQLite is the actual culprit (and I'm aware the subject is complicated) but it's annoying. Jean-Marie ___