github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/pessimistic_transaction/system_view.result (about)

     1  drop database if exists sv_db1;
     2  create database sv_db1;
     3  use sv_db1;
     4  use sv_db1;
     5  create table t1(a int);
     6  begin;
     7  insert into t1 values (1);
     8  select sleep(10);
     9  sleep(10)
    10  0
    11  select count(*) > 0 from mo_locks() l;
    12  count(*) > 0
    13  true
    14  select count(*) > 0 from mo_transactions() t join mo_locks() l where t.txn_id = l.txn_id;
    15  count(*) > 0
    16  true
    17  commit;
    18  drop database if exists sv_db1;