OceanBase 支持 MVCC 特性,读是快照读,不阻塞写,是 SELECT 语句还有个特殊的用法可以阻塞写。示例如下:

    1. obclient> select w_name, w_ytd, w_tax from ware where w_id=1 for update;
    2. +------------+---------+--------+
    3. | w_name | w_ytd | w_tax |
    4. +------------+---------+--------+
    5. | n1P4zYo8OH | 1200.00 | 0.1868 |
    6. +------------+---------+--------+
    7. 1 row in set (0.01 sec)