[sqlite] SQLite version 3.8.12 enters testing

2015-10-08 Thread Zsbán Ambrus
On Wed, Oct 7, 2015 at 9:42 PM, Richard Hipp wrote: > On 10/7/15, Zsb?n Ambrus wrote: > New documentation covering indexes on expressions has been added. > Please let me know if you think more is needed. Thanks, that's much better. The "http://sqlite.org/draft/expridx.html; documentation tells

[sqlite] SQLite version 3.8.12 enters testing

2015-10-08 Thread Dominique Devienne
On Wed, Oct 7, 2015 at 11:01 PM, R.Smith wrote: > [...] (Brilliant release btw, thanks) > +1 > [...] This definitely feels like a 3.9 release rather than a 3.8.12. I > mean it introduces functionality that a 3.8.11 engine won't be able to > comprehend - and not just one obscure item either. >

[sqlite] SQLite version 3.8.12 enters testing

2015-10-08 Thread Richard Hipp
On 10/8/15, Zsb?n Ambrus wrote: > > There is one apparent inconsistency I was wondering about. For a > partial index, the WHERE clause of the index cannot contain functions; > whereas for an index on an expression, the expression can contain > deterministic functions. What is the explanation of

[sqlite] SQLite version 3.8.12 enters testing

2015-10-08 Thread R.Smith
Some notes on 3.8.12: (Brilliant release btw, thanks) I've been following the thread about the version numbering, and at first thought the OP was a little over-enthusiastic about increasing version numbers prematurely, but then after reading the release notes, I have to agree to some extent -

[sqlite] SQLite version 3.8.12 enters testing

2015-10-07 Thread Simon Slavin
On 7 Oct 2015, at 8:42pm, Richard Hipp wrote: > New documentation covering indexes on expressions has been added. > Please let me know if you think more is needed. I tentatively suggest that modifications be made to the text describing

[sqlite] SQLite version 3.8.12 enters testing

2015-10-07 Thread Peter Aronson
Currently if you have a check constraint with a user-defined function that is not defined in the current environment, you can not execute any SQL statements in that database -- you get the same error you get with features not supported in the current release. ?I suspect the same thing would

[sqlite] SQLite version 3.8.12 enters testing

2015-10-07 Thread Peter Aronson
I assume, like with similar enhancements, a database created at SQLite 3.8.12 with an expression index will be unreadable with earlier versions of SQLite? ?As, for instance, a database created at 3.8.11 with an index with a where clauses causes SQLite 3.715.2 to fail when trying execute any SQL

[sqlite] SQLite version 3.8.12 enters testing

2015-10-07 Thread Zsbán Ambrus
On Wed, Oct 7, 2015 at 4:42 PM, Richard Hipp wrote: > A preliminary change log for version 3.8.12 can be seen at > https://www.sqlite.org/draft/releaselog/3_8_12.html and preliminary > documentation can be seen at https://www.sqlite.org/draft/ > > If you have issues or concerns with the current

[sqlite] SQLite version 3.8.12 enters testing

2015-10-07 Thread Dominique Devienne
On Wed, Oct 7, 2015 at 4:42 PM, Richard Hipp wrote: > The release checklist for version 3.8.12 > (https://www.sqlite.org/checklists/3081200/index) is now active. The > 3.8.12 release will occur when the checklist goes all-green. > > A preliminary change log for version 3.8.12 can be seen at >

[sqlite] SQLite version 3.8.12 enters testing

2015-10-07 Thread Scott Robison
On Wed, Oct 7, 2015 at 3:00 PM, Darren Duncan wrote: > Semantic versioning in general doesn't have any specific format, it just > means that within a project the succession of version numbers conveys > information by itself. There's no requirement there has to be 3 parts or > whatever. I

[sqlite] SQLite version 3.8.12 enters testing

2015-10-07 Thread Richard Hipp
On 10/7/15, Peter Aronson wrote: > I assume, like with similar enhancements, a database created at SQLite > 3.8.12 with an expression index will be unreadable with earlier versions of > SQLite? As, for instance, a database created at 3.8.11 with an index with a > where clauses causes SQLite

[sqlite] SQLite version 3.8.12 enters testing

2015-10-07 Thread Richard Hipp
On 10/7/15, Zsb?n Ambrus wrote: > > I have concerns with the [indexes on expressions] documentation. > New documentation covering indexes on expressions has been added. Please let me know if you think more is needed. -- D. Richard Hipp drh at sqlite.org

[sqlite] SQLite version 3.8.12 enters testing

2015-10-07 Thread Darren Duncan
Semantic versioning in general doesn't have any specific format, it just means that within a project the succession of version numbers conveys information by itself. There's no requirement there has to be 3 parts or whatever. I consider SQLite's versioning scheme to both be very appropriate

[sqlite] SQLite version 3.8.12 enters testing

2015-10-07 Thread Richard Hipp
On 10/7/15, Dominique Devienne wrote: > > Could you please provide links to the amalgamation? TIA, --DD https://www.sqlite.org/download.html - the first link at the top of the list of products. -- D. Richard Hipp drh at sqlite.org

[sqlite] SQLite version 3.8.12 enters testing

2015-10-07 Thread Richard Hipp
The release checklist for version 3.8.12 (https://www.sqlite.org/checklists/3081200/index) is now active. The 3.8.12 release will occur when the checklist goes all-green. A preliminary change log for version 3.8.12 can be seen at https://www.sqlite.org/draft/releaselog/3_8_12.html and