[MINOR] Cleanup append tests for proper exec type handling

[MINOR] Cleanup append tests for proper exec type handling #8209