My understanding of the google sheets filter function is that it should limit the results to an array where the conditions are satisfied but I noticed this oddity:

My understanding of the google sheets filter function is that it should limit the results to an array where the conditions are satisfied but I noticed this oddity: