#51 FOR UPDATE

open
nobody
None
5
2011-01-12
2011-01-12
No

There doesn't seem to be any support for 'FOR UPDATE':
SELECT * FROM test_data WHERE test_id = 1 FOR UPDATE

At the bare minimum, there should be an SQL way to lock an entire table.

Discussion

  • Esen Sagynov
    Esen Sagynov
    2011-01-13

    At this moment we do not provide this feature to lock the entire table in SQL and currently do not have plans on implementing this feature in our upcoming version. Maybe later.

    There a programmatic way, though, to lock the records (still not table) in PHP and CCI APIs. See http://www.php.net/manual/en/function.cubrid-lock-read.php.

    Also in SQL you can control the level of consistency and concurrency specific to a service by setting appropriate transaction isolation level. See http://www.cubrid.org/manual/syntax/syntax_tran_isolation_repeatcom.htm. But this will lock all SELECT statements, too, not the user specified ones.

    I will keep this issue open, so that once we set plans for it in one of our Milestones, I will inform here.