[sqlite] Likelihood() in Left Join affecting results

On Thu, Jun 18, 2015 at 4:34 PM, Richard Hipp wrote: > Thanks for the bug report. The problem is now fixed on trunk. > > On 6/18/15, Jean Chevalier wrote: >> The likelihood() function, which should help select a query plan but >> otherwise be logic-neutral, nevertheless seems to affect results r

[sqlite] Likelihood() in Left Join affecting results

On 7/6/15, Zsb?n Ambrus wrote: > On Thu, Jun 18, 2015 at 4:34 PM, Richard Hipp wrote: >> Thanks for the bug report. The problem is now fixed on trunk. >> >> On 6/18/15, Jean Chevalier wrote: >>> The likelihood() function, which should help select a query plan but >>> otherwise be logic-neutral,

[sqlite] Likelihood() in Left Join affecting results

On 2015-06-18 01:04 PM, Jean Chevalier wrote: > The likelihood() function, which should help select a query plan but > otherwise be logic-neutral, nevertheless seems to affect results returned by > a Left Join, when used as part of the join condition, possibly in other > circumstances. To add

[sqlite] Likelihood() in Left Join affecting results

The likelihood() function, which should help select a query plan but otherwise be logic-neutral, nevertheless seems to affect results returned by a Left Join, when used as part of the join condition, possibly in other circumstances. With the following sample data, the two SELECT queries should r

[sqlite] Likelihood() in Left Join affecting results

Thanks for the bug report. The problem is now fixed on trunk. On 6/18/15, Jean Chevalier wrote: > The likelihood() function, which should help select a query plan but > otherwise be logic-neutral, nevertheless seems to affect results returned by > a Left Join, when used as part of the join condi