| Ticket Hash: | c620261b5b5dc7f16bb1440bfdf5ff66de672524 | ||
| Title: | Incorrect result on query involving LEFT JOIN and transitive constraints | ||
| Status: | Fixed | Type: | Code_Defect |
| Severity: | Severe | Priority: | Immediate |
| Subsystem: | Unknown | Resolution: | Fixed |
| Last Modified: |
2013-10-28 20:39:11 11.54 years ago |
Created: |
2013-10-28 15:50:54 11.54 years ago |
| Version Found In: | 3.8.1 | ||
| User Comments: | ||||
|
drh added on 2013-10-28 15:50:54:
The following SQL should output a single result row, but in SQLite 3.8.1 it outputs no rows: CREATE TABLE t1(a); CREATE TABLE t2(b); CREATE TABLE t3(c INTEGER PRIMARY KEY); INSERT INTO t1 VALUES(1); INSERT INTO t3 VALUES(1); SELECT 'a row' FROM t1 LEFT JOIN t2 ON b=a JOIN t3 ON c=a; | ||||