Re: [sqlite] An artificial query whose outcome is changed after left join reduction

2018-04-10 Thread Graham Holden
0) To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> Subject: Re: [sqlite] An artificial query whose outcome is changed after   left join reduction Off Topic Addendum: Last night I wrote up a new document [1] on why the SQLite project does not use Git.  The URL above (https

Re: [sqlite] An artificial query whose outcome is changed after left join reduction

2018-04-10 Thread Richard Hipp
On 4/10/18, E.Pasma wrote: > Hello, the nature of this case is purely artificial and I thought it > is worth considering in the light of real world problem as reported by > Raphael Michel. E Pasma > > .version > SQLite 3.23.0 2018-03-24 13:24:02 >

Re: [sqlite] An artificial query whose outcome is changed after left join reduction

2018-04-10 Thread David Raymond
? -Original Message- From: David Raymond Sent: Tuesday, April 10, 2018 10:41 AM To: SQLite mailing list Subject: RE: [sqlite] An artificial query whose outcome is changed after left join reduction That's weird. My compiled CLI for 3.23 gets what you're showing for 3.22 SQLite version 3.23.0 2018

Re: [sqlite] An artificial query whose outcome is changed after left join reduction

2018-04-10 Thread David Raymond
o 0 1 000 Run Time: real 0.047 user 0.00 sys 0.00 sqlite> -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of E.Pasma Sent: Tuesday, April 10, 2018 10:24 AM To: SQLite mailing list Subject:

[sqlite] An artificial query whose outcome is changed after left join reduction

2018-04-10 Thread E.Pasma
Hello, the nature of this case is purely artificial and I thought it is worth considering in the light of real world problem as reported by Raphael Michel. E Pasma .version SQLite 3.23.0 2018-03-24 13:24:02 cf171abe954a5f25262161dd69f2e8cecdbf9446c3f6b298201507dbc743567e zlib version