[ARROW-10760] [Rust] [DataFusion] Predicate push down does not support joins correctly

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 3.0.0
• Component/s: Rust - DataFusion
• Labels: pull-request-available
• External issue URL: https://github.com/apache/arrow/issues/26704
• Assignee: Jorge Leitão
• Reporter: Andy Grove
• Created: 28/Nov/20 16:05
• Updated: 11/Jan/23 08:15
• Resolved: 29/Nov/20 14:02

Description

 See this ignored test in tests/sql.rs for an example (once https://github.com/apache/arrow/pull/8785 is merged)

---- equijoin_implicit_syntax_with_filter stdout ----
thread 'equijoin_implicit_syntax_with_filter' panicked at 'Creating physical plan for 'SELECT t1_id, t1_name, t2_name FROM t1, t2 WHERE t1_id > 0 AND t1_id = t2_id AND t2_id < 99 ORDER BY t1_id': Sort: #t1_id ASC NULLS FIRST
  Projection: #t1_id, #t1_name, #t2_name
    Join: t1_id = t2_id
      Filter: #t1_id Gt Int64(0) And #t2_id Lt Int64(99)
        TableScan: t1 projection=Some([0, 1])
      Filter: #t1_id Gt Int64(0) And #t2_id Lt Int64(99)
        TableScan: t2 projection=Some([0, 1]): ArrowError(InvalidArgumentError("Unable to get field named \"t2_id\". Valid fields: [\"t1_id\", \"t1_name\"]"))', datafusion/tests/sql.rs:1262:48
note: run with `RUST_BACKTRACE=1` environment variable to display a backtrace
 

Issue Links

• links to: GitHub Pull Request #8797