SQLite Forum

Inconsistant output when likely/unlikely and join keyword is applied
Login
For query:

```SQL:
CREATE TABLE v0 ( v1 PRIMARY KEY , v2 , v3 ) ;
INSERT INTO v0 VALUES ( '111' , '222' , '333' ) ;
CREATE TABLE v4 ( v5 PRIMARY KEY ) ;
INSERT INTO v4 VALUES ( '0' ) ;
SELECT * FROM v4 JOIN v0 ON v0.v3 = v0.v1 AND v0.v3 = '111';
SELECT * FROM v4 JOIN v0 ON likely( v0.v3 = v0.v1 ) AND v0.v3 = '111';
SELECT * FROM v4 JOIN v0 ON unlikely( v0.v3 = v0.v1 ) AND v0.v3 = '111';
```

The expected result should be: 

(EMPTY)

(EMPTY)

(EMPTY)

However, the actual output is:

(EMPTY)

0\|111\|222\|333

0\|111\|222\|333

This inconsistent behavior is reproducible with the latest development version: **FossilOrigin-Name: b5dc7aba036cfd6d09c68dd17608328063634ca99ff341f97bab2dc2a1f59b11**; and one of the latest released version: **SQLite version 3.31.1** 

This inconsistent behavior seems to be introduced in: **FossilOrigin-Name: 82c67efb723dba387964f690cd459b420e59e3367d9589016597a76531596391**