| * Description : Equi joins two datasets, Customers and Orders, based on the customer id. |
| * Given the 'indexnl' hint we expect the join to be transformed |
| * into an indexed nested-loop join using Customers' primary index. |
| * We expect the additional predicates to be put into a select above the |
| drop dataverse test if exists; |
| create type AddressType as closed { |
| create type CustomerType as closed { |
| create type OrderType as closed { |
| create dataset Customers(CustomerType) partitioned by key cid; |
| create dataset Orders(OrderType) partitioned by key oid; |
| write output to nc1:"rttest/btree-index-join_primary-equi-join-multipred.adm"; |
| for $c in dataset('Customers') |
| for $o in dataset('Orders') |
| where $c.cid /*+ indexnl */ = $o.cid and $c.name < $o.orderstatus and $c.age < $o.cid |
| return {"customer":$c, "order": $o} |