Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » SQL Anywhere Server - SQL Usage » Transactions and isolation levels » Isolation level tutorials

 

Tutorial: Understanding phantom rows

In this tutorial, you will observe the appearance of a phantom row.

Note

For this tutorial to work properly, the Automatically Release Database Locks option must not be selected in Interactive SQL (Tools » Options » SQL Anywhere).


Lesson 1: Creating phantom rows
Lesson 2: Avoiding phantom rows