When I am compiling the code, this is the error I get.
XXCA_CNOTE_FILE1:28: Warning: The column int #1 is not nullable, even though it may be NULL in the select list. This may result in a runtime error.