At low speeds in non-turbulent fluid, the simple formula holds. As you approach the speed of sound, it becomes more complex. Applying the simple formula at supersonic speeds yields negative pressures.

In liquids, high velocity results in cavitation. The liquid may boil, which makes the formula invalid. Similarly, low pressure may cause water vapor to condense, which also makes the formula invalid.