Fix case-sensitive bugs in join and delete compiler; add test cases