Before switching to Dig Deeper i was working on a rather successful, calm fort. It featured a brook and a chasm, which directly made me thing "oi! Infinite flowing water supply!" Since flowing water is never considered nasty (a think i remember from my cistern in an older fort) i took this opportunity to make a pipe from the brook to the chasm, eventually supplying water for my farm, moat and wells. And all was well...
Then came winter!
I eventually forgot to check the climate, so that the water pouring into the chasm froze, sealing the drain. I was pretty nervous at that point. The water filled a cave beneath the drain, but it was soon to be frozen as well. At that point i expected my many wells and moat to pour over and flood the place, since the water intake didn't freeze.
But as time went by nothing happened. No spills, no flood, nothing.
As to the mechanics: I tapped a brook tile, let the water fall down a few tiles where it flew straight to the chasm, regulating only with floodgates. Also a thing i noticed was, that the water streaming through the dug out pipe was not animated until it touched the chasm for the first time. After that it looked like a river does when flowing, making me wonder, if that particular flow was maybe tagged as "consistent" or with a solid drain or whatever.
In the end, i am just wondering why nothing has happened. I still got the save, so I might check on it again.