Re: [sqlite] SQLite 3.6.0 coming soon...

2008-07-12 Thread D. Richard Hipp
On Jul 12, 2008, at 5:34 PM, Virgilio Fornazin wrote: > These mutex changes, with sqlite3_initialize() / finalize() calls, > will > solve that problem reported that SQlite3 doesn't delete Critical > Sections > under MS-Windows VFS ? The new interface is designed to solve problems such as

Re: [sqlite] SQLite 3.6.0 coming soon...

2008-07-12 Thread Doug
And Section 2.0 has: "Partually or fully disable" > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Shawn Wilsher > Sent: Saturday, July 12, 2008 4:49 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] SQLite 3.6.0 coming soon...

Re: [sqlite] SQLite 3.6.0 coming soon...

2008-07-12 Thread Shawn Wilsher
I believe there is a typo in Section 1.1 in 1.c. You have "filesyste-specific" where I think you mean "filesystem-specific". Cheers, Shawn On Sat, Jul 12, 2008 at 5:00 PM, D. Richard Hipp <[EMAIL PROTECTED]> wrote: > The current plan is to release SQLite version 3.6.0 on Wednesday, >

Re: [sqlite] SQLite 3.6.0 coming soon...

2008-07-12 Thread Virgilio Fornazin
These mutex changes, with sqlite3_initialize() / finalize() calls, will solve that problem reported that SQlite3 doesn't delete Critical Sections under MS-Windows VFS ? On Sat, Jul 12, 2008 at 6:00 PM, D. Richard Hipp <[EMAIL PROTECTED]> wrote: > The current plan is to release SQLite version

Re: [sqlite] Using real

2008-07-12 Thread Radovan Antloga
I found that using cast(round(x * 100) as integer) will give me result I want. Thank you ! RA - Original Message - From: "D. Richard Hipp" <[EMAIL PROTECTED]> To: "General Discussion of SQLite Database" Sent: Saturday, July 12, 2008 10:54 PM Subject: Re:

[sqlite] SQLite 3.6.0 coming soon...

2008-07-12 Thread D. Richard Hipp
The current plan is to release SQLite version 3.6.0 on Wednesday, 2008-07-16. Draft documentation on version 3.6.0 is available at http://www.sqlite.org/draft/doc/index.html . Please pay particular attention to: http://www.sqlite.org/draft/doc/35to36.html If you sees any problems with

Re: [sqlite] Using real

2008-07-12 Thread D. Richard Hipp
On Jul 12, 2008, at 4:41 PM, Radovan Antloga wrote: > please check this sql: > > select cast((2.3 * 100) as integer), cast(round(2.3 * 100) as > integer), 2.3 * 100, cast(230.0 as integer) > > Is this proper behaviour ? > Yes it is. The CASE(* AS INTEGER) operation rounds toward zero. And

[sqlite] Using real

2008-07-12 Thread Radovan Antloga
please check this sql: select cast((2.3 * 100) as integer), cast(round(2.3 * 100) as integer), 2.3 * 100, cast(230.0 as integer) Is this proper behaviour ? Thanks in advance, RA ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] patch to allow integer rtree keys

2008-07-12 Thread Russell Leighton
On Jul 12, 2008, at 11:08 AM, Dan wrote: > > On Jul 12, 2008, at 2:42 AM, Steve Friedman wrote: > >> >> >> Filip Navara wrote: >>> how about actually attaching the patch? :) >>> >>> - Filip >>> >>> On Fri, Jul 11, 2008 at 9:23 PM, Steve Friedman >>> <[EMAIL PROTECTED]> wrote: I've just

Re: [sqlite] patch to allow integer rtree keys

2008-07-12 Thread Stephen Woodbridge
Dan wrote: > On Jul 12, 2008, at 2:42 AM, Steve Friedman wrote: > >> >> Filip Navara wrote: >>> how about actually attaching the patch? :) >>> >>> - Filip >>> >>> On Fri, Jul 11, 2008 at 9:23 PM, Steve Friedman >>> <[EMAIL PROTECTED]> wrote: I've just started using the rtree extension, and

Re: [sqlite] patch to allow integer rtree keys

2008-07-12 Thread Dan
On Jul 12, 2008, at 2:42 AM, Steve Friedman wrote: > > > Filip Navara wrote: >> how about actually attaching the patch? :) >> >> - Filip >> >> On Fri, Jul 11, 2008 at 9:23 PM, Steve Friedman >> <[EMAIL PROTECTED]> wrote: >>> I've just started using the rtree extension, and have found that