Function cursorMoveFlow

tests/integration/cursor_test.go:132–144

cursorMoveFlow covers MOVE n advancing the position without returning rows.

(t *testing.T, db *sql.DB)

// cursorMoveFlow covers MOVE n advancing the position without returning rows.
func cursorMoveFlow(t *testing.T, db *sql.DB) {
	tx := beginCursorTx(t, db)

	mustExecTx(t, tx, "DECLARE cur_move CURSOR FOR SELECT id, name FROM users ORDER BY id")

	moved := fetchCursorRows(t, tx, "MOVE 4 FROM cur_move")
	if len(moved) != 0 {
		t.Errorf("MOVE 4 returned %d rows %v, want none", len(moved), moved)
	}
	assertCursorRows(t, "FETCH ALL after MOVE", fetchCursorRows(t, tx, "FETCH ALL FROM cur_move"), cursorUsers(5, 10))

	mustExecTx(t, tx, "CLOSE cur_move")
}

// cursorBackwardFlow covers the forward-only restriction: backward fetch
// fails with a clean error. NO SCROLL pins real PostgreSQL to the same