fix: bug in the join condition

We have already fixed the problems with the bucket_id system column (fc8b6d93), but forgot to take care of the join condition references. Now this problem is fixed.