| * Description : Equi joins two datasets, DBLP and CSX, based on their title. |
| * DBLP has a secondary btree index on title, and given the 'indexnl' hint |
| * we expect the join to be transformed into an indexed nested-loop join. |
| * We expect the additional predicates to be put into a select above the |
| drop dataverse test if exists; |
| create type DBLPType as closed { |
| create type CSXType as closed { |
| create dataset DBLP(DBLPType) primary key id; |
| create dataset CSX(CSXType) primary key id; |
| create index title_index on DBLP(title); |
| write output to nc1:"rttest/btree-index-join_title-secondary-equi-join-multipred.adm"; |
| for $a in dataset('DBLP') |
| where $a.title /*+ indexnl */ = $b.title and $a.authors < $b.authors and $a.misc > $b.misc |
| return {"arec": $a, "brec": $b} |