Problem

By default NULLs show as blank on the test outputs, see:

This makes the NULL results not obvious at first sight.

Solution

Try adding an option like \pset null '<null>' so results show like:

 get_auth ------------------------------- (test_expired_user_password,<null>)