Hello,

I'm making a FilterableTable with LDAP as a backend.

I noticed in the FilterableTable method:
public Enumerable<Object[]> scan(DataContext root, List<RexNode> filters)

The filters list is empty if the sql where clause is checking the same
field in all tables.
ie.
select test1.field test2.field
from test1
full outer join test2 on test1.id = test2.id
where test1.field = 'myval' or test2.field = 'myval';

When I do an EXPLAIN PLAN FOR select ...
I notice the BindableTableScan filters array is empty with both:
where test1.field = 'myval' or test2.field = 'myval';
and it has the filter if I remove one:
where test1.field = 'myval'

Is there an example I could be pointed to help understand the query planner
here, and hopefully write my implementation such that the filters show up
as expected for each table?

Thank you!
Eric

Reply via email to