`FOR UPDATE` breaks batch execution in HANA
<p>HANA 102.05 fails to execute the following code:</p>
<pre><code>CREATE TABLE ATABLE( f INT );

CREATE PROCEDURE TestProc()
AS
BEGIN
    SELECT f FROM ATABLE
    FOR UPDATE; -- Without FOR UPDATE it works
END;

SELECT 'Hello' FROM DUMMY;
</code></pre>
<p>complaining that:</p>
<blockquote>
<p>SAP DBTech JDBC: [257]: sql syntax error: incorrect syntax near &quot;SELECT&quot;: line 8 col 2 (at pos 124)</p>
</blockquote>
<p>which points outside the proceudure, at <code>SELECT 'Hello'</code>.  The procedure itself compiles without error. The entire script completes successfully if I remove the <code>FOR UPDATE</code> directive. What is wrong with the original?</p>
<h3>Update</h3>
<p>When I execute the same query from <em>hdbsql.exe</em> I get:</p>
<pre><code>0 rows affected (overall time 26,076 msec; server time 6518 usec)

* 257: sql syntax error: line 5 col 9 (at pos 71) SQLSTATE: HY000
* 257: sql syntax error: incorrect syntax near &quot;END&quot;: line 2 col 1 (at pos 32) SQLSTATE: HY000
'Hello'
&quot;Hello&quot;

1 row selected (overall time 4644 usec; server time 143 usec)
</code></pre>