I used a piston to push a magma block under a tank of water, pushing a soulsand block out the bubble column stayed pushing upward, didn't update the direction. Also did same thing other way around, but when i used double piston with a block is between them it works.
It needs to be a source block. Yeah I know it's stupid I'm trying to make a huge elevator in survival and it's taking so long to place all the water