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] Request for help with SQLite Query to return missing Date/Time Ranges

2011-04-21 Thread Pete Attkins
On 2011-04-21, at 17:13, H. Phil Duby wrote: > [...] > With possible 'adjustments' for switching to daylight savings time and > back, depending on what timezone the original data is stored in. If > it was UTC, then no problem. But if it was in you local timezone, that > used daylight savings tim

Re: [sqlite] Corruption on many Windows XP hosts

2011-04-13 Thread Pete Attkins
On 2011-04-13, at 15:53, Richard Hipp wrote: > On Wed, Apr 13, 2011 at 10:33 AM, Simon Slavin > wrote: > >> >> On 13 Apr 2011, at 12:14pm, James Green wrote: >> >>> sync=full does not work well for our app (no transactions). Far >>> too slow. >> >> If you're not syncing, then section 3.2 of

Re: [sqlite] Corruption on many Windows XP hosts

2011-04-13 Thread Pete Attkins
On 2011-04-13, at 15:25, Richard Hipp wrote: > On Wed, Apr 13, 2011 at 9:53 AM, Pavel Ivanov > wrote: > >>> The fact that one engineer installed a site, began operating the >>> app, >>> then saw it become corrupt minutes later rules out power loss or >>> hard >>> resets in at least that ca