Re: [sqlite] SQLite 3.15.0 scheduled for 2016-10-14

2016-09-29 Thread Dominique Devienne
On Thu, Sep 22, 2016 at 9:43 PM, Darren Duncan wrote: > On 2016-09-22 12:16 PM, Petite Abeille wrote: > >> >> On Sep 22, 2016, at 9:04 PM, Richard Hipp wrote: >>> >>> (https://www.sqlite.org/draft/releaselog/3_15_0.html). >>> >> >> Oh! Row Values!

Re: [sqlite] SQLite 3.15.0 scheduled for 2016-10-14

2016-09-29 Thread Dominique Devienne
On Thu, Sep 29, 2016 at 2:37 PM, James K. Lowden wrote: > On Fri, 23 Sep 2016 16:35:07 + > Quan Yong Zhai wrote: > > > Quote << > > A "row value" is an ordered list of two or more scalar values. In > > other words, a "row value" is a vector.>> > > > >

Re: [sqlite] SQLite 3.15.0 scheduled for 2016-10-14

2016-09-29 Thread James K. Lowden
On Fri, 23 Sep 2016 16:35:07 + Quan Yong Zhai wrote: > Quote << > A "row value" is an ordered list of two or more scalar values. In > other words, a "row value" is a vector.>> > > A ?row value? is a tuple, not a vector. When your using a tuple, you > know how many items in it,

Re: [sqlite] SQLite 3.15.0 scheduled for 2016-10-14

2016-09-26 Thread Simon Slavin
On 26 Sep 2016, at 10:14pm, Richard Hipp wrote: > The first test failure cause the process to exit with a non-zero return code. Good. Simon. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] SQLite 3.15.0 scheduled for 2016-10-14

2016-09-26 Thread Richard Hipp
On 9/26/16, Simon Slavin wrote: > > On 26 Sep 2016, at 9:42pm, Richard Hipp wrote: > >> Generates output: "testcase-100 ok". Or, it generates an error >> message if the expected result does not appear. > > Does it also change the exit code of the

Re: [sqlite] SQLite 3.15.0 scheduled for 2016-10-14

2016-09-26 Thread Simon Slavin
On 26 Sep 2016, at 9:42pm, Richard Hipp wrote: > Generates output: "testcase-100 ok". Or, it generates an error > message if the expected result does not appear. Does it also change the exit code of the application ? If it does then you can test the output in shell scripts

Re: [sqlite] SQLite 3.15.0 scheduled for 2016-10-14

2016-09-26 Thread Richard Hipp
On 9/26/16, David Raymond wrote: > So the .help on .testcase says: > .testcase NAME Begin redirecting output to 'testcase-out.txt' > > And .check says: > .check GLOBFail if output since .testcase does not match These dot-commands help in writing

Re: [sqlite] SQLite 3.15.0 scheduled for 2016-10-14

2016-09-26 Thread David Raymond
are? I don't see anything on them in the linked CLI page draft. https://www.sqlite.org/draft/cli.html -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Richard Hipp Sent: Thursday, September 22, 2016 3:04 PM To: General Discussion of SQLite Database Subjec

Re: [sqlite] SQLite 3.15.0 scheduled for 2016-10-14

2016-09-26 Thread Simon Slavin
> On 26 Sep 2016, at 7:48pm, Warren Young wrote: > >> ​What can I do to beta test? The other part of the question is "How do I download the beta-test version in order to beta-test it ?". For technical reasons, the download page in the /draft/ version of the web site

Re: [sqlite] SQLite 3.15.0 scheduled for 2016-10-14

2016-09-26 Thread Warren Young
On Sep 25, 2016, at 4:50 AM, Cecil Westerhof wrote: > > 2016-09-22 21:04 GMT+02:00 Richard Hipp : > >> Our current schedule for the next SQLite release (3.15.0) is for >> 2016-10-14. >> >> Your beta-tests are appreciated. > > ​What can I do to beta

Re: [sqlite] SQLite 3.15.0 scheduled for 2016-10-14

2016-09-25 Thread Cecil Westerhof
2016-09-22 21:04 GMT+02:00 Richard Hipp : > Our current schedule for the next SQLite release (3.15.0) is for > 2016-10-14. > > Your beta-tests are appreciated. ​What can I do to beta test? -- Cecil Westerhof ___ sqlite-users mailing

Re: [sqlite] SQLite 3.15.0 scheduled for 2016-10-14

2016-09-23 Thread David Raymond
lite.org] On Behalf Of Richard Hipp Sent: Thursday, September 22, 2016 3:04 PM To: General Discussion of SQLite Database Subject: [sqlite] SQLite 3.15.0 scheduled for 2016-10-14 Our current schedule for the next SQLite release (3.15.0) is for 2016-10-14. Your beta-tests are appreciated. You c

Re: [sqlite] SQLite 3.15.0 scheduled for 2016-10-14

