I applied the patch and was able to run the test succesfully in Embedded.
Comparing the orginal cursor.java the new test I did not find the following in the new one:
testCursorName("select * from t for update of i", "myselect");
Also, the test seem to run only in embedded mode, are there plans to make it run under Network server?.
I tried running it under both using
in the suite() method.
With the Network server I noticed the SQLStates returned are different for line 87:
assertEquals("Wrong SQLState thrown",se.getSQLState(),"24000");
I am getting XJ121 (Invalid operation at current cursor position) instead of the
expected 24000 (Invalid cursor state - no current row) so the tests failed for me with Network Server.