test: Restore one test in CometExecSuite by adding COMET_SHUFFLE_MODE config

[viirya]

Which issue does this PR close?

Closes #.

Rationale for this change

Just found this test doesn't actually test what it did. We need to add specified COMET_SHUFFLE_MODE config to restore it.

What changes are included in this PR?

How are these changes tested?

[viirya]

Thanks @huaxingao