Re: [sqlite] SQLite 3.7.16 beta

[Richard Hipp]

The draft website for SQLite version 3.7.16 can be seen on the
http://www.sqlite.org/draft/ page and its descendents.  The status board
for 3.7.16 (http://www.sqlite.org/checklists/3071600) is now all green,
meaning that all test cases have passed.  We are simply waiting to give
beta testers a few more days to check things out before we release the
official version 3.7.16.  If you have not done so already, please download
either the canonical source code, or an amalgamation snapshot from
http://www.sqlite.org/draft/download.html and try out SQLite version 3.7.16
in your application.   Let us know if you encounter any problems.  Please
do so soon as we will cut the 3.7.16 release very early on Monday.

Thank you for help.

-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite 3.7.16 beta

[Roger Binns]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On 12/03/13 17:28, Richard Hipp wrote:
> The next release is currently scheduled for Monday, 2013-03-18.
> 
> Please let us know as soon as possible if you see or suspect any issues
> in the current beta.  Thanks.

I can provide the opposite data.  My test suite extensively covers the
SQLite C API.  Everything looks good and I don't even remember the last
release there was a problem.

Roger

-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.11 (GNU/Linux)

iEYEARECAAYFAlE/2oUACgkQmOOfHg372QS3CwCfY/P+4IMyy6OCL3wrjkge3Z6k
MBUAoLtSOTTNjURgOAGH6HA77BDlHnH0
=/Evg
-END PGP SIGNATURE-
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite 3.7.16 beta

[Richard Hipp]

A logic bug was found today in the 3.7.16 beta.  The DESC operator was not
working on ORDER BY clauses under some obscure circumstances.  The bug has
now been fixed and new snapshots have have been uploaded.

New snapshots:  http://www.sqlite.org/draft/download.html
Bug details:http://www.sqlite.org/src/info/4dd95f6943fbd18

Thanks for all the documentation typo reports.  All of them should have
been fixed on the "draft" website and will be transferred over to the main
website when the release occurs.  Please feel free to send in further typo
reports at any time.

The next release is currently scheduled for Monday, 2013-03-18.

Please let us know as soon as possible if you see or suspect any issues in
the current beta.  Thanks.
-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite 3.7.16 beta

[Kevin Benson]

On Mon, Mar 11, 2013 at 11:48 AM, Richard Hipp  wrote:

>
>
> On Sat, Mar 2, 2013 at 11:29 AM, Richard Hipp  wrote:
> >
> > Please report any problems encountered.
> >
> > --
> > D. Richard Hipp
> > d...@sqlite.org


Some lunchtime reading resulted in this minutiae:

http://www.sqlite.org/draft/atomiccommit.html

S//from the one describe in this article//from the one described in this
article//

S//if a power lose or OS crash occurs//if a power loss or OS crash occurs//

S//This would make it appears as if//This would make it appear as if//

S//The idea behind a reserved locks is//The idea behind a reserved lock is//

S//takes up most the time required//takes up most of the time required//

S//described later make it appears as if//described later make it appear as
if//

S//The rollback journal exist.//The rollback journal exists.//

S//write that content back to were it//write that content back to where it//

S//where deleting a file is expense.//where deleting a file is expensive.//

S//journal is no long hot after this step.//journal is no longer hot after
this step.//

S//prevents other processes for accessing//prevents other processes from
accessing//

S//device manufactures with more control//device manufacturers with more
control//

S//during step 3.10 above//during step 3.10
above//

S//in step 3.7 is//in step 3.7 is//

S//in section 3.2 above//in section 3.2 above//

S//at step 4.2//at step
4.2


CHEERS
--
   --
  --
 --Ô¿Ô--
K e V i N
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite 3.7.16 beta

[Simon Slavin]

On 11 Mar 2013, at 3:48pm, Richard Hipp  wrote:

> http://www.sqlite.org/draft/download.html

I'm afraid all I can help with is point out a grammatical problem:

"and templates (2) is used"

I think should have 'templates' in the singular.

I add a note that release 3.7.4 was back in 2010.  Given that the naming 
convention has been in place for 2.5 years it may be time to remove the first 
two sentences from the 'Build Product Names' section.  Or it may not.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite 3.7.16 beta

[Richard Hipp]

Thanks, everyone, for your help in testing 3.7.16.  A number of problems
have been found and fixed.  Because of these problems, the anticipated
release of 3.7.16 has been delayed until one week from today (2013-03-18).

The draft website, and especially the amalgamation snapshot on the
http://www.sqlite.org/draft/download.html page, has been updated.  Please
continue to test (using the latest snapshot) and let us know as soon as
possible if find any further issues.  Thanks.

On Sat, Mar 2, 2013 at 11:29 AM, Richard Hipp  wrote:

> The anticipated release date for SQLite 3.7.16 is currently 2013-03-12.
> Additional information about the forthcoming 3.7.16 release:
>
>(1)  http://www.sqlite.org/draft/releaselog/3_7_16.html
>(2)  http://www.sqlite.org/draft/download.html
>(3)  http://www.sqlite.org/checklists/3071600
>
> See a summary of changes at (1).  Download a snapshot of the latest code
> (in the form of an amalgamation "sqlite3.c" source file) from (2).  The
> status board at (3) will show the current state of release testing.  When
> the status board goes all green, we will cut the release.  The links above,
> and indeed the entire http://www.sqlite.org/draft/ sub-website, will be
> updated periodically between now and the official release so check back
> frequently.
>
> Please report any problems encountered.
>
> --
> D. Richard Hipp
> d...@sqlite.org




-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite 3.7.16 beta

[Levi Haskell (BLOOMBERG/ 731 LEXIN)]

Hi Richard,

I don't see any mentioning of the optional table argument to the 
foreign_key_check pragma in: 
http://www.sqlite.org/draft/pragma.html#pragma_foreign_key_check

For example:

SQLite version 3.7.16 2013-03-02 03:25:55
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> create table p(k integer primary key);
sqlite> create table c(k int references p);
sqlite> insert into c values (1),(2),(3);
sqlite> pragma foreign_key_check(c);
c|1|p|0
c|2|p|0
c|3|p|0
sqlite> pragma foreign_key_check(p);
sqlite>

Thanks,
 - Levi

- Original Message -
From: sqlite-users@sqlite.org
To: sqlite-...@sqlite.org, sqlite-users@sqlite.org
At: Mar  2 2013 11:30:23

The anticipated release date for SQLite 3.7.16 is currently 2013-03-12.
Additional information about the forthcoming 3.7.16 release:

   (1)  http://www.sqlite.org/draft/releaselog/3_7_16.html
   (2)  http://www.sqlite.org/draft/download.html
   (3)  http://www.sqlite.org/checklists/3071600

See a summary of changes at (1).  Download a snapshot of the latest code
(in the form of an amalgamation "sqlite3.c" source file) from (2).  The
status board at (3) will show the current state of release testing.  When
the status board goes all green, we will cut the release.  The links above,
and indeed the entire http://www.sqlite.org/draft/ sub-website, will be
updated periodically between now and the official release so check back
frequently.

Please report any problems encountered.

-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite 3.7.16 beta

[Eric Sink]

FWIW:  I am working on a project which uses SQLite extensively.  We 
generally use 3.7.11 on our client side and 3.7.15.2 on our server. I 
just switched both to this 3.7.16 beta, and all our automated tests 
still pass.


--
E


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite 3.7.16 beta

[Richard Hipp]

On Sat, Mar 2, 2013 at 11:36 AM, Simon Slavin  wrote:

>
> On 2 Mar 2013, at 4:29pm, Richard Hipp  wrote:
>
> >   (1)  http://www.sqlite.org/draft/releaselog/3_7_16.html
>
> "Enhance the command-line shell so that a non-zero argument to the ".exit"
> command causes the shell to exist immediately without cleanly shutting down
> the database connection."
>
> I'm guessing 'exist' --> 'exit'.
>

Fixed.


>
> Simon.
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite 3.7.16 beta

[Simon Slavin]

On 2 Mar 2013, at 4:29pm, Richard Hipp  wrote:

>   (1)  http://www.sqlite.org/draft/releaselog/3_7_16.html

"Enhance the command-line shell so that a non-zero argument to the ".exit" 
command causes the shell to exist immediately without cleanly shutting down the 
database connection."

I'm guessing 'exist' --> 'exit'.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLite 3.7.16 beta

[Richard Hipp]

The anticipated release date for SQLite 3.7.16 is currently 2013-03-12.
Additional information about the forthcoming 3.7.16 release:

   (1)  http://www.sqlite.org/draft/releaselog/3_7_16.html
   (2)  http://www.sqlite.org/draft/download.html
   (3)  http://www.sqlite.org/checklists/3071600

See a summary of changes at (1).  Download a snapshot of the latest code
(in the form of an amalgamation "sqlite3.c" source file) from (2).  The
status board at (3) will show the current state of release testing.  When
the status board goes all green, we will cut the release.  The links above,
and indeed the entire http://www.sqlite.org/draft/ sub-website, will be
updated periodically between now and the official release so check back
frequently.

Please report any problems encountered.

-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users