Left Outer Join does not handle combined predicate.

Author: freshp86Created Sep 9, 2015Updated Oct 10, 2020

Labelsenhancement

Currently leftOuterJoin() only accepts a single (join) predicate. For example the following query is supported

db.select().
    from(tableA, tableB).
    leftOuterJoin(tableA, tableA.id.eq(tableB.id)).
    exec();

but the one below is not (Syntax error: (541) Outer join accepts only join predicate.)

db.select().
    from(tableA, tableB).
    leftOuterJoin(tableA, lf.op.and(tableA.id.eq(tableB.id), tableA.id.gt(100))).
    exec();

Source: google/lovefield