READ ONLY cursors now see data at time of OPEN [CR 466135]

As of Sybase IQ 12.7 ESD #4, applications that use cursors declared FOR READ ONLY may notice a change in which version of the data is visible to a cursor.

The following statement will be added to the sections “DECLARE CURSOR statement [ESQL][SP],” “FETCH statement [ESQL][SP],” and “OPEN statement [ESQL][SP]” in Chapter 6, “SQL Statements” for this behavior change:

“A cursor declared FOR READ ONLY sees the version of table(s) on which the cursor is declared when the cursor is opened, not the version of table(s) at the time of the first FETCH.”