Water Broken by Piston Becomes a Ghost Block

When breaking water with a piston, it leaves behind a ghost block of the water that has the same properties as normal water, but cannot flow. The Ghost block goes away when in contact with water or interacted with.

The video shows how to recreate the bug.