2016-09-23 Thread Gerry Snyder
Just curious--will Tcl lists be usable as row values? Gerry Snyder On Thu, Sep 22, 2016 at 12:04 PM, Richard Hipp wrote: > Our current schedule for the next SQLite release (3.15.0) is for > 2016-10-14. > > Your beta-tests are appreciated. You can get a pre-release snapshot >

Re: [sqlite] SQLite 3.15.0 scheduled for 2016-10-14

2016-09-23 Thread Quan Yong Zhai
) or sqlite3_bind_vector() worth the effort. Zhai Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10 From: Dominique Devienne<mailto:ddevie...@gmail.com> Sent: 2016年9月23日 23:29 To: SQLite mailing list<mailto:sqlite-users@mailinglists.sqlite.org> Subj

Re: [sqlite] SQLite 3.15.0 scheduled for 2016-10-14

2016-09-23 Thread Dominique Devienne
On Fri, Sep 23, 2016 at 5:04 PM, Keith Medcalf wrote: > [...] bind the RHS of a IN operator of arbitrary size [...] > > A carray won't work for you? No. carray doesn't support blobs. The semantic of carray is fundamentally flawed for variable-sized values. And the

Re: [sqlite] SQLite 3.15.0 scheduled for 2016-10-14

2016-09-23 Thread Keith Medcalf
> For a long time, I've wanted to bind the RHS of a IN operator of arbitrary > size, > instead of > 1) having to hard-code the cardinality, e.g. IN (:1, :2); > 2) or use a tmp table to insert the values and use a subquery; > 3) somehow use an eponymous vtable as the RHS. > > None of which is

Re: [sqlite] SQLite 3.15.0 scheduled for 2016-10-14

2016-09-23 Thread Dominique Devienne
On Fri, Sep 23, 2016 at 1:39 PM, Richard Hipp wrote: > On 9/23/16, Dominique Devienne wrote: > > > > For a long time, I've wanted to bind the RHS of a IN operator of > arbitrary size, > > See the carray() table-valued function extension: >

Re: [sqlite] SQLite 3.15.0 scheduled for 2016-10-14

2016-09-23 Thread Richard Hipp
On 9/23/16, Dominique Devienne wrote: > > For a long time, I've wanted to bind the RHS of a IN operator of arbitrary > size, See the carray() table-valued function extension: https://www.sqlite.org/draft/carray.html -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] SQLite 3.15.0 scheduled for 2016-10-14

2016-09-23 Thread R Smith
On 2016/09/22 9:04 PM, Richard Hipp wrote: Our current schedule for the next SQLite release (3.15.0) is for 2016-10-14. 2.2. Row Values In UPDATE Statements Row values can also be used in the SET clause of an UPDATE statement. The RHS

Re: [sqlite] SQLite 3.15.0 scheduled for 2016-10-14

2016-09-23 Thread Clemens Ladisch
Petite Abeille wrote: > Oh! Row Values! Nice! :) This description exchanges "LHS" and "RHS". Regards, Clemens ___ sqlite-users mailing list

Re: [sqlite] SQLite 3.15.0 scheduled for 2016-10-14

2016-09-23 Thread Dominique Devienne
On Thu, Sep 22, 2016 at 9:04 PM, Richard Hipp wrote: > Our current schedule for the next SQLite release (3.15.0) is for > 2016-10-14. > [...] you can review the change log > (https://www.sqlite.org/draft/releaselog/3_15_0.html). > SQLite Release 3.15.0 (Pending) > > Added

Re: [sqlite] SQLite 3.15.0 scheduled for 2016-10-14

2016-09-22 Thread James K. Lowden
On Thu, 22 Sep 2016 12:43:29 -0700 Darren Duncan wrote: > single-element row could be done with say a trailing comma; eg > "(42,)" All hail the Python tuple! "Tuples of two or more items are formed by comma-separated lists of expressions. A tuple of one item

Re: [sqlite] SQLite 3.15.0 scheduled for 2016-10-14

2016-09-22 Thread Darren Duncan
On 2016-09-22 12:16 PM, Petite Abeille wrote: On Sep 22, 2016, at 9:04 PM, Richard Hipp wrote: (https://www.sqlite.org/draft/releaselog/3_15_0.html). Oh! Row Values! Nice! :) https://www.sqlite.org/draft/rowvalue.html I second that, its a valuable feature to have.

Re: [sqlite] SQLite 3.15.0 scheduled for 2016-10-14

2016-09-22 Thread Petite Abeille
> On Sep 22, 2016, at 9:04 PM, Richard Hipp wrote: > > (https://www.sqlite.org/draft/releaselog/3_15_0.html). Oh! Row Values! Nice! :) https://www.sqlite.org/draft/rowvalue.html ___ sqlite-users mailing list

[sqlite] SQLite 3.15.0 scheduled for 2016-10-14

2016-09-22 Thread Richard Hipp
Our current schedule for the next SQLite release (3.15.0) is for 2016-10-14. Your beta-tests are appreciated. You can get a pre-release snapshot from the download page (https://www.sqlite.org/download.html) and you can review the change log (https://www.sqlite.org/draft/releaselog/3_15_0.html).