When you shoot anything water filled - work up slowly. There is a point where the hydraulic pressure forces the sides out to touch the bore, then at some higher level forced out to where it ruptures. As such it is an indicator of relative pressure.
How far? Long barrel greater distance. I've shot some concrete filled bottles 1000 or more yards. 100 yds or within sight when they land is MUCH better.