When the command "show compare id detail" is issued immediately after starting compare, the following error shows up:
sp_ctrl> show compare id <number> detail
Failed to get stat() on
<filename> - No such file or directory
Most likely the compare has just started and the detail is yet to be compiled by it.
Unless the table is very small, it will take some time for the compare to finish its task. Only then will it compile the final results which include the SQL to be applied (or are applied in case of "repair" option). These SQLs are located in the file which is mentioned in the above error. So one needs to give compare enough time to finish before issuing the above command.
Once the compare finishes successfully, then the command "show compare id detail" will not show any error messages.