Why is one of the Solution files blank?

When playing a Secure Code Warrior® challenge, there are times during the 'Identify Solution' stage where a file within a branch can be totally blank.

There's nothing wrong with the solution. It simply means the solution you're currently viewing recommends deleting the selected file.

In this scenario, 'Solution 1' recommends removing the file D_PKG_MAIN_SECURE_RANDOM.sql from the repository entirely.

A quick way to tell if this is happening is by looking at the file structure. As you can see, there is a little '-' sign to the left of the file name. 

This indicates that this file exists in the Vulnerable Code, but does not exist in Solution 1 (there is no code because this file does not exist in Solution 1).