[CALCITE-92] Project should be optimized away, not converted to EnumerableCalcRel

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.0.0-incubating
• Labels: github-import
• Assignee: Unassigned
• Reporter: GitHub Import
• Created: 18/Jun/14 08:05
• Updated: 17/Jan/17 23:48
• Resolved: 06/Jan/15 13:26

Description

See JdbcTest.testNoCalcBetweenJoins. The plan contains

```
EnumerableJoinRel(condition=[=($33, $37)], joinType=[inner])
EnumerableCalcRel(expr(#0 | FLINK-0)..36=[

{inputs}

], customer_id=[$t8], account_num=[$t9], lname=[$t10], fname=[$t11], mi=[$t12], address1=[$t13], address2=[$t14], address3=[$t15], address4=[$t16], city=[$t17], state_province=[$t18], postal_code=[$t19], country=[$t20], customer_region_id=[$t21], phone1=[$t22], phone2=[$t23], birthdate=[$t24], marital_status=[$t25], yearly_income=[$t26], gender=[$t27], total_children=[$t28], num_children_at_home=[$t29], education=[$t30], date_accnt_opened=[$t31], member_card=[$t32], occupation=[$t33], houseowner=[$t34], num_cars_owned=[$t35], fullname=[$t36], product_id=[$t0], time_id=[$t1], customer_id0=[$t2], promotion_id=[$t3], store_id=[$t4], store_sales=[$t5], store_cost=[$t6], unit_sales=[$t7])
EnumerableJoinRel(condition=[=($2, $8)], joinType=[inner])
```

That calc is just a project. It was probably introduced by a SwapJoinRule. It should be expanded away during code generation, but as it stands the EnumerableCalcRel is expensive.

---------------- Imported from GitHub ----------------
Url: https://github.com/julianhyde/optiq/issues/92
Created by: julianhyde
Labels:
Created at: Sat Nov 30 06:17:28 CET 2013
State: open

Issue Links

• is duplicated by: CALCITE-486 Fast-path for EnumerableCalc in case of trivial program
• is related to: CALCITE-1584 ProjectRemoveRule loses field names