RE: [sqlite] Version 3.2.6

2005-09-22 Thread Thomas Briggs 

   CVS HEAD now compiles clean on Solaris, but the link line for the CLI
tool (or any application linking against the SQLite library) needs to
include -lposix4 in order to link correctly.

   -Tom

> -Original Message-
> From: D. Richard Hipp [mailto:[EMAIL PROTECTED] 
> Sent: Thursday, September 22, 2005 11:41 AM
> To: sqlite-users@sqlite.org
> Subject: RE: [sqlite] Version 3.2.6
> 
> Please try the patch at http://www.sqlite.org/cvstrac/chngview?cn=2732
> and let me know if this fixes the fdatasync problem on Solaris and
> OpenBSD.
> 
> On Thu, 2005-09-22 at 10:33 -0400, Thomas Briggs wrote:
> >Solaris also does not support fdatasync, and as such 
> doesn't compile
> > without this workaround. 
> > 
> > > -Original Message-
> > > From: Jolan Luff [mailto:[EMAIL PROTECTED] 
> > > Sent: Saturday, September 17, 2005 4:14 PM
> > > To: sqlite-users@sqlite.org
> > > Subject: Re: [sqlite] Version 3.2.6
> > > 
> > > On Sat, Sep 17, 2005 at 03:41:21PM -0400, D. Richard Hipp wrote:
> > > > Version 3.2.6 is now available on the website
> > > 
> > > 3.2.6 does not compile on FreeBSD and OpenBSD because 
> they do not have
> > > fdatasync().  AFAICT, NetBSD's fdatasync implementation 
> does the same
> > > thing as fsync.
> > > 
> > 
> 
>

RE: [sqlite] Version 3.2.6

2005-09-22 Thread D. Richard Hipp 
Please try the patch at http://www.sqlite.org/cvstrac/chngview?cn=2732
and let me know if this fixes the fdatasync problem on Solaris and
OpenBSD.

On Thu, 2005-09-22 at 10:33 -0400, Thomas Briggs wrote:
>Solaris also does not support fdatasync, and as such doesn't compile
> without this workaround. 
> 
> > -Original Message-
> > From: Jolan Luff [mailto:[EMAIL PROTECTED] 
> > Sent: Saturday, September 17, 2005 4:14 PM
> > To: sqlite-users@sqlite.org
> > Subject: Re: [sqlite] Version 3.2.6
> > 
> > On Sat, Sep 17, 2005 at 03:41:21PM -0400, D. Richard Hipp wrote:
> > > Version 3.2.6 is now available on the website
> > 
> > 3.2.6 does not compile on FreeBSD and OpenBSD because they do not have
> > fdatasync().  AFAICT, NetBSD's fdatasync implementation does the same
> > thing as fsync.
> > 
>

RE: [sqlite] Version 3.2.6

2005-09-22 Thread Thomas Briggs 

   Solaris also does not support fdatasync, and as such doesn't compile
without this workaround. 

> -Original Message-
> From: Jolan Luff [mailto:[EMAIL PROTECTED] 
> Sent: Saturday, September 17, 2005 4:14 PM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Version 3.2.6
> 
> On Sat, Sep 17, 2005 at 03:41:21PM -0400, D. Richard Hipp wrote:
> > Version 3.2.6 is now available on the website
> 
> 3.2.6 does not compile on FreeBSD and OpenBSD because they do not have
> fdatasync().  AFAICT, NetBSD's fdatasync implementation does the same
> thing as fsync.
>

Re: [sqlite] Version 3.2.6

2005-09-17 Thread Jolan Luff 
On Sat, Sep 17, 2005 at 03:41:21PM -0400, D. Richard Hipp wrote:
> Version 3.2.6 is now available on the website

3.2.6 does not compile on FreeBSD and OpenBSD because they do not have
fdatasync().  AFAICT, NetBSD's fdatasync implementation does the same
thing as fsync.

[sqlite] Version 3.2.6

2005-09-17 Thread D. Richard Hipp 
Version 3.2.6 is now available on the website

http://www.sqlite.org/

This version fixes a bug that might cause database
corruption if you VACUUM a database larger than 1GiB
but the vacuum aborts and tries to rollback.  

Also in this version:

   The ORDER BY and GROUP BY process was completely
   rewritten.

   COUNT(DISTINCT) is now supported.

   The LIKE operator might use indices to speed its
   search if the column being searched uses COLLATE NOCASE.

   Lots of smaller bug fixes and miscellaneous 
   enhancements.
-- 
D. Richard Hipp <[EMAIL PROTECTED]>