It might look like this dam in Magic Kingdom is containing water at a dead end of the hub moat. However, there's an open connection under the wall to the opposite side that reaches into Adventureland.