| Ticket Hash: | be84e357c035d068135f20bcfe82761bbf95006b | ||
| Title: | Segfault during query involving LEFT JOIN column in the ORDER BY clause | ||
| Status: | Fixed | Type: | Code_Defect |
| Severity: | Critical | Priority: | Immediate |
| Subsystem: | Unknown | Resolution: | Fixed |
| Last Modified: |
2013-09-03 14:03:54 11.84 years ago |
Created: |
2013-09-03 12:18:03 11.84 years ago |
| Version Found In: | 3.8.0.1 | ||
| User Comments: | ||||
|
drh added on 2013-09-03 12:18:03:
The following SQL segfaults: CREATE TABLE t1(a); CREATE TABLE t2(b,c); INSERT INTO t1 VALUES(1); SELECT DISTINCT a FROM t1 LEFT JOIN t2 ON a=b ORDER BY c IS NULL; Initially reported on the sqlite-users mailing list by Alexandre Courbot. | ||||