Allocate a transaction id at the beginning of join cursor iteration

The allocation of a transaction id should happen before bloom filters are created to guarantee consistency. Not sure if this is actually a bug, but this potential problem came out of recent discussions. We need a test case to be sure we have it right.