In the latest version (0.4.dev-20111204-1) sand falls. However, when it hits water, it does not fall further. Which causes the sand to float on top of the water. If the water is a stream, that does not fill the entire cube, the sand hovers above the water. The sand should continue its fall into the water.
EDIT:
Here is an image: