Consider the following POC:
---
CREATE TABLE v0 ( v1 ) ;
CREATE TABLE v2 ( v5 INTEGER PRIMARY KEY , v4 INT , v3 CHAR(100) ) ;
SELECT DISTINCT * FROM v0 LEFT JOIN v2 ON v5 = v4 AND v5 = ( SELECT zipfile ( lower ( '17' ) , v1 ) FROM v0 ORDER BY random () ) WHERE v2 . v4 > 10 ;
---

It triggers an assertion in debug version of trunk.