Who is responsible for flood damage from a water main break?

Insurance agents say flooding damage to cars is covered if you bought comprehensive auto insurance.